protected void Page_Load(object sender, EventArgs e) { order_number = Request.QueryString["orderdd"]; BLL.HG.Hg_list order = new BLL.HG.Hg_list(); Model.HG.HG_order model = order.Getorder(order_number); name = model.Nursing_name; tel = model.Nursing_tel; nur_sex = model.Nursing_sex; total = model.Total.ToString(); Status_order = model.Status_order; Str_sm = model.str_sm; server_time = model.Service_time; server_day = model.Service_day; by_age = model.By_age; by_name = model.By_name; by_sex = model.By_sex; by_care = model.By_care; by_adress = model.By_adress; HUli_type = model.HUli_type; hg_number = model.Hg_number; BLL.HG.Hg_list bb = new BLL.HG.Hg_list(); Model.HG.HGlist get = bb.Getmodel(int.Parse(hg_number)); hg_name_s = get.Phone; HiddenField1.Value = hg_number; HiddenField2.Value = hg_name_s; }
public Model.HG.HG_order DataRowToModel_order(DataRow row) { Model.HG.HG_order model = new Model.HG.HG_order(); if (row != null) { model.Total = double.Parse(row["Total"].ToString()); model.By_name = row["By_name"].ToString(); model.Openid = row["Openid"].ToString(); model.Service_time = row["Service_time"].ToString(); model.Hg_name = row["Hg_name"].ToString(); model.By_adress = row["By_adress"].ToString(); model.Nursing_name = row["Nursing_name"].ToString(); model.Nursing_tel = row["Nursing_tel"].ToString(); model.Nursing_sex = row["Nursing_sex"].ToString(); model.By_age = row["By_age"].ToString(); model.By_name = row["By_name"].ToString(); model.By_sex = row["By_sex"].ToString(); model.By_care = row["By_care"].ToString(); model.str_sm = row["Str_sm"].ToString(); model.HUli_type = row["Huli_type"].ToString(); model.Service_day = row["Service_day"].ToString(); model.Status_order = row["Status_order"].ToString(); model.Hg_number = row["Hg_number"].ToString(); } return(model); }
/// <summary> /// 微信发送模板消息 /// </summary> public void SendTemplateMessageTest() { // 您好,已为您成功预约上门服务。 //项目:高级美甲 //时间:2015年10月1日14:00~16:00 //技师:志玲 //费用:98元 //地址:西安市雁塔区曲江金地湖城大境 //2015年9月28日 16:36 BLL.HG.Hg_list order_T = new BLL.HG.Hg_list(); Model.HG.HG_order model = order_T.Getorder(Request.QueryString["order"]); var openId = HttpContext.Current.Request.Cookies["open_id"].Value; //换成已经关注用户的openId var templateId = "D_WYLHdtug59Q-e1DhPQHrQGB8MurmOhABo44y6qahQ"; //换成已经在微信后台添加的模板Id var accessToken = Token(); var testData = new //TestTemplateData() { first = new TemplateDataItem("您好,预约通知", "#F70D12"), keyword1 = new TemplateDataItem("医院护理"), keyword2 = new TemplateDataItem(model.Service_time), keyword3 = new TemplateDataItem(model.Hg_name, "#0AD690"), keyword4 = new TemplateDataItem((model.Total).ToString() + "元"), keyword5 = new TemplateDataItem(model.By_adress), remark = new TemplateDataItem(DateTime.Now.ToString()) }; var result = Senparc.Weixin.MP.AdvancedAPIs.TemplateApi.SendTemplateMessage(accessToken, openId, templateId, "http://www.hugongll.com/templates/Doc/order.aspx", testData); }
/// <summary> /// 更改评价 /// </summary> /// <returns></returns> public bool update_star(Model.HG.HG_order nn) { StringBuilder str = new StringBuilder(); str.Append(" update A_HG_oreder "); str.Append(" set Rated_status='" + nn.Rated_status + "',Status_order='已完成',Rated_hg='" + nn.Rated_hg + "' where Order_dd='" + nn.Order_dd + "'; "); int row = DbHelperSQL.ExecuteSql(str.ToString()); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 微信发送模板消息 /// </summary> public void SendTemplateMessageTest_hg() { // 您好,已为您成功预约上门服务。 //项目:高级美甲 //时间:2015年10月1日14:00~16:00 //技师:志玲 //费用:98元 //地址:西安市雁塔区曲江金地湖城大境 //2015年9月28日 16:36 // {{first.DATA}} //客户姓名:{{keyword1.DATA}} //联系电话:{{keyword2.DATA}} //上门时间:{{keyword3.DATA}} //支付信息:{{keyword4.DATA}} //服务地址:{{keyword5.DATA}} //{{remark.DATA}} // 你好,你收到一个新订单 //客户姓名:张三丰 //联系电话:13515812621 //上门时间:2015年5月26日 12:00 //支付信息:微信支付 ¥200.00 //服务地址:上海市浦东新区环林西路 //请联系你的客户,并及时提供服务 int number = int.Parse(Request.QueryString["kk"]); BLL.HG.Hg_list order_T = new BLL.HG.Hg_list(); int Hg_number = int.Parse(Request.QueryString["kk"]); Model.HG.HGlist model_hg = order_T.Getmodel(Hg_number); Model.HG.HG_order model = order_T.Getorder(Request.QueryString["order"]); var openId = model_hg.open_id_hg; //换成已经关注用户的openId var templateId = "6oFH4updt21Zfwbks6O7erhZRlOI6jS3Yju8l9qFsw4"; //换成已经在微信后台添加的模板Id var accessToken = Token(); var testData = new //TestTemplateData() { first = new TemplateDataItem("您好,新订单通知"), keyword1 = new TemplateDataItem(model.Nursing_name), keyword2 = new TemplateDataItem(model.Nursing_tel), keyword3 = new TemplateDataItem(model.Service_time), keyword4 = new TemplateDataItem("微信支付:" + (model.Total).ToString() + "元"), keyword5 = new TemplateDataItem(model.By_adress), remark = new TemplateDataItem("请联系你的客户,并及时提供服务") }; var result = Senparc.Weixin.MP.AdvancedAPIs.TemplateApi.SendTemplateMessage(accessToken, openId, templateId, "http://www.hugongll.com/templates/Doc/Hugo_list/Login.aspx", testData); }
protected void bt1_Click(object sender, EventArgs e) { if ((Request.Form["lb1"].Length != 0) && (t1.Text.Length != 0)) { BLL.HG.Hg_list bb = new BLL.HG.Hg_list(); Model.HG.HG_order nn = new Model.HG.HG_order(); string str = Request.Form["lb1"]; string star = Regex.Replace(str, @"[^\d.\d]", ""); nn.Rated_status = int.Parse(star); nn.Rated_hg = t1.Text; nn.Order_dd = Request.QueryString["order_dd"]; if (bb.update_star(nn) == true) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('感谢评价,祝您生活愉快!');{location.href='index.aspx'}</script>"); } } else { string script = "<script> alert('请为本次服务做出点评!!') </script>"; Page.RegisterStartupScript("", script); } }
/// <summary> /// 获取订单详情 /// </summary> /// <param name="order"></param> /// <returns></returns> public Model.HG.HG_order Getorder(string order) { StringBuilder str = new StringBuilder(); str.Append(" select top 1 * from A_HG_oreder where Order_dd=@order"); SqlParameter[] prm = { new SqlParameter("@order", SqlDbType.NVarChar, 250) }; prm[0].Value = order; Model.HG.HG_order model = new Model.HG.HG_order(); DataSet ds = DbHelperSQL.Query(str.ToString(), prm); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel_order(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void suc_Click(object sender, EventArgs e) { BLL.HG.Hg_list list = new BLL.HG.Hg_list(); int number = int.Parse(Request.QueryString["number"].ToString()); Model.HG.HGlist Hg = list.Getmodel(number); Cookie1(); cookie2(); if ((name.Text == null) || (name.Text == "")) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('联系人不能为空');</script>"); } else if ((text_time.Text == null) || (text_time.Text == "") || (pickdate.Text == null) || (pickdate.Text == "") || (picktime.Text == null) || (picktime.Text == "")) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('预约时间不能为空 ');</script>"); } else if ((telnum.Text == null) || (telnum.Text == "")) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('联系电话不能为空 ');</script>"); } else if ((by_name.Text == null) || (by_name.Text == "") || (by_age.Text == null) || (by_age.Text == "") || (by_adress.Text == "") || (by_adress.Text == null)) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('被护理人信息不能为空 ');</script>"); } else { if (Hg.Hg_st2 == "空闲") { string open_id = ""; if (System.Web.HttpContext.Current.Request.Cookies["open_id"] != null) { open_id = HttpContext.Current.Request.Cookies["open_id"].Value; } Model.HG.HG_order Str = new Model.HG.HG_order(); BLL.HG.Hg_list add = new BLL.HG.Hg_list(); Str.Openid = open_id; Str.Nursing_name = name.Text.Trim().ToString(); Str.Nursing_sex = Select1.Items[Select1.SelectedIndex].Value; Str.Nursing_tel = telnum.Text.Trim().ToString(); Str.By_name = by_name.Text.Trim().ToString(); Str.By_sex = Sel_Test.Items[Sel_Test.SelectedIndex].Value; Str.By_care = By_care.Items[By_care.SelectedIndex].Value; Str.By_age = by_age.Text.Trim().ToString(); Str.By_adress = by_adress.Text.Trim().ToString(); Str.HUli_type = huli_type.Text.Trim(); Str.Hg_name = TextBox2.Text; Str.Hg_number = Request.QueryString["number"].ToString(); Str.Service_time = pickdate.Text + "/" + picktime.Text; Str.Service_day = Request.Form["inp"].ToString(); Str.Status_order = "未完成"; Str.Start_time = DateTime.Now.ToString(); Str.Order_dd = DateTime.Now.Minute + GuidTo16String(); string total = hid.Value; //string bb = ""; //Regex reg = new Regex(@"[0-9][0-9,.]*"); //MatchCollection mc = reg.Matches(total); //foreach (Match m in mc) //{ // bb += m.Value; //} Str.Total = (double.Parse(total.ToString())); Str.Pay_type = "微信支付"; Str.Wid = 44; Str.Str_sm = TextBox1.Text; add.Add_order(Str); // int aa = add.Add_order(Str); //ClientScript.RegisterStartupScript(typeof(string), "操作提示", "<script>alert('" + by_name.Text + bb + text_time .Text+ "')</script>"); // Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('立即支付!');{location.href=''}</script>"); //Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>if(confirm('保存成功!是否?')){location.href='ProductonAdd.aspx'}else{location.href='ProductonList.aspx'}</script>"); Response.Redirect("/api/payment/Hg_pay.aspx?order_dd=" + Str.Order_dd + "&kkl=" + Request.QueryString["number"].ToString() + ""); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('手速一慢被人捷足先登了!');{location.href='card_sing.aspx'}</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { order_type = Request.QueryString["order_type"]; order_dd = Request.QueryString["Order_dd"]; BLL.HG.Hg_list order_T = new BLL.HG.Hg_list(); if (order_type == "new") { Model.HG.A_HG_new_order model = order_T.getorder(order_dd); string timeStamp = ""; string nonceStr = ""; string paySign = ""; //创建支付应答对象 Senparc.Weixin.MP.TenPayLibV3.RequestHandler packageReqHandler = new Senparc.Weixin.MP.TenPayLibV3.RequestHandler(null); //初始化 packageReqHandler.Init(); litMoney = double.Parse(model.total); timeStamp = TenPayV3Util.GetTimestamp(); nonceStr = TenPayV3Util.GetNoncestr(); //设置package订单参数 packageReqHandler.SetParameter("appid", "wx172ece37e2ed2939"); //公众账号ID packageReqHandler.SetParameter("mch_id", "1403543902"); //商户号 packageReqHandler.SetParameter("nonce_str", nonceStr); //随机字符串 packageReqHandler.SetParameter("body", model.Name_ + "服务"); //商品信息 packageReqHandler.SetParameter("out_trade_no", order_dd); //商家订单号 packageReqHandler.SetParameter("total_fee", ((double.Parse(model.total)) * 100).ToString()); //商品金额,以分为单位(money * 100).ToString() packageReqHandler.SetParameter("spbill_create_ip", Request.UserHostAddress); //用户的公网ip,不是商户服务器IP packageReqHandler.SetParameter("notify_url", MyCommFun.getWebSite() + "/api/wxpay/notify_url.aspx?wid=" + 44 + "|" + order_dd); //接收财付通通知的URL packageReqHandler.SetParameter("trade_type", TenPayV3Type.JSAPI.ToString()); //交易类型 packageReqHandler.SetParameter("openid", model.Openid_); //用户的openId string sign = packageReqHandler.CreateMd5Sign("key", "70OvzuXGLFP7539B9zbvEMUBd1H1Tv8Q"); packageReqHandler.SetParameter("sign", sign); //签名 string data = packageReqHandler.ParseXML(); var result = TenPayV3.Unifiedorder(data); var res = XDocument.Parse(result); string prepayId = res.Element("xml").Element("prepay_id").Value; //设置支付参数 RequestHandler paySignReqHandler = new RequestHandler(null); paySignReqHandler.SetParameter("appId", "wx172ece37e2ed2939"); paySignReqHandler.SetParameter("timeStamp", timeStamp); paySignReqHandler.SetParameter("nonceStr", nonceStr); paySignReqHandler.SetParameter("package", string.Format("prepay_id={0}", prepayId)); paySignReqHandler.SetParameter("signType", "MD5"); paySign = paySignReqHandler.CreateMd5Sign("key", "70OvzuXGLFP7539B9zbvEMUBd1H1Tv8Q"); payaddid = ""; paytimeStamp = timeStamp; paynonceStr = nonceStr; paypackageValue = string.Format("prepay_id={0}", prepayId); paypaySign = paySign; litDate = DateTime.Now.ToString(); oreder_name = model.Name_ + "服务预约"; } else { hg_number = int.Parse(Request.QueryString["kkl"]); Model.HG.HG_order model = order_T.Getorder(order_dd); string timeStamp = ""; string nonceStr = ""; string paySign = ""; //创建支付应答对象 Senparc.Weixin.MP.TenPayLibV3.RequestHandler packageReqHandler = new Senparc.Weixin.MP.TenPayLibV3.RequestHandler(null); //初始化 packageReqHandler.Init(); litMoney = model.Total; timeStamp = TenPayV3Util.GetTimestamp(); nonceStr = TenPayV3Util.GetNoncestr(); //设置package订单参数 packageReqHandler.SetParameter("appid", "wx172ece37e2ed2939"); //公众账号ID packageReqHandler.SetParameter("mch_id", "1403543902"); //商户号 packageReqHandler.SetParameter("nonce_str", nonceStr); //随机字符串 packageReqHandler.SetParameter("body", model.By_name + "护理"); //商品信息 packageReqHandler.SetParameter("out_trade_no", order_dd); //商家订单号 packageReqHandler.SetParameter("total_fee", ((model.Total) * 100).ToString()); //商品金额,以分为单位(money * 100).ToString() packageReqHandler.SetParameter("spbill_create_ip", Request.UserHostAddress); //用户的公网ip,不是商户服务器IP packageReqHandler.SetParameter("notify_url", MyCommFun.getWebSite() + "/api/wxpay/notify_url.aspx?wid=" + 44 + "|" + order_dd); //接收财付通通知的URL packageReqHandler.SetParameter("trade_type", TenPayV3Type.JSAPI.ToString()); //交易类型 packageReqHandler.SetParameter("openid", model.Openid); //用户的openId string sign = packageReqHandler.CreateMd5Sign("key", "70OvzuXGLFP7539B9zbvEMUBd1H1Tv8Q"); packageReqHandler.SetParameter("sign", sign); //签名 string data = packageReqHandler.ParseXML(); var result = TenPayV3.Unifiedorder(data); var res = XDocument.Parse(result); string prepayId = res.Element("xml").Element("prepay_id").Value; //设置支付参数 RequestHandler paySignReqHandler = new RequestHandler(null); paySignReqHandler.SetParameter("appId", "wx172ece37e2ed2939"); paySignReqHandler.SetParameter("timeStamp", timeStamp); paySignReqHandler.SetParameter("nonceStr", nonceStr); paySignReqHandler.SetParameter("package", string.Format("prepay_id={0}", prepayId)); paySignReqHandler.SetParameter("signType", "MD5"); paySign = paySignReqHandler.CreateMd5Sign("key", "70OvzuXGLFP7539B9zbvEMUBd1H1Tv8Q"); payaddid = ""; paytimeStamp = timeStamp; paynonceStr = nonceStr; paypackageValue = string.Format("prepay_id={0}", prepayId); paypaySign = paySign; litDate = DateTime.Now.ToString(); oreder_name = model.By_name + "护理预约"; } }
/// <summary> /// 添加预约 /// </summary> /// <param name="add"></param> /// <returns></returns> public int Add_order(Model.HG.HG_order add) { return(order.add_order(add)); }
public bool update_star(Model.HG.HG_order nn) { return(order.update_star(nn)); }
/// <summary> /// 添加预约订单 /// </summary> /// <param name="order"></param> /// <returns></returns> public int add_order(Model.HG.HG_order order) { StringBuilder str = new StringBuilder(); str.Append("insert into A_HG_oreder ("); str.Append("Openid,Nursing_name,Nursing_sex,Nursing_tel,Nursing_adress,By_name,By_sex,By_care,By_age,By_adress,Start_time,End_time,Hg_number,Status_order,Rated_hg,Rated_status,Pay_type,Total,wid,Service_time,Service_day,Str_sm,HUli_type,Order_dd,Hg_name) "); str.Append(" values ( "); str.Append("@Openid,@Nursing_name,@Nursing_sex,@Nursing_tel,@Nursing_adress,@By_name,@By_sex,@By_care,@By_age,@By_adress,@Start_time,@End_time,@Hg_number,@Status_order,@Rated_hg,@Rated_status,@Pay_type,@Total,@wid,@Service_time,@Service_day,@Str_sm,@HUli_type,@Order_dd,@Hg_name)"); SqlParameter[] parameters = { new SqlParameter("@Openid", SqlDbType.NVarChar, 100), new SqlParameter("@Nursing_name", SqlDbType.NVarChar, 250), new SqlParameter("@Nursing_sex", SqlDbType.NVarChar, 50), new SqlParameter("@Nursing_tel", SqlDbType.NVarChar, 50), new SqlParameter("@Nursing_adress", SqlDbType.NVarChar, 500), new SqlParameter("@By_name", SqlDbType.NVarChar, 150), new SqlParameter("@By_sex", SqlDbType.NVarChar, 50), new SqlParameter("@By_care", SqlDbType.NVarChar, 50), new SqlParameter("@By_age", SqlDbType.NVarChar, 50), new SqlParameter("@By_adress", SqlDbType.NVarChar, 500), new SqlParameter("@Start_time", SqlDbType.NVarChar, 100), new SqlParameter("@End_time", SqlDbType.NVarChar, 100), new SqlParameter("@Hg_number", SqlDbType.Int, 100000), new SqlParameter("@Status_order", SqlDbType.NVarChar, 100), new SqlParameter("@Rated_hg", SqlDbType.NVarChar, 10000), new SqlParameter("@Rated_status", SqlDbType.NVarChar, 50), new SqlParameter("@Pay_type", SqlDbType.NVarChar, 100), new SqlParameter("@Total", SqlDbType.Float), new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@Service_time", SqlDbType.NVarChar, 100), new SqlParameter("@Service_day", SqlDbType.NVarChar, 100), new SqlParameter("@Str_sm", SqlDbType.NVarChar, 10000), new SqlParameter("@HUli_type", SqlDbType.NVarChar, 50), new SqlParameter("@Order_dd", SqlDbType.NVarChar, 50), new SqlParameter("@Hg_name", SqlDbType.NVarChar, 100) }; parameters[0].Value = order.Openid; parameters[1].Value = order.Nursing_name; parameters[2].Value = order.Nursing_sex; parameters[3].Value = order.Nursing_tel; parameters[4].Value = order.Nursing_adress; parameters[5].Value = order.By_name; parameters[6].Value = order.By_sex; parameters[7].Value = order.By_care; parameters[8].Value = order.By_age; parameters[9].Value = order.By_adress; parameters[10].Value = order.Start_time; parameters[11].Value = order.End_time; parameters[12].Value = order.Hg_number; parameters[13].Value = order.Status_order; parameters[14].Value = order.Rated_hg; parameters[15].Value = order.Rated_status; parameters[16].Value = order.Pay_type; parameters[17].Value = order.Total; parameters[18].Value = order.Wid; parameters[19].Value = order.Service_time; parameters[20].Value = order.Service_day; parameters[21].Value = order.str_sm; parameters[22].Value = order.HUli_type; parameters[23].Value = order.Order_dd; parameters[24].Value = order.Hg_name; object obj = DbHelperSQL.GetSingle(str.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }