vs2005 增插删改 代码.docVIP

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Web.UI; /// summary /// Operation 网站业务流程类（封装所有业务方法） /// /summary public class Operation { public Operation() { // // TODO: 在此处添加构造函数逻辑 // } DataBase data = new DataBase(); #region 添加供求信息 /// summary /// 添加供求信息 /// /summary /// param name=type信息类别/param /// param name=title标题/param /// param name=info内容/param /// param name=linkMan联系人/param /// param name=tel联系电话/param public void InsertInfo(string type, string title, string info, string linkMan, string tel) { 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), }; int i = data.RunProc(INSERT INTO tb_info (type, title, info, linkman, tel) VALUES (@type, @title,@info,@linkMan, @tel), parms); } #endregion #region 修改供求信息 /// summary /// 修改供求信息的审核状态 /// /summary /// param name=id信息ＩＤ/param /// param name=type信息类型/param public void UpdateInfo(string id, string type) { DataSet ds = this.SelectInfo(type, Convert.ToInt32(id)); bool checkState = Convert.ToBoolean(ds.Tables[0].Rows[0][6].ToString()); int i; if (checkState) { i = data.RunProc(UPDATE tb_info SET checkState = 0 WHERE (ID = + id + )); } else { i = data.RunProc(UPDATE tb_info SET checkState = 1 WHERE (ID = + id + )); } } #endregion #region 删除供求信息