供求信息网(11)

4.查询供求信息

SelectInfo()方法为可重载方法,用于根据不同的条件查询免费供求信息,通过调用数据层中的RunProcReturn()方法实现。实现代码如下:

例程12 代码位置:光盘\TM\01\SIS\ App_Code \ Operation.cs

#region 查询供求信息

/// <summary>

/// 按类型查询供求信息

/// </summary>

/// <param name="type">供求信息类型</param>

/// <returns>返回查询结果DataSet数据集</returns>

public DataSet SelectInfo(string type)

{

SqlParameter[] parms ={ data.MakeInParam("@type", SqlDbType.VarChar, 50, type) };

return data.RunProcReturn("SELECT ID, type, title, info, linkman, tel, checkState, date FROM tb_info where type=@type ORDER BY date DESC", parms, "tb_info");

}

/// <summary>

/// 按类型和ID查询供求信息

/// </summary>

/// <param name="type">供求信息类型</param>

/// <param name="id">供求信息ID</param>

/// <returns>返回查询结果DataSet数据集</returns>

public DataSet SelectInfo(string type, int id)

{

SqlParameter[] parms ={

data.MakeInParam("@type", SqlDbType.VarChar, 50, type) ,

};

return data.RunProcReturn("SELECT ID, type, title, info, linkman, tel, checkState, date FROM tb_info where (type=@type) AND (ID=" + id + ") ORDER BY date DESC", parms, "tb_info1");

}

/// <summary>

/// 按信息类型查询,审核和未审核信息

/// </summary>

/// <param name="type">信息类型</param>

/// <param name="checkState">True 显示审核信息 False显示未审核信息</param>

/// <returns>返回查询结果DataSet数据集</returns>

public DataSet SelectInfo(string type, bool checkState)

{

return data.RunProcReturn("select * from tb_info where type='" + type + "' and checkState='" + checkState + "'", "tb_info");

}

/// <summary>

/// 供求信息快速检索

/// </summary>

/// <param name="type">信息类型</param>

/// <param name="infoSearch">查询信息的关键字</param>

/// <returns>返回查询结果DataSet数据集</returns>

public DataSet SelectInfo(string type, string infoSearch)

{

SqlParameter[] pars ={

data.MakeInParam("@type", SqlDbType.VarChar, 50, type) ,

data.MakeInParam("@info",SqlDbType.VarChar,50,"%"+infoSearch+"%")

};

return data.RunProcReturn("select * from tb_info where (type=@type) and (info like @info)", pars, "tb_info");

}

#endregion

5.添加收费供求信息

InsertLeaguerInfo()方法主要用于将收费供求信息添加到数据库中。实现代码如下:

例程13 代码位置:光盘\TM\01\SIS\ App_Code \ Operation.cs

#region 添加收费供求信息

/// <summary>

/// 添加收费供求信息

/// </summary>

/// <param name="type">信息类型</param>

/// <param name="title">信息标题</param>

/// <param name="info">信息内容</param>

/// <param name="linkMan">联系人</param>

/// <param name="tel">联系电话</param>

/// <param name="sumDay">有效天数</param>

public void InsertLeaguerInfo(string type, string title, string info, string linkMan, string tel, DateTime sumDay,bool checkState)

{

SqlParameter[] parms ={

data.MakeInParam("@type",SqlDbType.VarChar,50,type),

data.MakeInParam("@title",SqlDbType.VarChar,50,title),

data.MakeInParam("@info",SqlDbType.VarChar,500,info),

data.MakeInParam("@linkMan",SqlDbType.VarChar,50,linkMan),

data.MakeInParam("@tel",SqlDbType.VarChar,50,tel),

data.MakeInParam("@showday",SqlDbType.DateTime,8,sumDay),

data.MakeInParam("@CheckState",SqlDbType.Bit,8,checkState)

};

int i = data.RunProc("INSERT INTO tb_LeaguerInfo (type, title, info, linkman, tel,showday,checkState) VALUES (@type, @title,@info,@linkMan, @tel,@showday,@CheckState)", parms);

}

#endregion

读书导航