/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_message GetModel(int messageid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 messageid,Name,UnitName,PhoneNum,telNum,email,QQ,adress,title,content,userid,userName,updateTime,replay,re_updateTime,textParam1,textParam2,textParam3,textParam4,textParam5 from C_message "); strSql.Append(" where messageid=@messageid"); SqlParameter[] parameters = { new SqlParameter("@messageid", SqlDbType.Int, 4) }; parameters[0].Value = messageid; Cms.Model.C_message model = new Cms.Model.C_message(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Cms.Model.C_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into C_message("); strSql.Append("Name,UnitName,PhoneNum,telNum,email,QQ,adress,title,content,userid,userName,updateTime,replay,re_updateTime,textParam1,textParam2,textParam3,textParam4,textParam5)"); strSql.Append(" values ("); strSql.Append("@Name,@UnitName,@PhoneNum,@telNum,@email,@QQ,@adress,@title,@content,@userid,@userName,@updateTime,@replay,@re_updateTime,@textParam1,@textParam2,@textParam3,@textParam4,@textParam5)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 300), new SqlParameter("@UnitName", SqlDbType.VarChar, 300), new SqlParameter("@PhoneNum", SqlDbType.VarChar, 300), new SqlParameter("@telNum", SqlDbType.VarChar, 300), new SqlParameter("@email", SqlDbType.VarChar, 300), new SqlParameter("@QQ", SqlDbType.VarChar, 300), new SqlParameter("@adress", SqlDbType.VarChar, -1), new SqlParameter("@title", SqlDbType.VarChar, 300), new SqlParameter("@content", SqlDbType.Text), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@userName", SqlDbType.VarChar, 300), new SqlParameter("@updateTime", SqlDbType.DateTime), new SqlParameter("@replay", SqlDbType.Text), new SqlParameter("@re_updateTime", SqlDbType.VarChar, 350), new SqlParameter("@textParam1", SqlDbType.VarChar, -1), new SqlParameter("@textParam2", SqlDbType.VarChar, -1), new SqlParameter("@textParam3", SqlDbType.VarChar, -1), new SqlParameter("@textParam4", SqlDbType.VarChar, -1), new SqlParameter("@textParam5", SqlDbType.VarChar, -1) }; parameters[0].Value = model.Name; parameters[1].Value = model.UnitName; parameters[2].Value = model.PhoneNum; parameters[3].Value = model.telNum; parameters[4].Value = model.email; parameters[5].Value = model.QQ; parameters[6].Value = model.adress; parameters[7].Value = model.title; parameters[8].Value = model.content; parameters[9].Value = model.userid; parameters[10].Value = model.userName; parameters[11].Value = model.updateTime; parameters[12].Value = model.replay; parameters[13].Value = model.re_updateTime; parameters[14].Value = model.textParam1; parameters[15].Value = model.textParam2; parameters[16].Value = model.textParam3; parameters[17].Value = model.textParam4; parameters[18].Value = model.textParam5; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_message DataRowToModel(DataRow row) { Cms.Model.C_message model = new Cms.Model.C_message(); if (row != null) { if (row["messageid"] != null && row["messageid"].ToString() != "") { model.messageid = int.Parse(row["messageid"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["UnitName"] != null) { model.UnitName = row["UnitName"].ToString(); } if (row["PhoneNum"] != null) { model.PhoneNum = row["PhoneNum"].ToString(); } if (row["telNum"] != null) { model.telNum = row["telNum"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["QQ"] != null) { model.QQ = row["QQ"].ToString(); } if (row["adress"] != null) { model.adress = row["adress"].ToString(); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["userid"] != null && row["userid"].ToString() != "") { model.userid = int.Parse(row["userid"].ToString()); } if (row["userName"] != null) { model.userName = row["userName"].ToString(); } if (row["updateTime"] != null && row["updateTime"].ToString() != "") { model.updateTime = DateTime.Parse(row["updateTime"].ToString()); } if (row["replay"] != null) { model.replay = row["replay"].ToString(); } if (row["re_updateTime"] != null) { model.re_updateTime = row["re_updateTime"].ToString(); } if (row["textParam1"] != null) { model.textParam1 = row["textParam1"].ToString(); } if (row["textParam2"] != null) { model.textParam2 = row["textParam2"].ToString(); } if (row["textParam3"] != null) { model.textParam3 = row["textParam3"].ToString(); } if (row["textParam4"] != null) { model.textParam4 = row["textParam4"].ToString(); } if (row["textParam5"] != null) { model.textParam5 = row["textParam5"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cms.Model.C_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update C_message set "); strSql.Append("Name=@Name,"); strSql.Append("UnitName=@UnitName,"); strSql.Append("PhoneNum=@PhoneNum,"); strSql.Append("telNum=@telNum,"); strSql.Append("email=@email,"); strSql.Append("QQ=@QQ,"); strSql.Append("adress=@adress,"); strSql.Append("title=@title,"); strSql.Append("content=@content,"); strSql.Append("userid=@userid,"); strSql.Append("userName=@userName,"); strSql.Append("updateTime=@updateTime,"); strSql.Append("replay=@replay,"); strSql.Append("re_updateTime=@re_updateTime,"); strSql.Append("textParam1=@textParam1,"); strSql.Append("textParam2=@textParam2,"); strSql.Append("textParam3=@textParam3,"); strSql.Append("textParam4=@textParam4,"); strSql.Append("textParam5=@textParam5"); strSql.Append(" where messageid=@messageid"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 300), new SqlParameter("@UnitName", SqlDbType.VarChar, 300), new SqlParameter("@PhoneNum", SqlDbType.VarChar, 300), new SqlParameter("@telNum", SqlDbType.VarChar, 300), new SqlParameter("@email", SqlDbType.VarChar, 300), new SqlParameter("@QQ", SqlDbType.VarChar, 300), new SqlParameter("@adress", SqlDbType.VarChar, -1), new SqlParameter("@title", SqlDbType.VarChar, 300), new SqlParameter("@content", SqlDbType.Text), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@userName", SqlDbType.VarChar, 300), new SqlParameter("@updateTime", SqlDbType.DateTime), new SqlParameter("@replay", SqlDbType.Text), new SqlParameter("@re_updateTime", SqlDbType.VarChar, 350), new SqlParameter("@textParam1", SqlDbType.VarChar, -1), new SqlParameter("@textParam2", SqlDbType.VarChar, -1), new SqlParameter("@textParam3", SqlDbType.VarChar, -1), new SqlParameter("@textParam4", SqlDbType.VarChar, -1), new SqlParameter("@textParam5", SqlDbType.VarChar, -1), new SqlParameter("@messageid", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.UnitName; parameters[2].Value = model.PhoneNum; parameters[3].Value = model.telNum; parameters[4].Value = model.email; parameters[5].Value = model.QQ; parameters[6].Value = model.adress; parameters[7].Value = model.title; parameters[8].Value = model.content; parameters[9].Value = model.userid; parameters[10].Value = model.userName; parameters[11].Value = model.updateTime; parameters[12].Value = model.replay; parameters[13].Value = model.re_updateTime; parameters[14].Value = model.textParam1; parameters[15].Value = model.textParam2; parameters[16].Value = model.textParam3; parameters[17].Value = model.textParam4; parameters[18].Value = model.textParam5; parameters[19].Value = model.messageid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }