/// <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); } }
protected void Page_Load(object sender, EventArgs e) { #region 检查必要参数 string sErrorJs = string.Empty; if (this.Request.QueryString["CloseDialogCodes"] == null) { sErrorJs = "window.parent.RefreshPage();"; } else { sErrorJs = this.Request.QueryString["CloseDialogCodes"] + ";"; } bool bIsValid = PageCommon.ValidateQueryString(this, "LoanID", QueryStringType.ID); if (bIsValid == false) { PageCommon.RegisterJsMsg(this, "Missing required query string.", sErrorJs); return; } this.iLoanID = Convert.ToInt32(this.Request.QueryString["LoanID"]); bIsValid = PageCommon.ValidateQueryString(this, "TaskID", QueryStringType.ID); if (bIsValid == false) { PageCommon.RegisterJsMsg(this, "Missing required query string.", sErrorJs); return; } this.iTaskID = Convert.ToInt32(this.Request.QueryString["TaskID"]); #endregion #region 加载Loan Task信息 this.LoanTaskInfo = this.LoanTaskManager.GetLoanTaskInfo(this.iTaskID); if (this.LoanTaskInfo.Rows.Count == 0) { PageCommon.RegisterJsMsg(this, "Invalid required query string.", sErrorJs); return; } #endregion #region 检查是否是Prerequisite(is a father?) bool bIsPrerequisite = this.LoanTaskManager.IsPrerequisite(this.iTaskID); this.hndIsPrerequisite.Value = bIsPrerequisite.ToString(); #endregion #region 加载LoanInfo信息 DataTable LoanInfo = this.LoanManager.GetLoanInfo(this.iLoanID); if (LoanInfo.Rows.Count == 0) { PageCommon.RegisterJsMsg(this, "Invalid required query string.", sErrorJs); return; } // 存储Loan.EstCloseDate if (LoanInfo.Rows[0]["EstCloseDate"] != DBNull.Value) { this.hdnEstCloseDate.Value = Convert.ToDateTime(LoanInfo.Rows[0]["EstCloseDate"]).ToString("MM/dd/yyyy"); } #endregion if (this.IsPostBack == false) { #region 加载Owner DataTable OwnerList = this.LoanTaskManager.GetLoanTaskOwers(this.iLoanID); DataRow EmptyOwnerRow = OwnerList.NewRow(); EmptyOwnerRow["UserID"] = 0; EmptyOwnerRow["FullName"] = "-- select --"; OwnerList.Rows.InsertAt(EmptyOwnerRow, 0); this.ddlOwner.DataSource = OwnerList; this.ddlOwner.DataBind(); // 绑定Owner this.ddlOwner.SelectedValue = this.CurrUser.iUserID.ToString(); #endregion #region 加载ddlTaskList for TaskNaem LeadTaskList LeadTaskListMgr = new LeadTaskList(); string sOrderBy = string.Empty; if (this.CurrUser.SortTaskPickList == "S") { sOrderBy = "SequenceNumber"; } else { sOrderBy = "TaskName"; } DataTable LeadTaskList1 = LeadTaskListMgr.GetLeadTaskList(" and Enabled=1", sOrderBy); DataRow EmptyTaskRow = LeadTaskList1.NewRow(); EmptyTaskRow["TaskName"] = "-- select --"; LeadTaskList1.Rows.InsertAt(EmptyTaskRow, 0); this.ddlTaskList.DataSource = LeadTaskList1; this.ddlTaskList.DataBind(); #endregion #region 加载Prerequisite int iCurrentLoanStageId = Convert.ToInt32(this.LoanTaskInfo.Rows[0]["LoanStageId"]); DataTable PrerequisiteList = this.LoanTaskManager.GetPrerequisiteList(" and FileID=" + this.iLoanID + " and LoanStageId = " + iCurrentLoanStageId + " and PrerequisiteTaskId is null"); DataRow NonePrerequisiteRow = PrerequisiteList.NewRow(); NonePrerequisiteRow["LoanTaskId"] = 0; NonePrerequisiteRow["Name"] = "None"; PrerequisiteList.Rows.InsertAt(NonePrerequisiteRow, 0); this.ddlPrerequisite.DataSource = PrerequisiteList; this.ddlPrerequisite.DataBind(); this.ddlPrerequisite2.DataSource = PrerequisiteList; this.ddlPrerequisite2.DataBind(); #endregion #region 加载email template Template_Email EmailTempManager = new Template_Email(); this.EmailTemplates = EmailTempManager.GetEmailTemplate(" and Enabled = 1"); DataRow NoneEmailTemplateRow = this.EmailTemplates.NewRow(); NoneEmailTemplateRow["TemplEmailId"] = 0; NoneEmailTemplateRow["Name"] = "None"; this.EmailTemplates.Rows.InsertAt(NoneEmailTemplateRow, 0); this.ddlWarningEmail.DataSource = this.EmailTemplates; this.ddlWarningEmail.DataBind(); this.ddlOverdueEmail.DataSource = this.EmailTemplates; this.ddlOverdueEmail.DataBind(); this.ddlEmailTemplate.DataSource = this.EmailTemplates; this.ddlEmailTemplate.DataBind(); #endregion #region completion email list LPWeb.BLL.LoanTask_CompletionEmails bllTaskMail = new LoanTask_CompletionEmails(); gridCompletetionEmails.DataSource = bllTaskMail.GetList("LoanTaskid=" + iTaskID); gridCompletetionEmails.DataBind(); #endregion #region Stage //Template_Stages stage = new Template_Stages(); //var dtStage = stage.GetStageTemplateList(" And [Enabled] = 1 order by SequenceNumber "); LoanStages ls = new LoanStages(); var dtStage = ls.GetLoanStageSetupInfo(iLoanID); ddlStage.DataSource = dtStage; ddlStage.DataBind(); #endregion #region Bind Data ddlStage.SelectedValue = this.LoanTaskInfo.Rows[0]["LoanStageId"].ToString(); this.radTaskName.Checked = true; this.txtTaskName.Text = this.LoanTaskInfo.Rows[0]["Name"].ToString(); this.txtDescription.Text = this.LoanTaskInfo.Rows[0]["Desc"].ToString(); #region Owner string sOwnerID = this.LoanTaskInfo.Rows[0]["Owner"].ToString(); if (sOwnerID == string.Empty) { this.ddlOwner.SelectedIndex = 0; } else { this.ddlOwner.SelectedValue = sOwnerID; } #endregion #region Due Date string sDueDate = this.LoanTaskInfo.Rows[0]["Due"].ToString(); if (sDueDate != string.Empty) { this.txtDueDate.Text = Convert.ToDateTime(this.LoanTaskInfo.Rows[0]["Due"]).ToString("MM/dd/yyyy"); } string sDueTime = this.LoanTaskInfo.Rows[0]["DueTime"].ToString(); if (sDueTime != string.Empty) { TimeSpan DueTime = TimeSpan.Parse(this.LoanTaskInfo.Rows[0]["DueTime"].ToString()); this.txtDueTime.Text = DueTime.ToString().Substring(0, 5); ddlDueTime_hour.SelectedValue = DueTime.Hours.ToString(); ddlDueTime_min.SelectedValue = ((DueTime.Minutes / 5) * 5).ToString(); } #endregion //#region Completed Date string sCompletedDate = this.LoanTaskInfo.Rows[0]["Completed"].ToString(); if (sCompletedDate != string.Empty) { this.chkCompleted.Checked = true; this.txtCompletedDate.Text = Convert.ToDateTime(this.LoanTaskInfo.Rows[0]["Completed"]).ToString("MM/dd/yyyy"); this.hdnCompleted.Value = Convert.ToDateTime(this.LoanTaskInfo.Rows[0]["Completed"]).ToString("MM/dd/yyyy"); } //#endregion this.txtDaysToEst.Text = this.LoanTaskInfo.Rows[0]["DaysDueFromEstClose"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueFromEstClose"].ToString(); this.txtDaysAfterCreation.Text = this.LoanTaskInfo.Rows[0]["DaysFromCreation"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysFromCreation"].ToString(); this.txtDaysDueAfterPrevStage.Text = this.LoanTaskInfo.Rows[0]["DaysDueAfterPrevStage"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueAfterPrevStage"].ToString(); #region Prerequisite Task Id string sPrerequisiteTaskId = this.LoanTaskInfo.Rows[0]["PrerequisiteTaskId"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["PrerequisiteTaskId"].ToString(); if (sPrerequisiteTaskId == string.Empty) { this.ddlPrerequisite.SelectedIndex = 0; } else { this.ddlPrerequisite.SelectedValue = sPrerequisiteTaskId; } #endregion this.txtDaysDueAfter.Text = LoanTaskInfo.Rows[0]["DaysDueAfterPrerequisite"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueAfterPrerequisite"].ToString(); #region Warning Email string sWarningEmailId = this.LoanTaskInfo.Rows[0]["WarningEmailId"].ToString(); if (sWarningEmailId == string.Empty) { this.ddlWarningEmail.SelectedIndex = 0; } else { this.ddlWarningEmail.SelectedValue = sWarningEmailId; } #endregion #region Overdue Email string sOverdueEmailId = this.LoanTaskInfo.Rows[0]["OverdueEmailId"].ToString(); if (sOverdueEmailId == string.Empty) { this.ddlOverdueEmail.SelectedIndex = 0; } else { this.ddlOverdueEmail.SelectedValue = sOverdueEmailId; } #endregion #endregion } }
protected void Page_Load(object sender, EventArgs e) { string sErrorJs = "window.parent.CloseDialog_EditTask();"; #region 检查必要参数 bool bIsValid = PageCommon.ValidateQueryString(this, "LoanID", QueryStringType.ID); if (bIsValid == false) { PageCommon.RegisterJsMsg(this, "Missing required query string.", sErrorJs); return; } this.iLoanID = Convert.ToInt32(this.Request.QueryString["LoanID"]); bIsValid = PageCommon.ValidateQueryString(this, "TaskID", QueryStringType.ID); if (bIsValid == false) { PageCommon.RegisterJsMsg(this, "Missing required query string.", sErrorJs); return; } this.iTaskID = Convert.ToInt32(this.Request.QueryString["TaskID"]); #endregion // server now this.hdnNow.Value = DateTime.Now.ToString("MM/dd/yyyy"); // task icon this.imgTaskIcon.ImageUrl = "../images/task/" + WorkflowManager.GetTaskIcon(this.iTaskID); #region 加载Loan Task信息 this.LoanTaskInfo = this.LoanTaskManager.GetLoanTaskInfo(this.iTaskID); if (this.LoanTaskInfo.Rows.Count == 0) { PageCommon.RegisterJsMsg(this, "Invalid required query string.", sErrorJs); return; } #endregion #region 检查是否是Prerequisite(is a father?) bool bIsPrerequisite = this.LoanTaskManager.IsPrerequisite(this.iTaskID); this.hndIsPrerequisite.Value = bIsPrerequisite.ToString(); #endregion #region 获取Borrower和Property信息 #region Property DataTable LoanInfo = this.LoanManager.GetLoanInfo(this.iLoanID); if (LoanInfo.Rows.Count == 0) { PageCommon.RegisterJsMsg(this, "Invalid required query string.", sErrorJs); return; } string sPropertyAddress = LoanInfo.Rows[0]["PropertyAddr"].ToString(); string sPropertyCity = LoanInfo.Rows[0]["PropertyCity"].ToString(); string sPropertyState = LoanInfo.Rows[0]["PropertyState"].ToString(); string sPropertyZip = LoanInfo.Rows[0]["PropertyZip"].ToString(); string sProperty = sPropertyAddress + ", " + sPropertyCity + ", " + sPropertyState + " " + sPropertyZip; // 存储Loan.EstCloseDate if (LoanInfo.Rows[0]["EstCloseDate"] != DBNull.Value) { this.hdnEstCloseDate.Value = Convert.ToDateTime(LoanInfo.Rows[0]["EstCloseDate"]).ToString("MM/dd/yyyy"); } #endregion #region Borrower DataTable BorrowerInfo = this.LoanManager.GetBorrowerInfo(this.iLoanID); if (BorrowerInfo.Rows.Count == 0) { PageCommon.RegisterJsMsg(this, "There is no Borrower in this loan.", sErrorJs); return; } string sFirstName = BorrowerInfo.Rows[0]["FirstName"].ToString(); string sMiddleName = BorrowerInfo.Rows[0]["MiddleName"].ToString(); string sLastName = BorrowerInfo.Rows[0]["LastName"].ToString(); string sBorrower = sLastName + ", " + sFirstName; if (sMiddleName != string.Empty) { sBorrower += " " + sMiddleName; } this.lbProperty.Text = sProperty; this.lbBorrower.Text = sBorrower; #endregion #endregion if (this.IsPostBack == false) { #region 加载Stage DataTable LoanStages = this.LoanManager.GetLoanStages(this.iLoanID); this.ddlStage.DataSource = LoanStages; this.ddlStage.DataBind(); this.ddlStage2.DataSource = LoanStages; this.ddlStage2.DataBind(); #endregion #region 加载Owner DataTable OwnerList = this.LoanTaskManager.GetLoanTaskOwers(this.iLoanID); DataRow EmptyOwnerRow = OwnerList.NewRow(); EmptyOwnerRow["UserID"] = 0; EmptyOwnerRow["FullName"] = "-- select a task owner--"; OwnerList.Rows.InsertAt(EmptyOwnerRow, 0); this.ddlOwner.DataSource = OwnerList; this.ddlOwner.DataBind(); #endregion #region 加载Prerequisite // 先绑定Stage this.ddlStage.SelectedValue = this.LoanTaskInfo.Rows[0]["LoanStageId"].ToString(); string sSelectedStageID = string.Empty; if (this.Request.QueryString["Stage"] == null) { sSelectedStageID = this.ddlStage.SelectedItem.Value; } else { sSelectedStageID = this.Request.QueryString["Stage"].ToString(); } DataTable PrerequisiteList = this.LoanTaskManager.GetPrerequisiteList(" and FileID=" + this.iLoanID + " and LoanStageId = " + sSelectedStageID + " and PrerequisiteTaskId is null and LoanTaskId !=" + iTaskID); DataRow NonePrerequisiteRow = PrerequisiteList.NewRow(); NonePrerequisiteRow["LoanTaskId"] = 0; NonePrerequisiteRow["Name"] = "None"; PrerequisiteList.Rows.InsertAt(NonePrerequisiteRow, 0); this.ddlPrerequisite.DataSource = PrerequisiteList; this.ddlPrerequisite.DataBind(); this.ddlPrerequisite2.DataSource = PrerequisiteList; this.ddlPrerequisite2.DataBind(); #endregion #region 加载email template Template_Email EmailTempManager = new Template_Email(); EmailTemplates = EmailTempManager.GetEmailTemplate(" and Enabled = 1"); DataRow NoneEmailTemplateRow = EmailTemplates.NewRow(); NoneEmailTemplateRow["TemplEmailId"] = 0; NoneEmailTemplateRow["Name"] = "None"; EmailTemplates.Rows.InsertAt(NoneEmailTemplateRow, 0); this.ddlCompletionEmail.DataSource = EmailTemplates; this.ddlCompletionEmail.DataBind(); this.ddlWarningEmail.DataSource = EmailTemplates; this.ddlWarningEmail.DataBind(); this.ddlOverdueEmail.DataSource = EmailTemplates; this.ddlOverdueEmail.DataBind(); this.ddlEmailTemplate.DataSource = EmailTemplates; this.ddlEmailTemplate.DataBind(); #endregion #region 绑定对应模板列表 LPWeb.BLL.LoanTask_CompletionEmails bllTaskMail = new LoanTask_CompletionEmails(); gridCompletetionEmails.DataSource = bllTaskMail.GetList("LoanTaskid=" + iTaskID); gridCompletetionEmails.DataBind(); #endregion #region Bind Data this.txtTaskName.Text = this.LoanTaskInfo.Rows[0]["Name"].ToString(); #region Owner string sOwnerID = this.LoanTaskInfo.Rows[0]["Owner"].ToString(); if (sOwnerID == string.Empty) { this.ddlOwner.SelectedIndex = 0; } else { this.ddlOwner.SelectedValue = sOwnerID; } #endregion #region ExternalViewing if (this.LoanTaskInfo.Rows[0]["ExternalViewing"] != null && this.LoanTaskInfo.Rows[0]["ExternalViewing"].ToString() != "") { bool ExternalViewing = Convert.ToBoolean(this.LoanTaskInfo.Rows[0]["ExternalViewing"]); this.chbExternalViewing.Checked = ExternalViewing; } #endregion #region Due Date string sDueDate = this.LoanTaskInfo.Rows[0]["Due"].ToString(); if (sDueDate != string.Empty) { this.txtDueDate.Text = Convert.ToDateTime(this.LoanTaskInfo.Rows[0]["Due"]).ToString("MM/dd/yyyy"); } #endregion //#region Completed Date string sCompletedDate = this.LoanTaskInfo.Rows[0]["Completed"].ToString(); if (sCompletedDate != string.Empty) { this.hdnCompleted.Value = Convert.ToDateTime(this.LoanTaskInfo.Rows[0]["Completed"]).ToString("MM/dd/yyyy"); } //#endregion this.txtDaysToEst.Text = this.LoanTaskInfo.Rows[0]["DaysDueFromEstClose"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueFromEstClose"].ToString(); this.txtDaysAfterCreation.Text = this.LoanTaskInfo.Rows[0]["DaysFromCreation"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysFromCreation"].ToString(); this.txtDaysDueAfterPrevStage.Text = this.LoanTaskInfo.Rows[0]["DaysDueAfterPrevStage"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueAfterPrevStage"].ToString(); //Get task template Calculation Method if (this.LoanTaskInfo.Rows[0]["TemplTaskId"].ToString() != "" && this.LoanTaskInfo.Rows[0]["TemplTaskId"].ToString() != "0") { LPWeb.BLL.Template_Wfl_Tasks taskTempMgr = new Template_Wfl_Tasks(); LPWeb.Model.Template_Wfl_Tasks taskTempModel = taskTempMgr.GetModel(int.Parse(this.LoanTaskInfo.Rows[0]["TemplTaskId"].ToString())); int iCalculationMethod = 0; if (taskTempModel != null) { LPWeb.BLL.Template_Wfl_Stages stageWflMgr = new Template_Wfl_Stages(); LPWeb.Model.Template_Wfl_Stages stageModel = stageWflMgr.GetModel(taskTempModel.WflStageId); if (stageModel != null) { LPWeb.BLL.Template_Workflow templateMgr = new Template_Workflow(); LPWeb.Model.Template_Workflow templateModel = templateMgr.GetModel(stageModel.WflTemplId); if (templateModel != null) { iCalculationMethod = templateModel.CalculationMethod; } if (stageModel.CalculationMethod != null && stageModel.CalculationMethod.Value != 0) { iCalculationMethod = stageModel.CalculationMethod.Value; } } } if (iCalculationMethod == 1 && this.txtDaysAfterCreation.Text == "") { this.txtDaysToEst.Enabled = true; this.txtDaysAfterCreation.Enabled = false; } else if (iCalculationMethod == 2 && this.txtDaysToEst.Text == "") { this.txtDaysToEst.Enabled = false; this.txtDaysAfterCreation.Enabled = true; } } #region Prerequisite Task Id string sPrerequisiteTaskId = this.LoanTaskInfo.Rows[0]["PrerequisiteTaskId"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["PrerequisiteTaskId"].ToString(); if (sPrerequisiteTaskId == string.Empty) { this.ddlPrerequisite.SelectedIndex = 0; } else { this.ddlPrerequisite.SelectedValue = sPrerequisiteTaskId; } #endregion this.txtDaysDueAfter.Text = LoanTaskInfo.Rows[0]["DaysDueAfterPrerequisite"] == DBNull.Value ? string.Empty : this.LoanTaskInfo.Rows[0]["DaysDueAfterPrerequisite"].ToString(); #region Completion Email string sCompletionEmailID = this.LoanTaskInfo.Rows[0]["CompletionEmailId"].ToString(); if (sCompletionEmailID == string.Empty) { this.ddlCompletionEmail.SelectedIndex = 0; } else { this.ddlCompletionEmail.SelectedValue = sCompletionEmailID; } #endregion #region Warning Email string sWarningEmailId = this.LoanTaskInfo.Rows[0]["WarningEmailId"].ToString(); if (sWarningEmailId == string.Empty) { this.ddlWarningEmail.SelectedIndex = 0; } else { this.ddlWarningEmail.SelectedValue = sWarningEmailId; } #endregion #region Overdue Email string sOverdueEmailId = this.LoanTaskInfo.Rows[0]["OverdueEmailId"].ToString(); if (sOverdueEmailId == string.Empty) { this.ddlOverdueEmail.SelectedIndex = 0; } else { this.ddlOverdueEmail.SelectedValue = sOverdueEmailId; } #endregion #endregion } }
protected void Page_Load(object sender, EventArgs e) { #region 校验页面参数 string sErrorJs = "$('#divContainer').hide();alert('Missing required query string.');window.parent.CloseDialog_SendCompletionEmail();"; bool bIsValid = PageCommon.ValidateQueryString(this, "LoanID", QueryStringType.ID); if (bIsValid == false) { this.ClientScript.RegisterStartupScript(this.GetType(), "_InvalidQuery1", sErrorJs, true); return; } this.iLoanID = Convert.ToInt32(this.Request.QueryString["LoanID"]); bIsValid = PageCommon.ValidateQueryString(this, "EmailTemplateID", QueryStringType.ID); if (bIsValid == false) { this.ClientScript.RegisterStartupScript(this.GetType(), "_InvalidQuery2", sErrorJs, true); return; } this.iEmailTemplateID = Convert.ToInt32(this.Request.QueryString["EmailTemplateID"]); string sTaskID = ""; sTaskID = this.Request.QueryString["TaskID"]; if ((sTaskID != null) && (sTaskID != "")) { this.iTaskID = Convert.ToInt32(sTaskID); } #endregion #region EWS Company_Web CompanyWebManager = new Company_Web(); LPWeb.Model.Company_Web Company_Web_Model = CompanyWebManager.GetModel(); Users UserManager = new Users(); LPWeb.Model.Users UserModel = UserManager.GetModel(this.CurrUser.iUserID); if (Company_Web_Model.SendEmailViaEWS && UserModel.Password == string.Empty) { this.hdnUseEWS.Value = "True"; } else { this.hdnUseEWS.Value = "False"; } #endregion #region 旧代码 //#region 加载email template info //Template_Email EmailTempManager = new Template_Email(); //DataTable EmailTemplateInfo = EmailTempManager.GetEmailTemplateInfo(this.iEmailTemplateID); //if (EmailTemplateInfo.Rows.Count == 0) //{ // this.ClientScript.RegisterStartupScript(this.GetType(), "_InvalidQuery3", "$('#divContainer').hide();alert('The email template does not exist.');window.parent.CloseDialog_SendCompletionEmail();", true); // return; //} //string sEmailTemplate = EmailTemplateInfo.Rows[0]["Name"].ToString(); //this.lbEmailTemplate.Text = sEmailTemplate; //string sFromUserRoleID = EmailTemplateInfo.Rows[0]["FromUserRoles"].ToString(); //if (sFromUserRoleID != string.Empty) //{ // #region 获取Loan Team和Users信息 // string sSql = "select * from LoanTeam as a inner join Users as b on a.UserId = b.UserId where a.FileId=" + this.iLoanID + " and a.RoleId=" + sFromUserRoleID; // DataTable SenderInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql); // if (SenderInfo.Rows.Count == 0) // { // this.lbSender.Text = "There is no sender, so can't send email."; // this.lbSender.ForeColor = System.Drawing.Color.Red; // } // else // { // string sFirstName = SenderInfo.Rows[0]["FirstName"].ToString(); // string sLastName = SenderInfo.Rows[0]["LastName"].ToString(); // string sFullName = sLastName + ", " + sFirstName; // this.lbSender.Text = sFullName; // } // #endregion //} //else //{ // string sFromEmailAddress = EmailTemplateInfo.Rows[0]["FromEmailAddress"].ToString(); // if (sFromEmailAddress != string.Empty) // { // this.lbSender.Text = sFromEmailAddress; // } // else // { // this.lbSender.Text = "There is no sender."; // this.lbSender.ForeColor = System.Drawing.Color.Red; // } //} //#endregion //if (this.IsPostBack == false) //{ // #region 加载Recipient列表 // #region 获取Email Template的Recipient(s) // Template_Email EmailTemplateManager = new Template_Email(); // DataTable RecipientList = EmailTemplateManager.GetRecipientList(this.iEmailTemplateID); // #endregion // #region 获取Loan Team // string sSql = "select * from LoanTeam as a inner join Users as b on a.UserId = b.UserId where a.FileId=" + this.iLoanID; // DataTable LoanTeamList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql); // #endregion // #region 获取Contacts // string sSql2 = "select * from LoanContacts as a inner join Contacts as b on a.ContactId = b.ContactId where a.FileId=" + this.iLoanID; // DataTable ContactList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql2); // #endregion // DataTable RecipientListData = this.BuildRecipientDataTable(); // #region To // DataRow[] ToRecipient = RecipientList.Select("RecipientType='To'"); // if (ToRecipient.Length > 0) // { // string sEmailList_To = ToRecipient[0]["EmailAddr"].ToString(); // string sContactList_To = ToRecipient[0]["ContactRoles"].ToString(); // string sUserRoleList_To = ToRecipient[0]["UserRoles"].ToString(); // string sTaskOwner = ToRecipient[0]["TaskOwner"].ToString(); // #region Emails // if (sEmailList_To != string.Empty) // { // string[] EmailArray_To = sEmailList_To.Split(';'); // foreach (string sEmailTo in EmailArray_To) // { // this.AddNewRecipientRow(RecipientListData, "To", string.Empty, sEmailTo); // } // } // #endregion // #region User IDs // if (sUserRoleList_To != string.Empty) // { // string[] UserRoleArray_To = sUserRoleList_To.Split(';'); // foreach (string sUserRoleIDTo in UserRoleArray_To) // { // int iUserRoleIDTo = Convert.ToInt32(sUserRoleIDTo); // DataRow[] LoanTeamRows = LoanTeamList.Select("RoleId=" + iUserRoleIDTo); // foreach (DataRow LoanTeamRow in LoanTeamRows) // { // string sFullName = LoanTeamRow["LastName"].ToString() + ", " + LoanTeamRow["FirstName"].ToString(); // string sEmailAddress = LoanTeamRow["EmailAddress"].ToString(); // if (sEmailAddress == string.Empty) // { // this.AddNewRecipientRow(RecipientListData, "To", sFullName, "There is no emaill address in the user account."); // } // else // { // this.AddNewRecipientRow(RecipientListData, "To", sFullName, sEmailAddress); // } // } // } // } // #endregion // #region Contact IDs // if (sContactList_To != string.Empty) // { // string[] ContactArray_To = sContactList_To.Split(';'); // foreach (string sContactIDTo in ContactArray_To) // { // int iContactRoleIDTo = Convert.ToInt32(sContactIDTo); // DataRow[] ContactRows = ContactList.Select("ContactRoleId=" + iContactRoleIDTo); // foreach (DataRow ContactRow in ContactRows) // { // #region Build FullName // string sFirstName = ContactRow["FirstName"].ToString(); // string sLastName = ContactRow["LastName"].ToString(); // string sMiddleName = ContactRow["MiddleName"].ToString(); // string sFullName = string.Empty; // if (sMiddleName != string.Empty) // { // sFullName = sLastName + ", " + sFirstName + " " + sMiddleName; // } // else // { // sFullName = sLastName + ", " + sFirstName; // } // #endregion // string sEmailAddress = ContactRow["Email"].ToString(); // if (sEmailAddress == string.Empty) // { // this.AddNewRecipientRow(RecipientListData, "To", sFullName, "There is no emaill address in the contact account."); // } // else // { // this.AddNewRecipientRow(RecipientListData, "To", sFullName, sEmailAddress); // } // } // } // } // #endregion // #region TaskOwner // if ((sTaskOwner != string.Empty) && (sTaskOwner != null)) // { // if (sTaskOwner == "True") // { // string sSql_LoanTasks = "select Owner from LoanTasks where LoanTaskId=" + this.iTaskID; // DataTable LoanTasks_List = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql_LoanTasks); // string sOwnerId = LoanTasks_List.Rows[0]["Owner"].ToString(); // if ((sTaskOwner != string.Empty) && (sTaskOwner != null)) // { // int iOwnerId = Convert.ToInt32(sOwnerId); // string sSql_Users = "select EmailAddress, LastName, FirstName from Users where UserId=" + iOwnerId; // DataTable Users_List = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql_Users); // string Owner_EmailAddress = Users_List.Rows[0]["EmailAddress"].ToString(); // if ((Owner_EmailAddress != string.Empty) && (Owner_EmailAddress != null)) // { // string sOwnerFullName = Users_List.Rows[0]["LastName"].ToString() + ", " + Users_List.Rows[0]["FirstName"].ToString(); // this.AddNewRecipientRow(RecipientListData, "To", sOwnerFullName, Owner_EmailAddress); // } // } // } // } // #endregion // } // #endregion // #region CC // DataRow[] CCRecipient = RecipientList.Select("RecipientType='CC'"); // if (CCRecipient.Length > 0) // { // string sEmailList_CC = CCRecipient[0]["EmailAddr"].ToString(); // string sContactList_CC = CCRecipient[0]["ContactRoles"].ToString(); // string sUserRoleList_CC = CCRecipient[0]["UserRoles"].ToString(); // #region Emails // if (sEmailList_CC != string.Empty) // { // string[] EmailArray_CC = sEmailList_CC.Split(';'); // foreach (string sEmailCC in EmailArray_CC) // { // this.AddNewRecipientRow(RecipientListData, "CC", string.Empty, sEmailCC); // } // } // #endregion // #region User IDs // if (sUserRoleList_CC != string.Empty) // { // string[] UserRoleArray_CC = sUserRoleList_CC.Split(';'); // foreach (string sUserRoleIDCC in UserRoleArray_CC) // { // int iUserRoleIDCC = Convert.ToInt32(sUserRoleIDCC); // DataRow[] LoanTeamRows = LoanTeamList.Select("RoleId=" + iUserRoleIDCC); // foreach (DataRow LoanTeamRow in LoanTeamRows) // { // string sFullName = LoanTeamRow["LastName"].ToString() + ", " + LoanTeamRow["FirstName"].ToString(); // string sEmailAddress = LoanTeamRow["EmailAddress"].ToString(); // if (sEmailAddress == string.Empty) // { // this.AddNewRecipientRow(RecipientListData, "CC", sFullName, "There is no emaill address in the user account."); // } // else // { // this.AddNewRecipientRow(RecipientListData, "CC", sFullName, sEmailAddress); // } // } // } // } // #endregion // #region Contact IDs // if (sContactList_CC != string.Empty) // { // string[] ContactArray_CC = sContactList_CC.Split(';'); // foreach (string sContactIDCC in ContactArray_CC) // { // int iContactRoleIDCC = Convert.ToInt32(sContactIDCC); // DataRow[] ContactRows = ContactList.Select("ContactRoleId=" + iContactRoleIDCC); // foreach (DataRow ContactRow in ContactRows) // { // #region Build FullName // string sFirstName = ContactRow["FirstName"].ToString(); // string sLastName = ContactRow["LastName"].ToString(); // string sMiddleName = ContactRow["MiddleName"].ToString(); // string sFullName = string.Empty; // if (sMiddleName != string.Empty) // { // sFullName = sLastName + ", " + sFirstName + " " + sMiddleName; // } // else // { // sFullName = sLastName + ", " + sFirstName; // } // #endregion // string sEmailAddress = ContactRow["Email"].ToString(); // if (sEmailAddress == string.Empty) // { // this.AddNewRecipientRow(RecipientListData, "CC", sFullName, "There is no emaill address in the contact account."); // } // else // { // this.AddNewRecipientRow(RecipientListData, "CC", sFullName, sEmailAddress); // } // } // } // } // #endregion // } // #endregion // this.gridRecipientList.DataSource = RecipientListData; // this.gridRecipientList.DataBind(); // #endregion //} #endregion #region 新页面信息绑定 Borrower/Task/EmailTemplate #region 加载Borrower Info string sSql5 = "select * from LoanContacts as b1 inner join Contacts as b2 on b1.ContactId = b2.ContactId where b1.FileId=" + this.iLoanID + " and b1.ContactRoleId=dbo.lpfn_GetBorrowerRoleId() "; DataTable BorrowerInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql5); #endregion #region 绑定Borrower信息 this.lbBorrower.Text = ""; if (BorrowerInfo.Rows.Count > 0) { string sBorrowerLastName = BorrowerInfo.Rows[0]["LastName"].ToString(); string sBorrowerFristName = BorrowerInfo.Rows[0]["FirstName"].ToString(); string sBorrowerMiddleName = BorrowerInfo.Rows[0]["MiddleName"].ToString(); StringBuilder sbBorrowerName = new StringBuilder(); sbBorrowerName.Append(sBorrowerLastName); if (sBorrowerFristName != string.Empty) { sbBorrowerName.Append(", " + sBorrowerFristName); } if (sBorrowerMiddleName != string.Empty) { sbBorrowerName.Append(" " + sBorrowerMiddleName); } this.lbBorrower.Text = sbBorrowerName.ToString(); } #endregion #region 加载Task Info string sSql6 = "SELECT [Name] FROM [LoanTasks] WHERE LoanTaskId=" + this.iTaskID; DataTable TaskInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql6); #endregion #region 绑定Task Info信息 this.lbTask.Text = ""; if (TaskInfo.Rows.Count > 0) { string taskName = TaskInfo.Rows[0]["Name"].ToString(); this.lbTask.Text = taskName; } #endregion #region 加载email template Template_Email EmailTempManager = new Template_Email(); EmailTemplates = EmailTempManager.GetEmailTemplate(" and Enabled = 1"); DataRow NoneEmailTemplateRow = EmailTemplates.NewRow(); NoneEmailTemplateRow["TemplEmailId"] = 0; NoneEmailTemplateRow["Name"] = "None"; EmailTemplates.Rows.InsertAt(NoneEmailTemplateRow, 0); #endregion #region 加载 任务邮件模板 并绑定 LPWeb.BLL.LoanTask_CompletionEmails bllLT_com_Emails = new LoanTask_CompletionEmails(); var ltceDS = bllLT_com_Emails.GetList("[Enabled]=1 AND LoanTaskid=" + this.iTaskID); gridCompletetionEmails.DataSource = ltceDS;//new List<string>(){"t1","t2"}; gridCompletetionEmails.DataBind(); #endregion #endregion }