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