1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10
 11using System.Data.SqlClient;
 12
 13using System.Web.UI;
 14
 15/**//// <summary>
 16/// Operation 网站业务流程类（封装所有业务方法）
 17/// </summary>
 18public class Operation
 19...{
 20    public Operation()
 21    ...{
 22        //
 23        // TODO: 在此处添加构造函数逻辑
 24        //
 25    }
 26    DataBase data = new DataBase();
 27
 28    添加供求信息#region  添加供求信息
 29    /**//// <summary>
 30    /// 添加供求信息
 31    /// </summary>
 32    /// <param name="type">信息类别</param>
 33    /// <param name="title">标题</param>
 34    /// <param name="info">内容</param>
 35    /// <param name="linkMan">联系人</param>
 36    /// <param name="tel">联系电话</param>
 37    public void InsertInfo(string type, string title, string info, string linkMan, string tel)
 38    ...{
 39        SqlParameter[] parms =...{ 
 40            data.MakeInParam("@type",SqlDbType.VarChar,50,type),
 41            data.MakeInParam("@title",SqlDbType.VarChar,50,title),
 42            data.MakeInParam("@info",SqlDbType.VarChar,500,info),
 43            data.MakeInParam("@linkMan",SqlDbType.VarChar,50,linkMan),
 44            data.MakeInParam("@tel",SqlDbType.VarChar,50,tel),
 45        };
 46        int i = data.RunProc("INSERT INTO tb_info (type, title, info, linkman, tel) VALUES (@type, @title,@info,@linkMan, @tel)", parms);
 47    }
 48    #endregion
 49
 50    修改供求信息#region  修改供求信息
 51    /**//// <summary>
 52    /// 修改供求信息的审核状态
 53    /// </summary>
 54    /// <param name="id">信息ＩＤ</param>
 55    /// <param name="type">信息类型</param>
 56    public void UpdateInfo(string id, string type)
 57    ...{
 58
 59        DataSet ds = this.SelectInfo(type, Convert.ToInt32(id));
 60        bool checkState = Convert.ToBoolean(ds.Tables[0].Rows[0][6].ToString());
 61        int i;
 62        if (checkState)
 63        ...{
 64            i = data.RunProc("UPDATE tb_info SET checkState = 0 WHERE (ID = " + id + ")");
 65        }
 66        else
 67        ...{
 68            i = data.RunProc("UPDATE tb_info SET checkState = 1 WHERE (ID = " + id + ")");
 69        }
 70    }
 71    #endregion
 72
 73    删除供求信息#region  删除供求信息
 74
 75    /**//// <summary>
 76    /// 删除指定的供求信息
 77    /// </summary>
 78    /// <param name="id">供求信息ＩＤ</param>
 79    public void DeleteInfo(string id)
 80    ...{
 81        int d = data.RunProc("Delete from tb_info where id='" + id + "'");
 82    }
 83
 84    #endregion
 85
 86    查询供求信息#region  查询供求信息
 87    /**//// <summary>
 88    /// 按类型查询供求信息
 89    /// </summary>
 90    /// <param name="type">供求信息类型</param>
 91    /// <returns>返回查询结果DataSet数据集</returns>
 92    public DataSet SelectInfo(string type)
 93    ...{
 94        SqlParameter[] parms =...{ data.MakeInParam("@type", SqlDbType.VarChar, 50, type) };
 95        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");
 96    }
 97    /**//// <summary>
 98    /// 按类型和ＩＤ查询供求信息
 99    /// </summary>
100    /// <param name="type">供求信息类型</param>
101    /// <param name="id">供求信息ＩＤ</param>
102    /// <returns>返回查询结果DataSet数据集</returns>
103    public DataSet SelectInfo(string type, int id)
104    ...{
105        SqlParameter[] parms =...{ 
106            data.MakeInParam("@type", SqlDbType.VarChar, 50, type) ,
107        };
108        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");
109    }
110    /**//// <summary>
111    /// 按信息类型查询，审核和未审核信息。
112    /// </summary>
113    /// <param name="type">信息类型</param>
114    /// <param name="checkState">True 显示审核信息 False显示未审核信息</param>
115    /// <returns>返回查询结果DataSet数据集</returns>
116    public DataSet SelectInfo(string type, bool checkState)
117    ...{
118        return data.RunProcReturn("select * from tb_info where type='" + type + "' and checkState='" + checkState + "'", "tb_info");
119    }
120
121    /**//// <summary>
122    /// 供求信息快速检索
123    /// </summary>
124    /// <param name="type">信息类型</param>
125    /// <param name="infoSearch">查询信息的关键字</param>
126    /// <returns>返回查询结果DataSet数据集</returns>
127    public DataSet SelectInfo(string type, string infoSearch)
128    ...{
129        SqlParameter[] pars =...{
130            data.MakeInParam("@type", SqlDbType.VarChar, 50, type) ,
131            data.MakeInParam("@info",SqlDbType.VarChar,50,"%"+infoSearch+"%")
132        };
133        return data.RunProcReturn("select * from tb_info where (type=@type) and (info like @info) and (checkstate=1)", pars, "tb_info");
134    }
135
136    #endregion
137
138    添加收费供求信息#region 添加收费供求信息
139
140    /**//// <summary>
141    /// 添加收费供求信息
142    /// </summary>
143    /// <param name="type">信息类型</param>
144    /// <param name="title">信息标题</param>
145    /// <param name="info">信息内容</param>
146    /// <param name="linkMan">联系人</param>
147    /// <param name="tel">联系电话</param>
148    /// <param name="sumDay">有时天数</param>
149    public void InsertLeaguerInfo(string type, string title, string info, string linkMan, string tel, DateTime sumDay,bool checkState)
150    ...{
151        SqlParameter[] parms =...{ 
152            data.MakeInParam("@type",SqlDbType.VarChar,50,type),
153            data.MakeInParam("@title",SqlDbType.VarChar,50,title),
154            data.MakeInParam("@info",SqlDbType.VarChar,500,info),
155            data.MakeInParam("@linkMan",SqlDbType.VarChar,50,linkMan),
156            data.MakeInParam("@tel",SqlDbType.VarChar,50,tel),
157            data.MakeInParam("@showday",SqlDbType.DateTime,8,sumDay),
158            data.MakeInParam("@CheckState",SqlDbType.Bit,8,checkState)
159        };
160        int i = data.RunProc("INSERT INTO tb_LeaguerInfo (type, title, info, linkman, tel,showday,checkState) VALUES (@type, @title,@info,@linkMan, @tel,@showday,@CheckState)", parms);
161    }
162    #endregion
163
164    删除收费供求信息#region  删除收费供求信息
165    /**//// <summary>
166    /// 删除收费供求信息
167    /// </summary>
168    /// <param name="id">要删除信息的ＩＤ</param>
169    public void DeleteLeaguerInfo(string id)
170    ...{
171        int d = data.RunProc("Delete from tb_LeaguerInfo where id='" + id + "'");
172    }
173    #endregion
174
175    查询收费供求信息#region  查询收费供求信息
176    /**//// <summary>
177    /// 显示所有的收费信息
178    /// </summary>
179    /// <returns>返回DataSet结果集</returns>
180    public DataSet SelectLeaguerInfo()
181    ...{
182        return data.RunProcReturn("Select * from tb_LeaguerInfo order by date desc", "tb_LeaguerInfo");
183    }
184    /**//// <summary>
185    /// 查询收费到期和未到期供求信息
186    /// </summary>
187    /// <param name="All">True显示未到期信息,False显示到期信息</param>
188    /// <returns>返回DataSet结果集</returns>
189    public DataSet SelectLeaguerInfo(bool All)
190    ...{
191        if (All) 　　　　 //显示有效收费信息
192            return data.RunProcReturn("Select * from tb_LeaguerInfo where showday >= getdate() order by date desc", "tb_LeaguerInfo");
193        else　　　　　　　//显示过期收费信息
194            return data.RunProcReturn("select * from tb_LeaguerInfo where showday<getdate() order by date desc", "tb_LeaguerInfo");
195    }
196    /**//// <summary>
197    /// 查询同类型收费到期和未到期供求信息
198    /// </summary>
199    /// <param name="all">True显示未到期信息,False显示到期信息</param>
200    /// <param name="infoType">信息类型</param>
201    /// <returns>返回DataSet结果集</returns>
202    public DataSet SelectLeaguerInfo(bool All, string infoType)
203    ...{
204        if (All) 　　　　 //显示有效收费信息
205            return data.RunProcReturn("Select * from tb_LeaguerInfo where type='" + infoType + "' and showday >= getdate() order by date desc", "tb_LeaguerInfo");
206        else　　　　　　　//显示过期收费信息
207            return data.RunProcReturn("select * from tb_LeaguerInfo where type='" + infoType + "' and showday<getdate() order by date desc", "tb_LeaguerInfo");
208    }
209    /**//// <summary>
210    /// 查询显示‘按类型未过期推荐信息’或‘所有的未过期推荐信息’
211    /// </summary>
212    /// <param name="infoType">信息类型</param>
213    /// <param name="checkState">True按类型显示未过期推荐信息  False显示所有未过期推荐信息</param>
214    /// <returns></returns>
215    public DataSet SelectLeaguerInfo(string infoType,bool checkState)
216    ...{
217        if (checkState) 　 //按类型未过期推荐信息
218            return data.RunProcReturn("SELECT top 20 * FROM tb_LeaguerInfo WHERE (type = '" + infoType + "') AND (showday >= GETDATE()) AND (CheckState = '" + checkState + "') ORDER BY date DESC", "tb_LeaguerInfo");
219        else　　　　　　　//显示未过期推荐信息
220            return data.RunProcReturn("SELECT top 10 * FROM tb_LeaguerInfo WHERE (showday >=GETDATE()) AND (CheckState = '" + !checkState + "') ORDER BY date DESC", "tb_LeaguerInfo");
221    }
222    /**//// <summary>
223    /// 查询同类型收费到期和未到期供求信息(前Ｎ条信息)
224    /// </summary>
225    /// <param name="all">True显示有效收费信息,False显示过期收费信息</param>
226    /// <param name="infoType">信息类型</param>
227    /// <param name="top">获取前Ｎ条信息</param>
228    /// <returns></returns>
229    public DataSet SelectLeaguerInfo(bool All, string infoType, int top)
230    ...{
231        if (All) 　　　　 //显示有效收费信息
232            return data.RunProcReturn("Select top(" + top + ") * from tb_LeaguerInfo where type='" + infoType + "' and showday >= getdate() order by date desc", "tb_LeaguerInfo");
233        else　　　　　　　//显示过期收费信息
234            return data.RunProcReturn("select top(" + top + ") * from tb_LeaguerInfo where type='" + infoType + "' and showday<getdate() order by date desc", "tb_LeaguerInfo");