protected void Button1_Click(object sender, EventArgs e)
{
this.Label1.Text = "";
this.Label2.Text = "";
string alipayPaymentNumber = "";
string returnDescription = "";
OnlinePay pay = new OnlinePay();
DataTable table = new Views.V_UserPayDetails().Open("ID, Name, DateTime, Money, PayType, FormalitiesFees, UserID", "Result = 1", "");
double num2 = 0.0;
foreach (DataRow row in table.Rows)
{
alipayPaymentNumber = "";
if ((pay.Query(row["PayType"].ToString().Trim(), row["ID"].ToString(), ref alipayPaymentNumber, ref returnDescription) != 0) && (returnDescription == "等待买家付款"))
{
num2 += _Convert.StrToDouble(row["Money"].ToString(), 0.0);
string text = this.Label1.Text;
this.Label1.Text = text + "用户名：" + row["Name"].ToString() + "， 用户ID：" + row["UserID"].ToString() + "， 系统交易号：" + row["ID"].ToString() + "， 金额：" + row["Money"].ToString() + "<br />";
}
}
this.Label2.Text = "合计总金额：" + num2.ToString();
}
protected void g_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
{
int Result = -9999;
long ID = Shove._Convert.StrToLong(e.Item.Cells[9].Text, 0);
string bankPay = e.Item.Cells[10].Text;
double Money = Shove._Convert.StrToDouble(e.Item.Cells[3].Text, 0);
double FormalitiesFees = Shove._Convert.StrToDouble(e.Item.Cells[5].Text, 0);
string PayNumber = e.Item.Cells[8].Text;
string PayBank = getBankName(bankPay);
DateTime payDateTime = Shove._Convert.StrToDateTime(e.Item.Cells[2].Text, DateTime.Now.ToString("yyyyMMdd"));
string payDate = Shove._Convert.StrToDateTime(e.Item.Cells[2].Text, DateTime.Now.ToString("yyyyMMdd")).ToString("yyyyMMdd");
int ReturnValue = -1;
string ReturnDescription = "";
if (e.CommandName == "Query")
{
//要区分充值记录是通过什么接口(财付通、支付宝、51支付卡)
switch(bankPay.Split('_')[0].ToUpper())
{
case "ALIPAY":
{
//支付宝接口
string AlipayPaymentNumber = "";
Alipay.Gateway.OnlinePay onlinepay = new Alipay.Gateway.OnlinePay();
try
{
Result = onlinepay.Query(e.Item.Cells[10].Text.Trim(), PayNumber, ref AlipayPaymentNumber, ref ReturnDescription);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "查询失败，可能是网络通讯故障。请重试一次。");
return;
}
if (Result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "支付号为 " + PayNumber + " 的支付记录没有充值成功，描述：" + ReturnDescription);
return;
}
string Memo = "系统交易号：" + PayNumber + ",支付宝交易号：" + AlipayPaymentNumber;
ReturnDescription = "";
int Results = -1;
Results = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (Results < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "数据库读写错误");
return;
}
else
{
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值记录已到帐并已处理成功！");
}
}
break;
case "51ZFK":
{
//51支付卡、神州行充值卡
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/ZhiFuKa/PayQuery.aspx?sdcustomno=" + PayNumber);
}
break;
case "TENPAY":
{
//财付通接口
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/Tenpay/PayQuery.aspx?sp_billno=" + PayNumber + "&date=" + payDate);
}
break;
case "007KA":
{
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/007ka/PayQuery.aspx?OrderID="+PayNumber);
}
break;
case "99BILL"://快钱冲值
{
string dealID="";
string errorMsg="";
if (this.Check99BillPay(long.Parse(PayNumber),ref dealID, ref errorMsg) && errorMsg=="")
{
string Memo = "系统交易号：" + PayNumber + ",快钱交易号：" + dealID;
ReturnDescription = "";
ReturnValue = -1;
int result = -1;
result = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "数据库读写错误:" + _Site.ID+" , "+ID+" , "+Money+" , "+ FormalitiesFees+" , "+ PayNumber+" , "+ PayBank+" , "+ Memo );
return;
}
else
{
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值记录已到帐并已处理成功！");
BindData();
}
}
else
{
Shove._Web.JavaScript.Alert(this.Page, errorMsg);
}
}
break;
}
}
if (e.CommandName == "Accept")
{
string Memo = "手动处理充值" + ((TextBox)e.Item.Cells[4].FindControl("tbDescription")).Text.Trim();
Result = -1;
Result = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (Result < 0)
{
ReturnDescription = "数据库读写错误";
return;
}
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值处理成功！");
}
if (e.CommandName == "Del")
{
try
{
new DAL.Tables.T_UserPayDetails().Delete("ID=" + PayNumber + " and Result = 0");
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "此笔充值删除失败！");
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值删除成功！");
}
BindData();
}
}
protected void g_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
{
int Result = -9999;
long ID = Shove._Convert.StrToLong(e.Item.Cells[9].Text, 0);
string bankPay = e.Item.Cells[10].Text;
double Money = Shove._Convert.StrToDouble(e.Item.Cells[3].Text, 0);
double FormalitiesFees = Shove._Convert.StrToDouble(e.Item.Cells[5].Text, 0);
string PayNumber = e.Item.Cells[8].Text;
string PayBank = getBankName(bankPay);
DateTime payDateTime = Shove._Convert.StrToDateTime(e.Item.Cells[2].Text, DateTime.Now.ToString("yyyyMMdd"));
string payDate = Shove._Convert.StrToDateTime(e.Item.Cells[2].Text, DateTime.Now.ToString("yyyyMMdd")).ToString("yyyyMMdd");
int ReturnValue = -1;
string ReturnDescription = "";
if (e.CommandName == "Query")
{
//要区分充值记录是通过什么接口(财付通、支付宝、51支付卡)
switch (bankPay.Split('_')[0].ToUpper())
{
case "ALIPAY":
{
//支付宝接口
string AlipayPaymentNumber = "";
Alipay.Gateway.OnlinePay onlinepay = new Alipay.Gateway.OnlinePay();
try
{
Result = onlinepay.Query(e.Item.Cells[10].Text.Trim(), PayNumber, ref AlipayPaymentNumber, ref ReturnDescription);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "查询失败，可能是网络通讯故障。请重试一次。");
return;
}
if (Result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "支付号为 " + PayNumber + " 的支付记录没有充值成功，描述：" + ReturnDescription);
return;
}
string Memo = "系统交易号：" + PayNumber + ",支付宝交易号：" + AlipayPaymentNumber;
ReturnDescription = "";
int Results = -1;
Results = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (Results < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "数据库读写错误");
return;
}
else
{
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值记录已到帐并已处理成功！");
}
}
break;
case "51ZFK":
{
//51支付卡、神州行充值卡
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/ZhiFuKa/PayQuery.aspx?sdcustomno=" + PayNumber);
}
break;
case "TENPAY":
{
//财付通接口
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/Tenpay/PayQuery.aspx?sp_billno=" + PayNumber + "&date=" + payDate);
}
break;
case "007KA":
{
frmmain.Attributes.Add("src", "../Home/Room/OnlinePay/007ka/PayQuery.aspx?OrderID=" + PayNumber);
}
break;
case "99BILL": //快钱冲值
{
string dealID = "";
string errorMsg = "";
if (this.Check99BillPay(long.Parse(PayNumber), ref dealID, ref errorMsg) && errorMsg == "")
{
string Memo = "系统交易号：" + PayNumber + ",快钱交易号：" + dealID;
ReturnDescription = "";
ReturnValue = -1;
int result = -1;
result = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "数据库读写错误:" + _Site.ID + " , " + ID + " , " + Money + " , " + FormalitiesFees + " , " + PayNumber + " , " + PayBank + " , " + Memo);
return;
}
else
{
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值记录已到帐并已处理成功！");
BindData();
}
}
else
{
Shove._Web.JavaScript.Alert(this.Page, errorMsg);
}
}
break;
}
}
if (e.CommandName == "Accept")
{
string Memo = "手动处理充值" + ((TextBox)e.Item.Cells[4].FindControl("tbDescription")).Text.Trim();
Result = -1;
Result = DAL.Procedures.P_UserAddMoney(_Site.ID, ID, Money, FormalitiesFees, PayNumber, PayBank, Memo, ref ReturnValue, ref ReturnDescription);
if (Result < 0)
{
ReturnDescription = "数据库读写错误";
return;
}
if (ReturnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值处理成功！");
}
if (e.CommandName == "Del")
{
try
{
new DAL.Tables.T_UserPayDetails().Delete("ID=" + PayNumber + " and Result = 0");
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "此笔充值删除失败！");
}
Shove._Web.JavaScript.Alert(this.Page, "此笔充值删除成功！");
}
BindData();
}
}
