/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.LoanAlerts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LoanAlerts(");
strSql.Append("FileId,Desc,DueDate,ClearedBy,Cleared,AcknowlegeReq,AcknowledgedBy,Acknowledged,LoanRuleId,OwnerId,LoanTaskId,AlertType,DateCreated,Status,Accepted,Declined,Dismissed,AcceptedBy,DeclinedBy,DismissedBy,AlertEmail,RecomEmail)");
strSql.Append(" values (");
strSql.Append("@FileId,@Desc,@DueDate,@ClearedBy,@Cleared,@AcknowlegeReq,@AcknowledgedBy,@Acknowledged,@LoanRuleId,@OwnerId,@LoanTaskId,@AlertType,@DateCreated,@Status,@Accepted,@Declined,@Dismissed,@AcceptedBy,@DeclinedBy,@DismissedBy,@AlertEmail,@RecomEmail)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FileId", SqlDbType.Int, 4),
new SqlParameter("@Desc", SqlDbType.NVarChar, 255),
new SqlParameter("@DueDate", SqlDbType.DateTime),
new SqlParameter("@ClearedBy", SqlDbType.Int, 4),
new SqlParameter("@Cleared", SqlDbType.DateTime),
new SqlParameter("@AcknowlegeReq", SqlDbType.Bit, 1),
new SqlParameter("@AcknowledgedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@Acknowledged", SqlDbType.DateTime),
new SqlParameter("@LoanRuleId", SqlDbType.Int, 4),
new SqlParameter("@OwnerId", SqlDbType.Int, 4),
new SqlParameter("@LoanTaskId", SqlDbType.Int, 4),
new SqlParameter("@AlertType", SqlDbType.NVarChar, 50),
new SqlParameter("@DateCreated", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Accepted", SqlDbType.DateTime),
new SqlParameter("@Declined", SqlDbType.DateTime),
new SqlParameter("@Dismissed", SqlDbType.DateTime),
new SqlParameter("@AcceptedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@DeclinedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@DismissedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@AlertEmail", SqlDbType.VarBinary),
new SqlParameter("@RecomEmail", SqlDbType.VarBinary)
};
parameters[0].Value = model.FileId;
parameters[1].Value = model.Desc;
parameters[2].Value = model.DueDate;
parameters[3].Value = model.ClearedBy;
parameters[4].Value = model.Cleared;
parameters[5].Value = model.AcknowlegeReq;
parameters[6].Value = model.AcknowledgedBy;
parameters[7].Value = model.Acknowledged;
parameters[8].Value = model.LoanRuleId;
parameters[9].Value = model.OwnerId;
parameters[10].Value = model.LoanTaskId;
parameters[11].Value = model.AlertType;
parameters[12].Value = model.DateCreated;
parameters[13].Value = model.Status;
parameters[14].Value = model.Accepted;
parameters[15].Value = model.Declined;
parameters[16].Value = model.Dismissed;
parameters[17].Value = model.AcceptedBy;
parameters[18].Value = model.DeclinedBy;
parameters[19].Value = model.DismissedBy;
parameters[20].Value = model.AlertEmail;
parameters[21].Value = model.RecomEmail;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.LoanAlerts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update LoanAlerts set ");
strSql.Append("LoanAlertId=@LoanAlertId,");
strSql.Append("FileId=@FileId,");
strSql.Append("Desc=@Desc,");
strSql.Append("DueDate=@DueDate,");
strSql.Append("ClearedBy=@ClearedBy,");
strSql.Append("Cleared=@Cleared,");
strSql.Append("AcknowlegeReq=@AcknowlegeReq,");
strSql.Append("AcknowledgedBy=@AcknowledgedBy,");
strSql.Append("Acknowledged=@Acknowledged,");
strSql.Append("LoanRuleId=@LoanRuleId,");
strSql.Append("OwnerId=@OwnerId,");
strSql.Append("LoanTaskId=@LoanTaskId,");
strSql.Append("AlertType=@AlertType,");
strSql.Append("DateCreated=@DateCreated,");
strSql.Append("Status=@Status,");
strSql.Append("Accepted=@Accepted,");
strSql.Append("Declined=@Declined,");
strSql.Append("Dismissed=@Dismissed,");
strSql.Append("AcceptedBy=@AcceptedBy,");
strSql.Append("DeclinedBy=@DeclinedBy,");
strSql.Append("DismissedBy=@DismissedBy,");
strSql.Append("AlertEmail=@AlertEmail,");
strSql.Append("RecomEmail=@RecomEmail");
strSql.Append(" where LoanAlertId=@LoanAlertId ");
SqlParameter[] parameters =
{
new SqlParameter("@LoanAlertId", SqlDbType.Int, 4),
new SqlParameter("@FileId", SqlDbType.Int, 4),
new SqlParameter("@Desc", SqlDbType.NVarChar, 255),
new SqlParameter("@DueDate", SqlDbType.DateTime),
new SqlParameter("@ClearedBy", SqlDbType.Int, 4),
new SqlParameter("@Cleared", SqlDbType.DateTime),
new SqlParameter("@AcknowlegeReq", SqlDbType.Bit, 1),
new SqlParameter("@AcknowledgedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@Acknowledged", SqlDbType.DateTime),
new SqlParameter("@LoanRuleId", SqlDbType.Int, 4),
new SqlParameter("@OwnerId", SqlDbType.Int, 4),
new SqlParameter("@LoanTaskId", SqlDbType.Int, 4),
new SqlParameter("@AlertType", SqlDbType.NVarChar, 50),
new SqlParameter("@DateCreated", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Accepted", SqlDbType.DateTime),
new SqlParameter("@Declined", SqlDbType.DateTime),
new SqlParameter("@Dismissed", SqlDbType.DateTime),
new SqlParameter("@AcceptedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@DeclinedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@DismissedBy", SqlDbType.NVarChar, 200),
new SqlParameter("@AlertEmail", SqlDbType.VarBinary),
new SqlParameter("@RecomEmail", SqlDbType.VarBinary)
};
parameters[0].Value = model.LoanAlertId;
parameters[1].Value = model.FileId;
parameters[2].Value = model.Desc;
parameters[3].Value = model.DueDate;
parameters[4].Value = model.ClearedBy;
parameters[5].Value = model.Cleared;
parameters[6].Value = model.AcknowlegeReq;
parameters[7].Value = model.AcknowledgedBy;
parameters[8].Value = model.Acknowledged;
parameters[9].Value = model.LoanRuleId;
parameters[10].Value = model.OwnerId;
parameters[11].Value = model.LoanTaskId;
parameters[12].Value = model.AlertType;
parameters[13].Value = model.DateCreated;
parameters[14].Value = model.Status;
parameters[15].Value = model.Accepted;
parameters[16].Value = model.Declined;
parameters[17].Value = model.Dismissed;
parameters[18].Value = model.AcceptedBy;
parameters[19].Value = model.DeclinedBy;
parameters[20].Value = model.DismissedBy;
parameters[21].Value = model.AlertEmail;
parameters[22].Value = model.RecomEmail;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.LoanAlerts GetModel(int LoanAlertId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 LoanAlertId,FileId,Desc,DueDate,ClearedBy,Cleared,AcknowlegeReq,AcknowledgedBy,Acknowledged,LoanRuleId,OwnerId,LoanTaskId,AlertType,DateCreated,Status,Accepted,Declined,Dismissed,AcceptedBy,DeclinedBy,DismissedBy,AlertEmail,RecomEmail from LoanAlerts ");
strSql.Append(" where LoanAlertId=@LoanAlertId ");
SqlParameter[] parameters =
{
new SqlParameter("@LoanAlertId", SqlDbType.Int, 4)
};
parameters[0].Value = LoanAlertId;
LPWeb.Model.LoanAlerts model = new LPWeb.Model.LoanAlerts();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["LoanAlertId"].ToString() != "")
{
model.LoanAlertId = int.Parse(ds.Tables[0].Rows[0]["LoanAlertId"].ToString());
}
if (ds.Tables[0].Rows[0]["FileId"].ToString() != "")
{
model.FileId = int.Parse(ds.Tables[0].Rows[0]["FileId"].ToString());
}
model.Desc = ds.Tables[0].Rows[0]["Desc"].ToString();
if (ds.Tables[0].Rows[0]["DueDate"].ToString() != "")
{
model.DueDate = DateTime.Parse(ds.Tables[0].Rows[0]["DueDate"].ToString());
}
if (ds.Tables[0].Rows[0]["ClearedBy"].ToString() != "")
{
model.ClearedBy = int.Parse(ds.Tables[0].Rows[0]["ClearedBy"].ToString());
}
if (ds.Tables[0].Rows[0]["Cleared"].ToString() != "")
{
model.Cleared = DateTime.Parse(ds.Tables[0].Rows[0]["Cleared"].ToString());
}
if (ds.Tables[0].Rows[0]["AcknowlegeReq"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["AcknowlegeReq"].ToString() == "1") || (ds.Tables[0].Rows[0]["AcknowlegeReq"].ToString().ToLower() == "true"))
{
model.AcknowlegeReq = true;
}
else
{
model.AcknowlegeReq = false;
}
}
model.AcknowledgedBy = ds.Tables[0].Rows[0]["AcknowledgedBy"].ToString();
if (ds.Tables[0].Rows[0]["Acknowledged"].ToString() != "")
{
model.Acknowledged = DateTime.Parse(ds.Tables[0].Rows[0]["Acknowledged"].ToString());
}
if (ds.Tables[0].Rows[0]["LoanRuleId"].ToString() != "")
{
model.LoanRuleId = int.Parse(ds.Tables[0].Rows[0]["LoanRuleId"].ToString());
}
if (ds.Tables[0].Rows[0]["OwnerId"].ToString() != "")
{
model.OwnerId = int.Parse(ds.Tables[0].Rows[0]["OwnerId"].ToString());
}
if (ds.Tables[0].Rows[0]["LoanTaskId"].ToString() != "")
{
model.LoanTaskId = int.Parse(ds.Tables[0].Rows[0]["LoanTaskId"].ToString());
}
model.AlertType = ds.Tables[0].Rows[0]["AlertType"].ToString();
if (ds.Tables[0].Rows[0]["DateCreated"].ToString() != "")
{
model.DateCreated = DateTime.Parse(ds.Tables[0].Rows[0]["DateCreated"].ToString());
}
model.Status = ds.Tables[0].Rows[0]["Status"].ToString();
if (ds.Tables[0].Rows[0]["Accepted"].ToString() != "")
{
model.Accepted = DateTime.Parse(ds.Tables[0].Rows[0]["Accepted"].ToString());
}
if (ds.Tables[0].Rows[0]["Declined"].ToString() != "")
{
model.Declined = DateTime.Parse(ds.Tables[0].Rows[0]["Declined"].ToString());
}
if (ds.Tables[0].Rows[0]["Dismissed"].ToString() != "")
{
model.Dismissed = DateTime.Parse(ds.Tables[0].Rows[0]["Dismissed"].ToString());
}
model.AcceptedBy = ds.Tables[0].Rows[0]["AcceptedBy"].ToString();
model.DeclinedBy = ds.Tables[0].Rows[0]["DeclinedBy"].ToString();
model.DismissedBy = ds.Tables[0].Rows[0]["DismissedBy"].ToString();
if (ds.Tables[0].Rows[0]["AlertEmail"].ToString() != "")
{
model.AlertEmail = (byte[])ds.Tables[0].Rows[0]["AlertEmail"];
}
if (ds.Tables[0].Rows[0]["RecomEmail"].ToString() != "")
{
model.RecomEmail = (byte[])ds.Tables[0].Rows[0]["RecomEmail"];
}
return(model);
}
else
{
return(null);
}
}
