/// <summary> /// 得到一个对象实体 /// </summary> public XBWN.Model.xbwn_Loan GetModel(int LoanId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from dbo.[xbwn_Loan] "); strSql.Append(" where LoanId=@LoanId"); SqlParameter[] parameters = { new SqlParameter("@LoanId", SqlDbType.Int, 4) }; parameters[0].Value = LoanId; XBWN.Model.xbwn_Loan model = new XBWN.Model.xbwn_Loan(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_Loan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[xbwn_Loan]("); strSql.Append("LoanDate,LoanDays,DueDate,InterestName,InterestValue,BankCardId,MemberId,CustomerId,RealName,IdNo,NetLoanApplyId,BankCode,BankName,TelNo,IsCorrect,TradePasswordExist,TradePassword,TradePasswordSecond,Flag,Mark,IsDeleted,BorrowNo,CreateId,CreateDate,EditId,EditDate,BankId,LoanAmount,AmountReceived,LoanServiceCharge,LoanRate,ReturnAmount"); strSql.Append(") values ("); strSql.Append("@LoanDate,@LoanDays,@DueDate,@InterestName,@InterestValue,@BankCardId,@MemberId,@CustomerId,@RealName,@IdNo,@NetLoanApplyId,@BankCode,@BankName,@TelNo,@IsCorrect,@TradePasswordExist,@TradePassword,@TradePasswordSecond,@Flag,@Mark,@IsDeleted,@BorrowNo,@CreateId,@CreateDate,@EditId,@EditDate,@BankId,@LoanAmount,@AmountReceived,@LoanServiceCharge,@LoanRate,@ReturnAmount"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@LoanDate", model.LoanDate), new SqlParameter("@LoanDays", model.LoanDays), new SqlParameter("@DueDate", model.DueDate), new SqlParameter("@InterestName", model.InterestName), new SqlParameter("@InterestValue", model.InterestValue), new SqlParameter("@BankCardId", model.BankCardId), new SqlParameter("@MemberId", model.MemberId), new SqlParameter("@CustomerId", model.CustomerId), new SqlParameter("@RealName", model.RealName), new SqlParameter("@IdNo", model.IdNo), new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@BankCode", model.BankCode), new SqlParameter("@BankName", model.BankName), new SqlParameter("@TelNo", model.TelNo), new SqlParameter("@IsCorrect", model.IsCorrect), new SqlParameter("@TradePasswordExist", model.TradePasswordExist), new SqlParameter("@TradePassword", model.TradePassword), new SqlParameter("@TradePasswordSecond", model.TradePasswordSecond), new SqlParameter("@Flag", model.Flag), new SqlParameter("@Mark", model.Mark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@BorrowNo", model.BorrowNo), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@BankId", model.BankId), new SqlParameter("@LoanAmount", model.LoanAmount), new SqlParameter("@AmountReceived", model.AmountReceived), new SqlParameter("@LoanServiceCharge", model.LoanServiceCharge), new SqlParameter("@LoanRate", model.LoanRate), new SqlParameter("@ReturnAmount", model.ReturnAmount) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XBWN.Model.xbwn_Loan GetModelByBorrowNo(string borrowNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from dbo.[xbwn_Loan] "); strSql.Append(" where BorrowNo=@BorrowNo"); SqlParameter[] parameters = { new SqlParameter("@BorrowNo", borrowNo) }; XBWN.Model.xbwn_Loan model = new XBWN.Model.xbwn_Loan(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XBWN.Model.xbwn_Loan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[xbwn_Loan] set "); strSql.Append(" LoanDate = @LoanDate , "); strSql.Append(" LoanDays = @LoanDays , "); strSql.Append(" DueDate = @DueDate , "); strSql.Append(" InterestName = @InterestName , "); strSql.Append(" InterestValue = @InterestValue , "); strSql.Append(" BankCardId = @BankCardId , "); strSql.Append(" MemberId = @MemberId , "); strSql.Append(" CustomerId = @CustomerId , "); strSql.Append(" RealName = @RealName , "); strSql.Append(" IdNo = @IdNo , "); strSql.Append(" NetLoanApplyId = @NetLoanApplyId , "); strSql.Append(" BankCode = @BankCode , "); strSql.Append(" BankName = @BankName , "); strSql.Append(" TelNo = @TelNo , "); strSql.Append(" IsCorrect = @IsCorrect , "); strSql.Append(" TradePasswordExist = @TradePasswordExist , "); strSql.Append(" TradePassword = @TradePassword , "); strSql.Append(" TradePasswordSecond = @TradePasswordSecond , "); strSql.Append(" Flag = @Flag , "); strSql.Append(" Mark = @Mark , "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" BorrowNo = @BorrowNo , "); strSql.Append(" CreateId = @CreateId , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" EditId = @EditId , "); strSql.Append(" EditDate = @EditDate , "); strSql.Append(" BankId = @BankId , "); strSql.Append(" LoanAmount = @LoanAmount , "); strSql.Append(" AmountReceived = @AmountReceived , "); strSql.Append(" LoanServiceCharge = @LoanServiceCharge , "); strSql.Append(" LoanRate = @LoanRate , "); strSql.Append(" ReturnAmount = @ReturnAmount "); strSql.Append(" where LoanId=@LoanId "); SqlParameter[] parameters = { new SqlParameter("@LoanId", model.LoanId), new SqlParameter("@LoanDate", model.LoanDate), new SqlParameter("@LoanDays", model.LoanDays), new SqlParameter("@DueDate", model.DueDate), new SqlParameter("@InterestName", model.InterestName), new SqlParameter("@InterestValue", model.InterestValue), new SqlParameter("@BankCardId", model.BankCardId), new SqlParameter("@MemberId", model.MemberId), new SqlParameter("@CustomerId", model.CustomerId), new SqlParameter("@RealName", model.RealName), new SqlParameter("@IdNo", model.IdNo), new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@BankCode", model.BankCode), new SqlParameter("@BankName", model.BankName), new SqlParameter("@TelNo", model.TelNo), new SqlParameter("@IsCorrect", model.IsCorrect), new SqlParameter("@TradePasswordExist", model.TradePasswordExist), new SqlParameter("@TradePassword", model.TradePassword), new SqlParameter("@TradePasswordSecond", model.TradePasswordSecond), new SqlParameter("@Flag", model.Flag), new SqlParameter("@Mark", model.Mark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@BorrowNo", model.BorrowNo), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@BankId", model.BankId), new SqlParameter("@LoanAmount", model.LoanAmount), new SqlParameter("@AmountReceived", model.AmountReceived), new SqlParameter("@LoanServiceCharge", model.LoanServiceCharge), new SqlParameter("@LoanRate", model.LoanRate), new SqlParameter("@ReturnAmount", model.ReturnAmount) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// datarow转成对象实体 /// </summary> public XBWN.Model.xbwn_Loan DataRowToModel(DataRow row) { XBWN.Model.xbwn_Loan model = new XBWN.Model.xbwn_Loan(); if (row != null) { if (row["LoanId"].ToString() != "") { model.LoanId = int.Parse(row["LoanId"].ToString()); } if (row["LoanDate"].ToString() != "") { model.LoanDate = DateTime.Parse(row["LoanDate"].ToString()); } if (row["LoanDays"].ToString() != "") { model.LoanDays = int.Parse(row["LoanDays"].ToString()); } if (row["DueDate"].ToString() != "") { model.DueDate = DateTime.Parse(row["DueDate"].ToString()); } model.InterestName = row["InterestName"].ToString(); model.InterestValue = row["InterestValue"].ToString(); if (row["BankCardId"].ToString() != "") { model.BankCardId = int.Parse(row["BankCardId"].ToString()); } if (row["MemberId"].ToString() != "") { model.MemberId = int.Parse(row["MemberId"].ToString()); } if (row["CustomerId"].ToString() != "") { model.CustomerId = int.Parse(row["CustomerId"].ToString()); } model.RealName = row["RealName"].ToString(); model.IdNo = row["IdNo"].ToString(); if (row["NetLoanApplyId"].ToString() != "") { model.NetLoanApplyId = int.Parse(row["NetLoanApplyId"].ToString()); } model.BankCode = row["BankCode"].ToString(); model.BankName = row["BankName"].ToString(); model.TelNo = row["TelNo"].ToString(); if (row["IsCorrect"].ToString() != "") { model.IsCorrect = int.Parse(row["IsCorrect"].ToString()); } if (row["TradePasswordExist"].ToString() != "") { if ((row["TradePasswordExist"].ToString() == "1") || (row["TradePasswordExist"].ToString().ToLower() == "true")) { model.TradePasswordExist = true; } else { model.TradePasswordExist = false; } } model.TradePassword = row["TradePassword"].ToString(); model.TradePasswordSecond = row["TradePasswordSecond"].ToString(); if (row["Flag"].ToString() != "") { model.Flag = int.Parse(row["Flag"].ToString()); } if (row["Mark"].ToString() != "") { if ((row["Mark"].ToString() == "1") || (row["Mark"].ToString().ToLower() == "true")) { model.Mark = true; } else { model.Mark = false; } } if (row["IsDeleted"].ToString() != "") { model.IsDeleted = int.Parse(row["IsDeleted"].ToString()); } model.BorrowNo = row["BorrowNo"].ToString(); if (row["CreateId"].ToString() != "") { model.CreateId = int.Parse(row["CreateId"].ToString()); } if (row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["EditId"].ToString() != "") { model.EditId = int.Parse(row["EditId"].ToString()); } if (row["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(row["EditDate"].ToString()); } model.BankId = row["BankId"].ToString(); if (row["LoanAmount"].ToString() != "") { model.LoanAmount = decimal.Parse(row["LoanAmount"].ToString()); } if (row["AmountReceived"].ToString() != "") { model.AmountReceived = decimal.Parse(row["AmountReceived"].ToString()); } if (row["LoanServiceCharge"].ToString() != "") { model.LoanServiceCharge = decimal.Parse(row["LoanServiceCharge"].ToString()); } if (row["LoanRate"].ToString() != "") { model.LoanRate = decimal.Parse(row["LoanRate"].ToString()); } if (row["ReturnAmount"].ToString() != "") { model.ReturnAmount = decimal.Parse(row["ReturnAmount"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XBWN.Model.xbwn_Loan model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_Loan model) { return(dal.Add(model)); }