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");
}
}
