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
}
}
