private void ShowInfo() { Model.wx_userweixin weixin = GetWeiXinCode(); lblWSiteUrl.Text = MyCommFun.getWebSite() + "/index.aspx?wid=" + weixin.id; IList <WechatBuilder.Model.wx_wsite_setting> modellist = bll.GetModelList("wId=" + weixin.id); if (modellist == null || modellist.Count <= 0) { return; } WechatBuilder.Model.wx_wsite_setting model = modellist[0]; this.lblsiteId.Text = model.id.ToString(); this.txtwName.Text = model.wName; this.txtcompanyName.Text = model.companyName; this.txtbgMusic.Text = model.bgMusic; this.txtbgPic.Text = model.bgPic; this.txtbgDongHuaId.Text = model.bgDongHuaId.ToString(); this.txtwCopyright.Text = model.wCopyright; this.txtwBrief.Text = model.wBrief; this.txtphone.Text = model.phone; this.txtaddr.Text = model.addr; this.txtaddrUrl.Text = model.addrUrl; this.txtseo_title.Text = model.seo_title; this.txtseo_keywords.Text = model.seo_keywords; this.txtseo_desc.Text = model.seo_desc; //微信回复信息 DataSet ds = rBll.GetRuleContent(1, " modelFunctionName='微网站' and wId=" + weixin.id); if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) { return; } DataRow dr = ds.Tables[0].Rows[0]; lblrId.Text = MyCommFun.ObjToStr(dr["id"], "0"); lblrcId.Text = MyCommFun.ObjToStr(dr["cid"], "0"); txtreqKeywords.Text = MyCommFun.ObjToStr(dr["reqKeywords"]); if (MyCommFun.ObjToStr(dr["isLikeSearch"]) != "") { if (dr["isLikeSearch"].ToString().ToLower() == "false") { this.rblisLikeSearch.SelectedValue = "0"; } else { this.rblisLikeSearch.SelectedValue = "1"; } } txtTitle.Value = MyCommFun.ObjToStr(dr["rContent"]); txtImgUrl.Text = MyCommFun.ObjToStr(dr["picUrl"]); txtContent.InnerText = MyCommFun.ObjToStr(dr["rContent2"]); //lblWSiteUrl.Text = MyCommFun.ObjToStr(dr[""], lblWSiteUrl.Text); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "wx_wsite_setting"; * parameters[1].Value = "id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 通过wid获得该微帐号的站点信息 /// </summary> public WechatBuilder.Model.wx_wsite_setting GetModelByWid(int wid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2 from wx_wsite_setting "); strSql.Append(" where wId=@wId"); SqlParameter[] parameters = { new SqlParameter("@wId", SqlDbType.Int, 4) }; parameters[0].Value = wid; WechatBuilder.Model.wx_wsite_setting model = new WechatBuilder.Model.wx_wsite_setting(); 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(WechatBuilder.Model.wx_wsite_setting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into wx_wsite_setting("); strSql.Append("wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2)"); strSql.Append(" values ("); strSql.Append("@wId,@wName,@companyName,@bgMusic,@bgPic,@bgDongHuaId,@wCopyright,@wBrief,@remark,@phone,@addr,@addrUrl,@email,@seo_title,@seo_keywords,@seo_desc,@createDate,@extInt,@extStr,@extStr2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@wId", SqlDbType.Int, 4), new SqlParameter("@wName", SqlDbType.VarChar, 500), new SqlParameter("@companyName", SqlDbType.VarChar, 500), new SqlParameter("@bgMusic", SqlDbType.VarChar, 800), new SqlParameter("@bgPic", SqlDbType.VarChar, 800), new SqlParameter("@bgDongHuaId", SqlDbType.Int, 4), new SqlParameter("@wCopyright", SqlDbType.VarChar, 500), new SqlParameter("@wBrief", SqlDbType.VarChar, 500), new SqlParameter("@remark", SqlDbType.VarChar, 2000), new SqlParameter("@phone", SqlDbType.VarChar, 200), new SqlParameter("@addr", SqlDbType.VarChar, 1000), new SqlParameter("@addrUrl", SqlDbType.VarChar, 1000), new SqlParameter("@email", SqlDbType.VarChar, 200), new SqlParameter("@seo_title", SqlDbType.VarChar, 500), new SqlParameter("@seo_keywords", SqlDbType.VarChar, 500), new SqlParameter("@seo_desc", SqlDbType.VarChar, 1000), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@extInt", SqlDbType.Int, 4), new SqlParameter("@extStr", SqlDbType.VarChar, 500), new SqlParameter("@extStr2", SqlDbType.VarChar, 800) }; parameters[0].Value = model.wId; parameters[1].Value = model.wName; parameters[2].Value = model.companyName; parameters[3].Value = model.bgMusic; parameters[4].Value = model.bgPic; parameters[5].Value = model.bgDongHuaId; parameters[6].Value = model.wCopyright; parameters[7].Value = model.wBrief; parameters[8].Value = model.remark; parameters[9].Value = model.phone; parameters[10].Value = model.addr; parameters[11].Value = model.addrUrl; parameters[12].Value = model.email; parameters[13].Value = model.seo_title; parameters[14].Value = model.seo_keywords; parameters[15].Value = model.seo_desc; parameters[16].Value = model.createDate; parameters[17].Value = model.extInt; parameters[18].Value = model.extStr; parameters[19].Value = model.extStr2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WechatBuilder.Model.wx_wsite_setting DataRowToModel(DataRow row) { WechatBuilder.Model.wx_wsite_setting model = new WechatBuilder.Model.wx_wsite_setting(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["wId"] != null && row["wId"].ToString() != "") { model.wId = int.Parse(row["wId"].ToString()); } if (row["wName"] != null) { model.wName = row["wName"].ToString(); } if (row["companyName"] != null) { model.companyName = row["companyName"].ToString(); } if (row["bgMusic"] != null) { model.bgMusic = row["bgMusic"].ToString(); } if (row["bgPic"] != null) { model.bgPic = row["bgPic"].ToString(); } if (row["bgDongHuaId"] != null && row["bgDongHuaId"].ToString() != "") { model.bgDongHuaId = int.Parse(row["bgDongHuaId"].ToString()); } if (row["wCopyright"] != null) { model.wCopyright = row["wCopyright"].ToString(); } if (row["wBrief"] != null) { model.wBrief = row["wBrief"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["phone"] != null) { model.phone = row["phone"].ToString(); } if (row["addr"] != null) { model.addr = row["addr"].ToString(); } if (row["addrUrl"] != null) { model.addrUrl = row["addrUrl"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["seo_title"] != null) { model.seo_title = row["seo_title"].ToString(); } if (row["seo_keywords"] != null) { model.seo_keywords = row["seo_keywords"].ToString(); } if (row["seo_desc"] != null) { model.seo_desc = row["seo_desc"].ToString(); } if (row["createDate"] != null && row["createDate"].ToString() != "") { model.createDate = DateTime.Parse(row["createDate"].ToString()); } if (row["extInt"] != null && row["extInt"].ToString() != "") { model.extInt = int.Parse(row["extInt"].ToString()); } if (row["extStr"] != null) { model.extStr = row["extStr"].ToString(); } if (row["extStr2"] != null) { model.extStr2 = row["extStr2"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WechatBuilder.Model.wx_wsite_setting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_wsite_setting set "); strSql.Append("wId=@wId,"); strSql.Append("wName=@wName,"); strSql.Append("companyName=@companyName,"); strSql.Append("bgMusic=@bgMusic,"); strSql.Append("bgPic=@bgPic,"); strSql.Append("bgDongHuaId=@bgDongHuaId,"); strSql.Append("wCopyright=@wCopyright,"); strSql.Append("wBrief=@wBrief,"); strSql.Append("remark=@remark,"); strSql.Append("phone=@phone,"); strSql.Append("addr=@addr,"); strSql.Append("addrUrl=@addrUrl,"); strSql.Append("email=@email,"); strSql.Append("seo_title=@seo_title,"); strSql.Append("seo_keywords=@seo_keywords,"); strSql.Append("seo_desc=@seo_desc,"); strSql.Append("createDate=@createDate,"); strSql.Append("extInt=@extInt,"); strSql.Append("extStr=@extStr,"); strSql.Append("extStr2=@extStr2"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@wId", SqlDbType.Int, 4), new SqlParameter("@wName", SqlDbType.VarChar, 500), new SqlParameter("@companyName", SqlDbType.VarChar, 500), new SqlParameter("@bgMusic", SqlDbType.VarChar, 800), new SqlParameter("@bgPic", SqlDbType.VarChar, 800), new SqlParameter("@bgDongHuaId", SqlDbType.Int, 4), new SqlParameter("@wCopyright", SqlDbType.VarChar, 500), new SqlParameter("@wBrief", SqlDbType.VarChar, 500), new SqlParameter("@remark", SqlDbType.VarChar, 2000), new SqlParameter("@phone", SqlDbType.VarChar, 200), new SqlParameter("@addr", SqlDbType.VarChar, 1000), new SqlParameter("@addrUrl", SqlDbType.VarChar, 1000), new SqlParameter("@email", SqlDbType.VarChar, 200), new SqlParameter("@seo_title", SqlDbType.VarChar, 500), new SqlParameter("@seo_keywords", SqlDbType.VarChar, 500), new SqlParameter("@seo_desc", SqlDbType.VarChar, 1000), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@extInt", SqlDbType.Int, 4), new SqlParameter("@extStr", SqlDbType.VarChar, 500), new SqlParameter("@extStr2", SqlDbType.VarChar, 800), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.wId; parameters[1].Value = model.wName; parameters[2].Value = model.companyName; parameters[3].Value = model.bgMusic; parameters[4].Value = model.bgPic; parameters[5].Value = model.bgDongHuaId; parameters[6].Value = model.wCopyright; parameters[7].Value = model.wBrief; parameters[8].Value = model.remark; parameters[9].Value = model.phone; parameters[10].Value = model.addr; parameters[11].Value = model.addrUrl; parameters[12].Value = model.email; parameters[13].Value = model.seo_title; parameters[14].Value = model.seo_keywords; parameters[15].Value = model.seo_desc; parameters[16].Value = model.createDate; parameters[17].Value = model.extInt; parameters[18].Value = model.extStr; parameters[19].Value = model.extStr2; parameters[20].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/* /// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetList(int PageSize,int PageIndex,string strWhere) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar,1000), }; parameters[0].Value = "wx_wsite_setting"; parameters[1].Value = "id"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 通过wid获得该微帐号的站点信息 /// </summary> public WechatBuilder.Model.wx_wsite_setting GetModelByWid(int wid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2 from wx_wsite_setting "); strSql.Append(" where wId=@wId"); SqlParameter[] parameters = { new SqlParameter("@wId", SqlDbType.Int,4) }; parameters[0].Value = wid; WechatBuilder.Model.wx_wsite_setting model = new WechatBuilder.Model.wx_wsite_setting(); 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 WechatBuilder.Model.wx_wsite_setting DataRowToModel(DataRow row) { WechatBuilder.Model.wx_wsite_setting model=new WechatBuilder.Model.wx_wsite_setting(); if (row != null) { if(row["id"]!=null && row["id"].ToString()!="") { model.id=int.Parse(row["id"].ToString()); } if(row["wId"]!=null && row["wId"].ToString()!="") { model.wId=int.Parse(row["wId"].ToString()); } if(row["wName"]!=null) { model.wName=row["wName"].ToString(); } if(row["companyName"]!=null) { model.companyName=row["companyName"].ToString(); } if(row["bgMusic"]!=null) { model.bgMusic=row["bgMusic"].ToString(); } if(row["bgPic"]!=null) { model.bgPic=row["bgPic"].ToString(); } if(row["bgDongHuaId"]!=null && row["bgDongHuaId"].ToString()!="") { model.bgDongHuaId=int.Parse(row["bgDongHuaId"].ToString()); } if(row["wCopyright"]!=null) { model.wCopyright=row["wCopyright"].ToString(); } if(row["wBrief"]!=null) { model.wBrief=row["wBrief"].ToString(); } if(row["remark"]!=null) { model.remark=row["remark"].ToString(); } if(row["phone"]!=null) { model.phone=row["phone"].ToString(); } if(row["addr"]!=null) { model.addr=row["addr"].ToString(); } if(row["addrUrl"]!=null) { model.addrUrl=row["addrUrl"].ToString(); } if(row["email"]!=null) { model.email=row["email"].ToString(); } if(row["seo_title"]!=null) { model.seo_title=row["seo_title"].ToString(); } if(row["seo_keywords"]!=null) { model.seo_keywords=row["seo_keywords"].ToString(); } if(row["seo_desc"]!=null) { model.seo_desc=row["seo_desc"].ToString(); } if(row["createDate"]!=null && row["createDate"].ToString()!="") { model.createDate=DateTime.Parse(row["createDate"].ToString()); } if(row["extInt"]!=null && row["extInt"].ToString()!="") { model.extInt=int.Parse(row["extInt"].ToString()); } if(row["extStr"]!=null) { model.extStr=row["extStr"].ToString(); } if(row["extStr2"]!=null) { model.extStr2=row["extStr2"].ToString(); } } return model; }
/// <summary> /// 保存配置信息 /// </summary> protected void btnSubmit_Click(object sender, EventArgs e) { WechatBuilder.Model.wx_wsite_setting model = new WechatBuilder.Model.wx_wsite_setting(); try { Model.wx_userweixin weixin = GetWeiXinCode(); int wId = weixin.id; string wName = this.txtwName.Text; string companyName = this.txtcompanyName.Text; string bgMusic = this.txtbgMusic.Text; string bgPic = this.txtbgPic.Text; int bgDongHuaId = int.Parse(this.txtbgDongHuaId.Text); string wCopyright = this.txtwCopyright.Text; string wBrief = this.txtwBrief.Text; string phone = this.txtphone.Text; string addr = this.txtaddr.Text; string addrUrl = this.txtaddrUrl.Text; string seo_title = this.txtseo_title.Text; string seo_keywords = this.txtseo_keywords.Text; string seo_desc = this.txtseo_desc.Text; DateTime createDate = DateTime.Now; int id = int.Parse(lblsiteId.Text.Trim()); if (id != 0) { //修改 model = bll.GetModel(id); } else { //添加 model.wId = wId; model.createDate = createDate; } model.wName = wName; model.companyName = companyName; model.bgMusic = bgMusic; model.bgPic = bgPic; model.bgDongHuaId = bgDongHuaId; model.wCopyright = wCopyright; model.wBrief = wBrief; model.remark = ""; model.phone = phone; model.addr = addr; model.addrUrl = addrUrl; model.email = ""; model.seo_title = seo_title; model.seo_keywords = seo_keywords; model.seo_desc = seo_desc; if (id != 0) { bll.Update(model); } else { id= bll.Add(model); } //编辑关键词回复 EditWXResponseKW(id, wId); AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改微网站设置"); //记录日志 JscriptMsg("微网站设置成功!", "wSiteSetting.aspx", "Success"); } catch { JscriptMsg("微网站设置失败!", "", "Error"); } }
/// <summary> /// 保存配置信息 /// </summary> protected void btnSubmit_Click(object sender, EventArgs e) { WechatBuilder.Model.wx_wsite_setting model = new WechatBuilder.Model.wx_wsite_setting(); try { Model.wx_userweixin weixin = GetWeiXinCode(); int wId = weixin.id; string wName = this.txtwName.Text; string companyName = this.txtcompanyName.Text; string bgMusic = this.txtbgMusic.Text; string bgPic = this.txtbgPic.Text; int bgDongHuaId = int.Parse(this.txtbgDongHuaId.Text); string wCopyright = this.txtwCopyright.Text; string wBrief = this.txtwBrief.Text; string phone = this.txtphone.Text; string addr = this.txtaddr.Text; string addrUrl = this.txtaddrUrl.Text; string seo_title = this.txtseo_title.Text; string seo_keywords = this.txtseo_keywords.Text; string seo_desc = this.txtseo_desc.Text; DateTime createDate = DateTime.Now; int id = int.Parse(lblsiteId.Text.Trim()); if (id != 0) { //修改 model = bll.GetModel(id); } else { //添加 model.wId = wId; model.createDate = createDate; } model.wName = wName; model.companyName = companyName; model.bgMusic = bgMusic; model.bgPic = bgPic; model.bgDongHuaId = bgDongHuaId; model.wCopyright = wCopyright; model.wBrief = wBrief; model.remark = ""; model.phone = phone; model.addr = addr; model.addrUrl = addrUrl; model.email = ""; model.seo_title = seo_title; model.seo_keywords = seo_keywords; model.seo_desc = seo_desc; if (id != 0) { bll.Update(model); } else { id = bll.Add(model); } //编辑关键词回复 EditWXResponseKW(id, wId); AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改微网站设置"); //记录日志 JscriptMsg("微网站设置成功!", "wSiteSetting.aspx", "Success"); } catch { JscriptMsg("微网站设置失败!", "", "Error"); } }