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