/// <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)); }