/// <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 bb = new BLL.HG.Hg_list();
Model.HG.A_HG_new_order modle = bb.getorder_(Request.QueryString["order"]);
var openId = modle.Openid_; //换成已经关注用户的openId
var templateId = "6oFH4updt21Zfwbks6O7erhZRlOI6jS3Yju8l9qFsw4"; //换成已经在微信后台添加的模板Id
var accessToken = Token();
var testData = new //TestTemplateData()
{
first = new TemplateDataItem("护理服务支付成功"),
keyword1 = new TemplateDataItem(modle.Name_),
keyword2 = new TemplateDataItem(modle.Tel_),
keyword3 = new TemplateDataItem(modle.Time_),
keyword4 = new TemplateDataItem("微信支付：" + (modle.total).ToString() + "元"),
keyword5 = new TemplateDataItem(modle.Adress),
remark = new TemplateDataItem("请保持电话通畅，服务人员会和您取得联系，提供快捷舒心的服务！")
};
var result = Senparc.Weixin.MP.AdvancedAPIs.TemplateApi.SendTemplateMessage(accessToken, openId, templateId, "http://www.hugongll.com/hugongll/order.aspx", testData);
var openIds = "oZg9IwiZ4xGUBDtjT3lvrB4JV9Vo"; //换成已经关注用户的openId
templateId = "6oFH4updt21Zfwbks6O7erhZRlOI6jS3Yju8l9qFsw4"; //换成已经在微信后台添加的模板Id
accessToken = Token();
testData = new //TestTemplateData()
{
first = new TemplateDataItem("新订单提醒（管理通知）"),
keyword1 = new TemplateDataItem(modle.Name_),
keyword2 = new TemplateDataItem(modle.Tel_),
keyword3 = new TemplateDataItem(modle.Time_),
keyword4 = new TemplateDataItem("微信支付：" + (modle.total).ToString() + "元"),
keyword5 = new TemplateDataItem(modle.Adress),
remark = new TemplateDataItem("请与以上用户联系，并回访")
};
result = Senparc.Weixin.MP.AdvancedAPIs.TemplateApi.SendTemplateMessage(accessToken, openIds, templateId, "http://www.hugongll.com/hugongll/order.aspx", testData);
}
public Model.HG.A_HG_new_order Datarow_model1(DataRow row)
{
Model.HG.A_HG_new_order model = new Model.HG.A_HG_new_order();
if (row != null)
{
model.Openid_ = row["openid_"].ToString();
model.Name_ = row["name_"].ToString();
model.Tel_ = row["tel_"].ToString();
model.Sex_ = row["sex_"].ToString();
model.Weixin_name = row["weixin_name"].ToString();
model.Pick_many = row["pick_many"].ToString();
model.Type_ = row["type_"].ToString();
model.Time_ = row["time_"].ToString();
model.Pick_day = row["pick_day"].ToString();
model.Adress = row["adress"].ToString();
model.Fw_name = row["Fw_name"].ToString();
model.Fw_zt = row["Fw_zt"].ToString();
model.Order_from = row["order_from"].ToString();
model.Str_1 = row["str_1"].ToString();
model.Str_2 = row["str_2"].ToString();
model.Str_3 = row["str_3"].ToString();
model.total = row["total"].ToString();
model.start_time = row["strat_time"].ToString();
model.Order_dd = row["order_dd"].ToString();
model.end_time = row["end_time"].ToString();
}
return(model);
}
protected void pay_Click(object sender, EventArgs e)
{
if (Request.Form["name"] == null || Request.Form["name"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('雇主姓名不能为空');</script>");
}
else if (Request.Form["tel"] == null || Request.Form["tel"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('雇主电话不能为空');</script>");
}
else if (Request.Form["pick_many"] == null || Request.Form["pick_many"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('请选择服务价格');</script>");
}
else if (Request.Form["pick_day"] == null || Request.Form["pick_day"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('请选择服务天数');</script>");
}
else if (Request.Form["time_"] == null || Request.Form["time_"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('请选择服务时间');</script>");
}
else if (Request.Form["adress"] == null || Request.Form["adress"] == "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "js", "<script>alert('请选择服务地址');</script>");
}
else
{
Model.HG.A_HG_new_order add = new Model.HG.A_HG_new_order();
DAL.HG.HG_order Add = new DAL.HG.HG_order();
add.Openid_ = HttpContext.Current.Request.Cookies["open_id1"].Value;
add.Weixin_name = pick_name;
add.Name_ = Request.Form["name"]; //雇主姓名
add.Tel_ = Request.Form["tel"]; //雇主电话
add.Sex_ = sex_.Items[sex_.SelectedIndex].Text; //雇主性别
add.Pick_many = Request.Form["pick_many"]; //服务标准
add.Pick_day = Request.Form["pick_day"]; //服务天数
add.Time_ = Request.Form["time_"];; //服务时间
add.Type_ = type_; //服务类型
add.Adress = Request.Form["adress"]; //服务地址
add.start_time = DateTime.Now.ToString(); //开始时间
add.Order_from = "微信公众号";
add.Order_dd = DateTime.Now.Day.ToString() + GuidTo16String(); //生成的订单号
string nn = hid.Value;
add.Fw_zt = "未支付";
add.Delet_ = "未删除";
add.total = nn;
Add.add_order_new(add);
Response.Redirect("/api/payment/Hg_pay.aspx?Order_dd=" + add.Order_dd + "&order_type=new");
}
}
public Model.HG.A_HG_new_order getorder_(string order)
{
StringBuilder str = new StringBuilder();
str.Append("select top 1 * from A_HG_new_order where order_dd=@order");
SqlParameter[] par =
{
new SqlParameter("@order", SqlDbType.NVarChar, 50)
};
par[0].Value = order;
Model.HG.A_HG_new_order model = new Model.HG.A_HG_new_order();
DataSet ds = DbHelperSQL.Query(str.ToString(), par);
if (ds.Tables[0].Rows.Count > 0)
{
return(Datarow_model1(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
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 + "护理预约";
}
}
public void ProcessRequest(HttpContext context)
{
Model.HG.A_HG_new_order Str = new Model.HG.A_HG_new_order();
BLL.HG.Hg_list add = new BLL.HG.Hg_list();
Dictionary <string, string> jsonDict = new Dictionary <string, string>();
jsonDict = new Dictionary <string, string>();
string case_ = context.Request.QueryString["case_"];
if (case_ == "save")
{
// string openid=context.Request.QueryString["openid"];
string name = context.Request.QueryString["name"];
string phone = context.Request.QueryString["phone"];
string sex = context.Request.QueryString["sex"];
string money = context.Request.QueryString["money"];
string type_ = context.Request.QueryString["type_"];
string time = context.Request.QueryString["time"];
string day = context.Request.QueryString["day"];
string adress = context.Request.QueryString["adress"];
string weixiname = context.Request.QueryString["weixinname"];
string openid = context.Request.QueryString["openid"];
// string total=context.Request.QueryString["total"];
// Str.Openid_ = openid;
Str.Name_ = name;
Str.Tel_ = phone;
Str.Sex_ = sex;
Str.Pick_many = money;
Str.Type_ = type_;
Str.Time_ = time;
Str.start_time = DateTime.Now.ToString();//开始时间
Str.Pick_day = day;
Str.Weixin_name = weixiname;
Str.Openid_ = openid;
int day_ = int.Parse(day);
int money_ = int.Parse(money);
int total_ = day_ * money_;
Str.total = total_.ToString();
string bb = DateTime.Now.Day.ToString() + GuidTo16String();//生成的订单号
Str.Order_dd = bb;
Str.Order_from = "小程序";
Str.Fw_zt = "未支付";
Str.Delet_ = "未删除";
Str.Adress = adress;
int fal = add.Add_order_new(Str);
// Str.total = total;
if (fal == 0)
{
jsonDict.Add("order_dd", bb);
jsonDict.Add("errCode", "false");
jsonDict.Add("recontent", fal.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("order_dd", bb);
jsonDict.Add("errCode", "true");
jsonDict.Add("recontent", fal.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
else if (case_ == "jujia")
{
{
// string openid=context.Request.QueryString["openid"];
string name = context.Request.QueryString["name"];
string phone = context.Request.QueryString["phone"];
string sex = context.Request.QueryString["sex"];
string money = context.Request.QueryString["money"];
string type_ = context.Request.QueryString["type_"];
string time = context.Request.QueryString["time"];
string day = context.Request.QueryString["day"];
string adress = context.Request.QueryString["adress"];
string weixiname = context.Request.QueryString["weixinname"];
string openid = context.Request.QueryString["openid"];
// string total=context.Request.QueryString["total"];
// Str.Openid_ = openid;
Str.Name_ = name;
Str.Tel_ = phone;
Str.Sex_ = sex;
Str.Pick_many = money;
Str.Type_ = type_;
Str.Time_ = time;
Str.start_time = DateTime.Now.ToString();//开始时间
Str.Pick_day = day;
Str.Weixin_name = weixiname;
Str.Openid_ = openid;
Str.total = money;
string bb = DateTime.Now.Day.ToString() + GuidTo16String();//生成的订单号
Str.Order_dd = bb;
Str.Order_from = "小程序";
Str.Fw_zt = "未支付";
Str.Delet_ = "未删除";
Str.Adress = adress;
int fal = add.Add_order_new(Str);
// Str.total = total;
if (fal == 0)
{
jsonDict.Add("order_dd", bb);
jsonDict.Add("errCode", "false");
jsonDict.Add("recontent", fal.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
else
{
jsonDict.Add("order_dd", bb);
jsonDict.Add("errCode", "true");
jsonDict.Add("recontent", fal.ToString());
context.Response.Write(MyCommFun.getJsonStr(jsonDict));
}
}
}
else if (case_ == "order")
{
string openid = context.Request.QueryString["openid"];
context.Response.ContentType = "text/json";
context.Response.Write(MyCommFun.GetJsonByDataset(order_new(openid)));
}
else
{
order_dd = MyCommFun.QueryString("order");
BLL.HG.Hg_list order_T = new BLL.HG.Hg_list();
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();
timeStamp = TenPayV3Util.GetTimestamp();
nonceStr = TenPayV3Util.GetNoncestr();
//设置package订单参数
packageReqHandler.SetParameter("appid", "wx16650bedd9b0916a"); //公众账号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", context.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);
DateTime bb111 = new DateTime();
WriteTextLog(bb111, result);
var res = XDocument.Parse(result);
string prepayId = res.Element("xml").Element("prepay_id").Value;
//设置支付参数
RequestHandler paySignReqHandler = new RequestHandler(null);
paySignReqHandler.SetParameter("appId", "wx16650bedd9b0916a");
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_ + "服务预约";
context.Response.ContentType = "text/json";
pay_ bb = new pay_
{
timeStamp = timeStamp,
nonceStr = nonceStr,
paySign = paySign,
signType = "MD5",
package = prepayId
};
string json_bill = JsonMapper.ToJson(bb);
context.Response.Write(json_bill);
}
}
public int Add_order_new(Model.HG.A_HG_new_order add)
{
return(order.add_order_new(add));
}
public int add_order_new(Model.HG.A_HG_new_order order)
{
StringBuilder str = new StringBuilder();
str.Append("insert into A_HG_new_order (");
str.Append("openid_,name_,tel_,sex_,weixin_name,pick_many,type_,time_,pick_day,adress,order_dd,Fw_name,Fw_zt,order_from,str_1,str_2,str_3,total,strat_time,Delet_) ");
str.Append(" values( ");
str.Append("@openid_,@name_,@tel_,@sex_,@weixin_name,@pick_many,@type_,@time_,@pick_day,@adress,@order_dd,@Fw_name,@Fw_zt,@order_from,@str_1,@str_2,@str_3,@total,@strat_time,@Delet_)");
SqlParameter[] par =
{
new SqlParameter("@openid_", SqlDbType.NVarChar, 50),
new SqlParameter("@name_", SqlDbType.NVarChar, 50),
new SqlParameter("@tel_", SqlDbType.NVarChar, 50),
new SqlParameter("@sex_", SqlDbType.NVarChar, 50),
new SqlParameter("@weixin_name", SqlDbType.NVarChar, 100),
new SqlParameter("@pick_many", SqlDbType.NVarChar, 10),
new SqlParameter("@type_", SqlDbType.NVarChar, 50),
new SqlParameter("@time_", SqlDbType.NVarChar, 50),
new SqlParameter("@pick_day", SqlDbType.NVarChar, 50),
new SqlParameter("@adress", SqlDbType.NVarChar, 250),
new SqlParameter("@order_dd", SqlDbType.NVarChar, 100),
new SqlParameter("@Fw_name", SqlDbType.NVarChar, 50),
new SqlParameter("@Fw_zt", SqlDbType.NVarChar, 50),
new SqlParameter("@order_from", SqlDbType.NVarChar, 100),
new SqlParameter("@str_1", SqlDbType.NVarChar, 100),
new SqlParameter("@str_2", SqlDbType.NVarChar, 50),
new SqlParameter("@str_3", SqlDbType.NVarChar, 100),
new SqlParameter("@total", SqlDbType.NVarChar, 50),
new SqlParameter("@strat_time", SqlDbType.NVarChar, 50),
new SqlParameter("@Delet_", SqlDbType.NVarChar, 20)
};
par[0].Value = order.Openid_;
par[1].Value = order.Name_;
par[2].Value = order.Tel_;
par[3].Value = order.Sex_;
par[4].Value = order.Weixin_name;
par[5].Value = order.Pick_many;
par[6].Value = order.Type_;
par[7].Value = order.Time_;
par[8].Value = order.Pick_day;
par[9].Value = order.Adress;
par[10].Value = order.Order_dd;
par[11].Value = order.Fw_name;
par[12].Value = order.Fw_zt;
par[13].Value = order.Order_from;
par[14].Value = order.Str_1;
par[15].Value = order.Str_2;
par[16].Value = order.Str_3;
par[17].Value = order.total;
par[18].Value = order.start_time;
par[19].Value = order.Delet_;
object obj = DbHelperSQL.GetSingle(str.ToString(), par);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
