protected void btnVxPay_Click(object sender, EventArgs e)
{
if (hidhospital.Value != "" && this.UserId > 0)
{
pa1.Visible = false;
pa2.Visible = true;
//绑定支付条目
string sql = "select * from lists where listname='SeekPetPayItem' order by sortorder";
DataTable da = SqlDataProvider.SqlDataProvider.GetSQLTable(sql);
rePayList.DataSource = da;
rePayList.DataBind();
//int sumprice = 100;
//int sumprice = int.Parse((float.Parse(da.Compute("sum([cast([value] as float)])", "1=1").ToString()) * 100).ToString());
var p = (from DataRow record in da.Rows
select double.Parse(record["value"].ToString())).Sum();
int sumprice = Convert.ToInt32(p * 100);
lblSumPrice.Text = p.ToString();
int hospitalid = int.Parse(hidhospital.Value);
string returnurl = SuccessURL;
//订单号
string tradeno = "XP" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
returnurl += "?tradeno=" + tradeno;
int cost = sumprice;
//插入订单支付数据,生成订单
See_Pay pay = new See_Pay();
pay.UserID = this.UserId;
pay.UserSign = "";
pay.IsPay = false;
pay.TradeNo = tradeno;
pay.HospitalID = hospitalid;
pay.CostMoney = cost;
pay.CreateTime = DateTime.Now;
pay.IsVerify = false;
SqlDataProvider.SqlDataProvider.InsertSee_Pay(pay);
//支付链接
H5Pay h5pay = new H5Pay(Page);
h5pay.total_fee = pay.CostMoney;
WxPayData data = h5pay.GetUnifiedOrderResult(pay.TradeNo);
lblresult.Text = data.ToPrintStr();
hyFinishPay.NavigateUrl = returnurl;
btnsubmit.NavigateUrl = data.GetValue("mweb_url").ToString() + "&redirect_url=" + Server.UrlEncode(returnurl);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "resultTip", "<script>alert('支付出错！');</script>");
}
}
/// <summary>
/// 更新一条信息
/// </summary>
/// <param name="objSee_Pay">实例对象</param>
public static void UpdateSee_Pay(See_Pay objSee_Pay)
{
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(strDBConnectionString, "See_Pay_Update", GetNull(objSee_Pay.ID), GetNull(objSee_Pay.UserID), objSee_Pay.UserSign, objSee_Pay.TradeNo, GetNull(objSee_Pay.HospitalID), (objSee_Pay.IsPay), GetNull(objSee_Pay.CostMoney), GetNull(objSee_Pay.CreateTime), (objSee_Pay.IsVerify), objSee_Pay.ticket, objSee_Pay.Par1, objSee_Pay.Par2, objSee_Pay.Par3);
}
/// <summary>
/// 插入一条实例信息
/// </summary>
/// <param name="objSee_Pay">实例对象</param>
/// <returns>返回主键ID</returns>
public static Int32 InsertSee_Pay(See_Pay objSee_Pay)
{
return Convert.ToInt32(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(strDBConnectionString, "See_Pay_Insert", GetNull(objSee_Pay.UserID), objSee_Pay.UserSign, objSee_Pay.TradeNo, GetNull(objSee_Pay.HospitalID), (objSee_Pay.IsPay), GetNull(objSee_Pay.CostMoney), (objSee_Pay.CreateTime), (objSee_Pay.IsVerify), objSee_Pay.ticket, objSee_Pay.Par1, objSee_Pay.Par2, objSee_Pay.Par3));
}
protected void Page_Load(object sender, EventArgs e)
{
RenZheng();
CreateWxMenu();
wxmessage wx = GetWxMessage();
if (wx == null)
{
WriteToTxt("参数错误:wxmessage为空");
return;
}
string res = "";
switch (wx.Event)
{
case "subscribe":
{
string content = "";
content = "欢迎关注SeekPetM（觅宠）:" + wx.EventKey;
res = sendTextMessage(wx, content);
break;
}
case "SCAN":
{
string content = "";
//content = "扫描订单ID :" + wx.EventKey;
//订单核销
//订单号
string tradeno = "XP" + wx.EventKey;
See_Pay pay = SqlDataProvider.SqlDataProvider.GetInfoSee_PayByTradeNo(tradeno);
if (pay != null)
{
int count = SqlDataProvider.SqlDataProvider.GetTableInfoCount(string.Format("select count(*) from Lists where ListName='SeekPetQrCodeCheck' and Value='{0}'", wx.FromUserName));
//限制核销人
//if (wx.FromUserName != "zhaob")
if (count <= 0)
{
content = "您没有核销的权限";
}
else
{
if (pay.IsVerify)
{
content = "订单:" + tradeno + "已经核销";
}
else
{
pay.IsVerify = true;
SqlDataProvider.SqlDataProvider.UpdateSee_Pay(pay);
content = "订单:" + tradeno + "核销成功";
}
}
}
else
{
content = "订单:" + tradeno + "不存在";
}
content += "[" + wx.FromUserName + "]";
res = sendTextMessage(wx, content);
break;
}
default:
string output = "";
output = "欢迎关注SeekPetM（觅宠）" + wx.EventKey;
res = sendTextMessage(wx, output);
break;
}
//using (StreamWriter sw = new StreamWriter(Server.MapPath("wx.txt")))
//{
// sw.Write(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ",参数错误" + res);
//}
//WriteToTxt("res:"+res);
Response.Write(res);
}
