/// <summary> /// 插入数据 /// </summary> /// <param name="obj">对象</param> /// <returns>返回:该条数据的主键Id</returns> public int Insert(MPayLog obj) { if (obj == null) throw new ArgumentNullException("obj"); String stmtId = "MPayLog.Insert"; return SqlMapper.Instance().QueryForObject<int>(stmtId, obj); }
public void Notify() { try { QueryNotifyURL = QueryNotifyURL + "&partner=" + partner + "¬ify_id=" + HttpContext.Current.Request["notify_id"].ToString(); //��ȡ֧����ATN���ؽ����true����ȷ�Ķ�����Ϣ��false ����Ч�� // alipayNotifyURL = alipayNotifyURL + "&partner=" + partner + "¬ify_id=" + HttpContext.Current.Request.QueryString["notify_id"]; //��ȡ֧����ATN���ؽ����true����ȷ�Ķ�����Ϣ��false ����Ч�� string responseTxt = AliPayPackage.Get_Http(QueryNotifyURL, 120000); //*******����ǩ������ʼ//******* int i; System.Collections.Specialized.NameValueCollection coll; //Load Form variables into NameValueCollection variable. coll = HttpContext.Current.Request.Form; // Get names of all forms into a string array. String[] requestarr = coll.AllKeys; //�������� string[] Sortedstr = AliPayPackage.BubbleSort(requestarr); //�����md5ժҪ�ַ��� �� StringBuilder prestr = new StringBuilder(); // string temp = ""; for (i = 0; i < Sortedstr.Length; i++) { if (RQ(Sortedstr[i]) != "" && Sortedstr[i] != "sign" && Sortedstr[i] != "sign_type") { if (i == Sortedstr.Length - 1) { prestr.Append(Sortedstr[i] + "=" + RQ(Sortedstr[i])); } else { prestr.Append(Sortedstr[i] + "=" + RQ(Sortedstr[i]) + "&"); } } // temp+=Sortedstr[i]; } // MamShare.Utils.Log4Net.Error(temp); prestr.Append(key); //����Md5ժҪ�� string mysign = AliPayPackage.GetMD5(prestr.ToString(), _input_charset); //*******����ǩ���������******* string sign = RQ("sign"); // Response.Write(prestr.ToString()); string trade_status = RQ("trade_status"); MPayLog payrecordinfo = new MPayLog(); payrecordinfo.PayUrl = QueryNotifyURL;//���ص�ַ payrecordinfo.OrderId = decimal.Parse(RQ("out_trade_no"));//HttpContext.Current.Request.QueryString["out_trade_no"]); if (responseTxt == "true") payrecordinfo.PayResult = "1"; else payrecordinfo.PayResult = "0"; payrecordinfo.PayMoney = decimal.Parse(RQ("total_fee")); //decimal.Parse(HttpContext.Current.Request.QueryString["total_fee"]); payrecordinfo.TransactionId = RQ("trade_no"); //HttpContext.Current.Request.QueryString["trade_no"]; payrecordinfo.PayWay = PayWay; payrecordinfo.BackUrl = HttpContext.Current.Request.Url.AbsoluteUri; payrecordinfo.CreateTime = DateTime.Now; TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); if (responseTxt == "true") //��֤֧������������Ϣ��ǩ���Ƿ���ȷ { //�����Լ����ݿ�Ķ�����䣬���Լ���дһ�� if (trade_status == "TRADE_FINISHED" || trade_status == "TRADE_SUCCESS") { Service.Bll.Order.TOrderBLL obll = new TMM.Service.Bll.Order.TOrderBLL(); Service.Bll.User.MAccountBLL abll = new TMM.Service.Bll.User.MAccountBLL(); TOrder o = obll.GetOrderAndDetail(payrecordinfo.OrderId); if (o.Status >= 0 && o.Status < 10) //�¶��� -- �Ѹ��� ֮��Ĺ��� { //��ֵ abll.AddAmount(payrecordinfo.OrderId, payrecordinfo.PayMoney, Utils.TmmUtils.IPAddress(), this.PayWay); bool expandResult = true; //docidС��0 �����Ϊ���ⶩ������ִ���˻������Ķ��� if (o.SingleDetail.DocId > 0) { expandResult = abll.AccountExpend(payrecordinfo.OrderId, Utils.TmmUtils.IPAddress()); } if (expandResult) { Common.OrderCallBack oCallBack = new TMM.Core.Common.OrderCallBack(); oCallBack.UserId = o.UserId; oCallBack.OrderId = o.OrderId; oCallBack.PayWay = PayWay; oCallBack.Status = (int)OrderStatus.IsPaied; oCallBack.PayDetail = "�Ա�֧��"; oCallBack.ExecAfterPaid(); Utils.Log4Net.Error(string.Format("֧�����ӿ��첽���ûص������ɹ�����ת��URL��{0}", payOkUrl)); } else { payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "�˻����㣡"); } } } HttpContext.Current.Response.Write("success"); // Response.Write("success"); //���ظ�֧������Ϣ���ɹ� } else { //HttpContext.Current.Response.Write("------------------------------------------"); //HttpContext.Current.Response.Write("<br>Result:responseTxt=" + responseTxt); //HttpContext.Current.Response.Write("<br>Result:mysign=" + mysign); //HttpContext.Current.Response.Write("<br>Result:sign=" + sign); //HttpContext.Current.Response.Write("fail"); payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "У��ʧ��,֧��ʧ��" + responseTxt); HttpContext.Current.Response.Write("fail"); // HttpContext.Current.Response.Redirect(payErrorUrl); } } catch(Exception e) { Utils.Log4Net.Error(e); HttpContext.Current.Response.Write("fail"); } }
/// <summary> /// 更新数据 /// </summary> /// <param name="obj"></param> /// <returns>返回:ture 成功,false 失败</returns> public bool Update(MPayLog obj) { if (obj == null) throw new ArgumentNullException("obj"); String stmtId = "MPayLog.Update"; int result = SqlMapper.Instance().QueryForObject<int>(stmtId, obj); return result > 0 ? true : false; }
/// <summary> /// ����֧���ɹ����� /// </summary> public void Receive() { string suchtml = "<meta content=\"China TENCENT\" name=\"TENCENT_ONLINE_PAYMENT\">\n" + "<script language=\"javascript\">\n" + "window.location.href='" + payOkUrl + "';\n" + "</script>"; string errmsg = ""; //string key = "tenpaytesttenpaytesttenpaytest12"; // string bargainor_id = "1202437801"; Md5Pay md5pay = new Md5Pay(); //md5pay.Key = key; //md5pay.Bargainor_id = bargainorId; //�ж�ǩ�� if (md5pay.GetPayValueFromUrl(HttpContext.Current.Request.QueryString, out errmsg)) { Decimal orderid = 0; orderid = Decimal.Parse(md5pay.Sp_billno); MPayLog payrecordinfo = new MPayLog(); payrecordinfo.PayUrl = HttpContext.Current.Request.UrlReferrer+""; payrecordinfo.OrderId = orderid; payrecordinfo.PayResult = md5pay.Pay_Result.ToString(); payrecordinfo.PayMoney = decimal.Parse(md5pay.Total_fee.ToString())/100; payrecordinfo.PayWay = PayWay; payrecordinfo.TransactionId = md5pay.Transaction_id; payrecordinfo.BackUrl = HttpContext.Current.Request.Url.AbsoluteUri; payrecordinfo.CreateTime = DateTime.Now; TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); //��֤ǩ���ɹ� //֧���ж� if (md5pay.Pay_Result == Md5Pay.PAYOK) { Service.Bll.Order.TOrderBLL obll = new TMM.Service.Bll.Order.TOrderBLL(); Service.Bll.User.MAccountBLL abll = new TMM.Service.Bll.User.MAccountBLL(); TOrder o = obll.GetOrderAndDetail(payrecordinfo.OrderId); if (o.Status >= 0 && o.Status < 10) //�¶��� -- �Ѹ��� ֮��Ĺ��� { //��ֵ abll.AddAmount(payrecordinfo.OrderId, payrecordinfo.PayMoney, Utils.TmmUtils.IPAddress(),this.PayWay); bool expandResult = true; //docidС��0 �����Ϊ���ⶩ������ִ���˻������Ķ��� if (o.SingleDetail.DocId > 0) { expandResult = abll.AccountExpend(payrecordinfo.OrderId, Utils.TmmUtils.IPAddress()); } //�������ûص��ӿ� if (expandResult) { #region �����ص��ӿ� //obll.UpdateOrder2Paid(payrecordinfo.OrderId, PayWay, "�Ƹ�֧ͨ��", (int)Models.MOrderStateInfo.������); Common.OrderCallBack oCallBack = new TMM.Core.Common.OrderCallBack(); oCallBack.UserId = o.UserId; oCallBack.OrderId = o.OrderId; oCallBack.PayWay = PayWay; oCallBack.Status = (int)OrderStatus.IsPaied; oCallBack.PayDetail = "�Ƹ�֧ͨ��"; oCallBack.ExecAfterPaid(); suchtml = suchtml.Replace("{1}", orderid.ToString()); //֧���ɹ���ͬ������md5pay.Transaction_id���ܻ���֪ͨ�������ע���ж϶����Ƿ��ظ����� //����ҵ����������db֮��� //errmsg = "֧���ɹ�"; //Response.Write(errmsg+"<br/>"); //Response.Write("�Ƹ�ͨ������:"+ md5pay.Transaction_id +"(���μǶ�����)"+"<br/>"); //��ת���ɹ�ҳ�棬�Ƹ�ͨ�յ�<meta content=\"China TENCENT\" name=\"TENCENT_ONLINE_PAYMENT\">����Ϊ֪ͨ�ɹ� payOkUrl = payOkUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); Utils.Log4Net.Error(string.Format("���Ƹ�ͨ��-��ͬ���ص���-���ɹ���-��{0}��", payOkUrl)); HttpContext.Current.Response.Write(suchtml); #endregion } else { Utils.Log4Net.Error(string.Format("���Ƹ�ͨ��-��ͬ���ص���-��ʧ��AccountExpend��-��{0}��", payOkUrl)); payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "�˻����㣡"); } } else { Utils.Log4Net.Error(string.Format("���Ƹ�ͨ��-��ͬ���ص���-��ʧ�ܡ�-��{0}��������״̬{1}��", payOkUrl,o.Status)); payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "��������"); } } else { //֧��ʧ�ܣ��벻Ҫ���ɹ����� // Response.Write(md5pay.Pay_Result+" "+Md5Pay.PAYOK); payErrorUrl = payErrorUrl.Replace("{1}", md5pay.Sp_billno); payErrorUrl = payErrorUrl.Replace("{2}", "֧��ʧ��" + errmsg); HttpContext.Current.Response.Redirect(payErrorUrl); //HttpContext.Current.Response.Write("֧��ʧ��" + errmsg + "<br/>"); } } else { //��֤ǩ��ʧ�� payErrorUrl = payErrorUrl.Replace("{1}", md5pay.Sp_billno); payErrorUrl = payErrorUrl.Replace("{2}", "��֤ǩ��ʧ��"); HttpContext.Current.Response.Redirect(payErrorUrl); // errmsg = "��֤ǩ��ʧ��"; // HttpContext.Current.Response.Write("��֤ǩ��ʧ��" + "<br/>"); } }
public void Send(string orderNo, string total, string remark,int userId) { //ҵ�������ֵ�� string gateway = payUrl; //'֧���ӿ� string subject = remark; //subject ��Ʒ���� string body = remark; //body ��Ʒ���� string price = total; string quantity = "1"; string show_url = productUrl; string seller_email = alipayAccount; //����˺� string return_url = returnUrl; //������֪ͨ���ؽӿ� string notify_url = NotifyUrl; //������֪ͨ���ؽӿ� string logistics_type = "EMS";//����ͷ�ʽ string logistics_fee = "0";//���˷��� string logistics_payment = "BUYER_PAY";//֧���� string[] para ={ "service="+service, "partner=" + partner, "seller_email=" + seller_email, "out_trade_no=" + orderNo, "subject=" + subject, "body=" + body, "total_fee=" + total, "show_url=" + show_url, "payment_type=1", "notify_url=" + notify_url, "return_url=" + return_url, "_input_charset="+_input_charset }; //֧��URL���� string aliay_url = AliPayPackage.CreatUrl( gateway,//GET��ʽ���ݲ���ʱ��ȥ��ע�� para, _input_charset, sign_type, key ); //����֧����¼ MPayLog payrecordinfo = new MPayLog(); //Models.MPayLogInfo payrecordinfo = new Models.MPayLogInfo(); payrecordinfo.PayUrl = aliay_url; payrecordinfo.UserId = userId; payrecordinfo.OrderId = decimal.Parse(orderNo); payrecordinfo.PayMoney = decimal.Parse(total); payrecordinfo.TransactionId = orderNo; payrecordinfo.PayResult = "100"; payrecordinfo.PayWay = PayWay; payrecordinfo.BackUrl = PayReturnUrl; payrecordinfo.CreateTime = DateTime.Now; TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); //TMM.Core.Utils.Log4Net.Error(aliay_url); HttpContext.Current.Response.Redirect(aliay_url); }
//public TenPay() //{ // string domain = HttpContext.Current.Request.Url.Host; // returnUrl = returnUrl.Replace("{0}", domain).Replace("{1}", chargeType.ToString()); // payOkUrl = payOkUrl.Replace("{0}", domain); // payErrorUrl = payErrorUrl.Replace("{0}", domain); //} /// <summary> /// ����֧������ /// </summary> /// <param name="orderno"></param> /// <param name="total"></param> /// <param name="remark"></param> public void Send(string orderno, string total, string remark) { Md5Pay p = new Md5Pay(); p.Paygateurl = payUrl; p.Desc = remark; p.Total_fee = (long)(decimal.Parse(total)*100); p.Sp_billno = orderno; p.Attach = "1"; p.Return_url = returnUrl; p.Transaction_id = p.Bargainor_id + p.Date + p.UnixStamp(); p.Spbill_create_ip =HttpContext.Current.Request.UserHostAddress; string url = ""; if (!p.GetPayUrl(out url)) { HttpContext.Current.Response.Write("TenPay Error"); //labErrmsg.Text = Server.HtmlEncode(url); } else { /*��������� * ������ md5pay.Transaction_id * �̻������� md5pay.Sp_billno * ������� md5pay.Total_fee * ����Ϣ�������ݿ�. * */ MPayLog payrecordinfo = new MPayLog(); payrecordinfo.PayUrl = url; payrecordinfo.OrderId = decimal.Parse(orderno); payrecordinfo.PayMoney = decimal.Parse(total); payrecordinfo.UserId = this.UserId; payrecordinfo.PayResult = "100"; payrecordinfo.PayWay = PayWay; payrecordinfo.TransactionId = p.Transaction_id; payrecordinfo.BackUrl = p.Return_url; payrecordinfo.CreateTime = DateTime.Now; TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); HttpContext.Current.Response.Redirect(url); } }
/// <summary> /// �첽֪ͨ /// </summary> public void Notify() { v_oid = HttpContext.Current.Request["v_oid"]; v_pstatus = HttpContext.Current.Request["v_pstatus"]; v_pstring = HttpContext.Current.Request["v_pstring"]; v_pmode = HttpContext.Current.Request["v_pmode"]; v_md5str = HttpContext.Current.Request["v_md5str"]; v_amount = HttpContext.Current.Request["v_amount"]; v_moneytype = HttpContext.Current.Request["v_moneytype"]; remark1 = HttpContext.Current.Request["remark1"]; remark2 = HttpContext.Current.Request["remark2"]; string str = v_oid + v_pstatus + v_amount + v_moneytype + key; str = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str, "md5").ToUpper(); MPayLog payrecordinfo = new MPayLog(); payrecordinfo.PayUrl = HttpContext.Current.Request.UrlReferrer + ""; payrecordinfo.OrderId = decimal.Parse(v_oid); payrecordinfo.PayResult = v_pstatus; payrecordinfo.PayMoney = decimal.Parse(v_amount); payrecordinfo.TransactionId = v_oid.ToString(); payrecordinfo.PayWay = PayWay; payrecordinfo.BackUrl = HttpContext.Current.Request.Url.ToString(); TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); if (str == v_md5str) { if (v_pstatus.Equals("20")) { string domain = HttpContext.Current.Request.Url.Host; //ȷ����m6go�µĶ��� if (remark2.ToLower().Contains(domain.ToLower()) == true) { Service.Bll.Order.TOrderBLL obll = new TMM.Service.Bll.Order.TOrderBLL(); Service.Bll.User.MAccountBLL abll = new TMM.Service.Bll.User.MAccountBLL(); TOrder o = obll.Get(payrecordinfo.OrderId); if (o.Status >= 0 && o.Status < 10) //�¶��� -- �Ѹ��� ֮��Ĺ��� { abll.AddAmount(payrecordinfo.OrderId, payrecordinfo.PayMoney,Utils.TmmUtils.IPAddress(),this.PayWay); if (abll.AccountExpend(payrecordinfo.OrderId,Utils.TmmUtils.IPAddress())) { //Web.Common.OrderCallBack oCallBack = new MamShare.Mall.Web.Common.OrderCallBack( // o.UserId, o.OrderId, PayWay, (int)Models.MOrderStateInfo.������, "ChinaBank֧��"); //oCallBack.Update2Paid(); //payOkUrl = payOkUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); //HttpContext.Current.Response.Redirect(payOkUrl); Common.OrderCallBack oCallBack = new TMM.Core.Common.OrderCallBack(); oCallBack.UserId = o.UserId; oCallBack.OrderId = o.OrderId; oCallBack.PayWay = PayWay; oCallBack.Status = (int)OrderStatus.IsPaied; oCallBack.PayDetail = "ChinaBank֧��"; oCallBack.ExecAfterPaid(); } else { payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "�˻����㣡"); HttpContext.Current.Response.Redirect(payErrorUrl); } } } HttpContext.Current.Response.Write("ok"); } else HttpContext.Current.Response.Write("error"); } else { payErrorUrl = payErrorUrl.Replace("{1}", payrecordinfo.OrderId.ToString()); payErrorUrl = payErrorUrl.Replace("{2}", "У��ʧ��,���ݿ���"); HttpContext.Current.Response.Write("error"); // HttpContext.Current.Response.Redirect(payErrorUrl); // HttpContext.Current.Response.Write("У��ʧ��,���ݿ���"); } }
public void Send(string orderNo, string total, string remark) { v_oid = orderNo; if (v_oid == null || v_oid.Equals("")) { return; } v_amount = total; string text = v_amount + v_moneytype + v_oid + v_mid + v_url + key; // ƴ�ռ��ܴ� v_md5info = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(text, "md5").ToUpper(); v_remark1 = remark; string para = ""; para += "v_mid=" + v_mid; para += "&v_url=" + v_url; para += "&v_oid=" + v_oid; para += "&v_amount=" + v_amount; para += "&v_moneytype=" + v_moneytype; para += "&v_md5info=" + v_md5info; para += "&v_remark1=" + v_remark1; para += "&remark2=" + remark2; payUrl += "?" + para; MPayLog payrecordinfo = new MPayLog(); payrecordinfo.PayUrl = payUrl; payrecordinfo.OrderId = decimal.Parse(orderNo); payrecordinfo.PayMoney = decimal.Parse(v_amount); payrecordinfo.TransactionId = orderNo; payrecordinfo.PayResult = "100"; payrecordinfo.PayWay = PayWay; payrecordinfo.BackUrl = BackUrl; TMM.Service.Bll.Order.MPayLogBLL pbll = new TMM.Service.Bll.Order.MPayLogBLL(); pbll.Insert(payrecordinfo); HttpContext.Current.Response.Redirect(payUrl); }
/// <summary> /// 更新数据 /// </summary> /// <param name="obj"></param> /// <returns>返回:ture 成功,false 失败</returns> public bool Update(MPayLog obj) { return dal.Update(obj); }
/// <summary> /// 插入数据 /// </summary> /// <param name="obj">对象</param> /// <returns>返回:该条数据的主键Id</returns> public int Insert(MPayLog obj) { return dal.Insert(obj); }