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);
}
