6．删除收费供求信息
DeleteLeaguerInfo()方法主要用于删除收费供求信息。实现代码如下：
例程14 代码位置：光盘\TM\01\SIS\ App_Code \ Operation.cs
#region 删除收费供求信息
/// <summary>
/// 删除收费供求信息
/// </summary>
/// <param name="id">要删除信息的ID</param>
public void DeleteLeaguerInfo(string id)
{
int d = data.RunProc("Delete from tb_LeaguerInfo where id='" + id + "'");
}
#endregion
7．查询收费供求信息
SelectLeaguerInfo()方法为可重载方法，用于根据不同的条件查询收费供求信息。实现代码如下：
例程15 代码位置：光盘\TM\01\SIS\ App_Code \ Operation.cs
#region 查询收费供求信息
/// <summary>
/// 显示所有的收费信息
/// </summary>
/// <returns>返回DataSet结果集</returns>
public DataSet SelectLeaguerInfo()
{
return data.RunProcReturn("Select * from tb_LeaguerInfo order by date desc", "tb_LeaguerInfo");
}
/// <summary>
/// 查询收费到期和未到期供求信息
/// </summary>
/// <param name="All">True显示未到期信息,False显示到期信息</param>
/// <returns>返回DataSet结果集</returns>
public DataSet SelectLeaguerInfo(bool All)
{
if (All) //显示有效收费信息
return data.RunProcReturn("Select * from tb_LeaguerInfo where showday >= getdate() order by date desc", "tb_LeaguerInfo");
else //显示过期收费信息
return data.RunProcReturn("select * from tb_LeaguerInfo where showday<getdate() order by date desc", "tb_LeaguerInfo");
}
/// <summary>
/// 查询同类型收费到期和未到期供求信息
/// </summary>
/// <param name="all">True显示未到期信息,False显示到期信息</param>
/// <param name="infoType">信息类型</param>
/// <returns>返回DataSet结果集</returns>
public DataSet SelectLeaguerInfo(bool All, string infoType)
{
if (All) //显示有效收费信息
return data.RunProcReturn("Select * from tb_LeaguerInfo where type='" + infoType + "' and showday >= getdate() order by date desc", "tb_LeaguerInfo");
else //显示过期收费信息
return data.RunProcReturn("select * from tb_LeaguerInfo where type='" + infoType + "' and showday<getdate() order by date desc", "tb_LeaguerInfo");
}
/// <summary>
/// 查询显示“按类型未过期推荐信息”或“所有的未过期推荐信息”
/// </summary>
/// <param name="infoType">信息类型</param>
/// <param name="checkState">True按类型显示未过期推荐信息 False显示所有未过期推荐信息</param>
/// <returns></returns>
public DataSet SelectLeaguerInfo(string infoType,bool checkState)
{
if (checkState) //按类型未过期推荐信息
return data.RunProcReturn("SELECT top 20 * FROM tb_LeaguerInfo WHERE (type = '" + infoType + "') AND (showday >= GETDATE()) AND (CheckState = '" + checkState + "') ORDER BY date DESC", "tb_LeaguerInfo");
else //显示未过期推荐信息
return data.RunProcReturn("SELECT top 10 * FROM tb_LeaguerInfo WHERE (showday >=GETDATE()) AND (CheckState = '" + !checkState + "') ORDER BY date DESC", "tb_LeaguerInfo");
}
/// <summary>
/// 查询同类型收费到期和未到期供求信息（前N条信息）
/// </summary>
/// <param name="all">True显示未到期信息，False显示到期信息</param>
/// <param name="infoType">信息类型</param>
/// <param name="top">获取前Ｎ条信息</param>
/// <returns></returns>
public DataSet SelectLeaguerInfo(bool All, string infoType, int top)
{
if (All) //显示有效收费信息
return data.RunProcReturn("Select top(" + top + ") * from tb_LeaguerInfo where type='" + infoType + "' and showday >= getdate() order by date desc", "tb_LeaguerInfo");
else //显示过期收费信息
return data.RunProcReturn("select top(" + top + ") * from tb_LeaguerInfo where type='" + infoType + "' and showday<getdate() order by date desc", "tb_LeaguerInfo");
}
/// <summary>
/// 根据ID查询收费供求信息
/// </summary>
/// <param name="id">供求信息ID</param>
/// <returns></returns>
public DataSet SelectLeaguerInfo(string id)
{
return data.RunProcReturn("Select * from tb_LeaguerInfo where id='" + id + "' order by date desc", "tb_LeaguerInfo");
}
#endregion
8．DataList分页设置绑定
PageDataListBind()方法主要用于实现DataList绑定分页功能。实现代码如下：
例程16 代码位置：光盘\TM\01\SIS\ App_Code \ Operation.Cs
#region 分页设置绑定
/// <summary>
/// 绑定DataList控件，并且设置分页
/// </summary>
/// <param name="infoType">信息类型</param>
/// <param name="infoKey">查询的关键字（如果为空，则查询所有）</param>
/// <param name="currentPage">当前页</param>
/// <param name="PageSize">每页显示数量</param>
/// <returns>返回PagedDataSource对象</returns>
public PagedDataSource PageDataListBind(string infoType, string infoKey, int currentPage,int PageSize)
{
PagedDataSource pds = new PagedDataSource();
pds.DataSource = SelectInfo(infoType, infoKey).Tables[0].DefaultView; //将查询结果绑定到分页数据源上
pds.AllowPaging = true; //允许分页
pds.PageSize = PageSize; //设置每页显示的页数
pds.CurrentPageIndex = currentPage - 1; //设置当前页
return pds;
}
#endregion
9．后台登录
Logon()方法主要用于实现网站后台验证用户登录功能。实现代码如下：
例程17 代码位置：光盘\TM\01\SIS\ App_Code \ Operation.cs
#region 后台登录
public DataSet Logon(string user, string pwd)
{
SqlParameter[] parms ={
data.MakeInParam("@sysName",SqlDbType.VarChar,20,user),
data.MakeInParam("@sysPwd",SqlDbType.VarChar,20,pwd)
};
return data.RunProcReturn("Select * from tb_Power where sysName=@sysName and
sysPwd=@sysPwd",parms, "tb_Power");
}
#endregion
