/// <summary> /// 增加一条数据 /// </summary> public int Add(SystemRequestRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SystemRequestRecord("); strSql.Append("UserId,BussnessId,RequestMoney,RequestType,RequestDate,RequestOperStatus,RequestMark"); strSql.Append(") values ("); strSql.Append("@UserId,@BussnessId,@RequestMoney,@RequestType,@RequestDate,@RequestOperStatus,@RequestMark"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@BussnessId", SqlDbType.Int, 4), new SqlParameter("@RequestMoney", SqlDbType.Decimal, 9), new SqlParameter("@RequestType", SqlDbType.Int, 4), new SqlParameter("@RequestDate", SqlDbType.VarChar, 20), new SqlParameter("@RequestOperStatus", SqlDbType.Int, 4), new SqlParameter("@RequestMark", SqlDbType.VarChar, -1) }; parameters[0].Value = model.UserId; parameters[1].Value = model.BussnessId; parameters[2].Value = model.RequestMoney; parameters[3].Value = model.RequestType; parameters[4].Value = model.RequestDate; parameters[5].Value = model.RequestOperStatus; parameters[6].Value = model.RequestMark; return(db.ExecNon(strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public SystemRequestRecord GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, UserId, BussnessId, RequestMoney, RequestType, RequestDate, RequestOperStatus,RequestMark "); strSql.Append(" from SystemRequestRecord "); strSql.Append(" where "); strSql.Append(where); var dt = db.GetTable(strSql.ToString()); SystemRequestRecord model = null; if (dt.Rows.Count > 0) { model = Mapper.DynamicMap <IDataReader, List <SystemRequestRecord> >(dt.CreateDataReader()).FirstOrDefault(); } return(model); }
public JsonResult HandUpdate(SystemRequestRecord model) { JsonResult result = null; try { RQHandExecDto handExecDto = new RQHandExecDto(); handExecDto.RequestRecord = model; handExecDto.IP = this.RequestIP; handExecDto.OperatorUserId = this.UserInfo.ID; handExecDto.OperatorUserName = this.UserInfo.RealName; handExecDto.OperatorContent = "手动同步数据:"; BaseResultDto <string> resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}SysSetting/HandExec", this.WebApiUrl), handExecDto); result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
public BaseResultDto <string> HandExec(RQHandExecDto Exec) { SystemRequestRecord model = Exec.RequestRecord; BaseResultDto <string> result = new BaseResultDto <string>(); YeePay yeepay = new YeePay(); YeePayOper yeePayOper = new YeePayOper(); string strResult = "未处理"; try { if (helper.IsExists <SystemRequestRecord>(string.Format(" Id={0} and RequestOperStatus=1", model.Id))) { switch (model.RequestType) { case 1: //注册 { } break; case 2: //充值 { MoneyCarCar.Models.YeePay.RequestModel.Query query = new MoneyCarCar.Models.YeePay.RequestModel.Query(); query.mode = EnumMode.RECHARGE_RECORD.ToEnumDesc(); // 转款记录 query.platformUserNo = model.UserId.ToString(); query.requestNo = model.Id.ToString(); BaseResultDto <MoneyCarCar.Models.YeePay.Response.QUERY.response> baseResultDtoResponse = new BaseResultDto <MoneyCarCar.Models.YeePay.Response.QUERY.response>(); baseResultDtoResponse = yeepay.QUERY <MoneyCarCar.Models.YeePay.Response.QUERY.response>(query); string str = baseResultDtoResponse.ErrorMsg; //XML 数据 // 反序列化 MoneyCarCar.Models.YeePay.Response.QUERY.RECHARGE_RECORD.response _response = baseResultDtoResponse.ErrorMsg.XmlDeserialize <MoneyCarCar.Models.YeePay.Response.QUERY.RECHARGE_RECORD.response>(); if (_response.status == EnumNotifyStatus.SUCCESS.ToEnumDesc()) { bool b_reuslt = yeePayOper.ToRecharge(model.UserId.ToString(), model.Id.ToString()); if (b_reuslt) { strResult = "充值成功"; } else { strResult = "未充值成功"; } } else { // 未充值成功 strResult = "未充值成功"; } } break; case 3: // 投资 { } break; case 4: //提现 { } break; case 5: //查询 { } break; case 6: //绑卡 { } break; case 7: //解绑 { } break; case 8: //结息 { MoneyCarCar.Models.YeePay.RequestModel.Query query = new MoneyCarCar.Models.YeePay.RequestModel.Query(); query.mode = EnumMode.CP_TRANSACTION.ToEnumDesc(); // 转款记录 query.platformUserNo = model.UserId.ToString(); query.requestNo = model.Id.ToString(); BaseResultDto <MoneyCarCar.Models.YeePay.Response.QUERY.response> baseResultDtoResponse = new BaseResultDto <MoneyCarCar.Models.YeePay.Response.QUERY.response>(); baseResultDtoResponse = yeepay.QUERY <MoneyCarCar.Models.YeePay.Response.QUERY.response>(query); string str = baseResultDtoResponse.ErrorMsg; //XML 数据 // 反序列化 MoneyCarCar.Models.YeePay.Response.QUERY.CP_TRANSACTION.response _response = baseResultDtoResponse.ErrorMsg.XmlDeserialize <MoneyCarCar.Models.YeePay.Response.QUERY.CP_TRANSACTION.response>(); if (_response.status == EnumNotifyStatus.DIRECT.ToEnumDesc()) { bool b_reuslt = yeePayOper.Direct_Transaction(model.Id.ToString()); if (b_reuslt) { strResult = "结息成功"; } else { strResult = "结息未成功"; } } else { //结息未成功 strResult = "结息未成功"; } } break; default: break; } result.IsSeccess = true; result.ErrorCode = 1; result.ErrorMsg = strResult; } else { result.IsSeccess = true; result.ErrorCode = 1; result.ErrorMsg = "状态已处理"; } SystemLog log = new SystemLog(); log.OperatorUserId = Exec.OperatorUserId; log.OperatorUserName = Exec.OperatorUserName; log.OperatorType = 4; log.BusinessType = "手动同步数据"; log.OperatorTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); log.OperatorContent = Exec.OperatorContent + " " + strResult; log.OperatorIP = Exec.IP; //添加日志 helper.Add <SystemLog>(log); } catch (Exception ex) { result.ErrorMsg = ex.Message; result.ErrorCode = -1; } return(result); }