//修改数据 public int Update(ErrowTab model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ErrowTab set "); strSql.Append("BoolChuLi=@BoolChuLi,"); strSql.Append("BoolReturn=@BoolReturn,"); strSql.Append("ReturnContext=@ReturnContext,"); strSql.Append("Descript=@Descript,"); strSql.Append("updatetime=@updatetime"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@BoolChuLi", SqlDbType.Int, 4), new SqlParameter("@BoolReturn", SqlDbType.Int, 4), new SqlParameter("@ReturnContext", SqlDbType.Text), new SqlParameter("@Descript", SqlDbType.NVarChar, 500), new SqlParameter("@updatetime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.BoolChuLi; parameters[2].Value = model.BoolReturn; parameters[3].Value = model.ReturnContext; parameters[4].Value = model.Descript; parameters[5].Value = model.updatetime; return(DBHelper.ExecuteCommand(strSql.ToString(), parameters)); }
//通过ID获取一个实体对象 public ErrowTab GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; ErrowTab model = new ErrowTab(); DataSet ds = DBHelpe.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.LinkURL = ds.Tables[0].Rows[0]["LinkURL"].ToString(); model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString(); model.Connetions = ds.Tables[0].Rows[0]["Connetions"].ToString(); if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "") { model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString()); } if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "") { model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString()); } model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString(); model.Descript = ds.Tables[0].Rows[0]["Descript"].ToString(); model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); if (ds.Tables[0].Rows[0]["createtime"].ToString() != "") { model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString(); } if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "") { model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString(); } return(model); } else { return(null); } }
//修改数据 public int Update(ErrowTab model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ErrowTab set "); strSql.Append("LinkURL=@LinkURL,"); strSql.Append("QuestionDescript=@QuestionDescript,"); strSql.Append("Connetions=@Connetions,"); strSql.Append("BoolChuLi=@BoolChuLi,"); strSql.Append("BoolReturn=@BoolReturn,"); strSql.Append("ReturnContext=@ReturnContext,"); strSql.Append("Descript=@Descript,"); strSql.Append("LoginName=@LoginName,"); strSql.Append("createtime=@createtime,"); strSql.Append("updatetime=@updatetime"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 300), new SqlParameter("@QuestionDescript", SqlDbType.Text), new SqlParameter("@Connetions", SqlDbType.NVarChar, 300), new SqlParameter("@BoolChuLi", SqlDbType.Int, 4), new SqlParameter("@BoolReturn", SqlDbType.Int, 4), new SqlParameter("@ReturnContext", SqlDbType.Text), new SqlParameter("@Descript", SqlDbType.NVarChar, 500), new SqlParameter("@LoginName", SqlDbType.NVarChar, 300), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@updatetime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.LinkURL; parameters[2].Value = model.QuestionDescript; parameters[3].Value = model.Connetions; parameters[4].Value = model.BoolChuLi; parameters[5].Value = model.BoolReturn; parameters[6].Value = model.ReturnContext; parameters[7].Value = model.Descript; parameters[8].Value = model.LoginName; parameters[9].Value = model.createtime; parameters[10].Value = model.updatetime; return(DBHelpe.ExecuteCommand(strSql.ToString(), parameters)); }
/// <summary> /// 增加错误处理的一条数据 /// </summary> public int Add(ErrowTab model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ErrowTab("); strSql.Append("LoginName,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,createtime,updatetime)"); strSql.Append(" values ("); strSql.Append("@LoginName,@LinkURL,@QuestionDescript,@Connetions,@BoolChuLi,@BoolReturn,@ReturnContext,@Descript,@createtime,@updatetime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.NVarChar, 300), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 300), new SqlParameter("@QuestionDescript", SqlDbType.Text), new SqlParameter("@Connetions", SqlDbType.NVarChar, 300), new SqlParameter("@BoolChuLi", SqlDbType.Int, 4), new SqlParameter("@BoolReturn", SqlDbType.Int, 4), new SqlParameter("@ReturnContext", SqlDbType.Text), new SqlParameter("@Descript", SqlDbType.NVarChar, 500), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@updatetime", SqlDbType.DateTime) }; parameters[0].Value = model.LoginName; parameters[1].Value = model.LinkURL; parameters[2].Value = model.QuestionDescript; parameters[3].Value = model.Connetions; parameters[4].Value = model.BoolChuLi; parameters[5].Value = model.BoolReturn; parameters[6].Value = model.ReturnContext; parameters[7].Value = model.Descript; parameters[8].Value = model.createtime; parameters[9].Value = model.updatetime; object obj = DBHelpe.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
//获取实体对象集合 public List <ErrowTab> GetModelList() { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab "); List <ErrowTab> list = new List <ErrowTab>(); DataSet ds = DBHelpe.Query(strSql.ToString()); foreach (DataRow row in ds.Tables[0].Rows) { ErrowTab model = new ErrowTab(); if (row["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.LinkURL = ds.Tables[0].Rows[0]["LinkURL"].ToString(); model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString(); model.Connetions = ds.Tables[0].Rows[0]["Connetions"].ToString(); if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "") { model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString()); } if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "") { model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString()); } model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString(); model.Descript = ds.Tables[0].Rows[0]["Descript"].ToString(); model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); if (ds.Tables[0].Rows[0]["createtime"].ToString() != "") { model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString(); } if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "") { model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString(); } list.Add(model); } return(list); }
public int Update(ErrowTab model) { return(dal.Update(model)); }
public int Add(ErrowTab model) { return(dal.Add(model)); }