/// <summary> /// 处理交易结果 /// </summary> /// <param name="code"></param> /// <returns></returns> public bool SHPayHBIPS(string code) { Model.HKModel model = BLL.HKModel.GetModel(code); if (model == null) { return(false); } if (!model.HKState) { guidlist.Clear(); Hashtable MyHs = new Hashtable(); Model.Member member = DAL.Member.GetModel(model.MID); model.HKState = true; model.HKDate = DateTime.Now; BLL.HKModel.Update(model, MyHs); //充值MJB BLL.ChangeMoney.HBChangeTran(model.RealMoney, BLL.Member.ManageMember.TModel.MID, model.MID, "CZ", member, "MJB", "在线充值", MyHs); //if (model.Remark[0] == '0') //{ // BuyActiveCode(model, MyHs); //} //else //{ // BuyMMM(model, MyHs); //} if (BLL.CommonBase.RunHashtable(MyHs)) { return(true); } } return(false); }
public bool SHPayHB(string code) { Model.HKModel model = BLL.HKModel.GetModel(code); if (model == null) { return(false); } if (!model.HKState) { Hashtable MyHs = new Hashtable(); //Model.Member member = DAl.Member.GetModel(model.MID); model.HKState = true; model.HKDate = DateTime.Now; model.ValidMoney = model.RealMoney / BLL.Configuration.Model.B_InFloat; if (model.HKType == 1)//如果是激活且未激活 { BLL.ChangeMoney.CZMoneyChange(BLL.Member.ManageMember.TModel.MID, model.MID, model.ValidMoney, "MJB", MyHs); //DAl.ChangeMoney.TranChangeTran("", member.MID, model.ValidMoney, "MJB", MyHs); } BLL.HKModel.Update(model, MyHs); return(BLL.CommonBase.RunHashtable(MyHs)); } return(false); }
public static bool Update(Model.HKModel model) { Hashtable MyHs = new Hashtable(); DAL.HKModel.Update(model, MyHs); return(DAL.CommonBase.RunHashtable(MyHs)); }
/// <summary> /// 货币转移 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override string btnAdd_Click() { string error = GetBank(TModel); if (!string.IsNullOrEmpty(error)) { return("请先完善资料"); } if (Session["mantissa"] == null) { return("页面过期,请刷新页面"); } Model.HKModel model = HKModel; if (model.ValidMoney < 100) { return("最少充值100"); } if (BLL.HKModel.Insert(model)) { Session["code"] = null; Session["mantissa"] = null; BLL.Task.SendManage(TModel, "001", "员工账号:" + TModel.MID + "于当前时间" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "确认汇款信息,请注意查收,并及时审核!"); return("操作成功,请等待财务审核"); } return("操作失败"); }
public static Hashtable Update(Model.HKModel model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder sb = new StringBuilder("update HKModel set "); sb.Append("BankName=@BankName,"); sb.Append("FromBank=@FromBank,"); sb.Append("HKCreateDate=@HKCreateDate,"); sb.Append("HKDate=@HKDate,"); sb.Append("HKState=@HKState,"); sb.Append("HKType=@HKType,"); sb.Append("MID=@MID,"); sb.Append("RealMoney=@RealMoney,"); sb.Append("Remark=@Remark,"); sb.Append("MajorKey=@MajorKey,"); sb.Append("ToBank=@ToBank,"); sb.Append("IsAuto=@IsAuto,"); sb.Append("Sign=@Sign,"); sb.Append("ValidMoney=@ValidMoney "); sb.Append(" where "); sb.AppendFormat("HKCode=@HKCode and '{0}'='{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@BankName", SqlDbType.VarChar, 20), new SqlParameter("@FromBank", SqlDbType.VarChar, 50), new SqlParameter("@HKCode", SqlDbType.VarChar, 36), new SqlParameter("@HKCreateDate", SqlDbType.DateTime, 8), new SqlParameter("@HKDate", SqlDbType.DateTime, 8), new SqlParameter("@HKState", SqlDbType.Bit, 1), new SqlParameter("@HKType", SqlDbType.Int, 4), new SqlParameter("@MID", SqlDbType.VarChar, 20), new SqlParameter("@RealMoney", SqlDbType.Decimal), new SqlParameter("@ToBank", SqlDbType.VarChar, 50), new SqlParameter("@IsAuto", SqlDbType.Bit, 1), new SqlParameter("@Sign", SqlDbType.Bit, 1), new SqlParameter("@ValidMoney", SqlDbType.Decimal), new SqlParameter("@Remark", SqlDbType.VarChar, -1), new SqlParameter("@MajorKey", SqlDbType.VarChar, 50) }; parameters[0].Value = model.BankName; parameters[1].Value = model.FromBank; parameters[2].Value = model.HKCode; parameters[3].Value = model.HKCreateDate; parameters[4].Value = model.HKDate; parameters[5].Value = model.HKState; parameters[6].Value = model.HKType; parameters[7].Value = model.MID; parameters[8].Value = model.RealMoney; parameters[9].Value = model.ToBank; parameters[10].Value = model.IsAuto; parameters[11].Value = model.Sign; parameters[12].Value = model.ValidMoney; parameters[13].Value = model.Remark; parameters[14].Value = model.MajorKey; MyHs.Add(sb.ToString(), parameters); return(MyHs); }
/// <summary> /// 货币转移 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override string btnAdd_Click() { Model.HKModel model = HKModel; if (BLL.HKModel.Insert(model)) { BLL.Task.SendManage(TModel, "001", "会员账号:" + TModel.MID + "于当前时间" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "确认汇款信息,请注意查收,并及时审核!"); return("操作成功,请等待财务审核"); } return("操作失败"); }
public static bool Insert(Model.HKModel model) { Hashtable MyHs = new Hashtable(); //if (BLL.HKModel.Exist(model.MajorKey)) //{ // throw new Exception("请勿重复提交"); //} DAL.HKModel.Insert(model, MyHs); return(DAL.CommonBase.RunHashtable(MyHs)); }
public string SHHKModel(string hkCodeStr) { string[] hkCodeList = hkCodeStr.Split(','); Hashtable MyHs = new Hashtable(); Dictionary <Model.Member, decimal> midlist = new Dictionary <Model.Member, decimal>(); foreach (string hkcode in hkCodeList) { Model.HKModel model = BLL.HKModel.GetModel(hkcode); if (model == null) { continue; } if (!model.HKState) { Model.Member member = DAL.Member.GetModel(model.MID); model.HKState = true; model.HKDate = DateTime.Now; //model.ValidMoney = model.RealMoney / BLL.Configuration.Model.B_InFloat; if (model.HKType == 1)//如果是激活且未激活 { BLL.ChangeMoney.HBChangeTran(model.ValidMoney, BLL.Member.ManageMember.TModel.MID, model.MID, "HKSH", null, "MJB", "汇款审核" + model.HKCode, MyHs); } else { //BLL.Task.ManageSend(member, "尊敬的会员:" + model.MID + ",非常抱歉,您本次充值报单币" + model.ValidMoney + "充值失败!"); continue; } BLL.HKModel.Update(model, MyHs); midlist.Add(member, model.ValidMoney); } } if (DAL.CommonBase.RunHashtable(MyHs)) { foreach (KeyValuePair <Model.Member, decimal> mid in midlist) { BLL.Task.SendManage(mid.Key, "001", "会员于当前时间向公司汇款人民币:" + mid.Value.ToString()); BLL.Task.ManageSend(mid.Key, "尊敬的会员:" + mid.Key.MID + ",您的汇款记录已于当前时间" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "成功审核,请及时查看您的账户信息,如有疑问,请联系客服"); } return("操作成功"); } else { return("操作失败"); } }
protected void Page_Load(object sender, EventArgs e) { string merOrderNum = Request.QueryString["merOrderNum"]; Model.HKModel model = BLL.HKModel.GetModel(merOrderNum); LogHelper.Log("国付宝同步", string.Format("merOrderNum={0}", merOrderNum), "gfb"); if (model != null && model.HKState) { Response.Write("交易成功!"); Response.End(); } else { Response.Write("交易失败!"); Response.End(); } }
public static Hashtable Insert(Model.HKModel model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder sb = new StringBuilder("insert into HKModel (BankName,FromBank,HKCode,HKCreateDate,HKDate,HKState,HKType,MID,RealMoney,ToBank,ValidMoney,IsAuto,Sign,Remark,MajorKey) "); sb.Append("values"); sb.Append("(@BankName,@FromBank,@HKCode,@HKCreateDate,@HKDate,@HKState,@HKType,@MID,@RealMoney,@ToBank,@ValidMoney,@IsAuto,@Sign,@Remark,@MajorKey);"); sb.AppendFormat("select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@BankName", SqlDbType.VarChar, 20), new SqlParameter("@FromBank", SqlDbType.VarChar, 50), new SqlParameter("@HKCode", SqlDbType.VarChar, 36), new SqlParameter("@HKCreateDate", SqlDbType.DateTime, 8), new SqlParameter("@HKDate", SqlDbType.DateTime, 8), new SqlParameter("@HKState", SqlDbType.Bit, 1), new SqlParameter("@HKType", SqlDbType.Int, 4), new SqlParameter("@MID", SqlDbType.VarChar, 20), new SqlParameter("@RealMoney", SqlDbType.Decimal), new SqlParameter("@ToBank", SqlDbType.VarChar, 50), new SqlParameter("@ValidMoney", SqlDbType.Decimal), new SqlParameter("@IsAuto", SqlDbType.Bit, 1), new SqlParameter("@Sign", SqlDbType.Bit, 1), new SqlParameter("@Remark", SqlDbType.VarChar, -1), new SqlParameter("@MajorKey", SqlDbType.VarChar, 50) }; parameters[0].Value = model.BankName; parameters[1].Value = model.FromBank; parameters[2].Value = model.HKCode; parameters[3].Value = model.HKCreateDate; parameters[4].Value = model.HKDate; parameters[5].Value = model.HKState; parameters[6].Value = model.HKType; parameters[7].Value = model.MID; parameters[8].Value = model.RealMoney; parameters[9].Value = model.ToBank; parameters[10].Value = model.ValidMoney; parameters[11].Value = model.IsAuto; parameters[12].Value = model.Sign; parameters[13].Value = model.Remark; parameters[14].Value = model.MajorKey; MyHs.Add(sb.ToString(), parameters); return(MyHs); }
protected void Page_Load(object sender, EventArgs e) { string v_oid1 = Request.Form["v_oid"]; Model.HKModel model = BLL.HKModel.GetModel(v_oid1); if (model != null) { if (model.HKState) { Response.Write("交易成功!"); Response.End(); } else { Response.Write("交易失败!"); Response.End(); } } Response.Write("交易失败!"); Response.End(); }
private static Model.HKModel TranEntity(DataRow dr) { Model.HKModel model = new Model.HKModel(); if (!string.IsNullOrEmpty(dr["HKCreateDate"].ToString())) { model.HKCreateDate = DateTime.Parse(dr["HKCreateDate"].ToString()); } if (!string.IsNullOrEmpty(dr["HKDate"].ToString())) { model.HKDate = DateTime.Parse(dr["HKDate"].ToString()); } if (!string.IsNullOrEmpty(dr["BankName"].ToString())) { model.BankName = dr["BankName"].ToString(); } if (!string.IsNullOrEmpty(dr["FromBank"].ToString())) { model.FromBank = dr["FromBank"].ToString(); } if (!string.IsNullOrEmpty(dr["ToBank"].ToString())) { model.ToBank = dr["ToBank"].ToString(); } if (!string.IsNullOrEmpty(dr["HKCode"].ToString())) { model.HKCode = dr["HKCode"].ToString(); } if (!string.IsNullOrEmpty(dr["HKState"].ToString())) { model.HKState = bool.Parse(dr["HKState"].ToString()); } if (!string.IsNullOrEmpty(dr["IsAuto"].ToString())) { model.IsAuto = bool.Parse(dr["IsAuto"].ToString()); } if (!string.IsNullOrEmpty(dr["Sign"].ToString())) { model.Sign = bool.Parse(dr["Sign"].ToString()); } if (!string.IsNullOrEmpty(dr["HKType"].ToString())) { model.HKType = int.Parse(dr["HKType"].ToString()); if (model.HKType == 1) { model.HKTypeStr = DAL.Reward.List["MJB"].RewardName; } else { model.HKTypeStr = "未知类型"; } } if (!string.IsNullOrEmpty(dr["Remark"].ToString())) { model.Remark = dr["Remark"].ToString(); } if (!string.IsNullOrEmpty(dr["MajorKey"].ToString())) { model.MajorKey = dr["MajorKey"].ToString(); } if (!string.IsNullOrEmpty(dr["MID"].ToString())) { model.MID = dr["MID"].ToString(); } if (!string.IsNullOrEmpty(dr["RealMoney"].ToString())) { model.RealMoney = decimal.Parse(dr["RealMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["ValidMoney"].ToString())) { model.ValidMoney = decimal.Parse(dr["ValidMoney"].ToString()); } return(model); }
public static Hashtable Insert(Model.HKModel model, Hashtable MyHs) { DAL.HKModel.Insert(model, MyHs); return(MyHs); }
protected override void SetPowerZone() { try { Model.HKModel model = HKModel; if (!BLL.HKModel.Insert(model)) { Response.Write("提交失败"); Response.End(); } ////////////////////////////////////请求参数////////////////////////////////////// string url = Request.Url.Scheme + "://" + Request.Url.Authority.Replace("localhost", "127.0.0.1"); //参数编码字符集(必选) string input_charset1 = "UTF-8"; //接口版本(必选)固定值:V3.0 string interface_version1 = "V3.0"; //商家号(必填) string merchant_code1 = "2460634"; //后台通知地址(必填) string notify_url1 = url + "/Payment/DinPay/DinpayToMer.aspx"; //定单金额(必填) string order_amount1 = model.RealMoney.ToString(); //商家定单号(必填) string order_no1 = model.HKCode; //商家定单时间(必填) string order_time1 = model.HKCreateDate.ToString("yyyy-MM-dd HH:mm:ss"); //签名方式(必填) string sign_type1 = "MD5"; //服务编号(选填) string product_code1 = "1"; //服务描述(选填) string product_desc1 = "1"; //服务名称(必填) string product_name1 = "1"; //端口数量(选填) string product_num1 = "1"; //页面跳转同步通知地址(选填) string return_url1 = url; //业务类型(必填) string service_type1 = "direct_pay"; //服务展示地址(选填) string show_url1 = ""; //公用业务扩展参数(选填) string extend_param1 = ""; //公用业务回传参数(选填) string extra_return_param1 = model.MID; // 直联通道代码(选填) string bank_code1 = model.FromBank; //客户端IP(选填) string client_ip1 = ""; /* 注 new String(参数.getBytes("ISO-8859-1"),"此页面编码格式"); 若为GBK编码 则替换UTF-8 为GBK*/ /* ** ** 签名顺序按照参数名a到z的顺序排序,若遇到相同首字母,则看第二个字母,以此类推,同时将商家支付密钥key放在最后参与签名, ** 组成规则如下: ** 参数名1=参数值1&参数名2=参数值2&……&参数名n=参数值n&key=key值 **/ string signSrc = ""; //组织订单信息 if (bank_code1 != "") { signSrc = signSrc + "bank_code=" + bank_code1 + "&"; } if (client_ip1 != "") { signSrc = signSrc + "client_ip=" + client_ip1 + "&"; } if (extend_param1 != "") { signSrc = signSrc + "extend_param=" + extend_param1 + "&"; } if (extra_return_param1 != "") { signSrc = signSrc + "extra_return_param=" + extra_return_param1 + "&"; } if (input_charset1 != "") { signSrc = signSrc + "input_charset=" + input_charset1 + "&"; } if (interface_version1 != "") { signSrc = signSrc + "interface_version=" + interface_version1 + "&"; } if (merchant_code1 != "") { signSrc = signSrc + "merchant_code=" + merchant_code1 + "&"; } if (notify_url1 != "") { signSrc = signSrc + "notify_url=" + notify_url1 + "&"; } if (order_amount1 != "") { signSrc = signSrc + "order_amount=" + order_amount1 + "&"; } if (order_no1 != "") { signSrc = signSrc + "order_no=" + order_no1 + "&"; } if (order_time1 != "") { signSrc = signSrc + "order_time=" + order_time1 + "&"; } if (product_code1 != "") { signSrc = signSrc + "product_code=" + product_code1 + "&"; } if (product_desc1 != "") { signSrc = signSrc + "product_desc=" + product_desc1 + "&"; } if (product_name1 != "") { signSrc = signSrc + "product_name=" + product_name1 + "&"; } if (product_num1 != "") { signSrc = signSrc + "product_num=" + product_num1 + "&"; } if (return_url1 != "") { signSrc = signSrc + "return_url=" + return_url1 + "&"; } if (service_type1 != "") { signSrc = signSrc + "service_type=" + service_type1 + "&"; } if (show_url1 != "") { signSrc = signSrc + "show_url=" + show_url1 + "&"; } //设置密钥 string key = "sdjlJFIOIFJ_jsdfjiweuhflDFKLjsi238Jksk"; signSrc = signSrc + "key=" + key; string singInfo = signSrc; //Response.Write("singInfo=" + singInfo + "<br>"); //签名 string sign1 = FormsAuthentication.HashPasswordForStoringInConfigFile(singInfo, "md5").ToLower(); //Response.Write("sign1=" + sign1 + "<br>"); sign.Value = sign1; merchant_code.Value = merchant_code1; bank_code.Value = bank_code1; order_no.Value = order_no1; order_amount.Value = order_amount1; service_type.Value = service_type1; input_charset.Value = input_charset1; notify_url.Value = notify_url1; interface_version.Value = interface_version1; sign_type.Value = sign_type1; order_time.Value = order_time1; product_name.Value = product_name1; client_ip.Value = client_ip1; extend_param.Value = extend_param1; extra_return_param.Value = extra_return_param1; product_code.Value = product_code1; product_desc.Value = product_desc1; product_num.Value = product_num1; return_url.Value = return_url1; show_url.Value = show_url1; } finally { } }
public static Hashtable Update(Model.HKModel model, Hashtable MyHs) { DAL.HKModel.Update(model, MyHs); return(MyHs); }
protected new void Page_Load(object sender, EventArgs e) { Model.HKModel model = HKModel; try { if (model.ValidMoney < 50) { model.RealMoney = model.ValidMoney * BLL.MMMConfig.Model.ActiveCodePrice; } else if (model.ValidMoney < 100) { model.RealMoney = model.ValidMoney * 50; } else if (model.ValidMoney < 200) { model.RealMoney = model.ValidMoney * 40; } else { model.RealMoney = model.ValidMoney * 30; } model.RealMoney = model.ValidMoney * BLL.MMMConfig.Model.ActiveCodePrice; if (!BLL.HKModel.Insert(model)) { Response.Write("提交失败"); Response.End(); return; } } catch { return; } // 组织数据和签名 Dictionary <string, string> payData = new Dictionary <string, string>(); payData.Add("apiName", MobaopayConfig.Mobaopay_apiname_pay); payData.Add("apiVersion", MobaopayConfig.Mobaopay_api_version); payData.Add("platformID", MobaopayConfig.Platform_id); payData.Add("merchNo", MobaopayConfig.Merchant_acc); payData.Add("orderNo", model.HKCode); //订单号 payData.Add("tradeDate", model.HKDate.ToString("yyyyMMdd")); //交易日期 payData.Add("amt", model.RealMoney.ToString()); //总金额 payData.Add("merchUrl", MobaopayConfig.Merchant_notify_url); payData.Add("merchParam", "abcd"); //商户参数 payData.Add("tradeSummary", "充值"); //交易摘要 /** * bankCode为空,提交表单后浏览器在新窗口显示摩宝支付收银台页面,在这里可以通过账户余额支付或者选择银行支付; * bankCode不为空,取值只能是接口文档中列举的银行代码,提交表单后浏览器将在新窗口直接打开选中银行的支付页面。 * 无论选择上面两种方式中的哪一种,支付成功后收到的通知都是同一接口。 */ payData.Add("bankCode", Request.Form["yh"]); string requestStr = MobaopayMerchant.Instance.generatePayRequest(payData); // 组织签名源数据 payData.Add("signMsg", MobaopaySignUtil.Instance.sign(requestStr)); // 生成签名数据 // 生成表单并自动提交到支付网关。 StringBuilder sbHtml = new StringBuilder(); sbHtml.Append("<form id='mobaopaysubmit' name='mobaopaysubmit' action='" + MobaopayConfig.Mobaopay_gateway + "?' method='post'>"); foreach (KeyValuePair <string, string> temp in payData) { sbHtml.Append("<input type='hidden' name='" + temp.Key + "' value='" + temp.Value + "'/>"); } sbHtml.Append("</form>"); sbHtml.Append("<script>document.forms['mobaopaysubmit'].submit();</script>"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Write(sbHtml.ToString()); }
private static Model.HKModel TranEntity(DataRow dr) { Model.HKModel model = new Model.HKModel(); if (!string.IsNullOrEmpty(dr["HKCreateDate"].ToString())) { model.HKCreateDate = DateTime.Parse(dr["HKCreateDate"].ToString()); } if (!string.IsNullOrEmpty(dr["HKDate"].ToString())) { model.HKDate = DateTime.Parse(dr["HKDate"].ToString()); } if (!string.IsNullOrEmpty(dr["ConfirmTime"].ToString())) { model.ConfirmTime = DateTime.Parse(dr["ConfirmTime"].ToString()); } if (!string.IsNullOrEmpty(dr["BankName"].ToString())) { model.BankName = dr["BankName"].ToString(); } if (!string.IsNullOrEmpty(dr["FromBank"].ToString())) { model.FromBank = dr["FromBank"].ToString(); } if (!string.IsNullOrEmpty(dr["ToBank"].ToString())) { model.ToBank = dr["ToBank"].ToString(); } if (!string.IsNullOrEmpty(dr["HKCode"].ToString())) { model.HKCode = dr["HKCode"].ToString(); } if (!string.IsNullOrEmpty(dr["HKState"].ToString())) { model.HKState = bool.Parse(dr["HKState"].ToString()); } if (!string.IsNullOrEmpty(dr["IsAuto"].ToString())) { model.IsAuto = bool.Parse(dr["IsAuto"].ToString()); } if (!string.IsNullOrEmpty(dr["Sign"].ToString())) { model.Sign = bool.Parse(dr["Sign"].ToString()); } if (!string.IsNullOrEmpty(dr["HKType"].ToString())) { model.HKType = int.Parse(dr["HKType"].ToString()); if (model.HKType == 1) { model.HKTypeStr = "财付通"; } else if (model.HKType == 2) { model.HKTypeStr = "支付宝"; } else if (model.HKType == 3) { model.HKTypeStr = "网银"; } } if (!string.IsNullOrEmpty(dr["MID"].ToString())) { model.MID = dr["MID"].ToString(); } if (!string.IsNullOrEmpty(dr["RealMoney"].ToString())) { model.RealMoney = decimal.Parse(dr["RealMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["ValidMoney"].ToString())) { model.ValidMoney = decimal.Parse(dr["ValidMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["Remark"].ToString())) { model.Remark = dr["Remark"].ToString(); } return(model); }