/// <summary>
/// 通过wid获得该微帐号的站点信息,(换成存储过程获得数据)
/// </summary>
/// <param name="wid"></param>
/// <param name="templateskin">模版的虚拟路劲</param>
/// <returns></returns>
public WechatBuilder.Model.wxcodeconfig GetModelByWid(int wid, string templateskin)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append("select top 1 ws.id,wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,ws.remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc");
//strSql.Append(",wxName,wxId,weixinCode,headerpic,wxprovince,wxcity,w.enddate ");
//strSql.Append(" from wx_wsite_setting ws,wx_userweixin w ");
//strSql.Append(" where ws.wId=w.id and w.id=@wId and w.isDelete=0 ");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4)
};
parameters[0].Value = wid;
WechatBuilder.Model.wxcodeconfig config = new WechatBuilder.Model.wxcodeconfig();
SqlDataReader sr = DbHelperSQL.RunProcedure("p_wcode_wsiteinfo", parameters);
while (sr.Read())
{
config.wid = wid;
#region 微信帐号的基本信息
config.wxcode = MyCommFun.ObjToStr(sr["weixinCode"]);
config.wxname = MyCommFun.ObjToStr(sr["wxName"]);
config.wxphoto = MyCommFun.ObjToStr(sr["headerpic"]);
config.wxprovince = MyCommFun.ObjToStr(sr["wxprovince"]);
config.wxcity = MyCommFun.ObjToStr(sr["wxcity"]);
if (DateTime.Parse(sr["enddate"].ToString()) < DateTime.Now)
{ //过期
config.wxstatus = 0;
}
else
{
config.wxstatus = 1;
}
#endregion
#region 微网站的基本信息
config.templateskin = templateskin;
config.sitename = MyCommFun.ObjToStr(sr["wName"]);
config.companyname = MyCommFun.ObjToStr(sr["companyName"]);
config.bgmusic = MyCommFun.ObjToStr(sr["bgMusic"]);
config.bgpic = MyCommFun.ObjToStr(sr["bgPic"]);
config.bgdonghuaid = MyCommFun.Obj2Int(sr["bgDongHuaId"]);
config.wcopyright = MyCommFun.ObjToStr(sr["wCopyright"]);
config.wbrief = MyCommFun.ObjToStr(sr["wBrief"]);
config.remark = MyCommFun.ObjToStr(sr["remark"]);
config.phone = MyCommFun.ObjToStr(sr["phone"]);
config.addr = MyCommFun.ObjToStr(sr["addr"]);
config.addrurl = MyCommFun.ObjToStr(sr["addrUrl"]);
config.email = MyCommFun.ObjToStr(sr["email"]);
config.seotitle = MyCommFun.ObjToStr(sr["seo_title"]);
config.seokeywords = MyCommFun.ObjToStr(sr["seo_keywords"]);
config.seodesc = MyCommFun.ObjToStr(sr["seo_desc"]);
config.topht = MyCommFun.ObjToStr(sr["topcolorHtml"]);
#endregion
}
sr.Close();
return(config);
}
/// <summary>
/// 通过wid获得该微帐号的站点信息,(换成存储过程获得数据)
/// </summary>
/// <param name="wid"></param>
/// <param name="templateskin">模版的虚拟路劲</param>
/// <returns></returns>
public WechatBuilder.Model.wxcodeconfig GetModelByWid(int wid, string templateskin)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append("select top 1 ws.id,wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,ws.remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc");
//strSql.Append(",wxName,wxId,weixinCode,headerpic,wxprovince,wxcity,w.enddate ");
//strSql.Append(" from wx_wsite_setting ws,wx_userweixin w ");
//strSql.Append(" where ws.wId=w.id and w.id=@wId and w.isDelete=0 ");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4)
};
parameters[0].Value = wid;
WechatBuilder.Model.wxcodeconfig config = new WechatBuilder.Model.wxcodeconfig();
SqlDataReader sr = DbHelperSQL.RunProcedure("p_wcode_wsiteinfo", parameters);
while (sr.Read())
{
config.wid = wid;
#region 微信帐号的基本信息
config.wxcode = MyCommFun.ObjToStr(sr["weixinCode"]);
config.wxname = MyCommFun.ObjToStr(sr["wxName"]);
config.wxphoto = MyCommFun.ObjToStr(sr["headerpic"]);
config.wxprovince = MyCommFun.ObjToStr(sr["wxprovince"]);
config.wxcity = MyCommFun.ObjToStr(sr["wxcity"]);
if (DateTime.Parse(sr["enddate"].ToString()) < DateTime.Now)
{ //过期
config.wxstatus = 0;
}
else
{
config.wxstatus = 1;
}
#endregion
#region 微网站的基本信息
config.templateskin = templateskin;
config.sitename = MyCommFun.ObjToStr(sr["wName"]);
config.companyname = MyCommFun.ObjToStr(sr["companyName"]);
config.bgmusic = MyCommFun.ObjToStr(sr["bgMusic"]);
config.bgpic = MyCommFun.ObjToStr(sr["bgPic"]);
config.bgdonghuaid = MyCommFun.Obj2Int(sr["bgDongHuaId"]);
config.wcopyright = MyCommFun.ObjToStr(sr["wCopyright"]);
config.wbrief = MyCommFun.ObjToStr(sr["wBrief"]);
config.remark = MyCommFun.ObjToStr(sr["remark"]);
config.phone = MyCommFun.ObjToStr(sr["phone"]);
config.addr = MyCommFun.ObjToStr(sr["addr"]);
config.addrurl = MyCommFun.ObjToStr(sr["addrUrl"]);
config.email = MyCommFun.ObjToStr(sr["email"]);
config.seotitle = MyCommFun.ObjToStr(sr["seo_title"]);
config.seokeywords = MyCommFun.ObjToStr(sr["seo_keywords"]);
config.seodesc = MyCommFun.ObjToStr(sr["seo_desc"]);
config.topht = MyCommFun.ObjToStr(sr["topcolorHtml"]);
#endregion
}
sr.Close();
return config;
}
