/// <summary> /// 通过wid获得该微帐号的站点信息,(换成存储过程获得数据) /// </summary> /// <param name="wid"></param> /// <param name="templateskin">模版的虚拟路劲</param> /// <returns></returns> public MxWeiXinPF.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; MxWeiXinPF.Model.wxcodeconfig config = new MxWeiXinPF.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 MxWeiXinPF.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; MxWeiXinPF.Model.wxcodeconfig config = new MxWeiXinPF.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); }