/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_WebSiteconfig GetModel(int siteid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 siteid,webName,weburl,title,keyword,Description,upload,Copyright,IcpRecord,adress,telphone,mobiephone,fax,email,contactperson,textParam1,textParam2,textParam3,textParam4,textParam5,logo,mLogo,qq,weixin,tel from C_WebSiteconfig "); strSql.Append(" where siteid=@siteid"); SqlParameter[] parameters = { new SqlParameter("@siteid", SqlDbType.Int, 4) }; parameters[0].Value = siteid; Cms.Model.C_WebSiteconfig model = new Cms.Model.C_WebSiteconfig(); 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_WebSiteconfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into C_WebSiteconfig("); strSql.Append("webName,weburl,title,keyword,Description,upload,Copyright,IcpRecord,adress,telphone,mobiephone,fax,email,contactperson,textParam1,textParam2,textParam3,textParam4,textParam5,logo,mLogo,qq,weixin,tel)"); strSql.Append(" values ("); strSql.Append("@webName,@weburl,@title,@keyword,@Description,@upload,@Copyright,@IcpRecord,@adress,@telphone,@mobiephone,@fax,@email,@contactperson,@textParam1,@textParam2,@textParam3,@textParam4,@textParam5,@logo,@mLogo,@qq,@weixin,@tel)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@webName", SqlDbType.VarChar, -1), new SqlParameter("@weburl", SqlDbType.VarChar, -1), new SqlParameter("@title", SqlDbType.VarChar, -1), new SqlParameter("@keyword", SqlDbType.VarChar, -1), new SqlParameter("@Description", SqlDbType.VarChar, -1), new SqlParameter("@upload", SqlDbType.VarChar, -1), new SqlParameter("@Copyright", SqlDbType.VarChar, -1), new SqlParameter("@IcpRecord", SqlDbType.VarChar, -1), new SqlParameter("@adress", SqlDbType.VarChar, -1), new SqlParameter("@telphone", SqlDbType.VarChar, -1), new SqlParameter("@mobiephone", SqlDbType.VarChar, -1), new SqlParameter("@fax", SqlDbType.VarChar, -1), new SqlParameter("@email", SqlDbType.VarChar, -1), new SqlParameter("@contactperson", SqlDbType.VarChar, -1), 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("@logo", SqlDbType.Text), new SqlParameter("@mLogo", SqlDbType.Text), new SqlParameter("@qq", SqlDbType.VarChar, 50), new SqlParameter("@weixin", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50) }; parameters[0].Value = model.webName; parameters[1].Value = model.weburl; parameters[2].Value = model.title; parameters[3].Value = model.keyword; parameters[4].Value = model.Description; parameters[5].Value = model.upload; parameters[6].Value = model.Copyright; parameters[7].Value = model.IcpRecord; parameters[8].Value = model.adress; parameters[9].Value = model.telphone; parameters[10].Value = model.mobiephone; parameters[11].Value = model.fax; parameters[12].Value = model.email; parameters[13].Value = model.contactperson; 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.logo; parameters[20].Value = model.mLogo; parameters[21].Value = model.qq; parameters[22].Value = model.weixin; parameters[23].Value = model.tel; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_WebSiteconfig DataRowToModel(DataRow row) { Cms.Model.C_WebSiteconfig model = new Cms.Model.C_WebSiteconfig(); if (row != null) { if (row["siteid"] != null && row["siteid"].ToString() != "") { model.siteid = int.Parse(row["siteid"].ToString()); } if (row["webName"] != null) { model.webName = row["webName"].ToString(); } if (row["weburl"] != null) { model.weburl = row["weburl"].ToString(); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["keyword"] != null) { model.keyword = row["keyword"].ToString(); } if (row["Description"] != null) { model.Description = row["Description"].ToString(); } if (row["upload"] != null) { model.upload = row["upload"].ToString(); } if (row["Copyright"] != null) { model.Copyright = row["Copyright"].ToString(); } if (row["IcpRecord"] != null) { model.IcpRecord = row["IcpRecord"].ToString(); } if (row["adress"] != null) { model.adress = row["adress"].ToString(); } if (row["telphone"] != null) { model.telphone = row["telphone"].ToString(); } if (row["mobiephone"] != null) { model.mobiephone = row["mobiephone"].ToString(); } if (row["fax"] != null) { model.fax = row["fax"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["contactperson"] != null) { model.contactperson = row["contactperson"].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(); } if (row["logo"] != null) { model.logo = row["logo"].ToString(); } if (row["mLogo"] != null) { model.mLogo = row["mLogo"].ToString(); } if (row["qq"] != null) { model.qq = row["qq"].ToString(); } if (row["weixin"] != null) { model.weixin = row["weixin"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cms.Model.C_WebSiteconfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update C_WebSiteconfig set "); strSql.Append("webName=@webName,"); strSql.Append("weburl=@weburl,"); strSql.Append("title=@title,"); strSql.Append("keyword=@keyword,"); strSql.Append("Description=@Description,"); strSql.Append("upload=@upload,"); strSql.Append("Copyright=@Copyright,"); strSql.Append("IcpRecord=@IcpRecord,"); strSql.Append("adress=@adress,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobiephone=@mobiephone,"); strSql.Append("fax=@fax,"); strSql.Append("email=@email,"); strSql.Append("contactperson=@contactperson,"); strSql.Append("textParam1=@textParam1,"); strSql.Append("textParam2=@textParam2,"); strSql.Append("textParam3=@textParam3,"); strSql.Append("textParam4=@textParam4,"); strSql.Append("textParam5=@textParam5,"); strSql.Append("logo=@logo,"); strSql.Append("mLogo=@mLogo,"); strSql.Append("qq=@qq,"); strSql.Append("weixin=@weixin,"); strSql.Append("tel=@tel"); strSql.Append(" where siteid=@siteid"); SqlParameter[] parameters = { new SqlParameter("@webName", SqlDbType.VarChar, -1), new SqlParameter("@weburl", SqlDbType.VarChar, -1), new SqlParameter("@title", SqlDbType.VarChar, -1), new SqlParameter("@keyword", SqlDbType.VarChar, -1), new SqlParameter("@Description", SqlDbType.VarChar, -1), new SqlParameter("@upload", SqlDbType.VarChar, -1), new SqlParameter("@Copyright", SqlDbType.VarChar, -1), new SqlParameter("@IcpRecord", SqlDbType.VarChar, -1), new SqlParameter("@adress", SqlDbType.VarChar, -1), new SqlParameter("@telphone", SqlDbType.VarChar, -1), new SqlParameter("@mobiephone", SqlDbType.VarChar, -1), new SqlParameter("@fax", SqlDbType.VarChar, -1), new SqlParameter("@email", SqlDbType.VarChar, -1), new SqlParameter("@contactperson", SqlDbType.VarChar, -1), 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("@logo", SqlDbType.Text), new SqlParameter("@mLogo", SqlDbType.Text), new SqlParameter("@qq", SqlDbType.VarChar, 50), new SqlParameter("@weixin", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@siteid", SqlDbType.Int, 4) }; parameters[0].Value = model.webName; parameters[1].Value = model.weburl; parameters[2].Value = model.title; parameters[3].Value = model.keyword; parameters[4].Value = model.Description; parameters[5].Value = model.upload; parameters[6].Value = model.Copyright; parameters[7].Value = model.IcpRecord; parameters[8].Value = model.adress; parameters[9].Value = model.telphone; parameters[10].Value = model.mobiephone; parameters[11].Value = model.fax; parameters[12].Value = model.email; parameters[13].Value = model.contactperson; 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.logo; parameters[20].Value = model.mLogo; parameters[21].Value = model.qq; parameters[22].Value = model.weixin; parameters[23].Value = model.tel; parameters[24].Value = model.siteid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }