/// <summary> /// 更新一条数据 /// </summary> public void Update(TFXK.Model.Articles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Articles set "); strSql.Append("parentId=@parentId,"); strSql.Append("title=@title,"); strSql.Append("source=@source,"); strSql.Append("publisher=@publisher,"); strSql.Append("createTime=@createTime,"); strSql.Append("description=@description,"); strSql.Append("isOutlLink=@isOutlLink,"); strSql.Append("isSlideOn=@isSlideOn,"); strSql.Append("state=@state,"); strSql.Append("clicks=@clicks,"); strSql.Append("orderId=@orderId,"); strSql.Append("imgPath=@imgPath,"); strSql.Append("outLinkPath=@outLinkPath,fysmDes=@fysmDes,wxtsDes=@wxtsDes,ydxzDes=@ydxzDes"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@parentId", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 500), new SqlParameter("@source", SqlDbType.VarChar, 500), new SqlParameter("@publisher", SqlDbType.VarChar, 50), new SqlParameter("@createTime", SqlDbType.DateTime), new SqlParameter("@description", SqlDbType.Text), new SqlParameter("@isOutlLink", SqlDbType.Int, 4), new SqlParameter("@isSlideOn", SqlDbType.Int, 4), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@clicks", SqlDbType.Int, 4), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@imgPath", SqlDbType.VarChar, 100), new SqlParameter("@outLinkPath", SqlDbType.VarChar, 100), new SqlParameter("@fysmDes", SqlDbType.Text), new SqlParameter("@wxtsDes", SqlDbType.Text), new SqlParameter("@ydxzDes", SqlDbType.Text) }; parameters[0].Value = model.id; parameters[1].Value = model.parentId; parameters[2].Value = model.title; parameters[3].Value = model.source; parameters[4].Value = model.publisher; parameters[5].Value = model.createTime; parameters[6].Value = model.description; parameters[7].Value = model.isOutlLink; parameters[8].Value = model.isSlideOn; parameters[9].Value = model.state; parameters[10].Value = model.clicks; parameters[11].Value = model.orderId; parameters[12].Value = model.imgPath; parameters[13].Value = model.outLinkPath; parameters[14].Value = model.fysmDes; parameters[15].Value = model.wxtsDes; parameters[16].Value = model.ydxzDes; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TFXK.Model.Articles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Articles("); strSql.Append("parentId,title,source,publisher,createTime,description,isOutlLink,isSlideOn,state,clicks,orderId,imgPath,outLinkPath,fysmDes,wxtsDes,ydxzDes)"); strSql.Append(" values ("); strSql.Append("@parentId,@title,@source,@publisher,@createTime,@description,@isOutlLink,@isSlideOn,@state,@clicks,@orderId,@imgPath,@outLinkPath,@fysmDes,@wxtsDes,@ydxzDes)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@parentId", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 500), new SqlParameter("@source", SqlDbType.VarChar, 500), new SqlParameter("@publisher", SqlDbType.VarChar, 50), new SqlParameter("@createTime", SqlDbType.DateTime), new SqlParameter("@description", SqlDbType.Text), new SqlParameter("@isOutlLink", SqlDbType.Int, 4), new SqlParameter("@isSlideOn", SqlDbType.Int, 4), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@clicks", SqlDbType.Int, 4), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@imgPath", SqlDbType.VarChar, 100), new SqlParameter("@outLinkPath", SqlDbType.VarChar, 100), new SqlParameter("@fysmDes", SqlDbType.Text), new SqlParameter("@wxtsDes", SqlDbType.Text), new SqlParameter("@ydxzDes", SqlDbType.Text) }; parameters[0].Value = model.parentId; parameters[1].Value = model.title; parameters[2].Value = model.source; parameters[3].Value = model.publisher; parameters[4].Value = model.createTime; parameters[5].Value = model.description; parameters[6].Value = model.isOutlLink; parameters[7].Value = model.isSlideOn; parameters[8].Value = model.state; parameters[9].Value = model.clicks; parameters[10].Value = model.orderId; parameters[11].Value = model.imgPath; parameters[12].Value = model.outLinkPath; parameters[13].Value = model.fysmDes; parameters[14].Value = model.wxtsDes; parameters[15].Value = model.ydxzDes; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TFXK.Model.Articles GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,parentId,title,source,publisher,createTime,description,isOutlLink,isSlideOn,state,clicks,orderId,imgPath,outLinkPath,fysmDes,wxtsDes,ydxzDes from tb_Articles "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; TFXK.Model.Articles model = new TFXK.Model.Articles(); DataSet ds = DbHelperSQL.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()); } if (ds.Tables[0].Rows[0]["parentId"].ToString() != "") { model.parentId = int.Parse(ds.Tables[0].Rows[0]["parentId"].ToString()); } model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.source = ds.Tables[0].Rows[0]["source"].ToString(); model.publisher = ds.Tables[0].Rows[0]["publisher"].ToString(); if (ds.Tables[0].Rows[0]["createTime"].ToString() != "") { model.createTime = DateTime.Parse(ds.Tables[0].Rows[0]["createTime"].ToString()); } model.description = ds.Tables[0].Rows[0]["description"].ToString(); if (ds.Tables[0].Rows[0]["isOutlLink"].ToString() != "") { model.isOutlLink = int.Parse(ds.Tables[0].Rows[0]["isOutlLink"].ToString()); } if (ds.Tables[0].Rows[0]["isSlideOn"].ToString() != "") { model.isSlideOn = int.Parse(ds.Tables[0].Rows[0]["isSlideOn"].ToString()); } if (ds.Tables[0].Rows[0]["state"].ToString() != "") { model.state = int.Parse(ds.Tables[0].Rows[0]["state"].ToString()); } if (ds.Tables[0].Rows[0]["clicks"].ToString() != "") { model.clicks = int.Parse(ds.Tables[0].Rows[0]["clicks"].ToString()); } if (ds.Tables[0].Rows[0]["orderId"].ToString() != "") { model.orderId = int.Parse(ds.Tables[0].Rows[0]["orderId"].ToString()); } model.imgPath = ds.Tables[0].Rows[0]["imgPath"].ToString(); model.outLinkPath = ds.Tables[0].Rows[0]["outLinkPath"].ToString(); model.fysmDes = ds.Tables[0].Rows[0]["fysmDes"].ToString(); model.wxtsDes = ds.Tables[0].Rows[0]["wxtsDes"].ToString(); model.ydxzDes = ds.Tables[0].Rows[0]["ydxzDes"].ToString(); return(model); } else { return(null); } }