/// <summary>
/// 绑定积分信息
/// </summary>
/// <param name="user"></param>
private void bindJiFen(Model.wx_ucard_users user)
{
StringBuilder jiStr = new StringBuilder("");
jiStr.Append("<div class=\"jifen-box\" style=\"margin-top:13px;\"><ul class=\"zongjifen\">");
jiStr.Append("<li> <div class=\"fengexian\"> <p>会员总积分</p> <span>" + MyCommFun.ObjToStr(user.ttScore, "0") + "</span> </div> </li>");
jiStr.Append(" <li><a href=\"qiandao.aspx?wid=" + wid + "&sid=" + sid + "&openid=" + openid + "\">");
jiStr.Append(" <div class=\"fengexian\"> <p>签到积分</p> <span>" + MyCommFun.ObjToStr(user.qdScore, "0") + "</span> </div> </a></li>");
jiStr.Append(" <li><a href=\"shopping_history.aspx?wid=" + wid + "&sid=" + sid + "&openid=" + openid + "\">");
jiStr.Append("<p>消费积分</p> <span>" + MyCommFun.ObjToStr(user.consumeScore, "0") + "</span></a></li>");
jiStr.Append(" </ul><div class=\"clr\"></div></div>");
litJiFen.Text = jiStr.ToString();
}
/// <summary>
/// 取商品列表，混合调用
/// </summary>
public DataTable ProductIndexPage()
{
Tag tag = this.Document.CurrentRenderingTag;
//数据条数
var topTag = tag.Attributes["top"];
int top = MyCommFun.Obj2Int(topTag.Value.GetValue());
//取类ＩＤ
var classlayer = tag.Attributes["cid"];
int classid = MyCommFun.Obj2Int(classlayer.Value.GetValue());
//自定义where
var whereTag = tag.Attributes["where"];
string mywhere = MyCommFun.ObjToStr(whereTag.Value.GetValue());
var orderByTag = tag.Attributes["orderby"];
string orderby = MyCommFun.ObjToStr(orderByTag.Value.GetValue());
string where = where = " wid=" + wid;
if (classid != 0)
{
where += " and categoryId=" + classid;
}
where += mywhere;
DataSet productlist = new DataSet();
DAL.wx_shop_product artDal = new DAL.wx_shop_product();
productlist = artDal.GetList(top, where, orderby);
if (productlist != null && productlist.Tables.Count > 0 && productlist.Tables[0].Rows.Count > 0)
{
DataRow dr;
for (int i = 0; i < productlist.Tables[0].Rows.Count; i++)
{
dr = productlist.Tables[0].Rows[i];
dr["link_url"] = MyCommFun.urlAddOpenid("detail.aspx?wid=" + wid + "&pid=" + dr["id"].ToString(), openid);
productlist.AcceptChanges();
}
}
DataTable ds = new DataTable();
ds = productlist.Tables[0].Copy();
return(ds);
}
private void RptBind(int _channel_id, int _category_id, string _strWhere, string _orderby)
{
Model.wx_userweixin weixin = GetWeiXinCode();
this.page = MXRequest.GetQueryInt("page", 1);
this.txtKeywords.Text = this.keywords;
//图表或列表显示
BLL.article bll = new BLL.article();
DataSet ds = bll.GetWCodeList(weixin.id, _channel_id, _category_id, this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr;
int cout = ds.Tables[0].Rows.Count;
for (int i = 0; i < cout; i++)
{
dr = ds.Tables[0].Rows[i];
string linkUrl = MyCommFun.ObjToStr(dr["link_url"]);
if (linkUrl.Length > 0)
{
//外链地址
dr["link_url"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\">" + linkUrl + "</a>";
}
else
{
dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/content.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&aid=" + dr["id"].ToString() + "</a>";
// dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/detail.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&aid=" + dr["id"] + "</a>";
}
}
ds.AcceptChanges();
}
this.rptList1.DataSource = ds;
this.rptList1.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("wx_article_page_list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}&page={4}",
_channel_id.ToString(), _category_id.ToString(), this.keywords, this.property, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void ShowInfo()
{
IList <Model.wx_ucard_score> syslist = scoreBll.GetModelList("sId=" + sid);
if (syslist == null || syslist.Count <= 0)
{
return;
}
Model.wx_ucard_score score = syslist[0];
hidid.Value = score.id.ToString();
txtuserdContent.Value = score.userdContent;
txtscoreRegular.Value = score.scoreRegular;
txtqiandaoScore.Text = MyCommFun.ObjToStr(score.qiandaoScore.Value);
txtqiandao6Score.Text = MyCommFun.ObjToStr(score.qiandao6Score.Value);
txtconsumeMoney.Text = MyCommFun.ObjToStr(score.consumeMoney.Value);
txtconsumeMoneyScore.Text = MyCommFun.ObjToStr(score.consumeMoneyScore.Value);
//绑定等级
BLL.wx_ucard_udegree dBll = new wx_ucard_udegree();
IList <Model.wx_ucard_udegree> itemlist = dBll.GetModelList("sId=" + sid + " order by degreeNum asc");
if (itemlist != null && itemlist.Count > 0)
{
int count = itemlist.Count;
TextBox txtLevelName;
TextBox txtLevelMin;
TextBox txtLevelMax;
Model.wx_ucard_udegree itemEntity = new Model.wx_ucard_udegree();
for (int i = 1; i <= count; i++)
{
itemEntity = itemlist[(i - 1)];
txtLevelName = this.FindControl("txtLevel" + i + "Name") as TextBox;
txtLevelMin = this.FindControl("txtLevel" + i + "Min") as TextBox;
txtLevelMax = this.FindControl("txtLevel" + i + "Max") as TextBox;
txtLevelName.Text = itemEntity.callName;
txtLevelMin.Text = itemEntity.score_min.Value.ToString();
txtLevelMax.Text = itemEntity.score_max.Value.ToString();
}
}
}
/// <summary>
/// 关键词查询，找到该规则对应的主键ID,使用存储过程
/// </summary>
/// <param name="wid">微帐号主键Id</param>
/// <param name="keywords">关键词</param>
/// <param name="responseType">回复类型</param>
/// <param name="modelFunctionName">模块名称</param>
/// <param name="modelFunctionId">模块Id</param>
/// <returns></returns>
public int GetRuleIdByKeyWords(int wid, string keywords, out int responseType, out string modelFunctionName, out int modelFunctionId)
{
int ret = 0;
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@keywords", SqlDbType.VarChar, 500),
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@responseType", SqlDbType.Int, 4),
new SqlParameter("@modelFunctionName", SqlDbType.VarChar, 200),
new SqlParameter("@modelFunctionId", SqlDbType.Int, 4)
};
parameters[0].Value = wid;
parameters[1].Value = keywords;
parameters[2].Value = 0;
parameters[2].Direction = ParameterDirection.Output;
parameters[3].Value = 0;
parameters[3].Direction = ParameterDirection.Output;
parameters[4].Value = "";
parameters[4].Direction = ParameterDirection.Output;
parameters[5].Value = 0;
parameters[5].Direction = ParameterDirection.Output;
SqlDataReader sr = DbHelperSQL.RunProcedure("p_query_keywords", parameters);
//while (sr.Read())
//{
// ret = int.Parse(sr["id"].ToString());
//}
sr.Close();
ret = MyCommFun.Obj2Int(parameters[2].Value);
responseType = MyCommFun.Obj2Int(parameters[3].Value);
modelFunctionName = MyCommFun.ObjToStr(parameters[4].Value);
modelFunctionId = MyCommFun.Obj2Int(parameters[5].Value);
return(ret);
}
private void ShowInfo(int _id)
{
//获取实体对象
ModelInfo = bll.GetModel(_id);
//规格名称
this.txt_sName.Text = ModelInfo.sName;
//计量单位
this.txt_sUnit.Text = ModelInfo.sUnit;
//重量
this.txt_sWeight.Text = MyCommFun.ObjToStr(ModelInfo.sWeight);
//体积
this.txt_sVolume.Text = MyCommFun.ObjToStr(ModelInfo.sVolume);
//价格
this.txt_sPrice.Text = MyCommFun.ObjToStr(ModelInfo.sPrice);
//排序序号
this.txtSortid.Text = MyCommFun.ObjToStr(ModelInfo.sSortNum);
//备注
//this.txt_Remark.Text = ModelInfo.sRemark;
}
private void ShowInfo(int _id)
{
//获取实体对象
ModelInfo = bll.GetModel(_id);
//收料编号
txt_BNum.Text = ModelInfo.BNum;
//存放仓库
ddl_WareHouse.SelectedValue = ModelInfo.WareHouse;
//客户姓名
txt_CustomerName.Text = ModelInfo.CustomerName;
//移动电话
txt_Mobile.Text = ModelInfo.Mobile;
//固定电话
txt_Tel.Text = ModelInfo.Tel;
//代发银行
ddl_BankName.SelectedValue = ModelInfo.BankName;
//银行账号
txt_BankAccount.Text = ModelInfo.BankAccount;
//户名
txt_AccountName.Text = ModelInfo.AccountName;
//产品名称ID
ddl_ProductName.SelectedValue = MyCommFun.ObjToStr(ModelInfo.ProjectId);
//产品规格ID
ddl_ProductStandard.SelectedValue = MyCommFun.ObjToStr(ModelInfo.ProductStandardId);
//单位
txt_Unit.Text = ModelInfo.Unit;
//毛重
txt_GrossWeight.Text = MyCommFun.ObjToStr(ModelInfo.GrossWeight);
//皮重
txt_Tare.Text = MyCommFun.ObjToStr(ModelInfo.Tare);
//净重
txt_NetWeight.Value = MyCommFun.ObjToStr(ModelInfo.NetWeight);
//价格
txt_Price.Text = MyCommFun.ObjToStr(ModelInfo.Price);
//金额
txt_Amount.Value = MyCommFun.ObjToStr(ModelInfo.Amount);
//备注
this.txt_Remark.Text = ModelInfo.Remark;
}
private void ShowInfo(int _id)
{
litpwdtip.Text = "不填则不修改密码";
BLL.manager bll = new BLL.manager();
Model.manager model = bll.GetModel(_id);
//ddlRoleId.SelectedValue = model.role_id.ToString();
if (model.is_lock == 0)
{
cbIsLock.Checked = true;
}
else
{
cbIsLock.Checked = false;
}
txtUserName.Text = model.user_name;
txtUserName.ReadOnly = true;
txtUserName.Attributes.Remove("ajaxurl");
txtRealName.Text = model.real_name;
txtTelephone.Text = model.telephone;
txtEmail.Text = model.email;
ddlProvince.SelectedValue = model.province;
ddlCity.SelectedValue = model.city;
txtArea.Text = model.county;
txtqq.Text = model.qq;
txtEmail.Text = model.email;
txtSortid.Text = MyCommFun.ObjToStr(model.sort_id); // model.sort_id;
txtRemark.Text = model.remark;
//代理商信息
Model.wx_agent_info agentinfo = aBll.GetAgentModel(_id);
txtagentPrice.Text = agentinfo.agentPrice.Value.ToString();
txtsqJine.Text = agentinfo.sqJine.Value.ToString();
txtcompanyName.Text = agentinfo.companyInfo;
ddlagentType.SelectedValue = agentinfo.agentType.Value.ToString();
ddlagentLevel.SelectedValue = agentinfo.agentLevel;
txtagentArea.Text = agentinfo.agentArea;
txtindustry.Text = agentinfo.industry;
}
/// <summary>
/// 绑定页面的repeater活动列表
/// </summary>
/// <param name="currentPage"></param>
public void BindRepeater(int currentPage)
{
int RecordCount = 0;
// currentPage -= 1;
DataSet hdDt = hdBll.GetPageList(" typeId in (select id from wx_product_type where wid=" + wid + " and store_id=" + pid + ")", pageSize, currentPage, out RecordCount, " extInt asc,createdate desc");
string showinfoStr = "";
if (hdDt != null && hdDt.Tables.Count > 0 && hdDt.Tables[0].Rows.Count > 0)
{
DataRow dr;
for (int i = 0; i < hdDt.Tables[0].Rows.Count; i++)
{
dr = hdDt.Tables[0].Rows[i];
showinfoStr = "";
if (dr["showDate"].ToString().ToLower() == "true")
{
showinfoStr += " <span class=\"list_span\">" + dateStr(dr["createDate"]) + "</span>";
}
if (dr["showPrice"].ToString().ToLower() == "true")
{
showinfoStr += "<span class=\"list_span span_money\">￥" + MyCommFun.ObjToStr(dr["price"]) + "</span>";
}
if (dr["showYuDing"].ToString().ToLower() == "true")
{
showinfoStr += " <a href='" + MyCommFun.urlAddOpenid(MyCommFun.ObjToStr(dr["url"]), openid) + "' class=\"a_yuding\">" + (MyCommFun.ObjToStr(dr["btnName"]) == null ? "预定" : MyCommFun.ObjToStr(dr["btnName"])) + "</a>";
}
if (showinfoStr != "")
{
dr["showInfo"] = " <div class=\"list_div\">" + showinfoStr + " </div> ";
}
}
}
rpAction.DataSource = hdDt;
rpAction.DataBind();
litCurrentPage.Text = currentPage.ToString();
}
/// <summary>
/// 获得投票信息
/// </summary>
/// <param name="wid"></param>
/// <param name="id"></param>
/// <returns></returns>
public Model.wx_vote_base GetVoteBaseByWid(int wid, int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1");
strSql.Append(" * ");
strSql.Append(" from wx_vote_base where id=@id and wId=@wId");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@wId", SqlDbType.Int, 4)
};
parameters[0].Value = id;
parameters[1].Value = wid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
Model.wx_vote_base category = new Model.wx_vote_base();
while (sr.Read())
{
category = new Model.wx_vote_base();
category.id = MyCommFun.Obj2Int(sr["id"]);
category.title = MyCommFun.ObjToStr(sr["title"]);
category.votepic = MyCommFun.ObjToStr(sr["votepic"]);
category.picdisplay = MyCommFun.ObjBool(sr["picdisplay"]);
category.votecontent = MyCommFun.ObjToStr(sr["votecontent"]);
category.isRadio = MyCommFun.ObjBool(sr["isRadio"]);
category.beginTime = MyCommFun.Obj2DateTime(sr["beginTime"]);
category.endTime = MyCommFun.Obj2DateTime(sr["endTime"]);
category.resultShowtype = MyCommFun.Obj2Int(sr["resultShowtype"]);
category.actUrl = MyCommFun.ObjToStr(sr["actUrl"]);
category.voteType = MyCommFun.Obj2Int(sr["voteType"]);
category.sort_id = MyCommFun.Obj2Int(sr["sort_id"]);
category.creatDate = MyCommFun.Obj2DateTime(sr["creatDate"]);
}
sr.Close();
return(category);
}
private void ShowInfo(int id)
{
DataSet ds = rBll.GetRuleContent("id=" + id);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
txtreqKeywords.Text = MyCommFun.ObjToStr(dr["reqKeywords"]);
if (MyCommFun.ObjToStr(dr["isLikeSearch"]) != "")
{
if (dr["isLikeSearch"].ToString().ToLower() == "false")
{
rblisLikeSearch.SelectedValue = "0";
}
else
{
rblisLikeSearch.SelectedValue = "1";
}
}
txtrContent.Text = MyCommFun.ObjToStr(dr["rContent"]);
}
}
/// <summary>
/// 取购物车里的商品信息
/// </summary>
/// <param name="openid"></param>
/// <param name="wid"></param>
/// <returns></returns>
public List <Model.cartProduct> GetCartList(string openid, int wid)
{
DataSet ds = dal.GetCartList(openid, wid);
List <Model.cartProduct> cartlist = new List <cartProduct>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int count = ds.Tables[0].Rows.Count;
Model.cartProduct cproduct = new cartProduct();
DataRow dr;
for (int i = 0; i < count; i++)
{
dr = ds.Tables[0].Rows[i];
cproduct = new cartProduct();
cproduct.id = MyCommFun.Obj2Int(dr["id"]);
cproduct.openid = MyCommFun.ObjToStr(dr["openid"]);
cproduct.productId = MyCommFun.Obj2Int(dr["productId"]);
cproduct.productName = MyCommFun.ObjToStr(dr["productName"]);
cproduct.productNum = MyCommFun.Obj2Int(dr["productNum"]);
cproduct.productPic = MyCommFun.ObjToStr(dr["pic"]);
cproduct.skuId = MyCommFun.Obj2Int(dr["skuId"]);
cproduct.skuInfo = MyCommFun.ObjToStr(dr["skuInfo"]);
cproduct.totPrice = MyCommFun.Str2Decimal(dr["totPrice"].ToString());
cproduct.totPrice100 = cproduct.totPrice * 100;
cproduct.avgPrice = MyCommFun.decimalF2(cproduct.totPrice / (cproduct.productNum == 0?1:cproduct.productNum));
cproduct.avgPrice100 = cproduct.avgPrice * 100;
cproduct.createDate = MyCommFun.Obj2DateTime(dr["createDate"]);
cproduct.wid = MyCommFun.Obj2Int(dr["wid"]);
cproduct.stock = MyCommFun.Obj2Int(dr["stock"]);
cproduct.productUrl = "/shop/detail.aspx?wid=" + cproduct.wid + "&pid=" + cproduct.productId + "&openid=" + cproduct.openid;
cproduct.seq = i;
cartlist.Add(cproduct);
}
}
return(cartlist);
}
/// <summary>
/// 获得该分类信息，使用wid仅仅作为限制条件
/// </summary>
/// <param name="wid"></param>
/// <param name="id"></param>
/// <returns></returns>
public Model.article_category GetCategoryByWid(int wid, int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1");
strSql.Append(" id,title,call_index,parent_id,class_layer,link_url,img_url,[content],ico_url,seo_title,seo_keywords,seo_description ");
strSql.Append(" from dt_article_category where id=@id and wId=@wId");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@wId", SqlDbType.Int, 4)
};
parameters[0].Value = id;
parameters[1].Value = wid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
Model.article_category category = new Model.article_category();
while (sr.Read())
{
category = new Model.article_category();
category.id = MyCommFun.Obj2Int(sr["id"]);
category.title = MyCommFun.ObjToStr(sr["title"]);
category.call_index = MyCommFun.ObjToStr(sr["call_index"]);
category.parent_id = MyCommFun.Obj2Int(sr["parent_id"]);
category.class_layer = MyCommFun.Obj2Int(sr["class_layer"]);
category.link_url = MyCommFun.ObjToStr(sr["link_url"]);
category.img_url = MyCommFun.ObjToStr(sr["img_url"]);
category.content = MyCommFun.ObjToStr(sr["content"]);
category.ico_url = MyCommFun.ObjToStr(sr["ico_url"]);
category.seo_title = MyCommFun.ObjToStr(sr["seo_title"]);
category.seo_keywords = MyCommFun.ObjToStr(sr["seo_keywords"]);
category.seo_description = MyCommFun.ObjToStr(sr["seo_description"]);
}
sr.Close();
return(category);
}
/// <summary>
/// 通过wid获得该微帐号的站点信息,(换成存储过程获得数据)
/// </summary>
/// <param name="wid"></param>
/// <param name="templateskin">模版的虚拟路劲</param>
/// <returns></returns>
public WeiXinPF.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;
WeiXinPF.Model.wxcodeconfig config = new WeiXinPF.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"]);
config.bmenuTid = MyCommFun.ObjToStr(sr["bmenuTid"]);
#endregion
}
sr.Close();
return(config);
}
private void bindData()
{
string jibie = "会员卡号";
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(id);
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, id);
bool hasLq = true;
if (user == null || user.id <= 0)
{
//说明该用户还未领取这个会员卡
hasLq = false;
StringBuilder lqStr = new StringBuilder("");
lqStr.Append(" <div class=\"msk\"><p class=\"explain2\">");
lqStr.Append("<a id=\"showcard\" class=\"receive\" href=\"javascript:void(0)\">领取您的新会员卡</a><span>微时代会员卡，方便携带收藏，永不挂失</span>");
lqStr.Append("</p></div>");
litLQK.Text = lqStr.ToString();
}
else
{
jibie = BLL.wx_ucard_fun.userDegree(id, MyCommFun.Obj2Int(user.ttScore), jibie, out degreeNum);
//已经领取了会员卡
bindJiFen(user); //展示积分
bindNewInfo(user);
QDInof(user);
}
if (cardinfo != null)
{
Page.Title = cardinfo.cardName;
//卡版面设计
StringBuilder sbStr = new StringBuilder("");
string bgPic = "";
if (cardinfo.bgUrl == null || cardinfo.bgUrl.Trim().Length <= 0)
{
bgPic = cardinfo.bgTypeUrl;
}
else
{
bgPic = cardinfo.bgUrl;
}
sbStr.Append(" <img class=\"cardbg\" src=\"" + bgPic + "\">");
sbStr.Append(" <img id=\"cardlogo\" class=\"logo\" src=\"" + cardinfo.logo + "\">");
sbStr.Append(" <h1 style=\"color: " + cardinfo.cardNameColor + "\">" + cardinfo.cardName + "</h1>");
if (hasLq)
{
sbStr.Append(" <strong class=\"pdo verify\" style=\"color: " + cardinfo.cardNoColor + "\"><span id=\"cdnb\"><em>" + jibie + "</em>" + user.cardNo + "</span></strong>");
}
else
{
sbStr.Append(" <strong class=\"pdo verify\" style=\"color: #A985FF\"><span id=\"cdnb\"><em>普通会员</em>00000000</span></strong>");
}
litCardInfo.Text = sbStr.ToString();
}
//店铺信息
BLL.wx_ucard_store storeBll = new BLL.wx_ucard_store();
Model.wx_ucard_store store = storeBll.GetModel(id);
if (store != null)
{
litTel.Text = MyCommFun.ObjToStr(store.tel);
litAddr.Text = MyCommFun.ObjToStr(store.addr);
aAddr.HRef = "http://api.map.baidu.com/marker?location=" + store.yPoint + "," + store.xPoint + "&title=" + store.addr + "&content=" + store.cardBrief + "&output=html";
aTel.HRef = "tel:" + store.tel;;
}
}
/// <summary>
/// 获得微帐号的分类信息
/// </summary>
/// <param name="wid"></param>
/// <param name="topNum">取前几条数据；若为-1，则不作筛选条件</param>
/// <param name="parentId">若为-1，则不作筛选条件</param>
/// <returns></returns>
public IList <Model.article_category> GetCategoryListByWid(int wid, int topNum, int parentId, int class_layer)
{
IList <Model.article_category> categoryList = new List <Model.article_category>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (topNum >= 0)
{
strSql.Append(" top " + topNum + " ");
}
strSql.Append(" (select count(1) from dt_article_category sc where c.id=sc.parent_id) hasSun,id,title,call_index,parent_id,class_layer,link_url,img_url,[content],ico_url,seo_title,seo_keywords,seo_description from dt_article_category c where channel_id=1 ");
if (parentId != -1)
{
strSql.Append(" and parent_id=" + parentId);
}
if (class_layer != -1)
{
strSql.Append(" and class_layer=" + class_layer);
}
strSql.Append(" and wId=@wId and cStatus=1 order by sort_id asc,id desc");
SqlParameter[] parameters =
{
new SqlParameter("@wId", SqlDbType.Int, 4)
};
parameters[0].Value = wid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
Model.article_category category = new Model.article_category();
while (sr.Read())
{
category = new Model.article_category();
category.id = MyCommFun.Obj2Int(sr["id"]);
category.title = MyCommFun.ObjToStr(sr["title"]);
category.call_index = MyCommFun.ObjToStr(sr["call_index"]);
category.parent_id = MyCommFun.Obj2Int(sr["parent_id"]);
category.class_layer = MyCommFun.Obj2Int(sr["class_layer"]);
category.link_url = MyCommFun.ObjToStr(sr["link_url"]);
category.img_url = MyCommFun.ObjToStr(sr["img_url"]);
category.content = MyCommFun.ObjToStr(sr["content"]);
category.ico_url = MyCommFun.ObjToStr(sr["ico_url"]);
category.seo_title = MyCommFun.ObjToStr(sr["seo_title"]);
category.seo_keywords = MyCommFun.ObjToStr(sr["seo_keywords"]);
category.seo_description = MyCommFun.ObjToStr(sr["seo_description"]);
if (sr["hasSun"].ToString() == "0")
{//无子分类
category.hasSun = false;
}
else
{ //有子类
category.hasSun = true;
}
categoryList.Add(category);
}
sr.Close();
return(categoryList);
}
private void RptBind(string _strWhere, string _orderby)
{
Model.wx_userweixin weixin = GetWeiXinCode();
this.page = MXRequest.GetQueryInt("page", 1);
this.txtKeywords.Text = this.keywords;
//图表或列表显示
BLL.wx_qp_base bll = new BLL.wx_qp_base();
_strWhere = "wid=" + weixin.id + " and " + _strWhere;
DataSet ds = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr;
int cout = ds.Tables[0].Rows.Count;
for (int i = 0; i < cout; i++)
{
dr = ds.Tables[0].Rows[i];
dr["link_url"] = "<a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/weixin/qiangpiao/index.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&aid=" + dr["id"].ToString() + "</a>";
}
ds.AcceptChanges();
}
this.rptList1.DataSource = ds;
this.rptList1.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("action_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
//数据绑定
private void RptBind()
{
Model.wx_userweixin weixin = GetWeiXinCode();
BLL.article_category bll = new BLL.article_category();
DataTable dt = bll.GetWCodeList(weixin.id, 0, this.channel_id);
if (dt != null)
{
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["ico_url"] != null && dr["ico_url"].ToString().Trim() != "")
{
if (dr["ico_url"].ToString().Contains("."))
{
dr["ico_url"] = "<img src=\"" + dr["ico_url"].ToString() + "\" class=\"imgico\" />";
}
else
{
dr["ico_url"] = "<span class=\"" + dr["ico_url"].ToString() + "\" />";
}
}
//链接处理，待做
if (dr["link_url"] != null && dr["link_url"].ToString().Trim() != "")
{
dr["link_url"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\" title=\"" + dr["link_url"].ToString() + "\">" + Utils.CutString(dr["link_url"].ToString(), 40) + "</a>";
}
else
{
dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/list.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&cid=" + dr["id"] + "</a>";
}
}
dt.AcceptChanges();
}
this.rptList.DataSource = dt;
this.rptList.DataBind();
}
//数据绑定
private void RptBind()
{
BLL.wx_product_sys bll = new BLL.wx_product_sys();
Model.wx_userweixin weixin = GetWeiXinCode();
DataTable dt = bll.GetWCodeList(weixin.id);
if (dt != null)
{
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["banner"] != null && dr["banner"].ToString().Trim() != "")
{
if (dr["banner"].ToString().Contains("."))
{
dr["banner"] = "<img src=\"" + dr["banner"].ToString() + "\" class=\"imgico\" />";
}
else
{
dr["banner"] = "<span class=\"" + dr["banner"].ToString() + "\" />";
}
}
//链接处理，待做
if (dr["link_url"] != null && dr["link_url"].ToString().Trim() != "")
{
dr["link_url"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\">" + dr["link_url"] + "</a>";
}
else
{
dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/weixin/product/all.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&pid=" + dr["id"] + "</a>";
}
}
}
this.rptList.DataSource = dt;
this.rptList.DataBind();
}
private void RptBind(int _category_id, string _strWhere, string _orderby)
{
Model.wx_userweixin weixin = GetWeiXinCode();
this.page = MXRequest.GetQueryInt("page", 1);
if (this.category_id > 0)
{
this.ddlCategoryId.SelectedValue = _category_id.ToString();
}
this.txtKeywords.Text = this.keywords;
//列表显示
BLL.wx_product bll = new BLL.wx_product();
DataSet artDs = bll.GetWCodeList(weixin.id, _category_id, this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
//链接处理，待做
if (artDs != null)
{
DataRow dr;
for (int i = 0; i < artDs.Tables[0].Rows.Count; i++)
{
dr = artDs.Tables[0].Rows[i];
dr["url"] = " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/weixin/product/detail.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&id=" + dr["id"] + "</a>";
}
}
this.rptList1.DataSource = artDs;
this.rptList1.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("product_list.aspx", "category_id={0}&keywords={1}&page={2}", ddlCategoryId.SelectedValue, this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void ShowInfo(int id)
{
hidid.Value = id.ToString();
Model.wx_dzpActionInfo dzpAction = dzpBll.GetModel(id);
IList <Model.wx_dzpAwardItem> aItemlist = iBll.GetModelList("actId=" + id);
Model.wx_requestRule rule = rBll.GetModelList("modelFunctionName='大转盘' and modelFunctionId=" + id)[0];
txtKW.Text = rule.reqKeywords;
if (dzpAction.beginPic != null && dzpAction.beginPic.Trim() != "/weixin/dzp/images/start.jpg")
{
txtImgUrl.Text = dzpAction.beginPic;
imgbeginPic.ImageUrl = dzpAction.beginPic;
}
txtactName.Text = dzpAction.actName;
txtcontractInfo.Text = dzpAction.contractInfo;
txtbrief.Value = dzpAction.brief;
txtbeginDate.Text = dzpAction.beginDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
txtendDate.Text = dzpAction.endDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
txtactContent.Value = dzpAction.actContent;
txtcfcjhf.Text = dzpAction.cfcjhf;
this.txtdjPwd.Text = dzpAction.djPwd;
//结束
if (dzpAction.endPic != null && dzpAction.endPic.Trim() != "/weixin/dzp/images/end.jpg")
{
txtEndPic.Text = dzpAction.endPic;
imgEndPic.ImageUrl = dzpAction.endPic;
}
txtendNotice.Text = dzpAction.endNotice;
txtendContent.Text = dzpAction.endContent;
//奖项基本信息
txtpersonNum.Text = MyCommFun.ObjToStr(dzpAction.personNum);
txtpersonMaxTimes.Text = MyCommFun.ObjToStr(dzpAction.personMaxTimes);
txtdayMaxTimes.Text = MyCommFun.ObjToStr(dzpAction.dayMaxTimes);
//绑定奖项信息
IList <Model.wx_dzpAwardItem> itemlist = iBll.GetModelList("actId=" + id + " order by sort_id asc");
if (itemlist != null && itemlist.Count > 0)
{
int count = itemlist.Count;
TextBox txtJXName;
TextBox txtJPName;
TextBox txtNum;
TextBox txtRealNum;
Model.wx_dzpAwardItem itemEntity = new Model.wx_dzpAwardItem();
for (int i = 1; i <= count; i++)
{
itemEntity = itemlist[(i - 1)];
txtJXName = this.FindControl("txt" + i + "JXName") as TextBox;
txtJPName = this.FindControl("txt" + i + "JPName") as TextBox;
txtNum = this.FindControl("txt" + i + "Num") as TextBox;
txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox;
txtJXName.Text = itemEntity.jxName;
txtJPName.Text = itemEntity.jpName;
txtNum.Text = itemEntity.jpNum == null ? "0" : itemEntity.jpNum.Value.ToString();
txtRealNum.Text = itemEntity.jpRealNum == null ? "0" : itemEntity.jpRealNum.Value.ToString();
}
}
}
private void RptBind(int _channel_id, int _category_id, string _strWhere, string _orderby)
{
Model.wx_userweixin weixin = GetWeiXinCode();
this.page = MXRequest.GetQueryInt("page", 1);
if (this.category_id > 0)
{
this.ddlCategoryId.SelectedValue = _category_id.ToString();
}
this.ddlProperty.SelectedValue = this.property;
this.txtKeywords.Text = this.keywords;
//图表或列表显示
BLL.article bll = new BLL.article();
DataSet artDs = bll.GetWCodeList(weixin.id, _channel_id, _category_id, this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
//url链接地址处理
if (artDs != null && artDs.Tables.Count > 0 && artDs.Tables[0].Rows.Count > 0)
{
DataRow dr;
int count = artDs.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
dr = artDs.Tables[0].Rows[i];
string linkUrl = MyCommFun.ObjToStr(dr["link_url"]);
if (linkUrl.Length > 0)
{
//外链地址
dr["link_url"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\">" + linkUrl + "</a>";
}
else
{
dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/detail.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&aid=" + dr["id"] + "</a>";
}
}
artDs.AcceptChanges();
}
switch (this.prolistview)
{
case "Img":
this.rptList1.Visible = false;
this.rptList2.DataSource = artDs;
this.rptList2.DataBind();
Utils.WriteCookie("wx_article_list_view", "Img", 14400);
break;
default:
this.rptList2.Visible = false;
this.rptList1.DataSource = artDs;
this.rptList1.DataBind();
Utils.WriteCookie("wx_article_list_view", "Txt", 14400);
break;
}
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("wx_article_list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}&page={4}",
_channel_id.ToString(), _category_id.ToString(), this.keywords, this.property, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
//数据绑定
private void RptBind()
{
BLL.wx_product_type bll = new BLL.wx_product_type();
Model.wx_userweixin weixin = GetWeiXinCode();
string keywords = MyCommFun.QueryString("keywords");
int pid = MyCommFun.RequestInt("pid");
string whereStr = "wid=" + weixin.id;
if (keywords.Trim().Length > 0)
{
whereStr += " and tName like '%" + keywords.Trim() + "%'";
}
if (pid > 0)
{
whereStr += " and store_id=" + pid;
}
DataSet ds = bll.GetList(whereStr);
if (ds == null || ds.Tables.Count <= 0)
{
return;
}
DataTable dt = ds.Tables[0];
if (dt != null)
{
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["icoPic"] != null && dr["icoPic"].ToString().Trim() != "")
{
if (dr["icoPic"].ToString().Contains("."))
{
dr["icoPic"] = "<img src=\"" + dr["icoPic"].ToString() + "\" class=\"imgico\" />";
}
else
{
dr["icoPic"] = "<span class=\"" + dr["icoPic"].ToString() + "\" />";
}
}
//链接处理，待做
if (dr["tUrl"] != null && dr["tUrl"].ToString().Trim() != "")
{
dr["tUrl"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\">" + dr["tUrl"] + "</a>";
}
else
{
dr["tUrl"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/weixin/product/index.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&tid=" + dr["id"] + "</a>";
}
}
}
this.rptList.DataSource = dt;
this.rptList.DataBind();
}
