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>");
}
}
}
