public string Process(RequestMsgModel msg) { SubscribeEventRequestMsgModel msgMode = msg as SubscribeEventRequestMsgModel; if (msgMode != null) { SiteActivityDAL dal = new SiteActivityDAL(); SiteActivity activity = dal.GetSiteAct(Params["SiteCode"].ToString(), "Coupon"); if (activity != null) { CouponDAL cdal = new CouponDAL(); if (!cdal.ExistCoupon(Params["SiteCode"].ToString(), activity.ID, msgMode.FromUserName)) { Coupon coupon = new Coupon() { SiteCode = Params["SiteCode"].ToString(), SiteActivityID = activity.ID, OpenID = msgMode.FromUserName, CouponCode = GetCouponCode(msgMode.FromUserName), CouponStatus = 0 }; cdal.InsertInfo(coupon); } } } return(string.Empty); }
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context) { CouponDAL dal = new CouponDAL(); DataSet ds = dal.GetCouponInfo(CouponID); MyCouponInfo model = new MyCouponInfo(); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { model = DataConvert.DataRowToModel <MyCouponInfo>(ds.Tables[0].Rows[0]); } this.SetQRCode(context, model.ID); context.TempData["pDetail"] = model; if (model.CouponStatus == "已经使用") { context.TempData["RemainDay"] = ""; } else { if (int.Parse(model.RemainDay) > -1) { context.TempData["RemainDay"] = "有效期:还剩" + model.RemainDay + "天"; } else { context.TempData["RemainDay"] = "有效期:此券已经过期!"; } } }
public CartController(Cart cart, TourDAL tourDAL, CouponDAL couponDAL, IConfiguration configuration) { this.cart = cart; this.tourDAL = tourDAL; this.couponDAL = couponDAL; this.logger = new LoggerConfiguration() .WriteTo.AzureBlobStorage(configuration["Data:StorageAccount"], Serilog.Events.LogEventLevel.Information, $"logs", "{yyyy}/{MM}/{dd}/log.txt").CreateLogger(); }
public void CheckOutCoupon(string strCouponID) { CouponDAL dal = new CouponDAL(); if (dal.UpdateCouponState(strCouponID)) { strCouponInfo = "优惠券已经提交使用。"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strSiteCode = string.Empty; string strOpenID = string.Empty; //MyCoupon.aspx?sitecode=$sitecode&openid=$openid if (null == Request.QueryString["sitecode"]) { return; } else { strSiteCode = Common.Common.NoHtml(Request.QueryString["sitecode"].ToString()); Session["strSiteCode"] = strSiteCode; } if (null == Request.QueryString["openid"]) { return; } else { if (Request.QueryString["openid"].ToString().Length > 29 || Request.QueryString["openid"].ToString().Length < 25) { strOpenID = Common.Common.NoHtml(Request.QueryString["openid"].ToString()); } else { strOpenID = Request.QueryString["openid"].ToString(); } Session["openid"] = strOpenID; } //取所有参加的活动列表 List <MyCouponInfo> liCoupon = new List <MyCouponInfo>(); CouponDAL dalCoup = new CouponDAL(); DataSet ds = dalCoup.GetCouponInfoList(strSiteCode, strOpenID); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { MyCouponInfo model = DataConvert.DataRowToModel <MyCouponInfo>(row); liCoupon.Add(model); } } string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/MyCoupon.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["coupon_list"] = liCoupon; context.TempData["OpenID"] = strOpenID; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); } }
/// <summary> /// 获取兑奖SN码 /// </summary> void GetSNcode() { string sncode = string.Empty; string peizeid = string.Empty; if (Request["peizeid"] != null && Request["peizeid"] != "") { peizeid = Common.Common.NoHtml(Request["peizeid"].ToString()); } if (strOpenID.Trim() != null && strOpenID.Trim() != "") { if (!AwardUserDal.ExistAwardUser(strOpenID, "", "", peizeid, strActID)) { sncode = GenerateCheckCode(7); if (AwardUserDal.UpdateUserSNCode(strOpenID, peizeid, strActID, sncode)) { string strGuid = Guid.NewGuid().ToString("N"); CouponDAL cdal = new CouponDAL(); Model.ACT.Coupon coupon = null; coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = strSiteCode, SiteActivityID = strActID, OpenID = strOpenID, CouponCode = sncode, CouponStatus = 0 }; cdal.InsertInfo(coupon); Response.Write("{\"success\":true,\"sn\":\"" + sncode + "\"}"); } else { Response.Write("{\"error\":\"invalid\"}"); } } else { sncode = AwardUserDal.GetSNCodeByPhone(strOpenID, "", "", strActID); if (sncode.Trim() != null && sncode.Trim() != "") { Response.Write("{\"error\":\"getsn\",\"sn\":\"" + sncode + "\"}"); } else { Response.Write("{\"error\":\"isdoing\"}"); } } } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,请重新操作\"}"); return; } }
protected void Page_Load(object sender, EventArgs e) { string strCouponID = string.Empty; string strSiteCode = string.Empty; string strAction = string.Empty; if (null == Request.QueryString["id"]) { return; } if (null != Request.QueryString["action"]) { strCouponID = Common.Common.NoHtml(Request.QueryString["id"].ToString()); strAction = Common.Common.NoHtml(Request.QueryString["action"].ToString()); if (strAction == "checkout") { CheckOutCoupon(strCouponID); } } strCouponID = Common.Common.NoHtml(Request.QueryString["id"].ToString()); CouponDAL dal = new CouponDAL(); DataSet ds = dal.GetCouponInfo(strCouponID); MyCouponInfo model = new MyCouponInfo(); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { model = DataConvert.DataRowToModel <MyCouponInfo>(ds.Tables[0].Rows[0]); } string text = System.IO.File.ReadAllText(Server.MapPath("QRNotUse.html")); //读取模板内容 if (model.CouponStatus == "未使用") { text = System.IO.File.ReadAllText(Server.MapPath("QRNotUse.html")); } else { text = System.IO.File.ReadAllText(Server.MapPath("QRIsUse.html")); } JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["title"] = "奥琦微商易优惠券"; context.TempData["note"] = model.ActTitle; context.TempData["id"] = strCouponID; context.TempData["content"] = model.Remark; context.TempData["errinfo"] = strCouponInfo; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
protected override bool BeforeLoad() { if (null == Request.QueryString["id"]) { return(false); } CouponID = Common.Common.NoHtml(Request.QueryString["id"].ToString()); string strGuid = string.Empty; if (null != Request.QueryString["sitecode"] && null != Request.QueryString["openid"]) { SiteCode = Common.Common.NoHtml(Request.QueryString["sitecode"].ToString()); OpenID = Common.Common.NoHtml(Request.QueryString["openid"].ToString()); //插入优惠券 SiteActivityDAL dalActive = new SiteActivityDAL(); DataSet dsActive = dalActive.GetActivityDetail(CouponID); if (null != dsActive && dsActive.Tables.Count > 0 && dsActive.Tables[0].Rows.Count > 0) { strGuid = Guid.NewGuid().ToString("N"); CouponDAL cdal = new CouponDAL(); if (!cdal.ExistCoupon(SiteCode, CouponID, OpenID)) { Coupon coupon = new Coupon() { ID = strGuid, SiteCode = SiteCode, SiteActivityID = CouponID, OpenID = OpenID, CouponStatus = 0 }; cdal.InsertInfo(coupon); } } CouponID = strGuid; } else { SiteActivityDAL dalActive = new SiteActivityDAL(); DataSet dsActive = dalActive.GetActivityDetail(CouponID); if (null != dsActive && dsActive.Tables.Count > 0 && dsActive.Tables[0].Rows.Count > 0) { SiteCode = dsActive.Tables[0].Rows[0]["SIteCode"].ToString(); } } return(base.BeforeLoad()); }
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context) { base.AddTempData(context); //取最新抢购的优惠活动 List <Model.ACT.SiteActivity> liActive = new List <Model.ACT.SiteActivity>(); DAL.ACT.SiteActivityDAL dalActive = new SiteActivityDAL(); List <MyCouponInfo> liCoupon = new List <MyCouponInfo>(); CouponDAL dalCoup = new CouponDAL(); DataSet dsActive = dalActive.GetActivityList(" SiteCode = '" + SiteCode + "' AND ActStatus = 1 AND ActType = 'RushCoupon' AND StartTime < GETDATE() AND EndTime > GETDATE() "); if (null != dsActive && dsActive.Tables.Count > 0 && dsActive.Tables[0].Rows.Count > 0) { foreach (DataRow row in dsActive.Tables[0].Rows) { if (!dalCoup.ExistCoupon(SiteCode, row["ID"].ToString(), OpenID)) { Model.ACT.SiteActivity modelActive = DataConvert.DataRowToModel <Model.ACT.SiteActivity>(row); liActive.Add(modelActive); } } } DataSet ds = dalCoup.GetCouponInfoList(SiteCode, OpenID); string strInfo = string.Empty; if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { MyCouponInfo model = DataConvert.DataRowToModel <MyCouponInfo>(row); liCoupon.Add(model); } } else { strInfo = "亲,你还没有参加过活动哦,多多关注我们的新活动!"; } context.TempData["openid"] = OpenID; context.TempData["rushcoupon_list"] = liActive; context.TempData["coupon_list"] = liCoupon; context.TempData["couponinfo"] = strInfo; }
protected void btnCoupon_Click(object sender, EventArgs e) { string strWhere = " "; if (Session["strRoleCode"].ToString() != "ADMIN") { strWhere = " a.SiteCode = '" + Session["strSiteCode"].ToString() + "' "; } if (ddlselectName.SelectedValue.Trim() != null && ddlselectName.SelectedValue.Trim() != "" && ddlselectName.SelectedValue.Trim() != "0") { if (strWhere.Trim() != null && strWhere.Trim() != "") { strWhere = strWhere + " AND "; } strWhere = strWhere + " b.ID='" + ddlselectName.SelectedValue + "' "; } if (ddlselectName.SelectedValue.Trim() != null && ddlselectName.SelectedValue.Trim() != "" && ddlselectName.SelectedValue.Trim() != "0") { if (strWhere.Trim() != null && strWhere.Trim() != "") { strWhere = strWhere + " AND "; } string arrow = GetLoseWin(ddlselectName.SelectedValue); if (arrow == "0") { MessageBox.Show(this, "请设置正确的比赛结果再做统计!"); return; } strWhere = strWhere + " [dbo].[split](GuessScore,':',0) " + arrow + " [dbo].[split](GuessScore,':',1) "; } else { MessageBox.Show(this, "操作失败,请选择相应的赛事!"); return; } JC_ScoreDAL dal = new JC_ScoreDAL(); DataSet ds = dal.GetJCScoreListByStateNO(strWhere); //取正确比分 foreach (DataRow row in ds.Tables[0].Rows) { string strOpenID = row["OpenID"].ToString(); string strScoreID = row["ID"].ToString(); string strGuessScore = row["GuessScore"].ToString(); string strRightScore = row["RightScore"].ToString(); //修改竞猜状态; dal.UpdateJCScoreState(strScoreID); //写入优惠券 //AC87CE288FC24F23B7B68CE8F3D93D13 string strGuid = Guid.NewGuid().ToString("N"); CouponDAL cdal = new CouponDAL(); string strSiteCode = Session["strSiteCode"].ToString(); Model.ACT.Coupon coupon = null; if (strGuessScore == strRightScore) { coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = Session["strSiteCode"].ToString(), SiteActivityID = "AC87CE288FC24F23B7B68CE8F3D93D18", OpenID = strOpenID, CouponStatus = 0 }; } else { coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = Session["strSiteCode"].ToString(), SiteActivityID = "AC87CE288FC24F23B7B68CE8F3D93D22", OpenID = strOpenID, CouponStatus = 0 }; } cdal.InsertInfo(coupon); } MessageBox.Show(this, "优惠券发放完成!"); }
/// <summary> /// 处理回复消息 /// "text":回复文本消息处理,MsgValue对应回复的文本 /// "sub_auto_coupon":回复订阅自动优惠券处理,MsgValue对应回复的图文消息ID /// "auto_news_article":根据文章自动生成图文消息进行回复,MsgValue为类别ID /// "news":回复图文表中的消息,MsgValue为图文消息表ID集,用逗号分隔 /// </summary> /// <param name="replyMsgType"></param> /// <param name="replyMsgValue"></param> /// <param name="customParams"></param> /// <returns></returns> private string ProcessReply(RequestMsgModel msgModel, string replyMsgType, string replyMsgValue) { string res = string.Empty; try { switch (replyMsgType.ToLower()) { case "text": //回复文本消息处理,MsgValue对应回复的文本 TextResponseMsgModel textMsg = new TextResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), Content = replyMsgValue == null ? string.Empty : TransformText(replyMsgValue, msgModel) }; res = textMsg.ToString(); break; case "voice": //回复语音消息处理,MsgValue对应回复的文本 VoiceResponseMsgModel voiceMsg = new VoiceResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), }; Media media = MediaDAL.CreateInstance().GetMediaByID(replyMsgValue); if (media != null && !string.IsNullOrEmpty(media.MediaID)) { voiceMsg.MediaId = media.MediaID; } res = voiceMsg.ToString(); break; case "wxpay_test": //用于微信支付测试 TextResponseMsgModel textMsgx = new TextResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), Content = string.Format("<a href='{0}/Payment/wxpay/wxpayDemo.aspx?openid={1}'>微信支付测试</a>", GetSiteUrl(), msgModel.FromUserName) }; res = textMsgx.ToString(); break; case "transfer_customer_service": //将消息转发到多客服 TransferCustomerServiceResponseMsgModel transferMsg = new TransferCustomerServiceResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), }; res = transferMsg.ToString(); break; case "sub_auto_coupon": //回复订阅自动优惠券处理,MsgValue对应回复的优惠券图文消息ID //SubscribeCouponActHandle sch = new SubscribeCouponActHandle(); SiteActivityDAL dal = new SiteActivityDAL(); SiteActivity activity = dal.GetSiteAct(siteCode, "Coupon"); if (activity != null) { CouponDAL cdal = new CouponDAL(); if (!cdal.ExistCoupon(siteCode, activity.ID, msgModel.FromUserName)) { Coupon coupon = new Coupon() { SiteCode = siteCode, SiteActivityID = activity.ID, OpenID = msgModel.FromUserName, //CouponCode = msgModel.FromUserName, CouponStatus = 0 }; cdal.InsertInfo(coupon); } } CouponNewsDAL nmDAL = new CouponNewsDAL(); CouponNews nm = nmDAL.GetCouponNews(replyMsgValue); if (nm != null) { NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); articles.Add(new Article() { Title = nm.Title, Description = nm.Description, PicUrl = GetPicUrl(nm.PicUrl), Url = TransformUrl(nm.Url, msgModel) }); newsModel.Articles = articles; res = newsModel.ToString(); } break; case "auto_coupon_category": SiteActivityDAL dalCatList = new SiteActivityDAL(); SiteActivity activityCat = dalCatList.GetSiteAct(siteCode, "Coupon"); if (activityCat != null) { CouponDAL cdal = new CouponDAL(); if (!cdal.ExistCoupon(siteCode, activityCat.ID, msgModel.FromUserName)) { Coupon coupon = new Coupon() { SiteCode = siteCode, SiteActivityID = activityCat.ID, OpenID = msgModel.FromUserName, //CouponCode = msgModel.FromUserName, CouponStatus = 0 }; cdal.InsertInfo(coupon); } } ArticleDAL catDal = new ArticleDAL(); DataSet cdsCat = catDal.GetCategoryList(siteCode, replyMsgValue); if (cdsCat != null && cdsCat.Tables.Count > 0 && cdsCat.Tables[0] != null && cdsCat.Tables[0].Rows.Count > 0) { int i = 0; NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); foreach (DataRow dr in cdsCat.Tables[0].Rows) { if (++i > 4) { break; } articles.Add(new Article() { Title = dr["Title"].ToString(), Description = dr["Summary"].ToString(), //Description = RemoveHtmlTag(dr["Content"].ToString(), 30), PicUrl = GetPicUrl(dr["Pic"].ToString()), Url = GetArticleUrl(dr["ID"].ToString()) }); } newsModel.Articles = articles; res = newsModel.ToString(); } break; case "auto_news_article": //根据文章自动生成图文消息进行回复,MsgValue为文章ID ArticleDAL aDal = new ArticleDAL(); DataSet ds = aDal.GetArticleDetail(replyMsgValue); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { int i = 0; NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); foreach (DataRow dr in ds.Tables[0].Rows) { if (++i > 4) { break; } articles.Add(new Article() { Title = dr["Title"].ToString(), Description = dr["Summary"].ToString(), //Description = RemoveHtmlTag(dr["Content"].ToString(), 100), PicUrl = GetPicUrl(dr["Pic"].ToString()), Url = GetArticleUrl(dr["ID"].ToString()) }); } newsModel.Articles = articles; res = newsModel.ToString(); } break; case "auto_news_category": //根据类别自动生成图文消息进行回复,MsgValue为类别ID ArticleDAL cDal = new ArticleDAL(); DataSet cds = cDal.GetCategoryList(siteCode, replyMsgValue); if (cds != null && cds.Tables.Count > 0 && cds.Tables[0] != null && cds.Tables[0].Rows.Count > 0) { int i = 0; NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); foreach (DataRow dr in cds.Tables[0].Rows) { if (++i > 4) { break; } articles.Add(new Article() { Title = dr["Title"].ToString(), Description = dr["Summary"].ToString(), //Description = RemoveHtmlTag(dr["Content"].ToString(), 30), PicUrl = GetPicUrl(dr["Pic"].ToString()), Url = GetArticleUrl(dr["ID"].ToString()) }); } newsModel.Articles = articles; res = newsModel.ToString(); } break; case "coupon": //回复图文表中的消息,MsgValue为图文消息表ID集,用逗号分隔 NewsMsgDAL nmDAL1 = new NewsMsgDAL(); NewsMsg nms = nmDAL1.GetNewsMsg(replyMsgValue); if (nms != null) { NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); articles.Add(new Article() { Title = nms.Title, Description = nms.Description, PicUrl = GetPicUrl(nms.PicUrl), Url = TransformUrl(nms.Url, msgModel) }); newsModel.Articles = articles; res = newsModel.ToString(); } break; case "news": //回复图文表中的消息,MsgValue为图文消息表ID集,用逗号分隔 NewsMsgDAL nmDALs = new NewsMsgDAL(); IList <NewsMsg> newsMsgs = nmDALs.GetNewsMsgs(replyMsgValue); if (newsMsgs != null) { NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); foreach (NewsMsg msg in newsMsgs) { articles.Add(new Article() { Title = msg.Title, Description = msg.Description, PicUrl = GetPicUrl(msg.PicUrl), Url = TransformUrl(msg.Url, msgModel) }); } newsModel.Articles = articles; res = newsModel.ToString(); } break; case "url": //根据文章自动生成图文消息进行回复,MsgValue为文章ID DAL.SYS.AccountDAL dalUrl = new DAL.SYS.AccountDAL(); DataSet dsUrl = dalUrl.GetAccountExtData(replyMsgValue); if (dsUrl != null && dsUrl.Tables.Count > 0 && dsUrl.Tables[0] != null && dsUrl.Tables[0].Rows.Count > 0) { int i = 0; NewsResponseMsgModel newsModel = new NewsResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString() }; List <Article> articles = new List <Article>(); foreach (DataRow dr in dsUrl.Tables[0].Rows) { if (++i > 4) { break; } articles.Add(new Article() { Title = dr["Name"].ToString(), Description = dr["Summary"].ToString(), PicUrl = GetPicUrl(dr["Photo"].ToString()), Url = GetSiteInfo(dr["ID"].ToString()) }); } newsModel.Articles = articles; res = newsModel.ToString(); } break; case "hp_photo_text": //为当前hp_photo对应的照片附加文字信息 PhotoDAL photoDal = new PhotoDAL(); if (photoDal.ExistPhoto(siteCode, msgModel.FromUserName, 0)) { TextRequestMsgModel temp = msgModel as TextRequestMsgModel; string text = temp.Content.Replace("#ms", ""); //附加图片文字 photoDal.UpdateAttachText(siteCode, msgModel.FromUserName, text); TextResponseMsgModel textMsg2 = new TextResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), Content = replyMsgValue == null ? string.Empty : TransformText(replyMsgValue, msgModel) }; res = textMsg2.ToString(); } else { TextResponseMsgModel textMsg2 = new TextResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), Content = "对不起,您暂未参加图片打印活动!" }; res = textMsg2.ToString(); } break; case "hp_photo_ticket": //对当前hp_photo对应的照片进行打印认证 PrintCodeDAL printCodeDAL = new PrintCodeDAL(); TextRequestMsgModel temp1 = msgModel as TextRequestMsgModel; string printCode = temp1.Content.Replace("#dy", ""); string clientID = printCodeDAL.GetClientIDByPrintCode(printCode, siteCode); ExceptionLogDAL.InsertExceptionLog(new ExceptionLog() { Message = clientID }); if (!string.IsNullOrEmpty(clientID)) { PhotoDAL photoDal1 = new PhotoDAL(); photoDal1.UpdatePrintInfo(printCode, clientID, siteCode, msgModel.FromUserName); TextResponseMsgModel textMsg2 = new TextResponseMsgModel() { ToUserName = msgModel.FromUserName, FromUserName = msgModel.ToUserName, CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), Content = replyMsgValue == null ? string.Empty : TransformText(replyMsgValue, msgModel) }; res = textMsg2.ToString(); //TextResponseMsgModel textMsg2 = new TextResponseMsgModel() //{ // ToUserName = msgModel.FromUserName, // FromUserName = msgModel.ToUserName, // CreateTime = WeiXinHelper.ConvertDateTimeInt(DateTime.Now).ToString(), // Content = "照片打印中,请稍侯..." //}; //res = textMsg2.ToString(); } break; default: break; } } catch (Exception ex) { ExceptionLogDAL.InsertExceptionLog(ex); } return(res); }
/// <summary> /// 用户注册 /// </summary> void saveUserinfo() { if (strOpenID != null && strOpenID != "") { if (!AwardUserDal.ExistAwardUser(strOpenID, "", "", "", "")) { LuckyAwardUsers usermodel = new LuckyAwardUsers(); usermodel.ID = Guid.NewGuid().ToString("N").ToUpper(); usermodel.IsDel = 0; usermodel.OpenID = strOpenID; usermodel.SendAward = 0; usermodel.ActID = strActID; if (AwardUserDal.AddAwardUsers(usermodel)) { Random ran = new Random(); int RandKey = ran.Next(0, 6); string strGuid = Guid.NewGuid().ToString("N"); string strSN = GenerateCheckCode(7); string strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04"; switch (RandKey) { case 1: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D01"; break; case 2: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D02"; break; case 3: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D03"; break; case 4: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04"; break; case 5: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D05"; break; case 6: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D06"; break; default: strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04"; break; } CouponDAL cdal = new CouponDAL(); Model.ACT.Coupon coupon = null; coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = strSiteCode, SiteActivityID = strCouActID, OpenID = strOpenID, CouponCode = strSN, CouponStatus = 0 }; cdal.InsertInfo(coupon); Response.Write("{\"success\":\"true\",\"prizetype\":\"" + RandKey.ToString() + "\",\"sn\":\"a" + strSN + "\"}"); } else { Response.Write("{\"error\":\"invalid\"}"); } } else { //Response.Write("{\"prizetype\":\"null\",\"sn\":\"no\"}"); Response.Write("{\"error\":\"isdoing\"}"); } } else { Response.Write("{\"prizetype\":\"null\",\"sn\":\"no\"}"); } }
protected override bool BeforeLoad() { string strGuid = string.Empty; if (null != Request.QueryString["sitecode"] && null != Request.QueryString["openid"] && null != Request.QueryString["couponid"]) { CouponID = Common.Common.NoHtml(Request.QueryString["couponid"].ToString()); SiteCode = Common.Common.NoHtml(Request.QueryString["sitecode"].ToString()); if (Request.QueryString["sitecode"].ToString().Length > 6) { return(false); } if (Request.QueryString["couponid"].ToString().Length != 32) { return(false); } if (Request.QueryString["openid"].ToString().Length > 29 || Request.QueryString["openid"].ToString().Length < 25) { return(false); } else { OpenID = Request.QueryString["openid"].ToString(); } //插入优惠券 SiteActivityDAL dalActive = new SiteActivityDAL(); DataSet dsActive = dalActive.GetActivityDetail(CouponID); if (null != dsActive && dsActive.Tables.Count > 0 && dsActive.Tables[0].Rows.Count > 0) { strGuid = Guid.NewGuid().ToString("N"); CouponDAL cdal = new CouponDAL(); if (!cdal.ExistCoupon(SiteCode, CouponID, OpenID)) { //判断是否可以参加 //取当前已经参加的人数 int iCount = 10000000; if (null != dsActive.Tables[0].Rows[0]["DayLimit"].ToString()) { string strCount = "SiteCode = '" + SiteCode + "' AND SiteActivityID = '" + CouponID + "' AND CONVERT(VARCHAR(10),AddTime,120) = CONVERT(VARCHAR(10),GETDATE(),120)"; iCount = cdal.GetCouponCount(strCount); } string strStartTime = dsActive.Tables[0].Rows[0]["StartTime"].ToString(); string strEndTime = dsActive.Tables[0].Rows[0]["EndTime"].ToString(); string strOpenTime = dsActive.Tables[0].Rows[0]["OpenTime"].ToString(); string strCloseTime = dsActive.Tables[0].Rows[0]["CloseTime"].ToString(); string strDayLimit = dsActive.Tables[0].Rows[0]["DayLimit"].ToString(); if (DateTime.Now >= Convert.ToDateTime(strStartTime) && DateTime.Now < Convert.ToDateTime(strEndTime) && DateTime.Now.Hour >= int.Parse(strOpenTime) && DateTime.Now.Hour < int.Parse(strCloseTime) ) { if (iCount < int.Parse(strDayLimit)) { Coupon coupon = new Coupon() { ID = strGuid, SiteCode = SiteCode, SiteActivityID = CouponID, OpenID = OpenID, CouponStatus = 0 }; cdal.InsertInfo(coupon); strReHtml = "RushBuyOK.html"; } else { strReHtml = "RushBuyOver.html"; strMessage = "抱歉!优惠券已经被抢完,请关注下期活动!"; } } else { strReHtml = "RushBuyOver.html"; strMessage = "抱歉!近期活动未开始或者已经结束,请关注公方微信优惠消息!"; } } else { strReHtml = "RushBuyOver.html"; strMessage = "抱歉!您已经参与了活动,请把机会留给其余的顾客。"; } } CouponID = strGuid; } else { Response.Write("<script>window.opener=null;window.close();</script>"); return(false); } return(base.BeforeLoad()); }
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context) { base.AddTempData(context); CouponDAL dal = new CouponDAL(); DataSet ds = dal.GetCouponInfo(CouponID); MyCouponInfo model = new MyCouponInfo(); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { model = DataConvert.DataRowToModel <MyCouponInfo>(ds.Tables[0].Rows[0]); } //读取模板内容 //string text = System.IO.File.ReadAllText(Server.MapPath("Themes/Default/" + strReHtml)); //JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); if (strReHtml == "RushBuyOK.html" || strReHtml == "QJTVRushBuyOK.html") { this.SetQRCode(context, model.ID); context.TempData["pDetail"] = model; if (model.CouponStatus == "已经使用") { context.TempData["RemainDay"] = ""; } else { if (int.Parse(model.RemainDay) > -1) { context.TempData["RemainDay"] = "有效期:还剩" + model.RemainDay + "天"; } else { context.TempData["RemainDay"] = "有效期:此券已经过期!"; } } } else { #region 消费完成发生消息 string strAppID = string.Empty; string strSecret = string.Empty; Model.WeiXin.WXConfig wc = new Model.WeiXin.WXConfig(); WXConfigDAL wcdal = new WXConfigDAL(); wc = wcdal.GetWXConfigBySiteCode(SiteCode); if (null != wc) { strAppID = wc.WXAppID; strSecret = wc.WXAppSecret; } string strToken = WeiXinHelper.GetAccessToken(strAppID, strSecret); var KeyToken = new { access_token = "" }; var b = JsonConvert.DeserializeAnonymousType(strToken, KeyToken); string strRToken = b.access_token; WeiXinHelper.SendCustomTextMessage(strRToken, OpenID, strMessage); #endregion //Response.Write("<script>document.addEventListener('WeixinJSBridgeReady', function onBridgeReady() { WeixinJSBridge.call('closeWindow');});</script>"); //Response.Redirect("MyCoupon.aspx?SiteCode=" + strSiteCode + "&OpenID=" + strOpenID); //return; } context.TempData["strmsg"] = strMessage; context.TempData["OpenID"] = OpenID; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strSiteCode = string.Empty; string strOpenID = string.Empty; //if (null == Request["state"] || Request["state"] == "") if (null == Request.QueryString["state"]) { return; } else { strSiteCode = Common.Common.NoHtml(Request.QueryString["state"].ToString()); Session["strSiteCode"] = strSiteCode; } string code = Request.QueryString["code"] as string; if (!string.IsNullOrEmpty(code)) { WXConfigDAL dal = new WXConfigDAL(); Model.WeiXin.WXConfig wxConfig = dal.GetWXConfigBySiteCode(strSiteCode); if (wxConfig != null) { WeiXinCore.Models.WeiXinConfig weixinConfig = new WeiXinCore.Models.WeiXinConfig() { ID = wxConfig.WXID, Name = wxConfig.WXName, Token = wxConfig.WXToken, AppId = wxConfig.WXAppID, AppSecret = wxConfig.WXAppSecret }; WeiXinCore.WeiXin weixin = new WeiXinCore.WeiXin(weixinConfig); Oauth2AccessToken oauth2AccessToken = weixin.GetOauth2AccessToken(code); if (oauth2AccessToken != null) { strOpenID = oauth2AccessToken.OpenID; } } else { strOpenID = code; } } Session["OpenID"] = strOpenID; //取所有参加的活动列表 List <MyCouponInfo> liCoupon = new List <MyCouponInfo>(); CouponDAL dalCoup = new CouponDAL(); DataSet ds = dalCoup.GetCouponInfoList(strSiteCode, strOpenID); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { MyCouponInfo model = DataConvert.DataRowToModel <MyCouponInfo>(row); liCoupon.Add(model); } } string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/ActiveList.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["coupon_list"] = liCoupon; context.TempData["OpenID"] = strOpenID; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); } }
public CouponBLL() { dal = new CouponDAL(); }