/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.Loans model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Loans(");
strSql.Append("FileId,AppraisedValue,CCScenario,CLTV,County,DateOpen,DateSubmit,DateApprove,DateClearToClose,DateDocs,DateFund,DateRecord,DateClose,DateDenied,DateCanceled,DownPay,EstCloseDate,Lender,LienPosition,LoanAmount,LoanNumber,LoanType,LTV,MonthlyPayment,LenderNotes,Occupancy,Program,PropertyAddr,PropertyCity,PropertyState,PropertyZip,Purpose,Rate,RateLockExpiration,SalesPrice,Term,Due,DateSuspended,RegionID,DivisionID,BranchID,GroupID,UserID,Status,LastCompletedStage,CurrentStage,ProspectLoanStatus,Disposed,Ranking,Created,CreatedBy,Modifed,ModifiedBy,GlobalId,DateHMDA,DateProcessing,DateReSubmit,DateDocsOut,DateDocsReceived,LOS_LoanOfficer,DateNote,LeadStar_username,LeadStar_userid,Joint,CoBrwType,PropertyType,HousingStatus,RentAmount,InterestOnly,IncludeEscrows,DT_FileID,TD_2,TD_2Amount,Subordinate,MonthlyPMI,MonthlyPMITax,PurchasedDate,FirstTimeBuyer,MIOption,LoanChanged)");
strSql.Append(" values (");
strSql.Append("@FileId,@AppraisedValue,@CCScenario,@CLTV,@County,@DateOpen,@DateSubmit,@DateApprove,@DateClearToClose,@DateDocs,@DateFund,@DateRecord,@DateClose,@DateDenied,@DateCanceled,@DownPay,@EstCloseDate,@Lender,@LienPosition,@LoanAmount,@LoanNumber,@LoanType,@LTV,@MonthlyPayment,@LenderNotes,@Occupancy,@Program,@PropertyAddr,@PropertyCity,@PropertyState,@PropertyZip,@Purpose,@Rate,@RateLockExpiration,@SalesPrice,@Term,@Due,@DateSuspended,@RegionID,@DivisionID,@BranchID,@GroupID,@UserID,@Status,@LastCompletedStage,@CurrentStage,@ProspectLoanStatus,@Disposed,@Ranking,@Created,@CreatedBy,@Modifed,@ModifiedBy,@GlobalId,@DateHMDA,@DateProcessing,@DateReSubmit,@DateDocsOut,@DateDocsReceived,@LOS_LoanOfficer,@DateNote,@LeadStar_username,@LeadStar_userid,@Joint,@CoBrwType,@PropertyType,@HousingStatus,@RentAmount,@InterestOnly,@IncludeEscrows,@DT_FileID,@TD_2,@TD_2Amount,@Subordinate,@MonthlyPMI,@MonthlyPMITax,@PurchasedDate, @FirstTimeHomeBuyer,@MIOption,@LoanChanged);");
strSql.Append("select SCOPE_IDENTITY();");
SqlParameter[] parameters =
{
new SqlParameter("@FileId", SqlDbType.Int, 4),
new SqlParameter("@AppraisedValue", SqlDbType.Money, 8),
new SqlParameter("@CCScenario", SqlDbType.NVarChar, 50),
new SqlParameter("@CLTV", SqlDbType.SmallMoney, 4),
new SqlParameter("@County", SqlDbType.NVarChar, 50),
new SqlParameter("@DateOpen", SqlDbType.DateTime),
new SqlParameter("@DateSubmit", SqlDbType.DateTime),
new SqlParameter("@DateApprove", SqlDbType.DateTime),
new SqlParameter("@DateClearToClose", SqlDbType.DateTime),
new SqlParameter("@DateDocs", SqlDbType.DateTime),
new SqlParameter("@DateFund", SqlDbType.DateTime),
new SqlParameter("@DateRecord", SqlDbType.DateTime),
new SqlParameter("@DateClose", SqlDbType.DateTime),
new SqlParameter("@DateDenied", SqlDbType.DateTime),
new SqlParameter("@DateCanceled", SqlDbType.DateTime),
new SqlParameter("@DownPay", SqlDbType.Money, 8),
new SqlParameter("@EstCloseDate", SqlDbType.DateTime),
new SqlParameter("@Lender", SqlDbType.Int, 4),
new SqlParameter("@LienPosition", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanAmount", SqlDbType.Money, 8),
new SqlParameter("@LoanNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanType", SqlDbType.NVarChar, 50),
new SqlParameter("@LTV", SqlDbType.SmallMoney, 4),
new SqlParameter("@MonthlyPayment", SqlDbType.Money, 8),
new SqlParameter("@LenderNotes", SqlDbType.NVarChar, 255),
new SqlParameter("@Occupancy", SqlDbType.NVarChar, 50),
new SqlParameter("@Program", SqlDbType.NVarChar, 255),
new SqlParameter("@PropertyAddr", SqlDbType.NVarChar, 50),
new SqlParameter("@PropertyCity", SqlDbType.NVarChar, 50),
new SqlParameter("@PropertyState", SqlDbType.Char, 2),
new SqlParameter("@PropertyZip", SqlDbType.NVarChar, 10),
new SqlParameter("@Purpose", SqlDbType.NVarChar, 50),
new SqlParameter("@Rate", SqlDbType.SmallMoney, 4),
new SqlParameter("@RateLockExpiration", SqlDbType.DateTime),
new SqlParameter("@SalesPrice", SqlDbType.Money, 8),
new SqlParameter("@Term", SqlDbType.SmallInt, 2),
new SqlParameter("@Due", SqlDbType.SmallInt, 2),
new SqlParameter("@DateSuspended", SqlDbType.DateTime),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@DivisionID", SqlDbType.Int, 4),
new SqlParameter("@BranchID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.NVarChar, 50),
new SqlParameter("@LastCompletedStage", SqlDbType.NVarChar, 50),
new SqlParameter("@CurrentStage", SqlDbType.NVarChar, 50),
new SqlParameter("@ProspectLoanStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@Disposed", SqlDbType.DateTime),
new SqlParameter("@Ranking", SqlDbType.NVarChar, 20),
new SqlParameter("@Created", SqlDbType.DateTime),
new SqlParameter("@CreatedBy", SqlDbType.Int, 4),
new SqlParameter("@Modifed", SqlDbType.DateTime),
new SqlParameter("@ModifiedBy", SqlDbType.Int, 4),
new SqlParameter("@GlobalId", SqlDbType.NVarChar, 255),
new SqlParameter("@DateHMDA", SqlDbType.DateTime),
new SqlParameter("@DateProcessing", SqlDbType.DateTime),
new SqlParameter("@DateReSubmit", SqlDbType.DateTime),
new SqlParameter("@DateDocsOut", SqlDbType.DateTime),
new SqlParameter("@DateDocsReceived", SqlDbType.DateTime),
new SqlParameter("@LOS_LoanOfficer", SqlDbType.NVarChar, 255),
new SqlParameter("@DateNote", SqlDbType.DateTime),
new SqlParameter("@LeadStar_username", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_userid", SqlDbType.NVarChar, 255),
new SqlParameter("@Joint", SqlDbType.Bit, 1),
new SqlParameter("@CoBrwType", SqlDbType.NVarChar, 255),
new SqlParameter("@PropertyType", SqlDbType.NVarChar, 255),
new SqlParameter("@HousingStatus", SqlDbType.NVarChar, 255),
new SqlParameter("@RentAmount", SqlDbType.Decimal, 5),
new SqlParameter("@InterestOnly", SqlDbType.Bit, 1),
new SqlParameter("@IncludeEscrows", SqlDbType.Bit, 1),
new SqlParameter("@DT_FileID", SqlDbType.NVarChar, 50),
new SqlParameter("@TD_2", SqlDbType.Bit, 1),
new SqlParameter("@TD_2Amount", SqlDbType.Decimal, 9),
new SqlParameter("@Subordinate", SqlDbType.Bit, 1),
new SqlParameter("@MonthlyPMI", SqlDbType.Decimal, 9),
new SqlParameter("@MonthlyPMITax", SqlDbType.Decimal, 9),
new SqlParameter("@PurchasedDate", SqlDbType.DateTime),
new SqlParameter("@FirstTimeHomeBuyer", SqlDbType.Bit),
new SqlParameter("@MIOption", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanChanged", SqlDbType.Bit)
};
parameters[0].Value = model.FileId;
parameters[1].Value = model.AppraisedValue;
parameters[2].Value = model.CCScenario;
parameters[3].Value = model.CLTV;
parameters[4].Value = model.County;
parameters[5].Value = model.DateOpen;
parameters[6].Value = model.DateSubmit;
parameters[7].Value = model.DateApprove;
parameters[8].Value = model.DateClearToClose;
parameters[9].Value = model.DateDocs;
parameters[10].Value = model.DateFund;
parameters[11].Value = model.DateRecord;
parameters[12].Value = model.DateClose;
parameters[13].Value = model.DateDenied;
parameters[14].Value = model.DateCanceled;
parameters[15].Value = model.DownPay;
parameters[16].Value = model.EstCloseDate;
parameters[17].Value = model.Lender;
parameters[18].Value = model.LienPosition;
parameters[19].Value = model.LoanAmount;
parameters[20].Value = model.LoanNumber;
parameters[21].Value = model.LoanType;
parameters[22].Value = model.LTV;
parameters[23].Value = model.MonthlyPayment;
parameters[24].Value = model.LenderNotes;
parameters[25].Value = model.Occupancy;
parameters[26].Value = model.Program;
parameters[27].Value = model.PropertyAddr;
parameters[28].Value = model.PropertyCity;
parameters[29].Value = model.PropertyState;
parameters[30].Value = model.PropertyZip;
parameters[31].Value = model.Purpose;
parameters[32].Value = model.Rate;
parameters[33].Value = model.RateLockExpiration;
parameters[34].Value = model.SalesPrice;
parameters[35].Value = model.Term;
parameters[36].Value = model.Due;
parameters[37].Value = model.DateSuspended;
parameters[38].Value = model.RegionID;
parameters[39].Value = model.DivisionID;
parameters[40].Value = model.BranchID;
parameters[41].Value = model.GroupID;
parameters[42].Value = model.UserID;
parameters[43].Value = model.Status;
parameters[44].Value = model.LastCompletedStage;
parameters[45].Value = model.CurrentStage;
parameters[46].Value = model.ProspectLoanStatus;
parameters[47].Value = model.Disposed;
parameters[48].Value = model.Ranking;
parameters[49].Value = model.Created;
parameters[50].Value = model.CreatedBy;
parameters[51].Value = model.Modifed;
parameters[52].Value = model.ModifiedBy;
parameters[53].Value = model.GlobalId;
parameters[54].Value = model.DateHMDA;
parameters[55].Value = model.DateProcessing;
parameters[56].Value = model.DateReSubmit;
parameters[57].Value = model.DateDocsOut;
parameters[58].Value = model.DateDocsReceived;
parameters[59].Value = model.LOS_LoanOfficer;
parameters[60].Value = model.DateNote;
parameters[61].Value = model.LeadStar_username;
parameters[62].Value = model.LeadStar_userid;
parameters[63].Value = model.Joint;
parameters[64].Value = model.CoBrwType;
parameters[65].Value = model.PropertyType;
parameters[66].Value = model.HousingStatus;
parameters[67].Value = model.RentAmount;
parameters[68].Value = model.InterestOnly;
parameters[69].Value = model.IncludeEscrows;
parameters[70].Value = model.DT_FileID;
parameters[71].Value = model.TD_2;
parameters[72].Value = model.TD_2Amount;
parameters[73].Value = model.Subordinate;
parameters[74].Value = model.MonthlyPMI;
parameters[75].Value = model.MonthlyPMITax;
parameters[76].Value = model.PurchasedDate;
parameters[77].Value = model.FirstTimeHomeBuyer;
parameters[78].Value = model.MIOption;
parameters[79].Value = model.LoanChanged;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Loans GetModel(int FileId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FileId,AppraisedValue,CCScenario,CLTV,County,DateOpen,DateSubmit,DateApprove,DateClearToClose,DateDocs,DateFund,DateRecord,DateClose,DateDenied,DateCanceled,DownPay,EstCloseDate,Lender,LienPosition,LoanAmount,LoanNumber,LoanType,LTV,MonthlyPayment,LenderNotes,Occupancy,Program,PropertyAddr,PropertyCity,PropertyState,PropertyZip,Purpose,Rate,RateLockExpiration,SalesPrice,Term,Due,DateSuspended,RegionID,DivisionID,BranchID,GroupID,UserID,Status,LastCompletedStage,CurrentStage,ProspectLoanStatus,Disposed,Ranking,Created,CreatedBy,Modifed,ModifiedBy,GlobalId,DateHMDA,DateProcessing,DateReSubmit,DateDocsOut,DateDocsReceived,LOS_LoanOfficer,DateNote,LeadStar_username,LeadStar_userid,Joint,CoBrwType,PropertyType,HousingStatus,RentAmount,InterestOnly,IncludeEscrows,DT_FileID,TD_2,TD_2Amount,Subordinate,MonthlyPMI,MonthlyPMITax,PurchasedDate from Loans ");
strSql.Append(" where FileId=@FileId ");
SqlParameter[] parameters =
{
new SqlParameter("@FileId", SqlDbType.Int, 4)
};
parameters[0].Value = FileId;
LPWeb.Model.Loans model = new LPWeb.Model.Loans();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["FileId"].ToString() != "")
{
model.FileId = int.Parse(ds.Tables[0].Rows[0]["FileId"].ToString());
}
if (ds.Tables[0].Rows[0]["AppraisedValue"].ToString() != "")
{
model.AppraisedValue = decimal.Parse(ds.Tables[0].Rows[0]["AppraisedValue"].ToString());
}
model.CCScenario = ds.Tables[0].Rows[0]["CCScenario"].ToString();
if (ds.Tables[0].Rows[0]["CLTV"].ToString() != "")
{
model.CLTV = decimal.Parse(ds.Tables[0].Rows[0]["CLTV"].ToString());
}
model.County = ds.Tables[0].Rows[0]["County"].ToString();
if (ds.Tables[0].Rows[0]["DateOpen"].ToString() != "")
{
model.DateOpen = DateTime.Parse(ds.Tables[0].Rows[0]["DateOpen"].ToString());
}
if (ds.Tables[0].Rows[0]["DateSubmit"].ToString() != "")
{
model.DateSubmit = DateTime.Parse(ds.Tables[0].Rows[0]["DateSubmit"].ToString());
}
if (ds.Tables[0].Rows[0]["DateApprove"].ToString() != "")
{
model.DateApprove = DateTime.Parse(ds.Tables[0].Rows[0]["DateApprove"].ToString());
}
if (ds.Tables[0].Rows[0]["DateClearToClose"].ToString() != "")
{
model.DateClearToClose = DateTime.Parse(ds.Tables[0].Rows[0]["DateClearToClose"].ToString());
}
if (ds.Tables[0].Rows[0]["DateDocs"].ToString() != "")
{
model.DateDocs = DateTime.Parse(ds.Tables[0].Rows[0]["DateDocs"].ToString());
}
if (ds.Tables[0].Rows[0]["DateFund"].ToString() != "")
{
model.DateFund = DateTime.Parse(ds.Tables[0].Rows[0]["DateFund"].ToString());
}
if (ds.Tables[0].Rows[0]["DateRecord"].ToString() != "")
{
model.DateRecord = DateTime.Parse(ds.Tables[0].Rows[0]["DateRecord"].ToString());
}
if (ds.Tables[0].Rows[0]["DateClose"].ToString() != "")
{
model.DateClose = DateTime.Parse(ds.Tables[0].Rows[0]["DateClose"].ToString());
}
if (ds.Tables[0].Rows[0]["DateDenied"].ToString() != "")
{
model.DateDenied = DateTime.Parse(ds.Tables[0].Rows[0]["DateDenied"].ToString());
}
if (ds.Tables[0].Rows[0]["DateCanceled"].ToString() != "")
{
model.DateCanceled = DateTime.Parse(ds.Tables[0].Rows[0]["DateCanceled"].ToString());
}
if (ds.Tables[0].Rows[0]["DownPay"].ToString() != "")
{
model.DownPay = decimal.Parse(ds.Tables[0].Rows[0]["DownPay"].ToString());
}
if (ds.Tables[0].Rows[0]["EstCloseDate"].ToString() != "")
{
model.EstCloseDate = DateTime.Parse(ds.Tables[0].Rows[0]["EstCloseDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Lender"].ToString() != "")
{
model.Lender = int.Parse(ds.Tables[0].Rows[0]["Lender"].ToString());
}
model.LienPosition = ds.Tables[0].Rows[0]["LienPosition"].ToString();
if (ds.Tables[0].Rows[0]["LoanAmount"].ToString() != "")
{
model.LoanAmount = decimal.Parse(ds.Tables[0].Rows[0]["LoanAmount"].ToString());
}
model.LoanNumber = ds.Tables[0].Rows[0]["LoanNumber"].ToString();
model.LoanType = ds.Tables[0].Rows[0]["LoanType"].ToString();
if (ds.Tables[0].Rows[0]["LTV"].ToString() != "")
{
model.LTV = decimal.Parse(ds.Tables[0].Rows[0]["LTV"].ToString());
}
if (ds.Tables[0].Rows[0]["MonthlyPayment"].ToString() != "")
{
model.MonthlyPayment = decimal.Parse(ds.Tables[0].Rows[0]["MonthlyPayment"].ToString());
}
model.LenderNotes = ds.Tables[0].Rows[0]["LenderNotes"].ToString();
model.Occupancy = ds.Tables[0].Rows[0]["Occupancy"].ToString();
model.Program = ds.Tables[0].Rows[0]["Program"].ToString();
model.PropertyAddr = ds.Tables[0].Rows[0]["PropertyAddr"].ToString();
model.PropertyCity = ds.Tables[0].Rows[0]["PropertyCity"].ToString();
model.PropertyState = ds.Tables[0].Rows[0]["PropertyState"].ToString();
model.PropertyZip = ds.Tables[0].Rows[0]["PropertyZip"].ToString();
model.Purpose = ds.Tables[0].Rows[0]["Purpose"].ToString();
if (ds.Tables[0].Rows[0]["Rate"].ToString() != "")
{
model.Rate = decimal.Parse(ds.Tables[0].Rows[0]["Rate"].ToString());
}
if (ds.Tables[0].Rows[0]["RateLockExpiration"].ToString() != "")
{
model.RateLockExpiration = DateTime.Parse(ds.Tables[0].Rows[0]["RateLockExpiration"].ToString());
}
if (ds.Tables[0].Rows[0]["SalesPrice"].ToString() != "")
{
model.SalesPrice = decimal.Parse(ds.Tables[0].Rows[0]["SalesPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["Term"].ToString() != "")
{
model.Term = int.Parse(ds.Tables[0].Rows[0]["Term"].ToString());
}
if (ds.Tables[0].Rows[0]["Due"].ToString() != "")
{
model.Due = int.Parse(ds.Tables[0].Rows[0]["Due"].ToString());
}
if (ds.Tables[0].Rows[0]["DateSuspended"].ToString() != "")
{
model.DateSuspended = DateTime.Parse(ds.Tables[0].Rows[0]["DateSuspended"].ToString());
}
if (ds.Tables[0].Rows[0]["RegionID"].ToString() != "")
{
model.RegionID = int.Parse(ds.Tables[0].Rows[0]["RegionID"].ToString());
}
if (ds.Tables[0].Rows[0]["DivisionID"].ToString() != "")
{
model.DivisionID = int.Parse(ds.Tables[0].Rows[0]["DivisionID"].ToString());
}
if (ds.Tables[0].Rows[0]["BranchID"].ToString() != "")
{
model.BranchID = int.Parse(ds.Tables[0].Rows[0]["BranchID"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupID"].ToString() != "")
{
model.GroupID = int.Parse(ds.Tables[0].Rows[0]["GroupID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.Status = ds.Tables[0].Rows[0]["Status"].ToString();
model.LastCompletedStage = ds.Tables[0].Rows[0]["LastCompletedStage"].ToString();
model.CurrentStage = ds.Tables[0].Rows[0]["CurrentStage"].ToString();
model.ProspectLoanStatus = ds.Tables[0].Rows[0]["ProspectLoanStatus"].ToString();
if (ds.Tables[0].Rows[0]["Disposed"].ToString() != "")
{
model.Disposed = DateTime.Parse(ds.Tables[0].Rows[0]["Disposed"].ToString());
}
model.Ranking = ds.Tables[0].Rows[0]["Ranking"].ToString();
if (ds.Tables[0].Rows[0]["Created"].ToString() != "")
{
model.Created = DateTime.Parse(ds.Tables[0].Rows[0]["Created"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedBy"].ToString() != "")
{
model.CreatedBy = int.Parse(ds.Tables[0].Rows[0]["CreatedBy"].ToString());
}
if (ds.Tables[0].Rows[0]["Modifed"].ToString() != "")
{
model.Modifed = DateTime.Parse(ds.Tables[0].Rows[0]["Modifed"].ToString());
}
if (ds.Tables[0].Rows[0]["ModifiedBy"].ToString() != "")
{
model.ModifiedBy = int.Parse(ds.Tables[0].Rows[0]["ModifiedBy"].ToString());
}
model.GlobalId = ds.Tables[0].Rows[0]["GlobalId"].ToString();
if (ds.Tables[0].Rows[0]["DateHMDA"].ToString() != "")
{
model.DateHMDA = DateTime.Parse(ds.Tables[0].Rows[0]["DateHMDA"].ToString());
}
if (ds.Tables[0].Rows[0]["DateProcessing"].ToString() != "")
{
model.DateProcessing = DateTime.Parse(ds.Tables[0].Rows[0]["DateProcessing"].ToString());
}
if (ds.Tables[0].Rows[0]["DateReSubmit"].ToString() != "")
{
model.DateReSubmit = DateTime.Parse(ds.Tables[0].Rows[0]["DateReSubmit"].ToString());
}
if (ds.Tables[0].Rows[0]["DateDocsOut"].ToString() != "")
{
model.DateDocsOut = DateTime.Parse(ds.Tables[0].Rows[0]["DateDocsOut"].ToString());
}
if (ds.Tables[0].Rows[0]["DateDocsReceived"].ToString() != "")
{
model.DateDocsReceived = DateTime.Parse(ds.Tables[0].Rows[0]["DateDocsReceived"].ToString());
}
model.LOS_LoanOfficer = ds.Tables[0].Rows[0]["LOS_LoanOfficer"].ToString();
if (ds.Tables[0].Rows[0]["DateNote"].ToString() != "")
{
model.DateNote = DateTime.Parse(ds.Tables[0].Rows[0]["DateNote"].ToString());
}
model.LeadStar_username = ds.Tables[0].Rows[0]["LeadStar_username"].ToString();
model.LeadStar_userid = ds.Tables[0].Rows[0]["LeadStar_userid"].ToString();
if (ds.Tables[0].Rows[0]["Joint"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Joint"].ToString() == "1") || (ds.Tables[0].Rows[0]["Joint"].ToString().ToLower() == "true"))
{
model.Joint = true;
}
else
{
model.Joint = false;
}
}
model.CoBrwType = ds.Tables[0].Rows[0]["CoBrwType"].ToString();
model.PropertyType = ds.Tables[0].Rows[0]["PropertyType"].ToString();
model.HousingStatus = ds.Tables[0].Rows[0]["HousingStatus"].ToString();
if (ds.Tables[0].Rows[0]["RentAmount"].ToString() != "")
{
model.RentAmount = decimal.Parse(ds.Tables[0].Rows[0]["RentAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["InterestOnly"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["InterestOnly"].ToString() == "1") || (ds.Tables[0].Rows[0]["InterestOnly"].ToString().ToLower() == "true"))
{
model.InterestOnly = true;
}
else
{
model.InterestOnly = false;
}
}
if (ds.Tables[0].Rows[0]["IncludeEscrows"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IncludeEscrows"].ToString() == "1") || (ds.Tables[0].Rows[0]["IncludeEscrows"].ToString().ToLower() == "true"))
{
model.IncludeEscrows = true;
}
else
{
model.IncludeEscrows = false;
}
}
model.DT_FileID = ds.Tables[0].Rows[0]["DT_FileID"].ToString();
if (ds.Tables[0].Rows[0]["TD_2"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["TD_2"].ToString() == "1") || (ds.Tables[0].Rows[0]["TD_2"].ToString().ToLower() == "true"))
{
model.TD_2 = true;
}
else
{
model.TD_2 = false;
}
}
if (ds.Tables[0].Rows[0]["TD_2Amount"].ToString() != "")
{
model.TD_2Amount = decimal.Parse(ds.Tables[0].Rows[0]["TD_2Amount"].ToString());
}
if (ds.Tables[0].Rows[0]["Subordinate"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Subordinate"].ToString() == "1") || (ds.Tables[0].Rows[0]["Subordinate"].ToString().ToLower() == "true"))
{
model.Subordinate = true;
}
else
{
model.Subordinate = false;
}
}
if (ds.Tables[0].Rows[0]["MonthlyPMI"].ToString() != "")
{
model.MonthlyPMI = decimal.Parse(ds.Tables[0].Rows[0]["MonthlyPMI"].ToString());
}
if (ds.Tables[0].Rows[0]["MonthlyPMITax"].ToString() != "")
{
model.MonthlyPMITax = decimal.Parse(ds.Tables[0].Rows[0]["MonthlyPMITax"].ToString());
}
if (ds.Tables[0].Rows[0]["PurchasedDate"].ToString() != "")
{
model.PurchasedDate = DateTime.Parse(ds.Tables[0].Rows[0]["PurchasedDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Loans model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Loans set ");
strSql.Append("AppraisedValue=@AppraisedValue,");
strSql.Append("CCScenario=@CCScenario,");
strSql.Append("CLTV=@CLTV,");
strSql.Append("County=@County,");
strSql.Append("DateOpen=@DateOpen,");
strSql.Append("DateSubmit=@DateSubmit,");
strSql.Append("DateApprove=@DateApprove,");
strSql.Append("DateClearToClose=@DateClearToClose,");
strSql.Append("DateDocs=@DateDocs,");
strSql.Append("DateFund=@DateFund,");
strSql.Append("DateRecord=@DateRecord,");
strSql.Append("DateClose=@DateClose,");
strSql.Append("DateDenied=@DateDenied,");
strSql.Append("DateCanceled=@DateCanceled,");
strSql.Append("DownPay=@DownPay,");
strSql.Append("EstCloseDate=@EstCloseDate,");
strSql.Append("Lender=@Lender,");
strSql.Append("LienPosition=@LienPosition,");
strSql.Append("LoanAmount=@LoanAmount,");
strSql.Append("LoanNumber=@LoanNumber,");
strSql.Append("LoanType=@LoanType,");
strSql.Append("LTV=@LTV,");
strSql.Append("MonthlyPayment=@MonthlyPayment,");
strSql.Append("LenderNotes=@LenderNotes,");
strSql.Append("Occupancy=@Occupancy,");
strSql.Append("Program=@Program,");
strSql.Append("PropertyAddr=@PropertyAddr,");
strSql.Append("PropertyCity=@PropertyCity,");
strSql.Append("PropertyState=@PropertyState,");
strSql.Append("PropertyZip=@PropertyZip,");
strSql.Append("Purpose=@Purpose,");
strSql.Append("Rate=@Rate,");
strSql.Append("RateLockExpiration=@RateLockExpiration,");
strSql.Append("SalesPrice=@SalesPrice,");
strSql.Append("Term=@Term,");
strSql.Append("Due=@Due,");
strSql.Append("DateSuspended=@DateSuspended,");
strSql.Append("RegionID=@RegionID,");
strSql.Append("DivisionID=@DivisionID,");
strSql.Append("BranchID=@BranchID,");
strSql.Append("GroupID=@GroupID,");
strSql.Append("UserID=@UserID,");
strSql.Append("Status=@Status,");
strSql.Append("LastCompletedStage=@LastCompletedStage,");
strSql.Append("CurrentStage=@CurrentStage,");
strSql.Append("ProspectLoanStatus=@ProspectLoanStatus,");
strSql.Append("Disposed=@Disposed,");
strSql.Append("Ranking=@Ranking,");
strSql.Append("Created=@Created,");
strSql.Append("CreatedBy=@CreatedBy,");
strSql.Append("Modifed=@Modifed,");
strSql.Append("ModifiedBy=@ModifiedBy,");
strSql.Append("GlobalId=@GlobalId,");
strSql.Append("DateHMDA=@DateHMDA,");
strSql.Append("DateProcessing=@DateProcessing,");
strSql.Append("DateReSubmit=@DateReSubmit,");
strSql.Append("DateDocsOut=@DateDocsOut,");
strSql.Append("DateDocsReceived=@DateDocsReceived,");
strSql.Append("LOS_LoanOfficer=@LOS_LoanOfficer,");
strSql.Append("DateNote=@DateNote,");
strSql.Append("LeadStar_username=@LeadStar_username,");
strSql.Append("LeadStar_userid=@LeadStar_userid,");
strSql.Append("Joint=@Joint,");
strSql.Append("CoBrwType=@CoBrwType,");
strSql.Append("PropertyType=@PropertyType,");
strSql.Append("HousingStatus=@HousingStatus,");
strSql.Append("RentAmount=@RentAmount,");
strSql.Append("InterestOnly=@InterestOnly,");
strSql.Append("IncludeEscrows=@IncludeEscrows,");
strSql.Append("DT_FileID=@DT_FileID,");
strSql.Append("TD_2=@TD_2,");
strSql.Append("TD_2Amount=@TD_2Amount,");
strSql.Append("Subordinate=@Subordinate,");
strSql.Append("MonthlyPMI=@MonthlyPMI,");
strSql.Append("MonthlyPMITax=@MonthlyPMITax,");
strSql.Append("PurchasedDate=@PurchasedDate,");
strSql.Append("FirstTimeBuyer=@FirstTimeHomeBuyer,");
strSql.Append("MIOption=@MIOption,");
strSql.Append("LoanChanged=@LoanChanged ");
strSql.Append(" where FileId=@FileId ");
SqlParameter[] parameters =
{
new SqlParameter("@FileId", SqlDbType.Int, 4),
new SqlParameter("@AppraisedValue", SqlDbType.Money, 8),
new SqlParameter("@CCScenario", SqlDbType.NVarChar, 50),
new SqlParameter("@CLTV", SqlDbType.SmallMoney, 4),
new SqlParameter("@County", SqlDbType.NVarChar, 50),
new SqlParameter("@DateOpen", SqlDbType.DateTime),
new SqlParameter("@DateSubmit", SqlDbType.DateTime),
new SqlParameter("@DateApprove", SqlDbType.DateTime),
new SqlParameter("@DateClearToClose", SqlDbType.DateTime),
new SqlParameter("@DateDocs", SqlDbType.DateTime),
new SqlParameter("@DateFund", SqlDbType.DateTime),
new SqlParameter("@DateRecord", SqlDbType.DateTime),
new SqlParameter("@DateClose", SqlDbType.DateTime),
new SqlParameter("@DateDenied", SqlDbType.DateTime),
new SqlParameter("@DateCanceled", SqlDbType.DateTime),
new SqlParameter("@DownPay", SqlDbType.Money, 8),
new SqlParameter("@EstCloseDate", SqlDbType.DateTime),
new SqlParameter("@Lender", SqlDbType.Int, 4),
new SqlParameter("@LienPosition", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanAmount", SqlDbType.Money, 8),
new SqlParameter("@LoanNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanType", SqlDbType.NVarChar, 50),
new SqlParameter("@LTV", SqlDbType.SmallMoney, 4),
new SqlParameter("@MonthlyPayment", SqlDbType.Money, 8),
new SqlParameter("@LenderNotes", SqlDbType.NVarChar, 255),
new SqlParameter("@Occupancy", SqlDbType.NVarChar, 50),
new SqlParameter("@Program", SqlDbType.NVarChar, 255),
new SqlParameter("@PropertyAddr", SqlDbType.NVarChar, 50),
new SqlParameter("@PropertyCity", SqlDbType.NVarChar, 50),
new SqlParameter("@PropertyState", SqlDbType.Char, 2),
new SqlParameter("@PropertyZip", SqlDbType.NVarChar, 10),
new SqlParameter("@Purpose", SqlDbType.NVarChar, 50),
new SqlParameter("@Rate", SqlDbType.SmallMoney, 4),
new SqlParameter("@RateLockExpiration", SqlDbType.DateTime),
new SqlParameter("@SalesPrice", SqlDbType.Money, 8),
new SqlParameter("@Term", SqlDbType.SmallInt, 2),
new SqlParameter("@Due", SqlDbType.SmallInt, 2),
new SqlParameter("@DateSuspended", SqlDbType.DateTime),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@DivisionID", SqlDbType.Int, 4),
new SqlParameter("@BranchID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.NVarChar, 50),
new SqlParameter("@LastCompletedStage", SqlDbType.NVarChar, 50),
new SqlParameter("@CurrentStage", SqlDbType.NVarChar, 50),
new SqlParameter("@ProspectLoanStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@Disposed", SqlDbType.DateTime),
new SqlParameter("@Ranking", SqlDbType.NVarChar, 20),
new SqlParameter("@Created", SqlDbType.DateTime),
new SqlParameter("@CreatedBy", SqlDbType.Int, 4),
new SqlParameter("@Modifed", SqlDbType.DateTime),
new SqlParameter("@ModifiedBy", SqlDbType.Int, 4),
new SqlParameter("@GlobalId", SqlDbType.NVarChar, 255),
new SqlParameter("@DateHMDA", SqlDbType.DateTime),
new SqlParameter("@DateProcessing", SqlDbType.DateTime),
new SqlParameter("@DateReSubmit", SqlDbType.DateTime),
new SqlParameter("@DateDocsOut", SqlDbType.DateTime),
new SqlParameter("@DateDocsReceived", SqlDbType.DateTime),
new SqlParameter("@LOS_LoanOfficer", SqlDbType.NVarChar, 255),
new SqlParameter("@DateNote", SqlDbType.DateTime),
new SqlParameter("@LeadStar_username", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_userid", SqlDbType.NVarChar, 255),
new SqlParameter("@Joint", SqlDbType.Bit, 1),
new SqlParameter("@CoBrwType", SqlDbType.NVarChar, 255),
new SqlParameter("@PropertyType", SqlDbType.NVarChar, 255),
new SqlParameter("@HousingStatus", SqlDbType.NVarChar, 255),
new SqlParameter("@RentAmount", SqlDbType.Decimal, 5),
new SqlParameter("@InterestOnly", SqlDbType.Bit, 1),
new SqlParameter("@IncludeEscrows", SqlDbType.Bit, 1),
new SqlParameter("@DT_FileID", SqlDbType.NVarChar, 50),
new SqlParameter("@TD_2", SqlDbType.Bit, 1),
new SqlParameter("@TD_2Amount", SqlDbType.Decimal, 9),
new SqlParameter("@Subordinate", SqlDbType.Bit, 1),
new SqlParameter("@MonthlyPMI", SqlDbType.Decimal, 9),
new SqlParameter("@MonthlyPMITax", SqlDbType.Decimal, 9),
new SqlParameter("@PurchasedDate", SqlDbType.DateTime),
new SqlParameter("@FirstTimeHomeBuyer", SqlDbType.Bit),
new SqlParameter("@MIOption", SqlDbType.NVarChar, 50),
new SqlParameter("@LoanChanged", SqlDbType.Bit)
};
parameters[0].Value = model.FileId;
parameters[1].Value = model.AppraisedValue;
parameters[2].Value = model.CCScenario;
parameters[3].Value = model.CLTV;
parameters[4].Value = model.County;
parameters[5].Value = model.DateOpen;
parameters[6].Value = model.DateSubmit;
parameters[7].Value = model.DateApprove;
parameters[8].Value = model.DateClearToClose;
parameters[9].Value = model.DateDocs;
parameters[10].Value = model.DateFund;
parameters[11].Value = model.DateRecord;
parameters[12].Value = model.DateClose;
parameters[13].Value = model.DateDenied;
parameters[14].Value = model.DateCanceled;
parameters[15].Value = model.DownPay;
parameters[16].Value = model.EstCloseDate;
parameters[17].Value = model.Lender;
parameters[18].Value = model.LienPosition;
parameters[19].Value = model.LoanAmount;
parameters[20].Value = model.LoanNumber;
parameters[21].Value = model.LoanType;
parameters[22].Value = model.LTV;
parameters[23].Value = model.MonthlyPayment;
parameters[24].Value = model.LenderNotes;
parameters[25].Value = model.Occupancy;
parameters[26].Value = model.Program;
parameters[27].Value = model.PropertyAddr;
parameters[28].Value = model.PropertyCity;
parameters[29].Value = model.PropertyState;
parameters[30].Value = model.PropertyZip;
parameters[31].Value = model.Purpose;
parameters[32].Value = model.Rate;
parameters[33].Value = model.RateLockExpiration;
parameters[34].Value = model.SalesPrice;
parameters[35].Value = model.Term;
parameters[36].Value = model.Due;
parameters[37].Value = model.DateSuspended;
parameters[38].Value = model.RegionID;
parameters[39].Value = model.DivisionID;
parameters[40].Value = model.BranchID;
parameters[41].Value = model.GroupID;
parameters[42].Value = model.UserID;
parameters[43].Value = model.Status;
parameters[44].Value = model.LastCompletedStage;
parameters[45].Value = model.CurrentStage;
parameters[46].Value = model.ProspectLoanStatus;
parameters[47].Value = model.Disposed;
parameters[48].Value = model.Ranking;
parameters[49].Value = model.Created;
parameters[50].Value = model.CreatedBy;
parameters[51].Value = model.Modifed;
parameters[52].Value = model.ModifiedBy;
parameters[53].Value = model.GlobalId;
parameters[54].Value = model.DateHMDA;
parameters[55].Value = model.DateProcessing;
parameters[56].Value = model.DateReSubmit;
parameters[57].Value = model.DateDocsOut;
parameters[58].Value = model.DateDocsReceived;
parameters[59].Value = model.LOS_LoanOfficer;
parameters[60].Value = model.DateNote;
parameters[61].Value = model.LeadStar_username;
parameters[62].Value = model.LeadStar_userid;
parameters[63].Value = model.Joint;
parameters[64].Value = model.CoBrwType;
parameters[65].Value = model.PropertyType;
parameters[66].Value = model.HousingStatus;
parameters[67].Value = model.RentAmount;
parameters[68].Value = model.InterestOnly;
parameters[69].Value = model.IncludeEscrows;
parameters[70].Value = model.DT_FileID;
parameters[71].Value = model.TD_2;
parameters[72].Value = model.TD_2Amount;
parameters[73].Value = model.Subordinate;
parameters[74].Value = model.MonthlyPMI;
parameters[75].Value = model.MonthlyPMITax;
parameters[76].Value = model.PurchasedDate;
parameters[77].Value = model.FirstTimeHomeBuyer;
parameters[78].Value = model.MIOption;
parameters[79].Value = model.LoanChanged;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}