public Model.HG.HGlist DataRowToModel(DataRow row) { Model.HG.HGlist model = new Model.HG.HGlist(); if (row != null) { model.Hg_name = row["Hg_name"].ToString(); model.Hg_sex = row["Hg_sex"].ToString(); model.Hg_Degree = row["Hg_Degree"].ToString(); model.Hg_Profile = row["Hg_Profile"].ToString(); model.Hg_IDcard = row["Hg_IDcard"].ToString(); model.Hg_age = int.Parse(row["Hg_age"].ToString()); model.nation = row["Nation"].ToString(); model.marry = row["Marry"].ToString(); model.dengji = row["dengji"].ToString(); model.Hg_st1 = row["Hg_st1"].ToString(); model.Hg_st2 = row["Hg_st2"].ToString(); model.Techer = int.Parse(row["Teacher_i"].ToString()); model.Hg_number = int.Parse(row["Hg_number"].ToString()); model.Mony = row["Mony"].ToString(); model.Phone = row["Phone"].ToString(); model.Headurl = row["Headurl"].ToString(); model.open_id_hg = row["open_id_hg"].ToString(); } return(model); }
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; }
protected void Page_Load(object sender, EventArgs e) { string phone = Request.QueryString["name"]; BLL.HG.Hg_list list = new BLL.HG.Hg_list(); Model.HG.HGlist model = list.Get_xinxi(phone); name = model.Hg_name; HG_number = model.Hg_number; }
/// <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); }
public void Sing(int number) { Model.HG.HGlist Hg = list.Getmodel(number); name = Hg.Hg_name; sex = Hg.Hg_sex; Hg_Degree = Hg.Hg_Degree; Hg_Profile = Hg.Hg_Profile; Hg_IDcard = Hg.Hg_IDcard; Hg_age = Hg.Hg_age; nation = Hg.nation; marry = Hg.marry; Hg_st1 = Hg.Hg_st1; dengji = Hg.dengji; mony = Hg.Mony; hid4.Value = Hg.Hg_st2; string bb = ""; string[] aa = new string[Hg_IDcard.Length]; for (int a = 0; a < Hg_IDcard.Length; a++) { aa[a] = Hg_IDcard[a].ToString(); aa[10] = "*"; aa[11] = "*"; aa[12] = "*"; aa[13] = "*"; aa[14] = "*"; aa[15] = "*"; bb += aa[a]; } Hg_IDcard = bb; head = Hg.Headurl; teacher = Hg.Techer; hid2.Value = name; hid3.Value = Hg.Mony; }
/// <summary> /// 根据护工id获取信息 /// </summary> /// <param name="Number"></param> /// <returns></returns> public Model.HG.HGlist Getmodel(int Number) { StringBuilder str = new StringBuilder(); str.Append(" select top 1 * from A_HG_HG where Hg_number=@number;"); SqlParameter[] pam = { new SqlParameter("@number", SqlDbType.Int) }; pam[0].Value = Number; Model.HG.HGlist model = new Model.HG.HGlist(); DataSet ds = DbHelperSQL.Query(str.ToString(), pam); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(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>"); } } }