/// <summary> /// 增加一条数据 /// </summary> public int Add(ZxModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_ReferOnline("); strSql.Append("name,tel,address,department,email,type,content,fillTime,replyTime,replyPeople,title,replyContent,state,isCheck,platform,memberid)"); strSql.Append(" values ("); strSql.Append("@name,@tel,@address,@department,@email,@type,@content,@fillTime,@replyTime,@replyPeople,@title,@replyContent,@state,@isCheck,@platform,@memberid)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@address", SqlDbType.VarChar, 200), new SqlParameter("@department", SqlDbType.VarChar, 100), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@type", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NChar, 500), new SqlParameter("@fillTime", SqlDbType.DateTime), new SqlParameter("@replyTime", SqlDbType.DateTime), new SqlParameter("@replyPeople", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 500), new SqlParameter("@replyContent", SqlDbType.NText), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@isCheck", SqlDbType.Int, 4), new SqlParameter("@platform", SqlDbType.Int, 4), new SqlParameter("@memberid", SqlDbType.VarChar, 50) }; parameters[0].Value = model.name; parameters[1].Value = model.tel; parameters[2].Value = model.address; parameters[3].Value = model.department; parameters[4].Value = model.email; parameters[5].Value = model.type; parameters[6].Value = model.content; parameters[7].Value = model.fillTime; parameters[8].Value = model.replyTime; parameters[9].Value = model.replyPeople; parameters[10].Value = model.title; parameters[11].Value = model.replyContent; parameters[12].Value = model.state; parameters[13].Value = model.isCheck; parameters[14].Value = model.platform; parameters[15].Value = model.memberid; object obj = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZxModel GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,tel,address,department,email,type,content,fillTime,replyTime,replyPeople,title,replyContent,state,isCheck,platform,memberid from T_ReferOnline "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; ZxModel model = new ZxModel(); DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZxModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZxModel model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZxModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_ReferOnline set "); strSql.Append("name=@name,"); strSql.Append("tel=@tel,"); strSql.Append("address=@address,"); strSql.Append("department=@department,"); strSql.Append("email=@email,"); strSql.Append("type=@type,"); strSql.Append("content=@content,"); strSql.Append("fillTime=@fillTime,"); strSql.Append("replyTime=@replyTime,"); strSql.Append("replyPeople=@replyPeople,"); strSql.Append("title=@title,"); strSql.Append("replyContent=@replyContent,"); strSql.Append("state=@state,"); strSql.Append("isCheck=@isCheck,"); strSql.Append("platform=@platform,"); strSql.Append("memberid=@memberid"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@address", SqlDbType.VarChar, 200), new SqlParameter("@department", SqlDbType.VarChar, 100), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@type", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NChar, 500), new SqlParameter("@fillTime", SqlDbType.DateTime), new SqlParameter("@replyTime", SqlDbType.DateTime), new SqlParameter("@replyPeople", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 500), new SqlParameter("@replyContent", SqlDbType.NText), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@isCheck", SqlDbType.Int, 4), new SqlParameter("@platform", SqlDbType.Int, 4), new SqlParameter("@memberid", SqlDbType.VarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.tel; parameters[2].Value = model.address; parameters[3].Value = model.department; parameters[4].Value = model.email; parameters[5].Value = model.type; parameters[6].Value = model.content; parameters[7].Value = model.fillTime; parameters[8].Value = model.replyTime; parameters[9].Value = model.replyPeople; parameters[10].Value = model.title; parameters[11].Value = model.replyContent; parameters[12].Value = model.state; parameters[13].Value = model.isCheck; parameters[14].Value = model.platform; parameters[15].Value = model.memberid; parameters[16].Value = model.id; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZxModel DataRowToModel(DataRow row) { ZxModel model = new ZxModel(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["department"] != null) { model.department = row["department"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["type"] != null && row["type"].ToString() != "") { model.type = int.Parse(row["type"].ToString()); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["fillTime"] != null && row["fillTime"].ToString() != "") { model.fillTime = DateTime.Parse(row["fillTime"].ToString()); } if (row["replyTime"] != null && row["replyTime"].ToString() != "") { model.replyTime = DateTime.Parse(row["replyTime"].ToString()); } if (row["replyPeople"] != null) { model.replyPeople = row["replyPeople"].ToString(); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["replyContent"] != null) { model.replyContent = row["replyContent"].ToString(); } if (row["state"] != null && row["state"].ToString() != "") { model.state = int.Parse(row["state"].ToString()); } if (row["isCheck"] != null && row["isCheck"].ToString() != "") { model.isCheck = int.Parse(row["isCheck"].ToString()); } if (row["platform"] != null && row["platform"].ToString() != "") { model.platform = int.Parse(row["platform"].ToString()); } if (row["memberid"] != null) { model.memberid = row["memberid"].ToString(); } } return(model); }