public bool Update(SystemClaims model, List <string> fileds, string sqlWhere) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("update {0} set ", model.GetType().Name); List <string> filedsList = new List <string>(); List <SqlParameter> sqlParameter = new List <SqlParameter>(); SqlParameter Param = new SqlParameter("@ID", SqlDbType.Int, 4); if (string.IsNullOrEmpty(sqlWhere)) { Param.Value = model.ID; sqlParameter.Add(Param); } foreach (string filed in fileds) { filedsList.Add(string.Format("{0}=@{0}", filed)); Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null)); sqlParameter.Add(Param); } strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray())); if (string.IsNullOrEmpty(sqlWhere)) { strSql.Append(" where ID=@ID "); } else { strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere); } SqlParameter[] parameters = sqlParameter.ToArray(); return(db.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }
public ActionResult ShowAddUpdate(int ID) { SystemClaims systemClaims = new SystemClaims(); if (ID > 0) { systemClaims = HttpHelper.CreatHelper().DoGetObject <SystemClaims>(string.Format("{0}Claims/GetClaims?Id={1}", this.WebApiUrl, ID)); } return(View(systemClaims)); }
public BaseResultDto <PostBaseYeePayPar> AddSystemClaimsDetails(RQSubmitOrder model) { BaseResultDto <PostBaseYeePayPar> result = new BaseResultDto <PostBaseYeePayPar>(); SystemClaims claims = claimsOper.GetModel("ID = " + model.InvestorsID); SystemUsers user = userOper.GetUserInfo(model.UserID); int days = (int)(claims.EarningsStartTime.ToDateTime().AddMonths(claims.LoanPeriod) - claims.EarningsStartTime.ToDateTime()).TotalDays; string errorMsg = ""; int targetUserID = 0; decimal dayEarnings = (claims.SingleAmount * model.BuyCount * claims.APR / 100 / 365).ToMoney(2).ToDecimal(); decimal virtualMoney = userOper.GetUserVirtualMoney(model.UserID).Tag; decimal virtualMoneyDayEarnings = (virtualMoney * claims.APR / 100 / 365).ToMoney(2).ToDecimal(); int detailID = detail.SystemClaimsDetails_Add(user.ID, claims.ID, model.BuyCount, dayEarnings, dayEarnings * days, model.IsUserBounty, virtualMoney, virtualMoneyDayEarnings, out errorMsg, out targetUserID); result.IsSeccess = detailID > 0; if (!result.IsSeccess) { result.ErrorMsg = errorMsg; } else { MoneyCarCar.Models.YeePay.RequestModel.ToCpTransaction_TENDER toCpTransaction = new MoneyCarCar.Models.YeePay.RequestModel.ToCpTransaction_TENDER(); toCpTransaction.platformUserNo = user.ID + ""; toCpTransaction.requestNo = detailID + "";; //(2)投标[TENDER] toCpTransaction.tenderOrderNo = claims.ID + ""; toCpTransaction.tenderName = claims.Title; toCpTransaction.tenderAmount = claims.LoanAmount.ToMoney(2); toCpTransaction.tenderDescription = claims.Title; toCpTransaction.borrowerPlatformUserNo = claims.BorrowerID + ""; List <ToCpTransactionDetail> details = new List <ToCpTransactionDetail>(); ToCpTransactionDetail paydetail = new ToCpTransactionDetail(); paydetail.amount = (claims.SingleAmount * model.BuyCount).ToMoney(2); paydetail.targetPlatformUserNo = claims.BorrowerID + ""; //paydetail.targetUserType = EnumUserType.MERCHANT.ToEnumDesc(); // 用户类型 paydetail.bizType = EnumBizType.TENDER.ToString();//转账 details.Add(paydetail); toCpTransaction.details = details; return(yeePay.ToCpTransaction_TENDER(toCpTransaction)); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public SystemClaims GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, RepaymentWat, SellingPrice, InvestmentEndTime, EarningsStartTime, Borrower, PawnSpec, Publisher, PublishTime, IsApproved, ApproverUserName, Title, ApproverTime, BorrowerID, Icons,ClaimsApplayID, DetailsImages1, DetailsImages2, DetailsImages3, DetailsImages4, DetailsImages5, TitleImagePath, LoanAmount, APR, LoanPeriod, SingleAmount, AlreadyAmount, GuaranteeWay "); strSql.Append(" from SystemClaims "); strSql.Append(" where "); strSql.Append(where); DataTable dt = db.GetTable(strSql.ToString()); SystemClaims model = null; if (dt.Rows.Count > 0) { model = Mapper.DynamicMap <IDataReader, List <SystemClaims> >(dt.CreateDataReader()).FirstOrDefault(); } return(model); }
public JsonResult DelImage(int Id, string imgUrl) { JsonResult result = null; try { if (Id > 0) { RQUpdate <SystemClaims> model = new RQUpdate <SystemClaims>(); SystemClaims systemClaims = new SystemClaims(); systemClaims.ID = Id; systemClaims.TitleImagePath = ""; model.Tag = systemClaims; //更新审核字段数据 model.UpdateFileds.AddRange(new string[] { "TitleImagePath" }); bool rs = HttpHelper.CreatHelper().DoPostObject <bool>(string.Format("{0}Claims/UpdatePartal", this.WebApiUrl), model); } try { DataFornat dataformat = new DataFornat(); string strPath = dataformat.GetResovePath(imgUrl); if (System.IO.File.Exists(strPath)) { System.IO.File.Delete(strPath); } string strThumbnailFileName = System.IO.Path.GetFullPath(strPath) + "\\64_" + System.IO.Path.GetFileName(strPath); if (System.IO.File.Exists(strThumbnailFileName)) { System.IO.File.Delete(strThumbnailFileName); } } catch (Exception) { } result = Json(new { status = 1, message = "删除成功" }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
//订单确认页面 public ActionResult TransactionAct(RQSubmitOrder id) { ViewBag.OnIndex = 2; SystemClaims model = http.DoGetObject <SystemClaims>(ApplicationPropertys.WEBAPI_URL + "/Claims/GetClaims/" + id.InvestorsID); if (null == model) { return(RedirectToAction("Investment", "Home")); } ViewBag.SystemClaims = model; ViewBag.BuyCount = id.BuyCount; ViewBag.IsUserBounty = id.IsUserBounty; ViewBag.BountyCount = id.BountyCount; ViewBag.Already = model.AlreadyAmount * 100 / model.LoanAmount; //完成百分比 ViewBag.IsFull = model.AlreadyAmount >= model.LoanAmount; //是否满标 ViewBag.CanBuy = (int)((model.LoanAmount - model.AlreadyAmount) / model.SingleAmount); //剩余份数 ViewBag.AllCanBuy = (int)(model.LoanAmount / model.SingleAmount); //所有份数 ViewBag.HaveMoney = 0; ViewBag.HaveVirtualMoney = 0.00; //借款时间-天 ViewBag.Days = (model.EarningsStartTime.ToDateTime().AddMonths(model.LoanPeriod) - model.EarningsStartTime.ToDateTime()).TotalDays; ViewBag.IsLogin = false;//是否登录 if (null != Session["UserInfo"]) { SystemUsers userInfo = (SystemUsers)Session["UserInfo"]; ViewBag.IsLogin = true; BaseResultDto <decimal> result = http.DoGetObject <BaseResultDto <decimal> >(ApplicationPropertys.WEBAPI_URL + "/User/GetUserMoney/" + userInfo.ID); if (null != result) { userInfo.Balance = result.Tag; } ViewBag.HaveMoney = userInfo.Balance; result = http.DoGetObject <BaseResultDto <decimal> >(ApplicationPropertys.WEBAPI_URL + "/User/GetUserVirtualMoney/" + userInfo.ID); if (null != result) { ViewBag.HaveVirtualMoney = result.Tag; } } return(View()); }
public ApplayClaimsDto GetApplayClaims(int ApplyId) { SystemBorrowerApply systemBorrowerApply = helper.GetModelById <SystemBorrowerApply>(ApplyId); //借款人账号和申请的债权 唯一对应一条债权 string sqlwhere = string.Format(" BorrowerID={0} and ClaimsApplayID={1}", systemBorrowerApply.BorrowerID, systemBorrowerApply.Id); SystemClaims systemClaims = helper.GetList <SystemClaims>(sqlwhere).FirstOrDefault(); if (systemClaims == null) { systemClaims = new SystemClaims(); systemClaims.EarningsStartTime = System.DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd"); systemClaims.InvestmentEndTime = System.DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd"); } systemClaims.BorrowerID = systemBorrowerApply.BorrowerID; systemClaims.ClaimsApplayID = systemBorrowerApply.Id; systemClaims.Borrower = systemBorrowerApply.BorrowerName; systemClaims.LoanAmount = systemBorrowerApply.LoanAmount; //从字典表获取所有设置的小图标 sqlwhere = string.Format(" DicKey ='{0}' ", EnumDictionary.SmallIcon); List <SystemDictionary> dics = helper.GetList <SystemDictionary>(sqlwhere); List <IconProperty> ShowIcons = new List <IconProperty>(); List <IconProperty> ShowIconsAttrCode = new List <IconProperty>(); List <IconModel> icoList = new List <IconModel>(); if (systemClaims.Icons != "") { icoList = systemClaims.Icons.ToModel <List <IconModel> >(); } bool IsOpen = false; dics.ForEach(p => { //类型^标题^弹出提示^背景样式字符串^日息 string[] strArr = p.DicValue.Split('^'); if (strArr.Length >= 4) { string AtrrCode = strArr.Length >= 5 ? strArr[4] : ""; if (AtrrCode != "") { IsOpen = icoList.Exists(p1 => p1.IconType.Trim() == strArr[0].Trim() && p1.AtrrCode == AtrrCode); ShowIconsAttrCode.Add(new IconProperty() { IsOpen = IsOpen, AddShow = p.DicType, //显示 IconType = strArr[0], //类型 Title = strArr[1], //标题 TipMessage = strArr[2], //弹出提示 BackgroundClass = strArr[3], //背景样式字符串 AtrrCode = AtrrCode //还款方式 }); } else { IsOpen = icoList.Exists(p1 => p1.IconType.Trim() == strArr[0].Trim()); ShowIcons.Add(new IconProperty() { IsOpen = IsOpen, AddShow = p.DicType, //显示 IconType = strArr[0], //类型 Title = strArr[1], //标题 TipMessage = strArr[2], //弹出提示 BackgroundClass = strArr[3], //背景样式字符串 AtrrCode = AtrrCode //还款方式 }); } } }); var model = new ApplayClaimsDto() { Applay = systemBorrowerApply, Claims = systemClaims, ShowIcons = ShowIcons, ShowAttrCode = ShowIconsAttrCode }; return(model); }
public JsonResult AddUpdateClaims(SystemClaims systemClaims, int clickType) { JsonResult result = null; try { Type type = systemClaims.GetType(); PropertyInfo[] properties = type.GetProperties(BindingFlags.Public | BindingFlags.IgnoreCase | BindingFlags.Instance | BindingFlags.GetProperty); foreach (var item in properties) { if (item.PropertyType == typeof(string) && item.GetValue(systemClaims, null) == null) { item.SetValue(systemClaims, "", null); } } //操作数据之前 对的补齐和正确性的验证 //审核通过之类的该状态的调用存储过程 暂时未处理 //...... if (clickType == 1)//审核未通过 { systemClaims.IsApproved = false; systemClaims.ApproverUserName = this.UserInfo.RealName; systemClaims.ApproverTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else if (clickType == 2)//审核通过 { systemClaims.IsApproved = true; systemClaims.ApproverUserName = this.UserInfo.RealName; systemClaims.ApproverTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } systemClaims.DetailsImages1 = HttpUtility.UrlDecode(systemClaims.DetailsImages1); systemClaims.DetailsImages2 = HttpUtility.UrlDecode(systemClaims.DetailsImages2); systemClaims.DetailsImages3 = HttpUtility.UrlDecode(systemClaims.DetailsImages3); systemClaims.DetailsImages4 = HttpUtility.UrlDecode(systemClaims.DetailsImages4); systemClaims.DetailsImages5 = HttpUtility.UrlDecode(systemClaims.DetailsImages5); DataFornat dataformat = new DataFornat(); systemClaims.TitleImagePath = dataformat.ReplaceDomain(systemClaims.TitleImagePath, AppConfigHelper.MainSiteUrl); systemClaims.DetailsImages1 = dataformat.ReplaceImageSrc(systemClaims.DetailsImages1, AppConfigHelper.MainSiteUrl); systemClaims.DetailsImages2 = dataformat.ReplaceImageSrc(systemClaims.DetailsImages2, AppConfigHelper.MainSiteUrl); systemClaims.DetailsImages3 = dataformat.ReplaceImageSrc(systemClaims.DetailsImages3, AppConfigHelper.MainSiteUrl); systemClaims.DetailsImages4 = dataformat.ReplaceImageSrc(systemClaims.DetailsImages4, AppConfigHelper.MainSiteUrl); systemClaims.DetailsImages5 = dataformat.ReplaceImageSrc(systemClaims.DetailsImages5, AppConfigHelper.MainSiteUrl); string strIcons = HttpUtility.UrlDecode(systemClaims.Icons); List <IconModel> IconModelList = new List <IconModel>(); string[] strArr = strIcons.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in strArr) { IconModel model = new IconModel(); string[] strItem = item.Split('^'); if (strItem.Length >= 3) { model.IconType = strItem[0]; model.Title = strItem[1]; model.Description = strItem[2]; model.StyleName = strItem[3]; } if (strItem.Length >= 4) { model.AtrrCode = strItem[4]; } IconModelList.Add(model); } systemClaims.Icons = IconModelList.ToJsonString <List <IconModel> >(); //添加或者修改 BaseResultDto <string> resultDto = new BaseResultDto <string>(); string message = string.Empty; if (systemClaims.ID > 0) { #region 修改 RQUpdate <SystemClaims> model = new RQUpdate <SystemClaims>(); model.Tag = systemClaims; bool rs = false; if (clickType == 0 || clickType == 2)//修改资料 { //更新修改的字段数据 model.UpdateFileds.AddRange(new string[] { "Title", "TitleImagePath", "LoanAmount", "APR", "LoanPeriod", "SingleAmount", "GuaranteeWay", "RepaymentWat", "InvestmentEndTime", "EarningsStartTime", "PawnSpec", "Icons", "DetailsImages1", "DetailsImages2", "DetailsImages3", "DetailsImages4", "DetailsImages5" }); rs = HttpHelper.CreatHelper().DoPostObject <bool>(string.Format("{0}Claims/UpdatePartal", this.WebApiUrl), model); } if (clickType == 2 && rs) { //更新审核字段数据 RQAduitApplay aduitApplay = new RQAduitApplay(); aduitApplay.ApplyID = systemClaims.ClaimsApplayID; aduitApplay.ClaimsID = systemClaims.ID; aduitApplay.ApproverUserName = systemClaims.ApproverUserName; aduitApplay.OperatorUserId = this.UserInfo.ID; aduitApplay.Succeed = systemClaims.IsApproved; aduitApplay.IP = this.RequestIP; aduitApplay.OperatorContent = (clickType == 1 ? "审核未通过" : "审核通过"); rs = HttpHelper.CreatHelper().DoPostObject <bool>(string.Format("{0}ClaimsApplay/AduitApplayClaims", this.WebApiUrl), aduitApplay); } //修改 if (rs) { resultDto.ErrorCode = 1; resultDto.ErrorMsg = "成功"; } else { resultDto.ErrorMsg = "失败"; } #endregion } else { systemClaims.PublishTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); systemClaims.Publisher = this.UserInfo.RealName; int rs = HttpHelper.CreatHelper().DoPostObject <int>(string.Format("{0}Claims/Add", this.WebApiUrl), systemClaims); //添加 if (rs > 0) { resultDto.ErrorCode = 1; resultDto.ErrorMsg = "成功"; } else { resultDto.ErrorMsg = "失败"; } } 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 bool Update(SystemClaims model) { return(helper.Update <SystemClaims>(model)); }
public int Add(SystemClaims model) { return(helper.Add <SystemClaims>(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SystemClaims model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SystemClaims("); strSql.Append("RepaymentWat,SellingPrice,InvestmentEndTime,EarningsStartTime,Borrower,PawnSpec,Publisher,PublishTime,IsApproved,ApproverUserName,Title,ApproverTime,BorrowerID,Icons,ClaimsApplayID,DetailsImages1,DetailsImages2,DetailsImages3,DetailsImages4,DetailsImages5,TitleImagePath,LoanAmount,APR,LoanPeriod,SingleAmount,AlreadyAmount,GuaranteeWay"); strSql.Append(") values ("); strSql.Append("@RepaymentWat,@SellingPrice,@InvestmentEndTime,@EarningsStartTime,@Borrower,@PawnSpec,@Publisher,@PublishTime,@IsApproved,@ApproverUserName,@Title,@ApproverTime,@BorrowerID,@Icons,@ClaimsApplayID,@DetailsImages1,@DetailsImages2,@DetailsImages3,@DetailsImages4,@DetailsImages5,@TitleImagePath,@LoanAmount,@APR,@LoanPeriod,@SingleAmount,@AlreadyAmount,@GuaranteeWay"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RepaymentWat", SqlDbType.VarChar, 200), new SqlParameter("@SellingPrice", SqlDbType.Decimal, 9), new SqlParameter("@InvestmentEndTime", SqlDbType.VarChar, 20), new SqlParameter("@EarningsStartTime", SqlDbType.VarChar, 20), new SqlParameter("@Borrower", SqlDbType.VarChar, 100), new SqlParameter("@PawnSpec", SqlDbType.VarChar, 100), new SqlParameter("@Publisher", SqlDbType.VarChar, 20), new SqlParameter("@PublishTime", SqlDbType.VarChar, 20), new SqlParameter("@IsApproved", SqlDbType.Bit, 1), new SqlParameter("@ApproverUserName", SqlDbType.VarChar, 20), new SqlParameter("@Title", SqlDbType.VarChar, 200), new SqlParameter("@ApproverTime", SqlDbType.VarChar, 20), new SqlParameter("@BorrowerID", SqlDbType.Int, 4), new SqlParameter("@Icons", SqlDbType.VarChar, 8000), new SqlParameter("@ClaimsApplayID", SqlDbType.Int, 4), new SqlParameter("@DetailsImages1", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages2", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages3", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages4", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages5", SqlDbType.VarChar, 4000), new SqlParameter("@TitleImagePath", SqlDbType.VarChar, 200), new SqlParameter("@LoanAmount", SqlDbType.Decimal, 9), new SqlParameter("@APR", SqlDbType.Decimal, 9), new SqlParameter("@LoanPeriod", SqlDbType.TinyInt, 1), new SqlParameter("@SingleAmount", SqlDbType.Decimal, 9), new SqlParameter("@AlreadyAmount", SqlDbType.Decimal, 9), new SqlParameter("@GuaranteeWay", SqlDbType.VarChar, 200) }; parameters[0].Value = model.RepaymentWat; parameters[1].Value = model.SellingPrice; parameters[2].Value = model.InvestmentEndTime; parameters[3].Value = model.EarningsStartTime; parameters[4].Value = model.Borrower; parameters[5].Value = model.PawnSpec; parameters[6].Value = model.Publisher; parameters[7].Value = model.PublishTime; parameters[8].Value = model.IsApproved; parameters[9].Value = model.ApproverUserName; parameters[10].Value = model.Title; parameters[11].Value = model.ApproverTime; parameters[12].Value = model.BorrowerID; parameters[13].Value = model.Icons; parameters[14].Value = model.ClaimsApplayID; parameters[15].Value = model.DetailsImages1; parameters[16].Value = model.DetailsImages2; parameters[17].Value = model.DetailsImages3; parameters[18].Value = model.DetailsImages4; parameters[19].Value = model.DetailsImages5; parameters[20].Value = model.TitleImagePath; parameters[21].Value = model.LoanAmount; parameters[22].Value = model.APR; parameters[23].Value = model.LoanPeriod; parameters[24].Value = model.SingleAmount; parameters[25].Value = model.AlreadyAmount; parameters[26].Value = model.GuaranteeWay; return(db.ExecNon(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据(有删减,注意看清楚字段) /// </summary> public bool Update(SystemClaims model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SystemClaims set "); strSql.Append(" RepaymentWat = @RepaymentWat , "); strSql.Append(" SellingPrice = @SellingPrice , "); strSql.Append(" InvestmentEndTime = @InvestmentEndTime , "); strSql.Append(" EarningsStartTime = @EarningsStartTime , "); strSql.Append(" Borrower = @Borrower , "); strSql.Append(" PawnSpec = @PawnSpec , "); strSql.Append(" Publisher = @Publisher , "); strSql.Append(" PublishTime = @PublishTime , "); strSql.Append(" IsApproved = @IsApproved , "); strSql.Append(" ApproverUserName = @ApproverUserName , "); strSql.Append(" Title = @Title , "); strSql.Append(" ApproverTime = @ApproverTime , "); strSql.Append(" BorrowerID = @BorrowerID , "); strSql.Append(" ClaimsApplayID = @ClaimsApplayID , "); strSql.Append(" Icons = @Icons , "); strSql.Append(" DetailsImages1 = @DetailsImages1 , "); strSql.Append(" DetailsImages2 = @DetailsImages2 , "); strSql.Append(" DetailsImages3 = @DetailsImages3 , "); strSql.Append(" DetailsImages4 = @DetailsImages4 , "); strSql.Append(" DetailsImages5 = @DetailsImages5 , "); strSql.Append(" TitleImagePath = @TitleImagePath , "); strSql.Append(" LoanAmount = @LoanAmount , "); strSql.Append(" APR = @APR , "); strSql.Append(" LoanPeriod = @LoanPeriod , "); strSql.Append(" SingleAmount = @SingleAmount , "); strSql.Append(" AlreadyAmount = @AlreadyAmount , "); strSql.Append(" GuaranteeWay = @GuaranteeWay "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@RepaymentWat", SqlDbType.VarChar, 200), new SqlParameter("@SellingPrice", SqlDbType.Decimal, 9), new SqlParameter("@InvestmentEndTime", SqlDbType.VarChar, 20), new SqlParameter("@EarningsStartTime", SqlDbType.VarChar, 20), new SqlParameter("@Borrower", SqlDbType.VarChar, 100), new SqlParameter("@PawnSpec", SqlDbType.VarChar, 100), new SqlParameter("@Publisher", SqlDbType.VarChar, 20), new SqlParameter("@PublishTime", SqlDbType.VarChar, 20), new SqlParameter("@IsApproved", SqlDbType.Bit, 1), new SqlParameter("@ApproverUserName", SqlDbType.VarChar, 20), new SqlParameter("@Title", SqlDbType.VarChar, 200), new SqlParameter("@ApproverTime", SqlDbType.VarChar, 20), new SqlParameter("@BorrowerID", SqlDbType.Int, 4), new SqlParameter("@ClaimsApplayID", SqlDbType.Int, 4), new SqlParameter("@Icons", SqlDbType.VarChar, 8000), new SqlParameter("@DetailsImages1", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages2", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages3", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages4", SqlDbType.VarChar, 4000), new SqlParameter("@DetailsImages5", SqlDbType.VarChar, 4000), new SqlParameter("@TitleImagePath", SqlDbType.VarChar, 200), new SqlParameter("@LoanAmount", SqlDbType.Decimal, 9), new SqlParameter("@APR", SqlDbType.Decimal, 9), new SqlParameter("@LoanPeriod", SqlDbType.TinyInt, 1), new SqlParameter("@SingleAmount", SqlDbType.Decimal, 9), new SqlParameter("@AlreadyAmount", SqlDbType.Decimal, 9), new SqlParameter("@GuaranteeWay", SqlDbType.VarChar, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.RepaymentWat; parameters[2].Value = model.SellingPrice; parameters[3].Value = model.InvestmentEndTime; parameters[4].Value = model.EarningsStartTime; parameters[5].Value = model.Borrower; parameters[6].Value = model.PawnSpec; parameters[7].Value = model.Publisher; parameters[8].Value = model.PublishTime; parameters[9].Value = model.IsApproved; parameters[10].Value = model.ApproverUserName; parameters[11].Value = model.Title; parameters[12].Value = model.ApproverTime; parameters[13].Value = model.BorrowerID; parameters[14].Value = model.ClaimsApplayID; parameters[15].Value = model.Icons; parameters[16].Value = model.DetailsImages1; parameters[17].Value = model.DetailsImages2; parameters[18].Value = model.DetailsImages3; parameters[19].Value = model.DetailsImages4; parameters[20].Value = model.DetailsImages5; parameters[21].Value = model.TitleImagePath; parameters[22].Value = model.LoanAmount; parameters[23].Value = model.APR; parameters[24].Value = model.LoanPeriod; parameters[25].Value = model.SingleAmount; parameters[26].Value = model.AlreadyAmount; parameters[27].Value = model.GuaranteeWay; return(db.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }