/// <summary> /// 得到一个对象实体 /// </summary> public LPWeb.Model.LoanLocks GetModel(int FileId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FileId,LockOption,LockedBy,LockTime,LockTerm,ConfirmedBy,ConfirmTime,LockExpirationDate,Ext1Term,Ext1LockExpDate,Ext1LockTime,Ext1LockedBy,Ext1ConfirmTime,Ext2Term,Ext2LockExpDate,Ext2LockTime,Ext2LockedBy,Ext2ConfirmTime,Ext3Term,Ext3LockExpDate,Ext3LockTime,Ext3LockedBy,Ext3ConfirmTime,InvestorID,Investor,ProgramID,Program from LoanLocks "); strSql.Append(" where FileId=@FileId "); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.Int, 4) }; parameters[0].Value = FileId; LPWeb.Model.LoanLocks model = new LPWeb.Model.LoanLocks(); 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()); } model.LockOption = ds.Tables[0].Rows[0]["LockOption"].ToString(); model.LockedBy = ds.Tables[0].Rows[0]["LockedBy"].ToString(); if (ds.Tables[0].Rows[0]["LockTime"].ToString() != "") { model.LockTime = DateTime.Parse(ds.Tables[0].Rows[0]["LockTime"].ToString()); } if (ds.Tables[0].Rows[0]["LockTerm"].ToString() != "") { model.LockTerm = int.Parse(ds.Tables[0].Rows[0]["LockTerm"].ToString()); } model.ConfirmedBy = ds.Tables[0].Rows[0]["ConfirmedBy"].ToString(); if (ds.Tables[0].Rows[0]["ConfirmTime"].ToString() != "") { model.ConfirmTime = DateTime.Parse(ds.Tables[0].Rows[0]["ConfirmTime"].ToString()); } if (ds.Tables[0].Rows[0]["LockExpirationDate"].ToString() != "") { model.LockExpirationDate = DateTime.Parse(ds.Tables[0].Rows[0]["LockExpirationDate"].ToString()); } if (ds.Tables[0].Rows[0]["Ext1Term"].ToString() != "") { model.Ext1Term = int.Parse(ds.Tables[0].Rows[0]["Ext1Term"].ToString()); } if (ds.Tables[0].Rows[0]["Ext1LockExpDate"].ToString() != "") { model.Ext1LockExpDate = DateTime.Parse(ds.Tables[0].Rows[0]["Ext1LockExpDate"].ToString()); } if (ds.Tables[0].Rows[0]["Ext1LockTime"].ToString() != "") { model.Ext1LockTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext1LockTime"].ToString()); } model.Ext1LockedBy = ds.Tables[0].Rows[0]["Ext1LockedBy"].ToString(); if (ds.Tables[0].Rows[0]["Ext1ConfirmTime"].ToString() != "") { model.Ext1ConfirmTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext1ConfirmTime"].ToString()); } if (ds.Tables[0].Rows[0]["Ext2Term"].ToString() != "") { model.Ext2Term = int.Parse(ds.Tables[0].Rows[0]["Ext2Term"].ToString()); } if (ds.Tables[0].Rows[0]["Ext2LockExpDate"].ToString() != "") { model.Ext2LockExpDate = DateTime.Parse(ds.Tables[0].Rows[0]["Ext2LockExpDate"].ToString()); } if (ds.Tables[0].Rows[0]["Ext2LockTime"].ToString() != "") { model.Ext2LockTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext2LockTime"].ToString()); } model.Ext2LockedBy = ds.Tables[0].Rows[0]["Ext2LockedBy"].ToString(); if (ds.Tables[0].Rows[0]["Ext2ConfirmTime"].ToString() != "") { model.Ext2ConfirmTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext2ConfirmTime"].ToString()); } if (ds.Tables[0].Rows[0]["Ext3Term"].ToString() != "") { model.Ext3Term = int.Parse(ds.Tables[0].Rows[0]["Ext3Term"].ToString()); } if (ds.Tables[0].Rows[0]["Ext3LockExpDate"].ToString() != "") { model.Ext3LockExpDate = DateTime.Parse(ds.Tables[0].Rows[0]["Ext3LockExpDate"].ToString()); } if (ds.Tables[0].Rows[0]["Ext3LockTime"].ToString() != "") { model.Ext3LockTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext3LockTime"].ToString()); } model.Ext3LockedBy = ds.Tables[0].Rows[0]["Ext3LockedBy"].ToString(); if (ds.Tables[0].Rows[0]["Ext3ConfirmTime"].ToString() != "") { model.Ext3ConfirmTime = DateTime.Parse(ds.Tables[0].Rows[0]["Ext3ConfirmTime"].ToString()); } if (ds.Tables[0].Rows[0]["InvestorID"].ToString() != "") { model.InvestorID = int.Parse(ds.Tables[0].Rows[0]["InvestorID"].ToString()); } model.Investor = ds.Tables[0].Rows[0]["Investor"].ToString(); if (ds.Tables[0].Rows[0]["ProgramID"].ToString() != "") { model.ProgramID = int.Parse(ds.Tables[0].Rows[0]["ProgramID"].ToString()); } model.Program = ds.Tables[0].Rows[0]["Program"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(LPWeb.Model.LoanLocks model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LoanLocks("); strSql.Append("FileId,LockOption,LockedBy,LockTime,LockTerm,ConfirmedBy,ConfirmTime,LockExpirationDate,Ext1Term,Ext1LockExpDate,Ext1LockTime,Ext1LockedBy,Ext1ConfirmTime,Ext2Term,Ext2LockExpDate,Ext2LockTime,Ext2LockedBy,Ext2ConfirmTime,Ext3Term,Ext3LockExpDate,Ext3LockTime,Ext3LockedBy,Ext3ConfirmTime,InvestorID,Investor,ProgramID,Program)"); strSql.Append(" values ("); strSql.Append("@FileId,@LockOption,@LockedBy,@LockTime,@LockTerm,@ConfirmedBy,@ConfirmTime,@LockExpirationDate,@Ext1Term,@Ext1LockExpDate,@Ext1LockTime,@Ext1LockedBy,@Ext1ConfirmTime,@Ext2Term,@Ext2LockExpDate,@Ext2LockTime,@Ext2LockedBy,@Ext2ConfirmTime,@Ext3Term,@Ext3LockExpDate,@Ext3LockTime,@Ext3LockedBy,@Ext3ConfirmTime,@InvestorID,@Investor,@ProgramID,@Program)"); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.Int, 4), new SqlParameter("@LockOption", SqlDbType.NVarChar, 50), new SqlParameter("@LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@LockTime", SqlDbType.DateTime), new SqlParameter("@LockTerm", SqlDbType.SmallInt, 2), new SqlParameter("@ConfirmedBy", SqlDbType.NVarChar, 255), new SqlParameter("@ConfirmTime", SqlDbType.DateTime), new SqlParameter("@LockExpirationDate", SqlDbType.Date, 3), new SqlParameter("@Ext1Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext1LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext1LockTime", SqlDbType.DateTime), new SqlParameter("@Ext1LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext1ConfirmTime", SqlDbType.DateTime), new SqlParameter("@Ext2Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext2LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext2LockTime", SqlDbType.DateTime), new SqlParameter("@Ext2LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext2ConfirmTime", SqlDbType.DateTime), new SqlParameter("@Ext3Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext3LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext3LockTime", SqlDbType.DateTime), new SqlParameter("@Ext3LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext3ConfirmTime", SqlDbType.DateTime), new SqlParameter("@InvestorID", SqlDbType.Int, 4), new SqlParameter("@Investor", SqlDbType.NVarChar, 255), new SqlParameter("@ProgramID", SqlDbType.Int, 4), new SqlParameter("@Program", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.FileId; parameters[1].Value = model.LockOption; parameters[2].Value = model.LockedBy; parameters[3].Value = model.LockTime; parameters[4].Value = model.LockTerm; parameters[5].Value = model.ConfirmedBy; parameters[6].Value = model.ConfirmTime; parameters[7].Value = model.LockExpirationDate; parameters[8].Value = model.Ext1Term; parameters[9].Value = model.Ext1LockExpDate; parameters[10].Value = model.Ext1LockTime; parameters[11].Value = model.Ext1LockedBy; parameters[12].Value = model.Ext1ConfirmTime; parameters[13].Value = model.Ext2Term; parameters[14].Value = model.Ext2LockExpDate; parameters[15].Value = model.Ext2LockTime; parameters[16].Value = model.Ext2LockedBy; parameters[17].Value = model.Ext2ConfirmTime; parameters[18].Value = model.Ext3Term; parameters[19].Value = model.Ext3LockExpDate; parameters[20].Value = model.Ext3LockTime; parameters[21].Value = model.Ext3LockedBy; parameters[22].Value = model.Ext3ConfirmTime; parameters[23].Value = model.InvestorID; parameters[24].Value = model.Investor; parameters[25].Value = model.ProgramID; parameters[26].Value = model.Program; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LPWeb.Model.LoanLocks model) { if (model == null || model.FileId <= 0) { return(false); } StringBuilder strSql = new StringBuilder(); strSql.Append("update LoanLocks set "); strSql.Append("LockOption=@LockOption,"); strSql.Append("LockedBy=@LockedBy,"); strSql.Append("LockTime=@LockTime,"); strSql.Append("LockTerm=@LockTerm,"); strSql.Append("ConfirmedBy=@ConfirmedBy,"); strSql.Append("ConfirmTime=@ConfirmTime,"); strSql.Append("LockExpirationDate=@LockExpirationDate,"); strSql.Append("Ext1Term=@Ext1Term,"); strSql.Append("Ext1LockExpDate=@Ext1LockExpDate,"); strSql.Append("Ext1LockTime=@Ext1LockTime,"); strSql.Append("Ext1LockedBy=@Ext1LockedBy,"); strSql.Append("Ext1ConfirmTime=@Ext1ConfirmTime,"); strSql.Append("Ext2Term=@Ext2Term,"); strSql.Append("Ext2LockExpDate=@Ext2LockExpDate,"); strSql.Append("Ext2LockTime=@Ext2LockTime,"); strSql.Append("Ext2LockedBy=@Ext2LockedBy,"); strSql.Append("Ext2ConfirmTime=@Ext2ConfirmTime,"); strSql.Append("Ext3Term=@Ext3Term,"); strSql.Append("Ext3LockExpDate=@Ext3LockExpDate,"); strSql.Append("Ext3LockTime=@Ext3LockTime,"); strSql.Append("Ext3LockedBy=@Ext3LockedBy,"); strSql.Append("Ext3ConfirmTime=@Ext3ConfirmTime,"); strSql.Append("InvestorID=@InvestorID,"); strSql.Append("Investor=@Investor,"); strSql.Append("ProgramID=@ProgramID,"); strSql.Append("Program=@Program "); strSql.Append(" where FileId=@FileId "); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.Int, 4), new SqlParameter("@LockOption", SqlDbType.NVarChar, 50), new SqlParameter("@LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@LockTime", SqlDbType.DateTime), new SqlParameter("@LockTerm", SqlDbType.SmallInt, 2), new SqlParameter("@ConfirmedBy", SqlDbType.NVarChar, 255), new SqlParameter("@ConfirmTime", SqlDbType.DateTime), new SqlParameter("@LockExpirationDate", SqlDbType.Date, 3), new SqlParameter("@Ext1Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext1LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext1LockTime", SqlDbType.DateTime), new SqlParameter("@Ext1LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext1ConfirmTime", SqlDbType.DateTime), new SqlParameter("@Ext2Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext2LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext2LockTime", SqlDbType.DateTime), new SqlParameter("@Ext2LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext2ConfirmTime", SqlDbType.DateTime), new SqlParameter("@Ext3Term", SqlDbType.SmallInt, 2), new SqlParameter("@Ext3LockExpDate", SqlDbType.Date, 3), new SqlParameter("@Ext3LockTime", SqlDbType.DateTime), new SqlParameter("@Ext3LockedBy", SqlDbType.NVarChar, 255), new SqlParameter("@Ext3ConfirmTime", SqlDbType.DateTime), new SqlParameter("@InvestorID", SqlDbType.Int, 4), new SqlParameter("@Investor", SqlDbType.NVarChar, 255), new SqlParameter("@ProgramID", SqlDbType.Int, 4), new SqlParameter("@Program", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.FileId; parameters[1].Value = model.LockOption; parameters[2].Value = model.LockedBy; parameters[3].Value = model.LockTime; parameters[4].Value = model.LockTerm; parameters[5].Value = model.ConfirmedBy; parameters[6].Value = model.ConfirmTime; parameters[7].Value = model.LockExpirationDate; parameters[8].Value = model.Ext1Term; parameters[9].Value = model.Ext1LockExpDate; parameters[10].Value = model.Ext1LockTime; parameters[11].Value = model.Ext1LockedBy; parameters[12].Value = model.Ext1ConfirmTime; parameters[13].Value = model.Ext2Term; parameters[14].Value = model.Ext2LockExpDate; parameters[15].Value = model.Ext2LockTime; parameters[16].Value = model.Ext2LockedBy; parameters[17].Value = model.Ext2ConfirmTime; parameters[18].Value = model.Ext3Term; parameters[19].Value = model.Ext3LockExpDate; parameters[20].Value = model.Ext3LockTime; parameters[21].Value = model.Ext3LockedBy; parameters[22].Value = model.Ext3ConfirmTime; if (model.InvestorID <= 0) { parameters[23].Value = DBNull.Value; } else { parameters[23].Value = model.InvestorID; } parameters[24].Value = model.Investor; if (model.ProgramID <= 0) { parameters[25].Value = DBNull.Value; } else { parameters[25].Value = model.ProgramID; } parameters[26].Value = model.Program; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }