public ResponseResult Query([FromBody] QueryInfo query) { ColoPay.Model.Pay.Enterprise CurrEnterprise = bll.GetEnterpriseInfo(query.appid, query.secrit); if (CurrEnterprise == null) { return(FailResult(ResponseCode.ParamError, "appid or secrit is illegal")); } //判断订单是否存在 ColoPay.Model.Pay.Order orderInfo = orderBll.GetModelEx(query.order_no, CurrEnterprise.EnterpriseID); if (orderInfo.PaymentStatus != 2)//订单状态未支付,则去支付平台查询一次 { bool hasPaid = ColoPay.WebApi.PayApi.BZ_Pay.HasPaid(orderInfo.OrderCode); if (hasPaid) { bool isSuccess = orderBll.CompleteOrder(orderInfo); if (isSuccess) { orderInfo.PaymentStatus = 2; orderInfo.OrderStatus = 1; orderBll.HasNotify(orderInfo.OrderId); } } } YSWL.Json.JsonObject jsonObject = new JsonObject(); jsonObject["appid"] = query.appid; jsonObject["secrit"] = query.secrit; jsonObject["order_no"] = orderInfo.EnterOrder; jsonObject["amount"] = orderInfo.Amount.ToString(); jsonObject["sdorder_no"] = orderInfo.OrderCode; jsonObject["paytype"] = orderInfo.PaymentGateway; jsonObject["status"] = orderInfo.PaymentStatus.ToString(); return(SuccessResult(jsonObject)); }
public void ShowInfo(string strEnerpid) { EnterPriseModel = EnterpriseBll.GetModel(int.Parse(strEnerpid)); txtName.Text = EnterPriseModel.Name; txtSimpleName.Text = EnterPriseModel.SimpleName; txtEnterpriseNum.Text = EnterPriseModel.EnterpriseNum; txtBusinessLicense.Text = EnterPriseModel.BusinessLicense; txtCellPhone.Text = EnterPriseModel.CellPhone; //txtAccountBank.Text = EnterPriseModel.AccountBank; txtAccountInfo.Text = EnterPriseModel.AccountInfo; txtAccountNum.Text = EnterPriseModel.AccountNum; //txtWithdrawBank.Text = EnterPriseModel.WithdrawBank; txtWithdrawInfo.Text = EnterPriseModel.WithdrawInfo; txtWithdrawNum.Text = EnterPriseModel.WithdrawNum; txtBalance.Text = EnterPriseModel.Balance.ToString(); txtAppId.Text = EnterPriseModel.AppId; txtAppSecrit.Text = EnterPriseModel.AppSecrit; txtAppUrl.Text = EnterPriseModel.AppUrl; txtAppReturnUrl.Text = EnterPriseModel.AppReturnUrl; // txtContactMail.Text = EnterPriseModel.ContactMail; // txtAddress.Text = EnterPriseModel.Address; ddlEnteRank.SelectedValue = EnterPriseModel.EnteRank.ToString(); //txtRemark.Text = EnterPriseModel.Remark; }
public ColoPay.Model.Pay.Enterprise GetEnterpriseInfo(string appid, string secrit) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 EnterpriseID,AgentId,UserName,Name,SimpleName,Status,EnterpriseNum,BusinessLicense,TelPhone,CellPhone,AccountBank,AccountInfo,AccountNum,WithdrawBank,WithdrawInfo,WithdrawNum,Balance,AppId,AppSecrit,AppUrl,AppReturnUrl,ContactMail,Address,EnteRank,CreatedDate,CreatedUserID,RegisterIp,Remark from Pay_Enterprise "); strSql.Append(" where AppId=@AppId and AppSecrit=@AppSecrit and Status=1"); SqlParameter[] parameters = { new SqlParameter("@AppId", SqlDbType.NVarChar, 200), new SqlParameter("@AppSecrit", SqlDbType.NVarChar, 200) }; parameters[0].Value = appid; parameters[1].Value = secrit; ColoPay.Model.Pay.Enterprise model = new ColoPay.Model.Pay.Enterprise(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 获取商家名称 /// </summary> /// <param name="target"></param> /// <returns></returns> protected string GetEnterpriseName(object target) { int enterpriseId = YSWL.Common.Globals.SafeInt(target, 0); ColoPay.Model.Pay.Enterprise enterpriseModel = enterpriseBll.GetModelByCache(enterpriseId); return(enterpriseModel == null ? "未知" : enterpriseModel.Name); }
public void ShowInfo(string strEnerpid) { EnterPriseModel = EnterpriseBll.GetModel(int.Parse(strEnerpid)); txtAppId.Text = EnterPriseModel.AppId; txtAppSecrit.Text = EnterPriseModel.AppSecrit; txtAppUrl.Text = EnterPriseModel.AppUrl; txtAppReturnUrl.Text = EnterPriseModel.AppReturnUrl; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ColoPay.Model.Pay.Enterprise enterpriseModel = enterpriseBll.GetModel(CurrEnterpriseID); this.txtAmount.Text = enterpriseModel.Balance.ToString("F"); this.txtWithdrawBank.Text = enterpriseModel.WithdrawBank; this.txtWithdrawInfo.Text = enterpriseModel.WithdrawInfo; this.txtWithdrawNum.Text = enterpriseModel.WithdrawNum; } }
public void btnSave_Click(object sender, System.EventArgs e) { ColoPay.Model.Pay.Enterprise enterpriseModel = enterpriseBll.GetModel(CurrEnterpriseID); decimal amount = YSWL.Common.Globals.SafeDecimal(this.txtAmount.Text, 0); string withdrawBank = this.txtWithdrawBank.Text; string withdrawInfo = this.txtWithdrawInfo.Text; string withdrawNum = this.txtWithdrawNum.Text; string userName = this.txtUserName.Text; if (amount > enterpriseModel.Balance) { lblMsg.Text = "提现金额不能超过余额,请重新输入!"; return; } if (String.IsNullOrWhiteSpace(withdrawBank) || String.IsNullOrWhiteSpace(withdrawInfo) || String.IsNullOrWhiteSpace(withdrawNum)) { lblMsg.Text = "提现银行不完善,请检查!"; return; } ColoPay.Model.Pay.Withdraw model = new Model.Pay.Withdraw(); model.AgentId = 0; model.WithdrawCode = "TX" + DateTime.Now.ToString("yyyyMMddHHmmssfff"); model.Amount = amount; model.CreatedDate = DateTime.Now; model.CreatedUserId = currentUser.UserID; model.UserName = userName; model.EnterpriseID = CurrEnterpriseID; model.Type = 0; model.WithdrawBank = withdrawBank; model.WithdrawInfo = withdrawInfo; model.WithdrawNum = withdrawNum; model.Remark = txtRemark.Text; model.Status = 0; bool isSuccess = withdrawBll.AddWithdraw(model); //申请成功 if (isSuccess) { YSWL.Common.MessageBox.ShowSuccessTip(this, "申请提现成功!"); Response.Redirect("WithdrawList.aspx"); } else { YSWL.Common.MessageBox.ShowFailTip(this, "申请提现失败,请稍后再试!"); return; } }
/// <summary> /// 更新回调应用地址 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtnAppReturnUrl_Click(object sender, EventArgs e) { string strAppReturnUrl = YSWL.Common.InjectionFilter.SqlFilter(txtAppReturnUrl.Text); if (strAppReturnUrl.Length > 0) { EnterPriseModel = EnterpriseBll.GetModel(int.Parse(lbEnterPid.Text)); EnterPriseModel.AppReturnUrl = strAppReturnUrl; EnterpriseBll.Update(EnterPriseModel); YSWL.Common.MessageBox.ShowSuccessTip(this, "回调地址设置成功!"); } else { YSWL.Common.MessageBox.ShowFailTip(this, "请填写回调地址!"); } }
/// <summary> /// 获取企业名称 /// </summary> /// <param name="target"></param> /// <returns></returns> protected string GetEnterpriseName(object objEnterprise, object objAgent, object objType) { int enterpriseId = YSWL.Common.Globals.SafeInt(objEnterprise, 0); int agentId = YSWL.Common.Globals.SafeInt(objAgent, 0); int type = YSWL.Common.Globals.SafeInt(objType, 0); if (type == 0) { ColoPay.Model.Pay.Enterprise enterpriseModel = enterpriseBll.GetModelByCache(enterpriseId); return(enterpriseModel == null ? "未知" : enterpriseModel.Name); } else { ColoPay.Model.Pay.Agent agentModel = agentBll.GetModelByCache(agentId); return(agentModel == null ? "未知" : agentModel.Name); } }
/// <summary> /// 保存操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnSave_Click(object sender, System.EventArgs e) { if (txtPayFree.Text.Trim() == "") { YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("设置费率{0}!", "")); return; } PayFreeModel.EnterpriseID = int.Parse(lbEnterPid.Text); PayFreeModel.PayModeId = int.Parse(lbPayModelid.Text); PayFreeModel.FeeRate = decimal.Parse(txtPayFree.Text); EnterPriseModel = EnterpriseBll.GetModel(int.Parse(lbEnterPid.Text)); if (EnterPriseModel != null) { if (EnterPriseModel.AgentId.ToString() == lbAgentId.Text) { if (lbType.Text == "0") { //开通通道 if (PayFreeBll.Add(PayFreeModel)) { YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("开通通道成功,费率:【{0}】!", txtPayFree.Text)); LogHelp.AddUserLog(CurrentUser.UserName, CurrentUser.UserType, string.Format(" 商户" + lbEnterPid.Text + " ,设置费率:【{0}】", txtPayFree.Text), this); Response.Redirect("PayFeeList.aspx?Enterpid=" + lbEnterPid.Text + ""); } } else { if (PayFreeBll.Update(PayFreeModel)) { YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("修改费率:【{0}】成功!", txtPayFree.Text)); LogHelp.AddUserLog(CurrentUser.UserName, CurrentUser.UserType, string.Format(" 商户" + lbEnterPid.Text + " ,设置费率:【{0}】", txtPayFree.Text), this); Response.Redirect("PayFeeList.aspx?Enterpid=" + lbEnterPid.Text + ""); } } } else { YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("不可修改别家商户的数据!用户:【{0}】", CurrentUser.UserName)); LogHelp.AddUserLog(CurrentUser.UserName, CurrentUser.UserType, string.Format(" 商户" + lbEnterPid.Text + " ,不可修改别家商户的数据", txtPayFree.Text), this); } } }
public void ShowInfo(string strEnerpid) { EnterPriseModel = EnterpriseBll.GetModel(int.Parse(strEnerpid)); lbEnterName.Text = EnterPriseModel.Name; }
public void btnSave_Click(object sender, System.EventArgs e) { if (lbEnterPid.Text.Trim() != "") { EnterPriseModel = EnterpriseBll.GetModel(int.Parse(lbEnterPid.Text)); userModel = userbll.GetModel(EnterPriseModel.UserName); } User newUser = new User(); #pragma warning disable CS0219 // 变量“strErr”已被赋值,但从未使用过它的值 string strErr = ""; #pragma warning restore CS0219 // 变量“strErr”已被赋值,但从未使用过它的值 //if (newUser.HasUserByUserName(txtUserName.Text)) //{ // strErr += Resources.Site.TooltipUserExist; //} //if (strErr != "") //{ // YSWL.Common.MessageBox.ShowSuccessTip(this, strErr); // return; //} newUser.UserName = txtUserName.Text; newUser.Password = AccountsPrincipal.EncryptPassword("111111"); newUser.NickName = newUser.UserName; //昵称和用户名相同 SNS模块使用 newUser.TrueName = txtName.Text; newUser.Sex = "1"; newUser.EmployeeID = 0; newUser.Activity = true; newUser.UserType = "EE"; newUser.Style = 1; newUser.User_dateCreate = DateTime.Now; newUser.User_iCreator = CurrentUser.UserID; newUser.User_dateValid = DateTime.Now; newUser.User_cLang = "zh-CN"; EnterPriseModel.UserName = txtUserName.Text; EnterPriseModel.Name = txtName.Text; EnterPriseModel.SimpleName = txtSimpleName.Text; EnterPriseModel.Status = 0; EnterPriseModel.EnterpriseNum = txtEnterpriseNum.Text; EnterPriseModel.BusinessLicense = txtBusinessLicense.Text; EnterPriseModel.TelPhone = txtTelPhone.Text; EnterPriseModel.CellPhone = txtCellPhone.Text; EnterPriseModel.AccountBank = txtAccountBank.Text; EnterPriseModel.AccountInfo = txtAccountInfo.Text; EnterPriseModel.AccountNum = txtAccountNum.Text; EnterPriseModel.WithdrawBank = txtWithdrawBank.Text; EnterPriseModel.WithdrawInfo = txtWithdrawInfo.Text; EnterPriseModel.WithdrawNum = txtWithdrawNum.Text; EnterPriseModel.Balance = 0; EnterPriseModel.AppId = txtAppId.Text; EnterPriseModel.AppSecrit = txtAppSecrit.Text; EnterPriseModel.AppUrl = txtAppUrl.Text; EnterPriseModel.AppReturnUrl = txtAppReturnUrl.Text; EnterPriseModel.ContactMail = txtContactMail.Text; EnterPriseModel.Address = txtAddress.Text; EnterPriseModel.EnteRank = 1; EnterPriseModel.CreatedDate = DateTime.Now; EnterPriseModel.CreatedUserID = CurrentUser.UserID; EnterPriseModel.RegisterIp = ""; EnterPriseModel.Remark = txtRemark.Text; EnterPriseModel.AgentId = int.Parse(lbAgentId.Text); if (lbEnterPid.Text == "") { if (EnterpriseBll.ExistsUsername(txtUserName.Text)) { lblMsg.Text = "用户名已存在,请重新输入!"; return; } if (EnterpriseBll.ExistsName(txtName.Text)) { lblMsg.Text = "商户名称已存在,请重新输入!"; return; } else { int userid = newUser.Create(); if (userid == -100) { //ERROR YSWL.Common.MessageBox.ShowSuccessTip(this, Resources.Site.TooltipUserExist); return; } //新增商户成功 if (EnterpriseBll.Add(EnterPriseModel) > 0) { YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("新增商户:【{0}】成功!", txtUserName.Text)); LogHelp.AddUserLog(CurrentUser.UserName, CurrentUser.UserType, string.Format("新增商户:【{0}】", txtUserName.Text), this); Response.Redirect("EnterpriseList.aspx"); } } } else { if (EnterpriseBll.ExistsUsername(lbEnterPid.Text, txtUserName.Text)) { lblMsg.Text = "用户名已存在,请重新输入!"; } if (EnterpriseBll.ExistsName(lbEnterPid.Text, txtName.Text)) { lblMsg.Text = "商户名称已存在,请重新输入!"; return; } else { userModel.UserName = txtUserName.Text; EnterpriseBll.Update(EnterPriseModel);//修改企业信息 YSWL.Common.MessageBox.ShowSuccessTip(this, string.Format("修改商户信息:【{0}】成功!", txtUserName.Text)); Response.Redirect("EnterpriseList.aspx"); } } }
public ResponseResult SubmitOrder([FromBody] PayInfo payinfo) { //YSWL.Common.DEncrypt.DEncrypt.GetMD5FromStr //验证是否数据安全性 if (payinfo.amount < 0) { return(FailResult(ResponseCode.ParamError, "amount is illegal")); } if (String.IsNullOrWhiteSpace(payinfo.order_no)) { return(FailResult(ResponseCode.ParamError, "ordercode is illegal")); } ColoPay.Model.Pay.Enterprise CurrEnterprise = bll.GetEnterpriseInfo(payinfo.appid, payinfo.secrit); if (CurrEnterprise == null) { return(FailResult(ResponseCode.ParamError, "appid or secrit is illegal")); } //判断订单是否存在 ColoPay.Model.Pay.Order orderInfo = orderBll.GetModelEx(payinfo.order_no, CurrEnterprise.EnterpriseID); if (orderInfo == null) { //创建订单 orderInfo = new Model.Pay.Order(); orderInfo.Agentd = CurrEnterprise.AgentId; orderInfo.Amount = payinfo.amount; orderInfo.AppId = CurrEnterprise.AppId; orderInfo.AppReturnUrl = String.IsNullOrWhiteSpace(payinfo.return_url) ? CurrEnterprise.AppReturnUrl : payinfo.return_url; orderInfo.AppSecrit = CurrEnterprise.AppSecrit; orderInfo.AppUrl = HttpContext.Current.Request.Url.ToString(); orderInfo.CreatedTime = DateTime.Now; orderInfo.EnterOrder = payinfo.order_no; orderInfo.EnterpriseID = CurrEnterprise.EnterpriseID; orderInfo.OrderCode = DateTime.Now.ToString("yyyyMMddHHmmssfff") + CurrEnterprise.EnterpriseID; //获取支付方式 ColoPay.Model.Pay.PaymentTypes typeInfo = typeBll.GetPaymentInfo(payinfo.paytype); if (typeInfo == null) { return(FailResult(ResponseCode.ParamError, "paytype is illegal")); } //获取支付费率 ColoPay.Model.Pay.EnterprisePayFee feeInfo = feeBll.GetModel(CurrEnterprise.EnterpriseID, typeInfo.ModeId); if (feeInfo == null) { return(FailResult(ResponseCode.ParamError, "paytype is illegal")); } orderInfo.FeeRate = feeInfo.FeeRate; orderInfo.PaymentFee = payinfo.amount * (feeInfo.FeeRate / 100); orderInfo.OrderAmount = payinfo.amount - orderInfo.PaymentFee; orderInfo.PaymentGateway = typeInfo.Gateway; orderInfo.PaymentStatus = 0; orderInfo.AppNotifyUrl = CurrEnterprise.AppReturnUrl; orderInfo.PaymentTypeName = typeInfo.Name; orderInfo.PayModeId = typeInfo.ModeId; orderInfo.OrderInfo = String.IsNullOrWhiteSpace(payinfo.remark) ? "" : payinfo.remark; orderInfo.OrderId = orderBll.Add(orderInfo); if (orderInfo.OrderId == 0)//创建订单失败 { return(FailResult(ResponseCode.ServiceUnavailable, "payorder is error")); } } else //订单已经存在了 { if (orderInfo.Amount != payinfo.amount)//金额不一样,说明订单不一样 { return(FailResult(ResponseCode.OrderExists, "order_no has exist")); } if (orderInfo.PaymentStatus == 2) { return(FailResult(ResponseCode.HasPaid, "order has paid")); } } string resullt = ""; //BZ 支付金额必须要为整数,有点扯淡 //开始支付 if (!payinfo.istest) { //tuzh BZ_Pay 支付接口已失效 // resullt = ColoPay.WebApi.PayApi.BZ_Pay.PayRequest(orderInfo.OrderCode, payinfo.amount, orderInfo.PaymentGateway, payinfo.get_code, orderInfo.OrderInfo); // 如果是网银或者快捷支付,走丰核支付 YSWL.Log.LogHelper.AddInfoLog("支付网关", "PaymentGateway--->" + orderInfo.PaymentGateway); switch (orderInfo.PaymentGateway) { case "wangyin": case "kuaijie": resullt = ColoPay.WebApi.PayApi.FengHe.PayRequest(orderInfo.OrderCode, payinfo.amount, orderInfo.PaymentGateway, orderInfo.OrderInfo); break; case "onlinekj": resullt = ColoPay.WebApi.PayApi.YiYuan.PayRequest(orderInfo.OrderCode, payinfo.amount, payinfo.bankcard, payinfo.moblie, payinfo.idcard, payinfo.realname, payinfo.remark); break; case "wx": case "ali": case "aliwap": resullt = ColoPay.WebApi.PayApi.MidoPay.PayRequest(orderInfo.OrderCode, payinfo.amount, orderInfo.PaymentGateway, payinfo.bankcard, payinfo.title, payinfo.product, orderInfo.Remark); break; default: resullt = ColoPay.WebApi.PayApi.MidoPay.PayRequest(orderInfo.OrderCode, payinfo.amount, orderInfo.PaymentGateway, payinfo.bankcard, payinfo.title, payinfo.product, orderInfo.Remark); break; } } else //测试支付 { bool isSuccess = orderBll.CompleteOrder(orderInfo); if (isSuccess)//成功之后需要回调商家回调地址 { try { orderInfo.PaymentStatus = 2; ColoPay.BLL.Pay.Enterprise.Notify(orderInfo); } catch (Exception ex) { ColoPay.BLL.SysManage.LogHelp.AddErrorLog(String.Format("订单【{0}】BZPay支付回调通知失败:{1}", orderInfo.OrderCode, ex.Message), ex.StackTrace); } } } return(SuccessResult(resullt)); }
public HttpResponseMessage PayBankOrder([FromBody] PayInfo payinfo) { //YSWL.Common.DEncrypt.DEncrypt.GetMD5FromStr //验证是否数据安全性 if (payinfo.amount < 0) { return(new HttpResponseMessage { Content = new StringContent("amount is illegal", Encoding.GetEncoding("UTF-8"), "text/plain") }); } if (String.IsNullOrWhiteSpace(payinfo.order_no)) { return(new HttpResponseMessage { Content = new StringContent("ordercode is illegal", Encoding.GetEncoding("UTF-8"), "text/plain") }); } ColoPay.Model.Pay.Enterprise CurrEnterprise = bll.GetEnterpriseInfo(payinfo.appid, payinfo.secrit); if (CurrEnterprise == null) { return(new HttpResponseMessage { Content = new StringContent("appid or secrit is illegal", Encoding.GetEncoding("UTF-8"), "text/plain") }); } //判断订单是否存在 ColoPay.Model.Pay.Order orderInfo = orderBll.GetModelEx(payinfo.order_no, CurrEnterprise.EnterpriseID); if (orderInfo == null) { //创建订单 orderInfo = new Model.Pay.Order(); orderInfo.Agentd = CurrEnterprise.AgentId; orderInfo.Amount = payinfo.amount; orderInfo.AppId = CurrEnterprise.AppId; orderInfo.AppReturnUrl = String.IsNullOrWhiteSpace(payinfo.return_url) ? CurrEnterprise.AppReturnUrl : payinfo.return_url; orderInfo.AppSecrit = CurrEnterprise.AppSecrit; orderInfo.AppUrl = HttpContext.Current.Request.Url.ToString(); orderInfo.CreatedTime = DateTime.Now; orderInfo.EnterOrder = payinfo.order_no; orderInfo.EnterpriseID = CurrEnterprise.EnterpriseID; orderInfo.OrderCode = "P" + CurrEnterprise.EnterpriseID + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff"); //获取支付方式 ColoPay.Model.Pay.PaymentTypes typeInfo = typeBll.GetPaymentInfo(payinfo.paytype); if (typeInfo == null) { return(new HttpResponseMessage { Content = new StringContent("paytype is illegal", Encoding.GetEncoding("UTF-8"), "text/plain") }); } //获取支付费率 ColoPay.Model.Pay.EnterprisePayFee feeInfo = feeBll.GetModel(CurrEnterprise.EnterpriseID, typeInfo.ModeId); if (feeInfo == null) { return(new HttpResponseMessage { Content = new StringContent("paytype is illegal", Encoding.GetEncoding("UTF-8"), "text/plain") }); } orderInfo.FeeRate = feeInfo.FeeRate; orderInfo.PaymentFee = payinfo.amount * (feeInfo.FeeRate / 100); orderInfo.OrderAmount = payinfo.amount - orderInfo.PaymentFee; orderInfo.PaymentGateway = typeInfo.Gateway; orderInfo.PaymentStatus = 0; orderInfo.AppNotifyUrl = CurrEnterprise.AppReturnUrl; orderInfo.PaymentTypeName = typeInfo.Name; orderInfo.PayModeId = typeInfo.ModeId; orderInfo.OrderInfo = String.IsNullOrWhiteSpace(payinfo.remark) ? "" : payinfo.remark; orderInfo.OrderId = orderBll.Add(orderInfo); if (orderInfo.OrderId == 0)//创建订单失败 { return(new HttpResponseMessage { Content = new StringContent("payorder is error", Encoding.GetEncoding("UTF-8"), "text/plain") }); } } else //订单已经存在了 { if (orderInfo.Amount != payinfo.amount)//金额不一样,说明订单不一样 { return(new HttpResponseMessage { Content = new StringContent("order_no has exist", Encoding.GetEncoding("UTF-8"), "text/plain") }); } if (orderInfo.PaymentStatus == 2) { return(new HttpResponseMessage { Content = new StringContent("order has paid", Encoding.GetEncoding("UTF-8"), "text/plain") }); } } string resullt = ColoPay.WebApi.PayApi.DaDaBank.PayRequest(orderInfo.OrderCode, payinfo.amount, payinfo.bankcode, orderInfo.OrderInfo); YSWL.Json.JsonObject jsonObject = JsonConvert.Import <JsonObject>(resullt); if (jsonObject["bxstatus"].ToString() == "SUCCESS") { string pay_url = jsonObject["pay_url"].ToString(); HttpResponseMessage resp = new HttpResponseMessage(HttpStatusCode.Moved); resp.Headers.Location = new Uri(pay_url); return(resp); } else { return(new HttpResponseMessage { Content = new StringContent(jsonObject["bxmsg"].ToString(), Encoding.GetEncoding("UTF-8"), "text/plain") }); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ColoPay.Model.Pay.Enterprise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Pay_Enterprise set "); strSql.Append("AgentId=@AgentId,"); strSql.Append("UserName=@UserName,"); strSql.Append("Name=@Name,"); strSql.Append("SimpleName=@SimpleName,"); strSql.Append("Status=@Status,"); strSql.Append("EnterpriseNum=@EnterpriseNum,"); strSql.Append("BusinessLicense=@BusinessLicense,"); strSql.Append("TelPhone=@TelPhone,"); strSql.Append("CellPhone=@CellPhone,"); strSql.Append("AccountBank=@AccountBank,"); strSql.Append("AccountInfo=@AccountInfo,"); strSql.Append("AccountNum=@AccountNum,"); strSql.Append("WithdrawBank=@WithdrawBank,"); strSql.Append("WithdrawInfo=@WithdrawInfo,"); strSql.Append("WithdrawNum=@WithdrawNum,"); strSql.Append("Balance=@Balance,"); strSql.Append("AppId=@AppId,"); strSql.Append("AppSecrit=@AppSecrit,"); strSql.Append("AppUrl=@AppUrl,"); strSql.Append("AppReturnUrl=@AppReturnUrl,"); strSql.Append("ContactMail=@ContactMail,"); strSql.Append("Address=@Address,"); strSql.Append("EnteRank=@EnteRank,"); strSql.Append("CreatedDate=@CreatedDate,"); strSql.Append("CreatedUserID=@CreatedUserID,"); strSql.Append("RegisterIp=@RegisterIp,"); strSql.Append("Remark=@Remark"); strSql.Append(" where EnterpriseID=@EnterpriseID"); SqlParameter[] parameters = { new SqlParameter("@AgentId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@SimpleName", SqlDbType.NVarChar, 200), new SqlParameter("@Status", SqlDbType.SmallInt, 2), new SqlParameter("@EnterpriseNum", SqlDbType.NVarChar, 200), new SqlParameter("@BusinessLicense", SqlDbType.NVarChar, 200), new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50), new SqlParameter("@CellPhone", SqlDbType.NVarChar, 50), new SqlParameter("@AccountBank", SqlDbType.NVarChar, 300), new SqlParameter("@AccountInfo", SqlDbType.NVarChar, 200), new SqlParameter("@AccountNum", SqlDbType.NVarChar, 200), new SqlParameter("@WithdrawBank", SqlDbType.NVarChar, 300), new SqlParameter("@WithdrawInfo", SqlDbType.NVarChar, 200), new SqlParameter("@WithdrawNum", SqlDbType.NVarChar, 200), new SqlParameter("@Balance", SqlDbType.Money, 8), new SqlParameter("@AppId", SqlDbType.NVarChar, 200), new SqlParameter("@AppSecrit", SqlDbType.NVarChar, 200), new SqlParameter("@AppUrl", SqlDbType.NVarChar, 200), new SqlParameter("@AppReturnUrl", SqlDbType.NVarChar, 200), new SqlParameter("@ContactMail", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@EnteRank", SqlDbType.Int, 4), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@RegisterIp", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 1000), new SqlParameter("@EnterpriseID", SqlDbType.Int, 4) }; parameters[0].Value = model.AgentId; parameters[1].Value = model.UserName; parameters[2].Value = model.Name; parameters[3].Value = model.SimpleName; parameters[4].Value = model.Status; parameters[5].Value = model.EnterpriseNum; parameters[6].Value = model.BusinessLicense; parameters[7].Value = model.TelPhone; parameters[8].Value = model.CellPhone; parameters[9].Value = model.AccountBank; parameters[10].Value = model.AccountInfo; parameters[11].Value = model.AccountNum; parameters[12].Value = model.WithdrawBank; parameters[13].Value = model.WithdrawInfo; parameters[14].Value = model.WithdrawNum; parameters[15].Value = model.Balance; parameters[16].Value = model.AppId; parameters[17].Value = model.AppSecrit; parameters[18].Value = model.AppUrl; parameters[19].Value = model.AppReturnUrl; parameters[20].Value = model.ContactMail; parameters[21].Value = model.Address; parameters[22].Value = model.EnteRank; parameters[23].Value = model.CreatedDate; parameters[24].Value = model.CreatedUserID; parameters[25].Value = model.RegisterIp; parameters[26].Value = model.Remark; parameters[27].Value = model.EnterpriseID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ColoPay.Model.Pay.Enterprise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Pay_Enterprise("); strSql.Append("AgentId,UserName,Name,SimpleName,Status,EnterpriseNum,BusinessLicense,TelPhone,CellPhone,AccountBank,AccountInfo,AccountNum,WithdrawBank,WithdrawInfo,WithdrawNum,Balance,AppId,AppSecrit,AppUrl,AppReturnUrl,ContactMail,Address,EnteRank,CreatedDate,CreatedUserID,RegisterIp,Remark)"); strSql.Append(" values ("); strSql.Append("@AgentId,@UserName,@Name,@SimpleName,@Status,@EnterpriseNum,@BusinessLicense,@TelPhone,@CellPhone,@AccountBank,@AccountInfo,@AccountNum,@WithdrawBank,@WithdrawInfo,@WithdrawNum,@Balance,@AppId,@AppSecrit,@AppUrl,@AppReturnUrl,@ContactMail,@Address,@EnteRank,@CreatedDate,@CreatedUserID,@RegisterIp,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AgentId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@SimpleName", SqlDbType.NVarChar, 200), new SqlParameter("@Status", SqlDbType.SmallInt, 2), new SqlParameter("@EnterpriseNum", SqlDbType.NVarChar, 200), new SqlParameter("@BusinessLicense", SqlDbType.NVarChar, 200), new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50), new SqlParameter("@CellPhone", SqlDbType.NVarChar, 50), new SqlParameter("@AccountBank", SqlDbType.NVarChar, 300), new SqlParameter("@AccountInfo", SqlDbType.NVarChar, 200), new SqlParameter("@AccountNum", SqlDbType.NVarChar, 200), new SqlParameter("@WithdrawBank", SqlDbType.NVarChar, 300), new SqlParameter("@WithdrawInfo", SqlDbType.NVarChar, 200), new SqlParameter("@WithdrawNum", SqlDbType.NVarChar, 200), new SqlParameter("@Balance", SqlDbType.Money, 8), new SqlParameter("@AppId", SqlDbType.NVarChar, 200), new SqlParameter("@AppSecrit", SqlDbType.NVarChar, 200), new SqlParameter("@AppUrl", SqlDbType.NVarChar, 200), new SqlParameter("@AppReturnUrl", SqlDbType.NVarChar, 200), new SqlParameter("@ContactMail", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@EnteRank", SqlDbType.Int, 4), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@RegisterIp", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 1000) }; parameters[0].Value = model.AgentId; parameters[1].Value = model.UserName; parameters[2].Value = model.Name; parameters[3].Value = model.SimpleName; parameters[4].Value = model.Status; parameters[5].Value = model.EnterpriseNum; parameters[6].Value = model.BusinessLicense; parameters[7].Value = model.TelPhone; parameters[8].Value = model.CellPhone; parameters[9].Value = model.AccountBank; parameters[10].Value = model.AccountInfo; parameters[11].Value = model.AccountNum; parameters[12].Value = model.WithdrawBank; parameters[13].Value = model.WithdrawInfo; parameters[14].Value = model.WithdrawNum; parameters[15].Value = model.Balance; parameters[16].Value = model.AppId; parameters[17].Value = model.AppSecrit; parameters[18].Value = model.AppUrl; parameters[19].Value = model.AppReturnUrl; parameters[20].Value = model.ContactMail; parameters[21].Value = model.Address; parameters[22].Value = model.EnteRank; parameters[23].Value = model.CreatedDate; parameters[24].Value = model.CreatedUserID; parameters[25].Value = model.RegisterIp; parameters[26].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ColoPay.Model.Pay.Enterprise DataRowToModel(DataRow row) { ColoPay.Model.Pay.Enterprise model = new ColoPay.Model.Pay.Enterprise(); if (row != null) { if (row["EnterpriseID"] != null && row["EnterpriseID"].ToString() != "") { model.EnterpriseID = int.Parse(row["EnterpriseID"].ToString()); } if (row["AgentId"] != null && row["AgentId"].ToString() != "") { model.AgentId = int.Parse(row["AgentId"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["SimpleName"] != null) { model.SimpleName = row["SimpleName"].ToString(); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["EnterpriseNum"] != null) { model.EnterpriseNum = row["EnterpriseNum"].ToString(); } if (row["BusinessLicense"] != null) { model.BusinessLicense = row["BusinessLicense"].ToString(); } if (row["TelPhone"] != null) { model.TelPhone = row["TelPhone"].ToString(); } if (row["CellPhone"] != null) { model.CellPhone = row["CellPhone"].ToString(); } if (row["AccountBank"] != null) { model.AccountBank = row["AccountBank"].ToString(); } if (row["AccountInfo"] != null) { model.AccountInfo = row["AccountInfo"].ToString(); } if (row["AccountNum"] != null) { model.AccountNum = row["AccountNum"].ToString(); } if (row["WithdrawBank"] != null) { model.WithdrawBank = row["WithdrawBank"].ToString(); } if (row["WithdrawInfo"] != null) { model.WithdrawInfo = row["WithdrawInfo"].ToString(); } if (row["WithdrawNum"] != null) { model.WithdrawNum = row["WithdrawNum"].ToString(); } if (row["Balance"] != null && row["Balance"].ToString() != "") { model.Balance = decimal.Parse(row["Balance"].ToString()); } if (row["AppId"] != null) { model.AppId = row["AppId"].ToString(); } if (row["AppSecrit"] != null) { model.AppSecrit = row["AppSecrit"].ToString(); } if (row["AppUrl"] != null) { model.AppUrl = row["AppUrl"].ToString(); } if (row["AppReturnUrl"] != null) { model.AppReturnUrl = row["AppReturnUrl"].ToString(); } if (row["ContactMail"] != null) { model.ContactMail = row["ContactMail"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["EnteRank"] != null && row["EnteRank"].ToString() != "") { model.EnteRank = int.Parse(row["EnteRank"].ToString()); } if (row["CreatedDate"] != null && row["CreatedDate"].ToString() != "") { model.CreatedDate = DateTime.Parse(row["CreatedDate"].ToString()); } if (row["CreatedUserID"] != null && row["CreatedUserID"].ToString() != "") { model.CreatedUserID = int.Parse(row["CreatedUserID"].ToString()); } if (row["RegisterIp"] != null) { model.RegisterIp = row["RegisterIp"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }