/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.LoanAlerts model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.LoanAlerts> DataTableToList(DataTable dt)
{
List <LPWeb.Model.LoanAlerts> modelList = new List <LPWeb.Model.LoanAlerts>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.LoanAlerts model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.LoanAlerts();
if (dt.Rows[n]["LoanAlertId"].ToString() != "")
{
model.LoanAlertId = int.Parse(dt.Rows[n]["LoanAlertId"].ToString());
}
if (dt.Rows[n]["FileId"].ToString() != "")
{
model.FileId = int.Parse(dt.Rows[n]["FileId"].ToString());
}
model.Desc = dt.Rows[n]["Desc"].ToString();
if (dt.Rows[n]["DueDate"].ToString() != "")
{
model.DueDate = DateTime.Parse(dt.Rows[n]["DueDate"].ToString());
}
if (dt.Rows[n]["ClearedBy"].ToString() != "")
{
model.ClearedBy = int.Parse(dt.Rows[n]["ClearedBy"].ToString());
}
if (dt.Rows[n]["Cleared"].ToString() != "")
{
model.Cleared = DateTime.Parse(dt.Rows[n]["Cleared"].ToString());
}
if (dt.Rows[n]["AcknowlegeReq"].ToString() != "")
{
if ((dt.Rows[n]["AcknowlegeReq"].ToString() == "1") || (dt.Rows[n]["AcknowlegeReq"].ToString().ToLower() == "true"))
{
model.AcknowlegeReq = true;
}
else
{
model.AcknowlegeReq = false;
}
}
model.AcknowledgedBy = dt.Rows[n]["AcknowledgedBy"].ToString();
if (dt.Rows[n]["Acknowledged"].ToString() != "")
{
model.Acknowledged = DateTime.Parse(dt.Rows[n]["Acknowledged"].ToString());
}
if (dt.Rows[n]["LoanRuleId"].ToString() != "")
{
model.LoanRuleId = int.Parse(dt.Rows[n]["LoanRuleId"].ToString());
}
if (dt.Rows[n]["OwnerId"].ToString() != "")
{
model.OwnerId = int.Parse(dt.Rows[n]["OwnerId"].ToString());
}
if (dt.Rows[n]["LoanTaskId"].ToString() != "")
{
model.LoanTaskId = int.Parse(dt.Rows[n]["LoanTaskId"].ToString());
}
model.AlertType = dt.Rows[n]["AlertType"].ToString();
if (dt.Rows[n]["DateCreated"].ToString() != "")
{
model.DateCreated = DateTime.Parse(dt.Rows[n]["DateCreated"].ToString());
}
model.Status = dt.Rows[n]["Status"].ToString();
if (dt.Rows[n]["Accepted"].ToString() != "")
{
model.Accepted = DateTime.Parse(dt.Rows[n]["Accepted"].ToString());
}
if (dt.Rows[n]["Declined"].ToString() != "")
{
model.Declined = DateTime.Parse(dt.Rows[n]["Declined"].ToString());
}
if (dt.Rows[n]["Dismissed"].ToString() != "")
{
model.Dismissed = DateTime.Parse(dt.Rows[n]["Dismissed"].ToString());
}
model.AcceptedBy = dt.Rows[n]["AcceptedBy"].ToString();
model.DeclinedBy = dt.Rows[n]["DeclinedBy"].ToString();
model.DismissedBy = dt.Rows[n]["DismissedBy"].ToString();
if (dt.Rows[n]["AlertEmail"].ToString() != "")
{
model.AlertEmail = (byte[])dt.Rows[n]["AlertEmail"];
}
if (dt.Rows[n]["RecomEmail"].ToString() != "")
{
model.RecomEmail = (byte[])dt.Rows[n]["RecomEmail"];
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.LoanAlerts model)
{
return(dal.Add(model));
}
