/// <summary> /// 插入优惠卷信息 /// </summary> /// <param name="info"></param> public bool InsertInfo(Model.Site.ConRecords info) { StringBuilder strSql = new StringBuilder(); strSql.Append(" INSERT INTO [Site_ConRecords] ([ID],[SiteCode],[OpenID],[MemberShipNo],[CreateTime],[Price]) "); strSql.Append(" VALUES (@ID,@SiteCode,@OpenID,@MemberShipNo,@CreateTime,@Price)"); System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", info.ID), new System.Data.SqlClient.SqlParameter("@SiteCode", info.SiteCode), new System.Data.SqlClient.SqlParameter("@OpenID", info.OpenID), new System.Data.SqlClient.SqlParameter("@MemberShipNo", info.MemberShipNo), new System.Data.SqlClient.SqlParameter("@CreateTime", info.CreateTime), new System.Data.SqlClient.SqlParameter("@Price", info.Price) }; int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { string strOpenID = string.Empty; string strSiteCode = string.Empty; string strMemNo = string.Empty; string strAction = string.Empty; string strPrice = string.Empty; string strCode = string.Empty; if (null == Request.QueryString["SiteCode"]) { return; } if (null == Request.QueryString["MemNo"]) { return; } if (null == Request.QueryString["OpenId"]) { return; } strOpenID = Common.Common.NoHtml(Request.QueryString["OpenId"].ToString()); strSiteCode = Common.Common.NoHtml(Request.QueryString["SiteCode"].ToString()); strMemNo = Common.Common.NoHtml(Request.QueryString["MemNo"].ToString()); if (null != Request.QueryString["action"]) { strAction = Request.QueryString["action"]; if (string.IsNullOrEmpty(strSiteCode)) { return; } strPrice = Request.Form["txtFee"].ToString(); strCode = Request.Form["txtCode"].ToString(); if (strAction == "checkout" && strCode == "888666") { DAL.Site.ConRecordsDAL dal = new DAL.Site.ConRecordsDAL(); Model.Site.ConRecords modelAdd = new Model.Site.ConRecords { ID = Guid.NewGuid().ToString("N").ToUpper(), SiteCode = strSiteCode, MemberShipNo = strMemNo, OpenID = strOpenID, CreateTime = DateTime.Now, Price = float.Parse(strPrice) }; if (dal.InsertInfo(modelAdd)) { strInfo = "消费记录生成完成。"; #region 消费完成发生消息 //string strAppID = string.Empty; //string strSecret = string.Empty; //Model.WeiXin.WXConfig wc = new Model.WeiXin.WXConfig(); //WXConfigDAL wcdal = new WXConfigDAL(); //wc = wcdal.GetWXConfigBySiteCode(strSiteCode); //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, strOpenID, "欢迎到海立方消费!"); #endregion strOpenID = string.Empty; strSiteCode = string.Empty; strMemNo = string.Empty; strAction = string.Empty; strPrice = string.Empty; } } } string text = System.IO.File.ReadAllText(Server.MapPath("CustMemNo.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["sitecode"] = strSiteCode; context.TempData["openid"] = strOpenID; context.TempData["memno"] = strMemNo; context.TempData["title"] = "会员消费处理"; context.TempData["errinfo"] = strInfo; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }