Example #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            _strPstatus = Request.QueryString["tls"];
            strFileId   = Request.QueryString["fid"]; // file id

            if (!IsPostBack)
            {
                string strTargetStatus = Request.QueryString["tls"];    // target folder status
                string strBranchId     = Request.QueryString["bid"];
                string err;
                if (string.IsNullOrEmpty(strFileId) || string.IsNullOrEmpty(strTargetStatus))
                {
                    err = string.Format("Invalid file Id: {0} or LoanStatus={1}.", strFileId, strTargetStatus);
                    LPLog.LogMessage(LogType.Logerror, err);
                    //PageCommon.WriteJsEnd(this, "The operation failed, "+err, PageCommon.Js_RefreshParent);
                    PageCommon.WriteJsEnd(this, "The operation failed, " + err, "window.parent.CloseGlobalPopup();");
                    return;
                }
                int iLoanId                 = Convert.ToInt32(strFileId);
                BLL.PointFolders PF         = new BLL.PointFolders();
                string           sqlCondStr = " 1>0 ";
                string           orderby    = "  Order By Name ";

                //CR60
                BLL.Company_Point   CPMgr   = new BLL.Company_Point();
                Model.Company_Point CPModel = CPMgr.GetModel();
                //check if Company_Point.Enable_MultiBranchFolders=true
                //select FolderId, [Name] from PointFolders where (LoanStatus=<selected loan/lead status>) order by [Name] asc
                bool bMultBranchFolder = false;
                if (CPModel.Enable_MultiBranchFolders == true)
                {
                    bMultBranchFolder = true;
                }

                #region 需求变化,暂去掉Status控制,bug 1186  by Alex 20110904
                //if ("1" == Request.QueryString["forProspect"])
                //{
                //    switch (strTargetStatus.ToLower())
                //    {
                //        //change Request 011 : if the Loans.ProspectLoanStatus<>’Active’, display a list of prospect archive folders (PointFolders.LoanStatus=8) within the branch of the loan and invoke Point Manager’s MoveFile method as it’s currently doing.
                //        //case "converted":
                //        //    sqlCondStr = " LoanStatus=1 AND Enabled=1 ";         // processing
                //        //    break;
                //        case "active":
                //            sqlCondStr = " LoanStatus=6 AND Enabled=1 ";         // active prospect
                //            break;
                //        default:
                //            sqlCondStr = " LoanStatus=8 AND Enabled=1 ";  // " LoanStatus<>1 AND LoanStatus<>6 ";
                //            break;
                //    }
                //}
                //else
                //{
                //    if (strTargetStatus == "Processing")
                //    {
                //        strTargetStatus = "1";
                //    }
                //    else if (strTargetStatus == "Prospect")
                //    {
                //        strTargetStatus = "6";
                //    }
                //    else if (strTargetStatus == "Canceled")
                //    {
                //        strTargetStatus = "2";
                //    }
                //    else if (strTargetStatus == "Closed")
                //    {
                //        strTargetStatus = "3";
                //    }
                //    else if (strTargetStatus == "Denied")
                //    {
                //        strTargetStatus = "4";
                //    }
                //    else if (strTargetStatus == "Suspended")
                //    {
                //        strTargetStatus = "5";
                //    }
                //    else if (strTargetStatus == "Archive")
                //    {
                //        strTargetStatus = "7";
                //    }


                //    sqlCondStr = " (LoanStatus=" + strTargetStatus;

                //    if (strTargetStatus == "1" || strTargetStatus == "6")
                //        sqlCondStr += " AND Enabled=1) ";            // processing
                //    else
                //        sqlCondStr += " OR LoanStatus=7) ";
                //}
                #endregion
                DataSet dsPF      = null;
                string  sProspect = "";
                if (strBranchId == "-1" || string.IsNullOrEmpty(strBranchId) || strBranchId == "0")
                {
                    sProspect   = Request.QueryString["forProspect"] == null ? "" : Request.QueryString["forProspect"].ToString(); //是否是Lead调用
                    strBranchId = PF.GetLoanOfficerBranchID(iLoanId, (sProspect == "1" ? "lead" : ""));
                    if (strBranchId == "0")                                                                                        //查不到Branch信息
                    {
                        if (bMultBranchFolder == false)
                        {
                            dsPF = PF.GetListByLoanId(iLoanId, sqlCondStr + orderby);
                        }
                        else
                        {
                            dsPF = PF.GetList(sqlCondStr + orderby);
                        }
                    }
                    else
                    {
                        if (bMultBranchFolder == false)
                        {
                            sqlCondStr += " AND BranchId=" + strBranchId;
                        }
                        dsPF = PF.GetList(sqlCondStr + orderby);
                    }
                }
                else
                {
                    if (bMultBranchFolder == false)
                    {
                        sqlCondStr += " AND BranchId=" + strBranchId;
                    }
                    dsPF = PF.GetList(sqlCondStr + orderby);
                }
                this.gvFolder.DataSource = dsPF;
                this.gvFolder.DataBind();
            }
        }
Example #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            sCloseDialogCodes = this.Request.QueryString["CloseDialogCodes"];

            if (sCloseDialogCodes == null)
            {
                string Msg = "";
                nullflag = true;
                //sCloseDialogCodes = "window.parent.CloseDialog_CloseLoan();";
                //PageCommon.WriteJsEnd(this, Msg, sCloseDialogCodes);
                //return;
            }

            if (sCloseDialogCodes == "taskBaseParent.parent.CloseGlobalPopup()")
            {
                sCloseDialogCodes = "window.parent.CloseGlobalPopup();";
            }
            else
            {
                sCloseDialogCodes = "window.parent.CloseDialog_CloseLoan();";
            }

            if (!IsPostBack)
            {
                string strFileId = Request.QueryString["fid"];  // file id
                if (string.IsNullOrEmpty(strFileId))
                {
                    PageCommon.WriteJsEnd(this, "Invalid FileId=" + strFileId, PageCommon.Js_RefreshSelf);
                    return;
                }
                int FileId = Convert.ToInt32(strFileId);
                if (FileId <= 0)
                {
                    PageCommon.WriteJsEnd(this, "Invalid FileId.", PageCommon.Js_RefreshSelf);
                    return;
                }



                string strTargetStatus = "3";
                //string strTargetStatus = Request.QueryString["tls"];    // target folder status
                int    iBranchId  = 0;
                string strStatus7 = " OR LoanStatus='7'";

                BLL.PointFiles pFile = new BLL.PointFiles();
                iBranchId = pFile.GetPointFileBrancId(strFileId, "");
                BLL.PointFolders PF         = new BLL.PointFolders();
                string           sqlCondStr = string.Format(" BranchId='{0}' AND (LoanStatus='{1}' {2})", iBranchId, strTargetStatus, strStatus7);

                //CR60 ADD

                BLL.Company_Point   bllcomPoint  = new BLL.Company_Point();
                Model.Company_Point compointInfo = bllcomPoint.GetModel();

                if (compointInfo != null && compointInfo.Enable_MultiBranchFolders)
                {
                    sqlCondStr = string.Format(" (LoanStatus=2 OR LoanStatus=7) order by [Name] asc");
                }
                //CR60  END

                //DataSet dsPF = PF.GetList(20, 1,sqlCondStr);
                DataSet dsPF = PF.GetList(sqlCondStr);
                if (dsPF == null || dsPF.Tables[0].Rows.Count <= 0)
                {
                    PageCommon.WriteJsEnd(this, "No Closed or Archived Loan folder found for the branch.", sCloseDialogCodes);
                    return;
                }
                this.gvFolder.DataSource = dsPF;
                this.gvFolder.DataBind();
                hdnUserId.Value = CurrentUser.iUserID.ToString();
                hdnFileId.Value = strFileId;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            _strPstatus = Request.QueryString["tls"];

            if (!IsPostBack)
            {
                string strFileId = Request.QueryString["fid"];                                                   // file id

                string strTargetStatus = Request.QueryString["tls"];                                             // target folder status
                string strBranchId     = Request.QueryString["bid"];
                string sType           = Request.QueryString["type"] == null ? "" : Request.QueryString["type"]; //Loan List 页面Dispose传递专用参数
                string err;
                if (string.IsNullOrEmpty(strFileId) || string.IsNullOrEmpty(strTargetStatus))
                {
                    err = string.Format("Invalid file Id: {0} or LoanStatus={1}.", strFileId, strTargetStatus);
                    LPLog.LogMessage(LogType.Logerror, err);
                    PageCommon.WriteJsEnd(this, "The operation failed, " + err, PageCommon.Js_RefreshParent);
                    ClientFun("callback", string.Format("callBack('{0}');", -1));
                    return;
                }

                Loans LoansManager = new Loans();

                int iLoanId                 = Convert.ToInt32(strFileId);
                BLL.PointFolders PF         = new BLL.PointFolders();
                string           sqlCondStr = " 1>0 ";
                string           orderby    = "  Order By Name ";

                //CR60
                BLL.Company_Point   CPMgr   = new BLL.Company_Point();
                Model.Company_Point CPModel = CPMgr.GetModel();
                //check if Company_Point.Enable_MultiBranchFolders=true
                //select FolderId, [Name] from PointFolders where (LoanStatus=<selected loan/lead status>) order by [Name] asc
                bool bMultBranchFolder = false;
                if (CPModel.Enable_MultiBranchFolders == true)
                {
                    bMultBranchFolder = true;
                }

                #region 需求变化,暂去掉Status控制,bug 1186  by Alex 20110904
                if (sType == "dispose")
                {
                    if ("1" == Request.QueryString["forProspect"])
                    {
                        switch (strTargetStatus.ToLower())
                        {
                        case "converted":
                            sqlCondStr = " LoanStatus=1 AND Enabled=1 ";             // processing
                            break;

                        case "active":
                            sqlCondStr = " LoanStatus=6 AND Enabled=1 ";             // active prospect
                            break;

                        default:
                            sqlCondStr = " LoanStatus=8 AND Enabled=1 ";      // " LoanStatus<>1 AND LoanStatus<>6 ";
                            break;
                        }
                    }
                    else if ("2" == Request.QueryString["forProspect"])
                    {
                        sqlCondStr = " LoanStatus=8 AND Enabled=1 ";  // " LoanStatus<>1 AND LoanStatus<>6 ";
                    }
                    else
                    {
                        if (strTargetStatus == "Processing")
                        {
                            strTargetStatus = "1";
                        }
                        else if (strTargetStatus == "Prospect")
                        {
                            strTargetStatus = "6";
                        }
                        else if (strTargetStatus == "Canceled")
                        {
                            strTargetStatus = "2";
                        }
                        else if (strTargetStatus == "Closed")
                        {
                            strTargetStatus = "3";
                        }
                        else if (strTargetStatus == "Denied")
                        {
                            strTargetStatus = "4";
                        }
                        else if (strTargetStatus == "Suspended")
                        {
                            strTargetStatus = "5";
                        }
                        else if (strTargetStatus == "Archive")
                        {
                            strTargetStatus = "7";
                        }


                        sqlCondStr = " (LoanStatus=" + strTargetStatus;

                        if (strTargetStatus == "1" || strTargetStatus == "6")
                        {
                            sqlCondStr += " AND Enabled=1) ";            // processing
                        }
                        else
                        {
                            sqlCondStr += " OR LoanStatus=7) ";
                        }
                    }
                }
                #endregion
                string sFileName = LoansManager.GetProspectFileNameInfo(Convert.ToInt32(strFileId));
                if (sFileName == "" && strTargetStatus.ToLower() != "converted")  //bug 877
                {
                    ClientFun("callback", string.Format("callBack('{0}');", "0"));
                    return;
                }



                DataSet dsPF      = null;
                string  sProspect = "";
                if (strBranchId == "-1" || string.IsNullOrEmpty(strBranchId) || strBranchId == "0")
                {
                    sProspect   = Request.QueryString["forProspect"] == null ? "" : Request.QueryString["forProspect"].ToString(); //是否是Lead调用
                    strBranchId = PF.GetLoanOfficerBranchID(iLoanId, (sProspect == "1" ? "lead" : ""));
                    if (strBranchId == "0")                                                                                        //查不到Branch信息
                    {
                        if (bMultBranchFolder == false)
                        {
                            dsPF = PF.GetListByLoanId(iLoanId, sqlCondStr + orderby);
                        }
                        else
                        {
                            dsPF = PF.GetList(sqlCondStr + orderby);
                        }
                    }
                    else
                    {
                        if (bMultBranchFolder == false)
                        {
                            sqlCondStr += " AND BranchId=" + strBranchId;
                        }
                        dsPF = PF.GetList(sqlCondStr + orderby);
                    }
                }
                else
                {
                    if (bMultBranchFolder == false)
                    {
                        sqlCondStr += " AND BranchId=" + strBranchId;
                    }
                    dsPF = PF.GetList(sqlCondStr + orderby);
                }
                this.gvFolder.DataSource = dsPF;
                this.gvFolder.DataBind();
            }
        }