private void ShowInfo(int id)
{
hidid.Value = id.ToString();
Model.wx_ucard_users user = uBll.GetModel(id);
txtrealName.Text = user.realName;
lblcardNo.Text = user.cardNo;
lblopenid.Text = user.openid;
//等级
BLL.wx_ucard_udegree degreeBll = new wx_ucard_udegree();
IList <Model.wx_ucard_udegree> degreelist = degreeBll.GetModelList("sid=" + sid);
int degreeNum = 0;
string jibie = "";
jibie = BLL.wx_ucard_fun.userDegree(id, MyCommFun.Obj2Int(user.ttScore), jibie, out degreeNum);
lblDegree.Text = jibie;
rblSex.SelectedValue = user.sex == null ? "3" : user.sex.Value.ToString();
txtwxName.Text = user.wxName;
txtage.Text = user.age == null?"0":user.age.ToString();
txtttScore.Text = MyCommFun.ObjToStr(user.ttScore);
txtqdScore.Text = MyCommFun.ObjToStr(user.qdScore);
txtconsumeScore.Text = MyCommFun.ObjToStr(user.consumeScore);
txtconsumeMoney.Text = MyCommFun.ObjToStr(user.consumeMoney);
txtregTime.Text = MyCommFun.Obj2DateTime(user.regTime).ToString("yyyy-MM-dd HH:mm:ss");
txtendDate.Text = MyCommFun.Obj2DateTime(user.endDate).ToString("yyyy-MM-dd HH:mm:ss");
txtmobile.Text = MyCommFun.ObjToStr(user.mobile);
txtaddr.Text = MyCommFun.ObjToStr(user.addr);
}
/// <summary>
/// 查询该月的消费信息
/// </summary>
/// <param name="user"></param>
/// <param name="month">如果为0，则表示当月的数据，</param>
private void bindMonthXFinfo(Model.wx_ucard_users user, int month)
{
int year = DateTime.Now.Year;
int todayMonth = DateTime.Now.Month;
if (month == 0)
{
month = todayMonth;
}
IList <Model.wx_ucard_users_consumeinfo> clist = cBll.GetModelList("sId=" + sid + " and uid=" + user.id + " and moduleType!='签到' and year(addTime)=" + year + " and month(addTime)=" + month + " order by addTime desc");
StringBuilder xfSb = new StringBuilder("");
decimal ttMoney = 0;
int ttScore = 0;
if (clist != null && clist.Count > 0)
{
Model.wx_ucard_users_consumeinfo c = new Model.wx_ucard_users_consumeinfo();
for (int i = 0; i < clist.Count; i++)
{
c = clist[i];
xfSb.Append("<tr><td>" + c.addTime.Value.ToString("yyyy-MM-dd") + "</td> <td>" + MyCommFun.Obj2Decimal(c.consumeMoney, 0) + "</td> <td>" + MyCommFun.Obj2Int(c.score) + "</td> </tr>");
ttMoney += MyCommFun.Obj2Decimal(c.consumeMoney, 0);
ttScore += MyCommFun.Obj2Int(c.score);
}
BindDaysDetailInfo(clist);
}
litXFStr.Text = xfSb.ToString();
litttMoney.Text = ttMoney.ToString();
litttScore.Text = ttScore.ToString();
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.qiandaoPic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
bool hasLq = true;
if (user == null || user.id <= 0)
{
//说明该用户还未领取这个会员卡
hidStatus.Value = "-1";
hidErrInfo.Value = "请先领取会员卡";
}
else
{
bindJiFen(user);
uid = user.id;
QDInof(user);
int month = MyCommFun.RequestInt("m");
bindMonthQD(user, month);
}
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.noticePic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{
return;
}
int degreeNum = 0;
BLL.wx_ucard_fun.userDegree(sid, MyCommFun.Obj2Int(user.ttScore), "", out degreeNum);
BLL.wx_ucard_notice nBll = new BLL.wx_ucard_notice();
IList <Model.wx_ucard_notice> nlist = nBll.GetModelList(" sid=" + sid + " and ( userDegree ='0' or userDegree like '%," + degreeNum + ",%' ) order by createDate desc");
StringBuilder noticeStr = new StringBuilder();
if (nlist != null && nlist.Count > 0)
{
Model.wx_ucard_notice notice = new Model.wx_ucard_notice();
for (int i = 0; i < nlist.Count; i++)
{
notice = nlist[i];
if (i == 0)
{
//第一条数据
noticeStr.Append("<div id=\"test0-header\" class=\"accordion_headings header_highlight \">");
noticeStr.Append(" <div class=\"tab new \">");
noticeStr.Append(" <span class=\"title\">" + notice.nName + "<p>" + notice.createDate.Value.ToString("yyyy年MM月dd日") + "</p>");
noticeStr.Append(" </span></div>");
noticeStr.Append(" <div id=\"test0-content\" style=\"display: block; overflow: hidden; opacity: 1;\"> ");
noticeStr.Append("<div class=\"accordion_child\"><p class=\"xiangqing\">");
noticeStr.Append(notice.nContent);
noticeStr.Append(" </p></div></div></div>");
}
else
{
noticeStr.Append("<div id=\"test" + i + "-header\" class=\"accordion_headings \">");
noticeStr.Append("<div class=\"tab \">");
noticeStr.Append("<span class=\"title\">" + notice.nName + "<p>" + notice.createDate.Value.ToString("yyyy年MM月dd日") + "</p></span>");
noticeStr.Append("</div>");
noticeStr.Append(" <div id=\"test" + i + "-content\" style=\"display: none; overflow: hidden;\">");
noticeStr.Append("<div class=\"accordion_child\">");
noticeStr.Append("<p class=\"xiangqing\">" + notice.nContent + "</p>");
noticeStr.Append("</div> </div> </div>");
}
}
}
litNoticeList.Text = noticeStr.ToString();
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
int id = MyCommFun.Str2Int(hidid.Value);
#region //先判断
string strErr = "";
if (this.txtrealName.Text.Trim().Length == 0)
{
strErr += "姓名不能为空！";
}
if (strErr != "")
{
JscriptMsg(strErr, "back", "Error");
return;
}
#endregion
Model.wx_ucard_users user = new Model.wx_ucard_users();
if (id > 0)
{
user = uBll.GetModel(id);
}
user.realName = txtrealName.Text.Trim();
user.sex = MyCommFun.Str2Int(rblSex.SelectedItem.Value);
user.wxName = txtwxName.Text;
user.age = MyCommFun.Str2Int(txtage.Text);
user.ttScore = MyCommFun.Str2Int(txtttScore.Text);
user.qdScore = MyCommFun.Str2Int(txtqdScore.Text);
user.consumeScore = MyCommFun.Str2Int(txtconsumeScore.Text);
user.consumeMoney = MyCommFun.Str2Decimal(txtconsumeMoney.Text);
user.regTime = MyCommFun.Obj2DateTime(txtregTime.Text);
user.endDate = MyCommFun.Obj2DateTime(txtendDate.Text);
user.mobile = txtmobile.Text;
user.addr = txtaddr.Text;
if (id <= 0)
{ //新增
////1新增主表
//id = uBll.Add(user);
//AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加会员，主键为" + id); //记录日志
//JscriptMsg("添加会员成功！", "gift_list.aspx?id=" + sid, "Success");
}
else
{ //修改
//1修改主表
uBll.Update(user);
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改会员卡--会员信息，主键为" + id); //记录日志
JscriptMsg("修改会员卡--会员信息成功！", "user_list.aspx?id=" + sid, "Success");
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
int id = MyCommFun.Str2Int(hidid.Value);
#region //先判断
string strErr = "";
if (this.txtrealName.Text.Trim().Length == 0)
{
strErr += "姓名不能为空！";
}
if (strErr != "")
{
JscriptMsg(strErr, "back", "Error");
return;
}
#endregion
Model.wx_ucard_users user = new Model.wx_ucard_users();
if (id > 0)
{
user = uBll.GetModel(id);
}
user.realName = txtrealName.Text.Trim();
user.sex = MyCommFun.Str2Int(rblSex.SelectedItem.Value);
user.wxName = txtwxName.Text;
user.age = MyCommFun.Str2Int(txtage.Text);
user.ttScore = MyCommFun.Str2Int(txtttScore.Text);
user.qdScore = MyCommFun.Str2Int(txtqdScore.Text);
user.consumeScore = MyCommFun.Str2Int(txtconsumeScore.Text);
user.consumeMoney = MyCommFun.Str2Decimal(txtconsumeMoney.Text);
user.regTime = MyCommFun.Obj2DateTime(txtregTime.Text);
user.endDate = MyCommFun.Obj2DateTime(txtendDate.Text);
user.mobile = txtmobile.Text;
user.addr = txtaddr.Text;
if (id <= 0)
{ //新增
////1新增主表
//id = uBll.Add(user);
//AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加会员，主键为" + id); //记录日志
//JscriptMsg("添加会员成功！", "gift_list.aspx?id=" + sid, "Success");
}
else
{ //修改
//1修改主表
uBll.Update(user);
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改会员卡--会员信息，主键为" + id); //记录日志
JscriptMsg("修改会员卡--会员信息成功！", "user_list.aspx?id=" + sid, "Success");
}
}
/// <summary>
/// 今天是否签到
/// </summary>
/// <param name="user"></param>
private void QDInof(Model.wx_ucard_users user)
{
bool hasQd = cBll.hasDayQD(sid, user.id, DateTime.Now);
if (hasQd)
{
litQDinfo.Text = "您今天已经签到了！";
}
else
{
litQDinfo.Text = "点击这里签到赚积分";
}
}
/// <summary>
/// 查询该月的签到信息
/// </summary>
/// <param name="user"></param>
/// <param name="month">如果为0，则表示当月的数据，</param>
private void bindMonthQD(Model.wx_ucard_users user, int month)
{
int year = DateTime.Now.Year;
int todayMonth = DateTime.Now.Month;
if (month == 0)
{
month = todayMonth;
}
IList <Model.wx_ucard_users_consumeinfo> qdlist = cBll.GetModelList("sId=" + sid + " and uid=" + user.id + " and moduleType='签到' and year(addTime)=" + year + " and month(addTime)=" + month + " order by addTime desc");
DateTime thisBeginTimes = DateTime.Parse(year + "-" + month + "-1");
DateTime thisEndTimes;
if (todayMonth == month)
{
//当前月
thisEndTimes = DateTime.Now;
}
else
{
//非当前月
thisEndTimes = thisBeginTimes.AddMonths(1).AddDays(-1);
}
int maxDays = thisEndTimes.Day;
StringBuilder qdStr = new StringBuilder("");
DateTime tmpTimes = new DateTime();
Model.wx_ucard_users_consumeinfo tmpConsume = new Model.wx_ucard_users_consumeinfo();
int totqdjifen = 0;
for (int i = maxDays; i > 0; i--)
{
//待完成
tmpTimes = DateTime.Parse(year + "-" + month + "-" + i);
tmpConsume = getqdInfo(qdlist, tmpTimes);
if (tmpConsume != null)
{ //已经签到
qdStr.Append(getqdStr(tmpTimes, tmpConsume.score.Value, true));
totqdjifen += tmpConsume.score.Value;
}
else
{
//未签到
qdStr.Append(getqdStr(tmpTimes, 0, false));
}
}
litQDStr.Text = qdStr.ToString();
litTTqdScore.Text = totqdjifen.ToString();
}
/// <summary>
/// 今天是否签到
/// </summary>
/// <param name="user"></param>
private void QDInof(Model.wx_ucard_users user)
{
BLL.wx_ucard_users_consumeinfo qdBll = new BLL.wx_ucard_users_consumeinfo();
bool hasQd = qdBll.hasDayQD(id, user.id, DateTime.Now);
if (hasQd)
{
litHasQD.Text = "<em class=\"ok\">今日已签到</em>";
}
else
{
litHasQD.Text = "<em class=\"error\">今日未签到</em>";
}
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.perinfoPic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
uName = user.realName;
tel = user.mobile;
}
/// <summary>
/// 通知，特权，优惠券，礼品券
/// </summary>
private void bindNewInfo(Model.wx_ucard_users user)
{
//通知列表
BLL.wx_ucard_notice noticeBll = new BLL.wx_ucard_notice();
int noticeNum = noticeBll.GetRecordCount(" sid=" + id + " and ( userDegree ='0' or userDegree like '%," + degreeNum + ",%' ) ");
StringBuilder sbStr = new StringBuilder("");
if (noticeNum > 0)
{
sbStr.Append(" <li><a href=\"ucardNotice.aspx?wid=" + wid + "&sid=" + id + "&openid=" + openid + "\"><span>最新通知<em class=\"ok\">" + noticeNum + "</em></span></a></li>");
}
//特权
BLL.wx_ucard_privileges privilegesBLL = new BLL.wx_ucard_privileges();
int privilegesNum = privilegesBLL.GetRecordCount(" sid=" + id + " and ( userDegree ='0' or userDegree like '%," + degreeNum + ",%' ) and beginDate<='" + DateTime.Now + "' and endDate>='" + DateTime.Now + "' ");
if (privilegesNum > 0)
{
sbStr.Append(" <li><a href=\"ucardPrivileges.aspx?wid=" + wid + "&sid=" + id + "&openid=" + openid + "\"><span>最新特权<em class=\"ok\">" + privilegesNum + "</em></span></a></li>");
}
//优惠券
BLL.wx_ucard_ticket ticketBLL = new BLL.wx_ucard_ticket();
string ticketStr = ticketBLL.getUserTicketStr(id, user.id, degreeNum, MyCommFun.Obj2Int(user.consumeMoney, 0));
if (ticketStr != null)
{
string[] strArr = Utils.SplitString(ticketStr, ",");
int ticketNum = 0;
for (int i = 0; i < strArr.Length; i++)
{
if (strArr[i].Trim().Length > 0)
{
ticketNum++;
}
}
sbStr.Append("<li><a href=\"ucardTicket.aspx?wid=" + wid + "&sid=" + id + "&openid=" + openid + "\"><span>会员优惠券<em class=\"ok\">" + ticketNum + "</em></span></a></li>");
}
//礼品券
BLL.wx_ucard_gift giftBll = new BLL.wx_ucard_gift();
int giftNum = giftBll.GetRecordCount(" sid=" + id + " and beginDate>='" + DateTime.Now + "' and endDate<'" + DateTime.Now + "'");
if (giftNum > 0)
{
sbStr.Append("<li><a href=\"ucardGift.aspx?wid=" + wid + "&sid=" + id + "&openid=" + openid + "\"><span>会员礼品券<em class=\"ok\">" + giftNum + "</em></span></a></li>");
}
litNotice.Text = sbStr.ToString();
}
/// <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();
}
private void RptBind(string _strWhere, string _orderby)
{
//绑定用户的基本信息
Model.wx_ucard_users user = uBll.GetModel(id);
lblrealName.Text = user.realName;
lblCardNo.Text = user.cardNo;
lblTel.Text = user.mobile;
lblAddr.Text = user.addr;
//绑定消费积分信息
_strWhere = "c.sId=" + sid + " and c.uid=" + id + " " + _strWhere;
this.page = MXRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
DataSet ds = cBll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataSource = ds;
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("user_score.aspx?id=" + id + "&sid=" + sid, "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.privilegesPic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{
return;
}
uid = user.id;
int degreeNum = 0;
BLL.wx_ucard_fun.userDegree(sid, MyCommFun.Obj2Int(user.ttScore), "", out degreeNum);
string ticketStr = ticketBLL.getUserTicketStr(sid, user.id, degreeNum, MyCommFun.Obj2Int(user.consumeMoney, 0));
IList <Model.wx_ucard_ticket> plist = ticketBLL.GetModelList(" id in " + comStrByTid(ticketStr));
StringBuilder pStr = new StringBuilder();
if (plist != null && plist.Count > 0)
{
Model.wx_ucard_ticket ticket = new Model.wx_ucard_ticket();
string sn = "";
int syNum = 0; //剩余次数
for (int i = 0; i < plist.Count; i++)
{
ticket = plist[i];
syNum = MyCommFun.Obj2Int(ticket.usedTimes);
sn = Utils.Number(16, true);
if (i == 0)
{
//第一条数据
pStr.Append(" <div id=\"test0-header\" class=\"accordion_headings header_highlight \">");
pStr.Append(" <div class=\"tab coupon \">");
pStr.Append(" <span class=\"title\">" + ticket.tName + "(<span id=\"cid" + ticket.id + "\">" + syNum + "</span>张)<p>有效期至" + ticket.endDate.Value.ToString("yyyy年MM月dd日") + "</p></span>");
pStr.Append(" </div>");
pStr.Append(" <div id=\"test0-content\" style=\"display: block; overflow: hidden; opacity: 1;\">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append(" <p class=\"num\" onclick=\"jQ('#test0-content').height(300);document.getElementById('queren0').style.display=''\" id=\"sn0\">" + sn + "</p>");
pStr.Append(" <div id=\"queren0\" style=\"display: none\">");
pStr.Append(" <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"money0\" value=\"\" placeholder=\"请输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"bmoney0\" value=\"\" placeholder=\"请再次输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0 0 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword0\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append("<a id=\"showcard0\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"coupon(0,'" + sn + "','" + ticket.id + "')\">确定使用</a>");
pStr.Append(" </p> </div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
pStr.Append(" <b>详情说明</b>");
pStr.Append("<ul>" + ticket.usedContent + "</ul></div> </div> </div>");
}
else
{
pStr.Append(" <div id=\"test" + i + "-header\" class=\"accordion_headings \">");
pStr.Append(" <div class=\"tab coupon \">");
pStr.Append(" <span class=\"title\">" + ticket.tName + "(<span id=\"cid" + ticket.id + "\">" + syNum + "</span>张)<p>有效期至" + ticket.endDate.Value.ToString("yyyy年MM月dd日") + "</p>");
pStr.Append(" </span> </div>");
pStr.Append(" <div id=\"test" + i + "-content\" style=\"display: none; overflow: hidden;\">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append("<p class=\"num\" onclick=\"jQ('#test" + i + "-content').height(300);document.getElementById('queren" + i + "').style.display=''\" id=\"sn" + i + "\">" + sn + "</p>");
pStr.Append("<div id=\"queren" + i + "\" style=\"display: none\"> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"money" + i + "\" value=\"\" placeholder=\"请输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"bmoney" + i + "\" value=\"\" placeholder=\"请再次输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0 0 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword" + i + "\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p><p style=\"margin: 10px 0\">");
pStr.Append(" <a id=\"showcard" + i + "\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"coupon(" + i + ",'" + sn + "','" + ticket.id + "')\">确定使用</a>");
pStr.Append(" </p></div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
pStr.Append(" <b>详情说明</b>");
pStr.Append(" <ul>" + ticket.usedContent + "</ul></div> </div> </div>");
}
}
}
litTicketlist.Text = pStr.ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/json";
string _action = MyCommFun.QueryString("myact");
string openid = MyCommFun.RequestOpenid(); //得到微信用户的openid
Dictionary <string, string> jsonDict = new Dictionary <string, string>();
int sid = MyCommFun.RequestInt("sid");
int uid = 0;
BLL.wx_ucard_store storeBll = new BLL.wx_ucard_store();
BLL.wx_ucard_users_consumeinfo conBll = new BLL.wx_ucard_users_consumeinfo();
BLL.wx_ucard_score scoreBll = new BLL.wx_ucard_score();
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users_consumeinfo consume = new Model.wx_ucard_users_consumeinfo();
Model.wx_ucard_score score = new Model.wx_ucard_score();
Model.wx_ucard_store store = storeBll.GetModel(sid);
if (store == null)
{
jsonDict.Add("ret", "err");
jsonDict.Add("msg", "店铺不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (_action == "userreg")
{
#region //用户第一次领取卡
jsonDict = new Dictionary <string, string>();
if (sid == 0)
{
jsonDict.Add("ret", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
string tel = MyCommFun.QueryString("tel");
string realName = MyCommFun.QueryString("truename");
XCWeiXin.Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{ //第一次添加
user = new Model.wx_ucard_users();
user.mobile = tel;
user.realName = realName;
user.regTime = DateTime.Now;
user.sid = sid;
user.openid = openid;
user.ttScore = 0;
user.consumeScore = 0;
user.qdScore = 0;
user.consumeMoney = 0;
user.regIp = MXRequest.GetIP();
int ret = userBll.Add(user);
if (ret > 0)
{
jsonDict.Add("ret", "succ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("ret", "err");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
else
{
user.mobile = tel;
user.realName = realName;
user.regTime = DateTime.Now;
user.sid = sid;
user.openid = openid;
user.regIp = MXRequest.GetIP();
bool ret = userBll.Update(user);
if (ret)
{
jsonDict.Add("ret", "succ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("ret", "err");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
context.Response.End();
#endregion
}
else if (_action == "qiandao")
{
#region 签到
jsonDict = new Dictionary <string, string>();
sid = MyCommFun.RequestInt("sid");
uid = MyCommFun.RequestInt("uid");
if (sid == 0 || uid == 0)
{
jsonDict.Add("ret", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
bool hasqd = conBll.hasDayQD(sid, uid, DateTime.Now);
int retScore = 0;
if (!hasqd)
{
//新增
//取签到积分策略
score = scoreBll.GetStoreModel(sid);
if (score != null)
{
//判断是否6天连续签到，并且6天内没有给额外的奖励
DateTime day6before = DateTime.Now.AddDays(-6);
int record = conBll.GetRecordCount("sId=" + sid + " and uid=" + uid + " and moduleType='签到' and addTime>='" + day6before.ToShortDateString() + "' and addTime<'" + DateTime.Now.ToShortDateString() + "' and moduleActionId=6 ");
if (record >= 5)
{
consume = new Model.wx_ucard_users_consumeinfo();
consume.sId = sid;
consume.uid = uid;
consume.moduleType = "签到";
consume.moduleActionName = "连续6天签到奖励";
consume.moduleActionId = 6;
consume.score = MyCommFun.Obj2Int(score.qiandao6Score) + score.qiandaoScore.Value;
conBll.AddJiFen(consume, 0);
retScore = MyCommFun.Obj2Int(score.qiandao6Score) + score.qiandaoScore.Value;
}
else
{
consume = new Model.wx_ucard_users_consumeinfo();
consume.sId = sid;
consume.uid = uid;
consume.moduleType = "签到";
consume.score = score.qiandaoScore.Value;
conBll.AddJiFen(consume, 0);
retScore = score.qiandaoScore.Value;
}
}
}
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "+" + retScore + "分，明天继续");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "tequan")
{
#region //消费： 特权 ,注意，只有在新增这个的时候记录user表总积分，修改的时候 对user表的总积分和金额先减后加
jsonDict = new Dictionary <string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid"); //用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int pid = MyCommFun.RequestInt("pid"); //特权主键id
string type = MyCommFun.QueryString("type"); //tequan:特权
if (sid == 0 || uid == 0 || pid == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_privileges privBll = new BLL.wx_ucard_privileges();
Model.wx_ucard_privileges privileges = privBll.GetModel(pid);
if (privileges == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "特权不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//积分策略
score = scoreBll.GetStoreModel(sid);
int avgScore = score.consumeMoneyScore.Value / score.consumeMoney.Value;
//1先添加消费明细,和修改用户的总积分和总消费金额
//IList<Model.wx_ucard_users_consumeinfo> conlist = conBll.GetModelList("moduleType='特权' and moduleActionId=" + privileges.id + " and sid=" + sid + " and uid=" + uid);
//if (conlist == null || conlist.Count <= 0 || conlist[0] == null)
//{
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "特权";
consume.moduleActionId = privileges.id;
consume.moduleActionName = privileges.pName;
consume.sId = sid;
consume.uid = uid;
consume.consumeMoney = (decimal)money;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.cMoneyType = 2;
consume.score = (int)(avgScore * money);
consume.cScoreType = 1;
conBll.Add(consume, true);
//}
//else
//{
// //修改
// consume = conlist[0];
// decimal oldMoney = MyCommFun.Obj2Decimal(consume.consumeMoney, 0);
// int oldScore = MyCommFun.Obj2Int(consume.score);
// consume.moduleActionName = privileges.pName;
// consume.consumeMoney = (decimal)money;
// consume.sn = sn;
// consume.pwd = pwd;
// consume.cMoneyType = 2;
// consume.score = (int)(avgScore * money);
// conBll.UpdateInfoAndUserTT(consume, oldMoney, oldScore);
//}
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "获得" + consume.score.Value + "积分 ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "lq_yhq")
{
#region 领取优惠券
jsonDict = new Dictionary <string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid"); //用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int ticketId = MyCommFun.RequestInt("cid");//优惠券主键id
if (sid == 0 || uid == 0 || ticketId == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_ticket ticketBll = new BLL.wx_ucard_ticket();
Model.wx_ucard_ticket ticket = ticketBll.GetModel(ticketId);
if (ticket == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "优惠券不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int syTimes = ticketBll.getsyTimesByTicket(uid, ticketId);
if (syTimes <= 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "已没有使用次数");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//积分策略
score = scoreBll.GetStoreModel(sid);
int avgScore = score.consumeMoneyScore.Value / score.consumeMoney.Value;
//1先添加消费明细,和修改用户的总积分和总消费金额
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "优惠券";
consume.moduleActionId = ticket.id;
consume.moduleActionName = ticket.tName;
consume.sId = sid;
consume.uid = uid;
consume.consumeMoney = (decimal)money;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.cMoneyType = 2;
consume.score = (int)(avgScore * money);
consume.cScoreType = 1;
conBll.Add(consume, true);
syTimes -= 1;
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "获得" + consume.score.Value + "积分 ");
jsonDict.Add("sy", syTimes.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "gift")
{
#region 兑换礼品券
jsonDict = new Dictionary <string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid"); //用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int giftId = MyCommFun.RequestInt("gid");//礼品主键id
if (sid == 0 || uid == 0 || giftId == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_gift giftBll = new BLL.wx_ucard_gift();
Model.wx_ucard_gift gift = giftBll.GetModel(giftId);
if (gift == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "优惠券不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int userTTScore = userBll.GetUserJiFen(uid);
if (userTTScore < gift.score.Value)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "积分不够");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//1先添加消费明细,和修改用户的总积分和总消费金额
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "礼品券";
consume.moduleActionId = gift.id;
consume.moduleActionName = gift.gName;
consume.sId = sid;
consume.uid = uid;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.score = -gift.score.Value;
consume.cScoreType = 1;
conBll.Add(consume, false);
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "成功兑换礼品扣除 " + gift.score.Value + " 积分 ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
}
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;;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/json";
string _action = MyCommFun.QueryString("myact");
string openid = MyCommFun.RequestOpenid(); //得到微信用户的openid
Dictionary<string, string> jsonDict = new Dictionary<string, string>();
int sid = MyCommFun.RequestInt("sid");
int uid = 0;
BLL.wx_ucard_store storeBll = new BLL.wx_ucard_store();
BLL.wx_ucard_users_consumeinfo conBll = new BLL.wx_ucard_users_consumeinfo();
BLL.wx_ucard_score scoreBll = new BLL.wx_ucard_score();
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users_consumeinfo consume = new Model.wx_ucard_users_consumeinfo();
Model.wx_ucard_score score = new Model.wx_ucard_score();
Model.wx_ucard_store store = storeBll.GetModel(sid);
if (store == null)
{
jsonDict.Add("ret", "err");
jsonDict.Add("msg", "店铺不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (_action == "userreg")
{
#region //用户第一次领取卡
jsonDict = new Dictionary<string, string>();
if (sid == 0)
{
jsonDict.Add("ret", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
string tel = MyCommFun.QueryString("tel");
string realName = MyCommFun.QueryString("truename");
WechatBuilder.Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{ //第一次添加
user = new Model.wx_ucard_users();
user.mobile = tel;
user.realName = realName;
user.regTime = DateTime.Now;
user.sid = sid;
user.openid = openid;
user.ttScore = 0;
user.consumeScore = 0;
user.qdScore = 0;
user.consumeMoney = 0;
user.regIp = MXRequest.GetIP();
int ret = userBll.Add(user);
if (ret > 0)
{
jsonDict.Add("ret", "succ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("ret", "err");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
else
{
user.mobile = tel;
user.realName = realName;
user.regTime = DateTime.Now;
user.sid = sid;
user.openid = openid;
user.regIp = MXRequest.GetIP();
bool ret = userBll.Update(user);
if (ret)
{
jsonDict.Add("ret", "succ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("ret", "err");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
context.Response.End();
#endregion
}
else if (_action == "qiandao")
{
#region 签到
jsonDict = new Dictionary<string, string>();
sid = MyCommFun.RequestInt("sid");
uid = MyCommFun.RequestInt("uid");
if (sid == 0 || uid == 0)
{
jsonDict.Add("ret", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
bool hasqd = conBll.hasDayQD(sid, uid, DateTime.Now);
int retScore = 0;
if (!hasqd)
{
//新增
//取签到积分策略
score = scoreBll.GetStoreModel(sid);
if (score != null)
{
//判断是否6天连续签到，并且6天内没有给额外的奖励
DateTime day6before = DateTime.Now.AddDays(-6);
int record = conBll.GetRecordCount("sId=" + sid + " and uid=" + uid + " and moduleType='签到' and addTime>='" + day6before.ToShortDateString() + "' and addTime<'" + DateTime.Now.ToShortDateString() + "' and moduleActionId=6 ");
if (record >= 5)
{
consume = new Model.wx_ucard_users_consumeinfo();
consume.sId = sid;
consume.uid = uid;
consume.moduleType = "签到";
consume.moduleActionName = "连续6天签到奖励";
consume.moduleActionId = 6;
consume.score = MyCommFun.Obj2Int(score.qiandao6Score) + score.qiandaoScore.Value;
conBll.AddJiFen(consume, 0);
retScore = MyCommFun.Obj2Int(score.qiandao6Score) + score.qiandaoScore.Value;
}
else
{
consume = new Model.wx_ucard_users_consumeinfo();
consume.sId = sid;
consume.uid = uid;
consume.moduleType = "签到";
consume.score = score.qiandaoScore.Value;
conBll.AddJiFen(consume, 0);
retScore = score.qiandaoScore.Value;
}
}
}
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "+" + retScore + "分，明天继续");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "tequan")
{
#region //消费： 特权 ,注意，只有在新增这个的时候记录user表总积分，修改的时候 对user表的总积分和金额先减后加
jsonDict = new Dictionary<string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid");//用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int pid = MyCommFun.RequestInt("pid");//特权主键id
string type = MyCommFun.QueryString("type");//tequan:特权
if (sid == 0 || uid == 0 || pid == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_privileges privBll = new BLL.wx_ucard_privileges();
Model.wx_ucard_privileges privileges = privBll.GetModel(pid);
if (privileges == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "特权不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//积分策略
score = scoreBll.GetStoreModel(sid);
int avgScore = score.consumeMoneyScore.Value / score.consumeMoney.Value;
//1先添加消费明细,和修改用户的总积分和总消费金额
//IList<Model.wx_ucard_users_consumeinfo> conlist = conBll.GetModelList("moduleType='特权' and moduleActionId=" + privileges.id + " and sid=" + sid + " and uid=" + uid);
//if (conlist == null || conlist.Count <= 0 || conlist[0] == null)
//{
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "特权";
consume.moduleActionId = privileges.id;
consume.moduleActionName = privileges.pName;
consume.sId = sid;
consume.uid = uid;
consume.consumeMoney = (decimal)money;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.cMoneyType = 2;
consume.score = (int)(avgScore * money);
consume.cScoreType = 1;
conBll.Add(consume,true);
//}
//else
//{
// //修改
// consume = conlist[0];
// decimal oldMoney = MyCommFun.Obj2Decimal(consume.consumeMoney, 0);
// int oldScore = MyCommFun.Obj2Int(consume.score);
// consume.moduleActionName = privileges.pName;
// consume.consumeMoney = (decimal)money;
// consume.sn = sn;
// consume.pwd = pwd;
// consume.cMoneyType = 2;
// consume.score = (int)(avgScore * money);
// conBll.UpdateInfoAndUserTT(consume, oldMoney, oldScore);
//}
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "获得" + consume.score.Value + "积分 ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "lq_yhq")
{
#region 领取优惠券
jsonDict = new Dictionary<string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid");//用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int ticketId = MyCommFun.RequestInt("cid");//优惠券主键id
if (sid == 0 || uid == 0 || ticketId == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_ticket ticketBll = new BLL.wx_ucard_ticket();
Model.wx_ucard_ticket ticket = ticketBll.GetModel(ticketId);
if (ticket == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "优惠券不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int syTimes = ticketBll.getsyTimesByTicket(uid, ticketId);
if (syTimes <= 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "已没有使用次数");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//积分策略
score = scoreBll.GetStoreModel(sid);
int avgScore = score.consumeMoneyScore.Value / score.consumeMoney.Value;
//1先添加消费明细,和修改用户的总积分和总消费金额
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "优惠券";
consume.moduleActionId = ticket.id;
consume.moduleActionName = ticket.tName;
consume.sId = sid;
consume.uid = uid;
consume.consumeMoney = (decimal)money;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.cMoneyType = 2;
consume.score = (int)(avgScore * money);
consume.cScoreType = 1;
conBll.Add(consume,true);
syTimes -= 1;
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "获得" + consume.score.Value + "积分 ");
jsonDict.Add("sy", syTimes.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
else if (_action == "gift")
{
#region 兑换礼品券
jsonDict = new Dictionary<string, string>();
sid = MyCommFun.RequestInt("sid"); //店铺id
uid = MyCommFun.RequestInt("uid");//用户id
string sn = MyCommFun.QueryString("sncode");
string pwd = MyCommFun.QueryString("parssword");
float money = MyCommFun.RequestFloat("money", 0);
int giftId = MyCommFun.RequestInt("gid");//礼品主键id
if (sid == 0 || uid == 0 || giftId == 0)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "error");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
if (pwd != store.consumePwd)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "密码错误");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int ssid = userBll.ExistsStoreAndUser(uid);
if (ssid == 0 || sid != ssid)
{ //验证，用户存在，店铺存在，并且用户属于这个店铺
return;
}
BLL.wx_ucard_gift giftBll = new BLL.wx_ucard_gift();
Model.wx_ucard_gift gift = giftBll.GetModel(giftId);
if (gift == null)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "优惠券不存在");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
int userTTScore = userBll.GetUserJiFen(uid);
if (userTTScore <gift.score.Value)
{
jsonDict.Add("ret", "error");
jsonDict.Add("msg", "积分不够");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
return;
}
//1先添加消费明细,和修改用户的总积分和总消费金额
//新增
consume = new Model.wx_ucard_users_consumeinfo();
consume.moduleActionId = 10;
consume.moduleType = "礼品券";
consume.moduleActionId = gift.id;
consume.moduleActionName = gift.gName;
consume.sId = sid;
consume.uid = uid;
consume.addTime = DateTime.Now;
consume.sn = sn;
consume.pwd = pwd;
consume.score = -gift.score.Value;
consume.cScoreType = 1;
conBll.Add(consume,false);
jsonDict.Add("ret", "succ");
jsonDict.Add("msg", "成功兑换礼品扣除 " + gift.score.Value + " 积分 ");
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
#endregion
}
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.privilegesPic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{
return;
}
uid = user.id;
int degreeNum = 0;
BLL.wx_ucard_fun.userDegree(sid, MyCommFun.Obj2Int(user.ttScore), "", out degreeNum);
BLL.wx_ucard_privileges privilegesBLL = new BLL.wx_ucard_privileges();
IList <Model.wx_ucard_privileges> plist = privilegesBLL.GetModelList(" sid=" + sid + " and ( userDegree ='0' or userDegree like '%," + degreeNum + ",%' ) and beginDate<='" + DateTime.Now + "' and endDate>='" + DateTime.Now + "' ");
StringBuilder pStr = new StringBuilder();
if (plist != null && plist.Count > 0)
{
Model.wx_ucard_privileges privileges = new Model.wx_ucard_privileges();
string sn = "";
for (int i = 0; i < plist.Count; i++)
{
privileges = plist[i];
sn = Utils.Number(16, true);
if (i == 0)
{
//第一条数据
pStr.Append(" <div id=\"test0-header\" class=\"accordion_headings header_highlight \">");
pStr.Append(" <div class=\"tab vip \">");
pStr.Append(" <span class=\"title\">" + privileges.pName + "<p>有效期至" + privileges.endDate.Value.ToString("yyyy年MM月dd日") + "</p></span>");
pStr.Append(" </div>");
pStr.Append(" <div id=\"test0-content\" style=\"display: block; overflow: hidden; opacity: 1;\">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append(" <p class=\"num\" onclick=\"jQ('#test0-content').height(300);document.getElementById('queren0').style.display=''\" id=\"sn0\">" + sn + "</p>");
pStr.Append(" <div id=\"queren0\" style=\"display: none\">");
pStr.Append(" <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"money0\" value=\"\" placeholder=\"请输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"bmoney0\" value=\"\" placeholder=\"请再次输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0 0 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword0\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append("<a id=\"showcard0\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"power(0,'" + sn + "','" + privileges.id + "')\">确定使用</a>");
pStr.Append(" </p> </div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
pStr.Append(" <b>详情说明</b>");
pStr.Append("<ul>" + privileges.usedContent + "</ul></div> </div> </div>");
}
else
{
pStr.Append(" <div id=\"test" + i + "-header\" class=\"accordion_headings \">");
pStr.Append(" <div class=\"tab vip \">");
pStr.Append(" <span class=\"title\">" + privileges.pName + "<p>有效期至" + privileges.endDate.Value.ToString("yyyy年MM月dd日") + "</p>");
pStr.Append(" </span> </div>");
pStr.Append(" <div id=\"test" + i + "-content\" style=\"display: none; overflow: hidden;\">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append("<p class=\"num\" onclick=\"jQ('#test" + i + "-content').height(300);document.getElementById('queren" + i + "').style.display=''\" id=\"sn" + i + "\">" + sn + "</p>");
pStr.Append("<div id=\"queren" + i + "\" style=\"display: none\"> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"money" + i + "\" value=\"\" placeholder=\"请输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" type=\"text\" class=\"px\" id=\"bmoney" + i + "\" value=\"\" placeholder=\"请再次输入实际消费金额\">");
pStr.Append(" </p> <p style=\"margin: 10px 0 0 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword" + i + "\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p><p style=\"margin: 10px 0\">");
pStr.Append(" <a id=\"showcard" + i + "\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"power(" + i + ",'" + sn + "','" + privileges.id + "')\">确定使用</a>");
pStr.Append(" </p></div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
pStr.Append(" <b>详情说明</b>");
pStr.Append(" <ul>所有的特权来吧 </ul></div> </div> </div>");
}
}
}
litPrivilegeslist.Text = pStr.ToString();
}
private void bindData()
{
BLL.wx_ucard_cardinfo cardBll = new BLL.wx_ucard_cardinfo();
Model.wx_ucard_cardinfo cardinfo = cardBll.GetModelBySid(sid);
if (cardinfo != null)
{
imgTopPic.ImageUrl = cardinfo.privilegesPic;
}
BLL.wx_ucard_users userBll = new BLL.wx_ucard_users();
Model.wx_ucard_users user = userBll.GetStoreUserInfo(openid, sid);
if (user == null)
{
return;
}
uid = user.id;
DateTime today = DateTime.Now;
IList <Model.wx_ucard_gift> glist = giftBLL.GetModelList(" sid=" + sid + " and beginDate<='" + today.ToString() + "' and endDate>='" + today.ToString() + "'");
StringBuilder pStr = new StringBuilder();
if (glist != null && glist.Count > 0)
{
Model.wx_ucard_gift gift = new Model.wx_ucard_gift();
string sn = "";
int syNum = 0; //剩余次数
for (int i = 0; i < glist.Count; i++)
{
gift = glist[i];
sn = Utils.Number(16, true);
if (i == 0)
{
//第一条数据
pStr.Append(" <div id=\"test0-header\" class=\"accordion_headings header_highlight \">");
pStr.Append(" <div class=\"tab gift \">");
pStr.Append(" <span class=\"title\">" + gift.gName + "(<span id=\"cid" + gift.id + "\">" + MyCommFun.Obj2Int(gift.score) + "</span>积分)<p>有效期至" + gift.endDate.Value.ToString("yyyy年MM月dd日") + "</p></span>");
pStr.Append(" </div>");
pStr.Append(" <div id=\"test0-content\" style=\"display: block; overflow: hidden; opacity: 1; \">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append(" <p class=\"num\" onclick=\"jQ('#test0-content').height(210);document.getElementById('queren0').style.display=''\" id=\"sn0\">" + sn + "</p>");
pStr.Append(" <div id=\"queren0\" style=\"display: none\">");
pStr.Append(" <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword0\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p> <p style=\"margin: 10px 0\">");
pStr.Append("<a id=\"showcard0\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"gift(0,'" + sn + "','" + gift.id + "')\">确定使用</a>");
pStr.Append(" </p> </div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
/*
* <p class="ewmimg">
* <img width="220" onclick="jQ('#test0-content').height(210);document.getElementById('queren0').style.display=''" src="http://comment.duapp.com/qrcode.php?url=http%3A%2F%2Fwww.apiwx.com%2Findex.php%3Fac%3Dcardpower3%26tid%3D4486%26c%3Do99epjsmex1G-PTaaHYb7vmeP588%26qrcode%3D1%26cid%3D0" /></p>
* **/
pStr.Append(" <b>详情说明</b>");
pStr.Append("<ul>" + gift.useContent + "</ul></div> </div> </div>");
}
else
{
pStr.Append(" <div id=\"test" + i + "-header\" class=\"accordion_headings \">");
pStr.Append(" <div class=\"tab gift \">");
pStr.Append(" <span class=\"title\">" + gift.gName + "(<span id=\"cid" + gift.id + "\">" + MyCommFun.Obj2Int(gift.score) + "</span>积分)<p>有效期至" + gift.endDate.Value.ToString("yyyy年MM月dd日") + "</p>");
pStr.Append(" </span> </div>");
pStr.Append(" <div id=\"test" + i + "-content\" style=\"display: none; overflow: hidden;\">");
pStr.Append(" <div class=\"accordion_child\">");
pStr.Append("<p class=\"num\" onclick=\"jQ('#test" + i + "-content').height(210);document.getElementById('queren" + i + "').style.display=''\" id=\"sn" + i + "\">" + sn + "</p>");
pStr.Append("<div id=\"queren" + i + "\" style=\"display: none\"> <p style=\"margin: 10px 0\">");
pStr.Append(" <input name=\"\" class=\"px\" id=\"parssword" + i + "\" value=\"\" type=\"password\" placeholder=\"请输入管理员密码\">");
pStr.Append(" </p><p style=\"margin: 10px 0\">");
pStr.Append(" <a id=\"showcard" + i + "\" class=\"submit\" href=\"javascript:void(0)\" onclick=\"gift(" + i + ",'" + sn + "','" + gift.id + "')\">确定使用</a>");
pStr.Append(" </p></div>");
pStr.Append(" <p class=\"explain_sn\"><span>点击处理</span></p>");
pStr.Append(" <b>详情说明</b>");
pStr.Append(" <ul>" + gift.useContent + "</ul></div> </div> </div>");
}
}
}
litGiftlist.Text = pStr.ToString();
}
