protected void Page_Load(object sender, EventArgs e) { this.hdnNowDate.Value = DateTime.Now.ToString("MM/dd/yyyy"); this.hdnNowTime.Value = DateTime.Now.ToString("hh:mm"); if (!IsPostBack) { this.ddlDueTime_hour.SelectedValue = DateTime.Now.Hour.ToString("00"); this.ddlDueTime_min.SelectedValue = (DateTime.Now.Minute / 5 * 5).ToString("00"); if (cbInterestOnly.Checked == true) { //if (string.IsNullOrEmpty(txtDate.Text.Trim())) //{ // txtDate.Text = System.DateTime.Now.ToString("MM/dd/yyyy"); //} //if (string.IsNullOrEmpty(txtTime.Text.Trim())) //{ // txtTime.Text = System.DateTime.Now.ToString("HH:mm"); //} txtDate.Enabled = false; txtTime.Enabled = false; } #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 } }
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) { if (this.IsPostBack == false) { #region 加载 ddlLeadSource Company_Lead_Sources LeadSourceManager = new Company_Lead_Sources(); DataTable LeadSourceList = LeadSourceManager.GetList("1=1 order by LeadSource").Tables[0]; DataRow NewLeadSourceRow = LeadSourceList.NewRow(); NewLeadSourceRow["LeadSourceID"] = 0; NewLeadSourceRow["LeadSource"] = "- select -"; NewLeadSourceRow["Default"] = DBNull.Value; LeadSourceList.Rows.InsertAt(NewLeadSourceRow, 0); this.ddlLeadSource.DataSource = LeadSourceList; this.ddlLeadSource.DataBind(); // set default selected DataRow[] DefaultRowArray = LeadSourceList.Select("Default=1"); if (DefaultRowArray.Length > 0) { string sLeadSource = DefaultRowArray[0]["LeadSourceID"].ToString(); this.ddlLeadSource.SelectedValue = sLeadSource; } #endregion #region 加载 ddlLoanOfficer DataTable dtLoadOfficer = this.GetLoanOfficerList(CurrUser.iUserID); DataRow drNew = dtLoadOfficer.NewRow(); //2014/1/16 CR072 Add the current user in the Loan Officer dropdown list if (dtLoadOfficer.Select("ID=" + CurrUser.iUserID.ToString()).Length < 1) { drNew["ID"] = CurrUser.iUserID; drNew["Name"] = CurrUser.sFullName; drNew["LastName"] = CurrUser.sLastName; drNew["FirstName"] = CurrUser.sFirstName; dtLoadOfficer.Rows.InsertAt(drNew, 0); } drNew = dtLoadOfficer.NewRow(); drNew["ID"] = 0; drNew["Name"] = "Lead Routing Engine"; dtLoadOfficer.Rows.InsertAt(drNew, 0); drNew = dtLoadOfficer.NewRow(); drNew["ID"] = -1; drNew["Name"] = "Unassigned"; dtLoadOfficer.Rows.InsertAt(drNew, 0); drNew = dtLoadOfficer.NewRow(); drNew["ID"] = -2; drNew["Name"] = "- select -"; dtLoadOfficer.Rows.InsertAt(drNew, 0); ddlLoanOfficer.DataSource = dtLoadOfficer; ddlLoanOfficer.DataTextField = "Name"; ddlLoanOfficer.DataValueField = "ID"; //if (dtLoadOfficer.Select("ID=" + CurrUser.iUserID.ToString()).Length > 0) //{ // ddlLoanOfficer.SelectedValue = CurrUser.iUserID.ToString(); //} //else //{ ddlLoanOfficer.SelectedValue = "0"; //} ddlLoanOfficer.DataBind(); #endregion #region 加载ddlWorkflow Template_Workflow WflTempMgr = new Template_Workflow(); DataTable WorkflowList = WflTempMgr.GetWorkflowTemplateList(" and WorkflowType='Prospect' and Enabled=1", "Name"); this.ddlWorkflow.DataSource = WorkflowList; this.ddlWorkflow.DataBind(); // set default selected DefaultRowArray = WorkflowList.Select("Default=1"); if (DefaultRowArray.Length > 0) { string sWflTemplId = DefaultRowArray[0]["WflTemplId"].ToString(); this.ddlWorkflow.SelectedValue = sWflTemplId; } #endregion #region 加载Marketing enrollment MailChimpLists MailChimpListsMgr = new MailChimpLists(); DataTable MailChimpList = null; CheckRolePermistion(this.CurrUser.iUserID); if (_isAccessAllMailChimpList == true) { if (this.CurrUser.bIsCompanyExecutive == true) { MailChimpList = MailChimpListsMgr.GetMailChimpList(" and 1=1 ", "Name"); } else { if (this.CurrUser.bIsBranchManager == true) { MailChimpList = MailChimpListsMgr.GetMailChimpList_BranchManager(this.CurrUser.iUserID); } else { MailChimpList = MailChimpListsMgr.GetMailChimpList(" and UserId=" + this.CurrUser.iUserID, "Name"); } } } else { MailChimpList = MailChimpListsMgr.GetMailChimpList(" and UserId=" + this.CurrUser.iUserID, "Name"); } DataRow NewMarkingRow = MailChimpList.NewRow(); NewMarkingRow["LID"] = ""; NewMarkingRow["Name"] = "-- select --"; MailChimpList.Rows.InsertAt(NewMarkingRow, 0); this.ddlMarketing.DataSource = MailChimpList; this.ddlMarketing.DataBind(); #endregion #region 加载ddlTaskList 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 NewTaskRow = LeadTaskList1.NewRow(); NewTaskRow["TaskName"] = "-- select --"; NewTaskRow["SequenceNumber"] = 0; NewTaskRow["Enabled"] = "True"; LeadTaskList1.Rows.InsertAt(NewTaskRow, 0); this.ddlTaskList.DataSource = LeadTaskList1; this.ddlTaskList.DataBind(); #endregion // set default value this.txtDueDate.Text = DateTime.Now.ToString("MM/dd/yyyy"); this.txtDueTime.Text = System.DateTime.Now.AddHours(2).ToString("HH:mm"); this.txtReminderUser.Text = this.CurrUser.sLastName + ", " + this.CurrUser.sFirstName; this.hdnReminderUserID.Value = this.CurrUser.iUserID.ToString(); } }
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"]); #endregion #region 校验LoanId 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"); } this.iCurrentLoanStageId = WorkflowManager.GetCurrentLoanStageId(this.iLoanID); bIsValid = PageCommon.ValidateQueryString(this, "Stage", QueryStringType.ID); if (bIsValid == true) { int iout = 0; string sStage = this.Request.QueryString["Stage"]; if (Int32.TryParse(sStage, out iout)) { this.iCurrentLoanStageId = iout; } } #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 // set default value this.txtDueDate.Text = DateTime.Now.ToString("MM/dd/yyyy"); //this.txtDueTime.Text = DateTime.Now.AddMinutes(15).ToShortTimeString(); this.ddlDueTime_hour.SelectedValue = DateTime.Now.Hour.ToString("00"); this.ddlDueTime_min.SelectedValue = (DateTime.Now.AddMinutes(15).Minute / 5 * 5).ToString(); #region 加载Prerequisite 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(); DataTable EmailTemplates = EmailTempManager.GetEmailTemplate(" and Enabled = 1"); DataRow NoneEmailTemplateRow = EmailTemplates.NewRow(); NoneEmailTemplateRow["TemplEmailId"] = 0; NoneEmailTemplateRow["Name"] = "None"; EmailTemplates.Rows.InsertAt(NoneEmailTemplateRow, 0); this.ddlWarningEmail.DataSource = EmailTemplates; this.ddlWarningEmail.DataBind(); this.ddlOverdueEmail.DataSource = EmailTemplates; this.ddlOverdueEmail.DataBind(); this.ddlEmailTemplate.DataSource = EmailTemplates; this.ddlEmailTemplate.DataBind(); #endregion #region completion email list gridCompletetionEmails.DataSource = null; 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(); ddlStage.SelectedValue = this.iCurrentLoanStageId.ToString(); #endregion } }