/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.LoanTask_CompletionEmails> DataTableToList(DataTable dt) { List <LPWeb.Model.LoanTask_CompletionEmails> modelList = new List <LPWeb.Model.LoanTask_CompletionEmails>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.LoanTask_CompletionEmails model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.LoanTask_CompletionEmails(); if (dt.Rows[n]["TaskCompletionEmailId"] != null && dt.Rows[n]["TaskCompletionEmailId"].ToString() != "") { model.TaskCompletionEmailId = int.Parse(dt.Rows[n]["TaskCompletionEmailId"].ToString()); } if (dt.Rows[n]["LoanTaskid"] != null && dt.Rows[n]["LoanTaskid"].ToString() != "") { model.LoanTaskid = int.Parse(dt.Rows[n]["LoanTaskid"].ToString()); } if (dt.Rows[n]["TemplEmailId"] != null && dt.Rows[n]["TemplEmailId"].ToString() != "") { model.TemplEmailId = int.Parse(dt.Rows[n]["TemplEmailId"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 保存任务完成邮件模板关系 /// </summary> /// <param name="iLoanTaskId"></param> public void SaveCompletetionEmails(int iLoanTaskId) { var tmp = hdnCompletionEmail.Value; if (string.IsNullOrEmpty(tmp)) { return; } var tmpList = tmp.Split('|').ToList(); LPWeb.BLL.LoanTask_CompletionEmails blltaskMail = new LoanTask_CompletionEmails(); var tmpidList = new List <int> { }; foreach (var item in tmpList) { var list = item.Split(',').ToList(); if (list.Count == 3 && !string.IsNullOrEmpty(list[1]) && !string.IsNullOrEmpty(list[2]) && Convert.ToInt32(list[1]) != 0) { int templEmailId = Convert.ToInt32(list[1]); if (tmpidList.Contains(templEmailId)) { continue; } LPWeb.Model.LoanTask_CompletionEmails modMail = new LPWeb.Model.LoanTask_CompletionEmails(); modMail.LoanTaskid = iLoanTaskId; modMail.TemplEmailId = Convert.ToInt32(list[1]); modMail.Enabled = list[2] == "1" ? true : false; blltaskMail.Add(modMail); tmpidList.Add(templEmailId); } } }
/// <summary> /// 保存任务完成邮件模板关系 /// </summary> /// <param name="iLoanTaskId"></param> public void SaveCompletetionEmails(int iLoanTaskId) { var tmp = hdnCompletionEmail.Value; LPWeb.BLL.LoanTask_CompletionEmails blltaskMail = new LoanTask_CompletionEmails(); var ds = blltaskMail.GetList("LoanTaskid=" + iTaskID); //数据库中原有数据 List <int> IdList = ds.Tables[0].AsEnumerable().Select(c => c.Field <int>("TaskCompletionEmailId")).ToList(); List <int> tmpIdList = ds.Tables[0].AsEnumerable().Select(c => c.Field <int>("TemplEmailId")).ToList(); var oldDataList = ds.Tables[0].AsEnumerable().Select(c => new { Id = c.Field <int>("TaskCompletionEmailId"), tmpId = c.Field <int>("TemplEmailId") }).ToList(); if (string.IsNullOrEmpty(tmp) && IdList.Count == 0) { return; } if (!string.IsNullOrEmpty(tmp)) { var tmpList = tmp.Split('|').ToList(); foreach (var item in tmpList) { var list = item.Split(',').ToList(); if (list.Count == 3 && !string.IsNullOrEmpty(list[1]) && !string.IsNullOrEmpty(list[2]) && Convert.ToInt32(list[1]) != 0) { int Id = Convert.ToInt32(list[0]); int templEmailId = Convert.ToInt32(list[1]); bool enabled = list[2] == "1" ? true : false; var oldData = oldDataList.Where(c => c.tmpId == templEmailId).FirstOrDefault(); if (tmpIdList.Contains(templEmailId) && oldData != null & oldData.Id != Id) { continue; } else if (Id == 0) { LPWeb.Model.LoanTask_CompletionEmails modMail = new LPWeb.Model.LoanTask_CompletionEmails(); modMail.LoanTaskid = iLoanTaskId; modMail.TemplEmailId = templEmailId; modMail.Enabled = enabled; blltaskMail.Add(modMail); tmpIdList.Add(templEmailId); } else if (IdList.Where(c => c == Id).Count() > 0) { LPWeb.Model.LoanTask_CompletionEmails modMail = new LPWeb.Model.LoanTask_CompletionEmails(); modMail.TaskCompletionEmailId = Id; modMail.LoanTaskid = iLoanTaskId; modMail.TemplEmailId = templEmailId; modMail.Enabled = enabled; blltaskMail.Update(modMail); IdList.Remove(Id); } } } } //删除 if (IdList.Count > 0) { var allDelId = string.Empty; foreach (var Id in IdList) { allDelId += "," + Id; } if (!string.IsNullOrEmpty(allDelId)) { allDelId = allDelId.Remove(0, 1); } blltaskMail.DeleteList(allDelId); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LPWeb.Model.LoanTask_CompletionEmails model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LPWeb.Model.LoanTask_CompletionEmails model) { return(dal.Add(model)); }