예제 #1
0
    private void DeleteViewData()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        this.IType = "D";
        MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
        objBSC.Iview_ref_id = this.IViewRefID;

        int intRtn = objBSC.DeleteData(objBSC.Iview_ref_id,
                                       "N",
                                       gUserInfo.Emp_Ref_ID);

        if (objBSC.Transaction_Result == "Y")
        {
            this.FileUpload(fudViewImage);
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
        }
        else
        {
            this.IType = "U";
        }
    }
예제 #2
0
    private void DeleteViewData()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        //this.IType = "D";

        Biz_RoleInfos objRoleInfo = new Biz_RoleInfos();

        bool result = objRoleInfo.RemoveRoleInfo(_irole_ref_id);

        if (result)
        {
            this.IType = "U";
            this.SetFormData();
            this.SetButton();

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("권한삭제가 성공되었습니다.", this.ICCB1, true);
        }
        else
        {
            hdfRoleRefID.Value = "";

            ltrScript.Text = JSHelper.GetAlertScript("권한삭제가 실패했습니다.", false);
        }
    }
예제 #3
0
    protected void iBtnFeedbackAgree_Click(object sender, ImageClickEventArgs e)
    {
        bool isSuccessed = SaveQuestionData();

        if (isSuccessed)
        {
            Biz_QuestionComments questionComment = new Biz_QuestionComments();
            questionComment.AddQuestionComment(COMP_ID
                                               , EST_ID
                                               , ESTTERM_REF_ID
                                               , ESTTERM_SUB_ID
                                               , ESTTERM_STEP_ID
                                               , EST_DEPT_ID
                                               , EST_EMP_ID
                                               , TGT_DEPT_ID
                                               , TGT_EMP_ID
                                               , ""//txtFeedbackComment.Text
                                               , "TGT"
                                               , "AGR"
                                               , DateTime.Now
                                               , EMP_REF_ID);
        }

        if (!isSuccessed)
        {
            if (ltrScript.Text.Equals(""))
            {
                ltrScript.Text = JSHelper.GetAlertScript("질의동의가 정상적으로 처리되지 않았습니다.", false);
            }

            return;
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 질의평가에 동의 하셨습니다.", "lbnReload", true);
    }
예제 #4
0
    private void DeleteWorkTask()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        this.IType = "D";
        MicroBSC.BSC.Biz.Biz_Bsc_Work_Task objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Work_Task();
        objBSC.Iexec_ref_id = this.IExec_Ref_ID;
        objBSC.Itask_ref_id = this.ITask_Ref_ID;
        objBSC.Itxr_user    = gUserInfo.Emp_Ref_ID;

        int intRtn = objBSC.DeleteData(objBSC.Iexec_ref_id,
                                       objBSC.Itask_ref_id,
                                       objBSC.Itxr_user);

        if (objBSC.Transaction_Result == "Y")
        {
            //            this.TxrWorkPoolQuestion();
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
            this.IType     = "U";
        }
    }
예제 #5
0
    private void DeleteKpiPool()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        this.IType = "D";
        MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
        objBSC.Itxr_user = gUserInfo.Emp_Ref_ID;

        int intRtn = objBSC.DeleteData(this.IKpiPoolRefID,
                                       objBSC.Itxr_user);

        if (objBSC.Transaction_Result == "Y")
        {
            this.TxrKpiPoolQuestion();
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
            this.IType     = "U";
        }
    }
예제 #6
0
    /// <summary>
    /// 반려
    /// </summary>
    public void SetReturn()
    {
        if (this.IApp_Ref_Id > 0 && this.IVersion_No > 0 && this.ILine_Step > 0)
        {
            DataTable dtAppLine = new DataTable("APP_LINE");
            dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
            dtAppLine.Columns.Add("VERSION_NO", typeof(int));
            dtAppLine.Columns.Add("LINE_STEP", typeof(int));
            dtAppLine.Columns.Add("RETURN_REASON", typeof(string));
            dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));

            DataRow drAppLine = dtAppLine.NewRow();
            drAppLine["APP_REF_ID"]    = this.IApp_Ref_Id;
            drAppLine["VERSION_NO"]    = this.IVersion_No;
            drAppLine["LINE_STEP"]     = this.ILine_Step;
            drAppLine["RETURN_REASON"] = txtRtnReason.Text;
            drAppLine["APP_EMP_ID"]    = gUserInfo.Emp_Ref_ID;

            dtAppLine.Rows.Add(drAppLine);

            Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
            int iRtn = objPrc.Return(dtAppLine);

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.IAPP_CCB, true);
            return;
        }
        else
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
        }
    }
예제 #7
0
    private void DeleteViewData()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        Biz_MenuInfo objMenuInfo = new Biz_MenuInfo();

        bool result = objMenuInfo.RemoveMenuinfo(_imenu_ref_id);

        if (result)
        {
            this.IType = "U";
            this.SetFormData();
            this.SetButton();

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("메뉴삭제가 성공되었습니다.", this.ICCB1, true);
        }
        else
        {
            hdfMenuRefID.Value = "";

            ltrScript.Text = JSHelper.GetAlertScript("메뉴삭제가 실패했습니다.", false);
        }
    }
예제 #8
0
    private void InsertViewData()
    {
        if (!this.CheckFormData())
        {
            return;
        }


        Biz_MenuInfo objMenuInfo = new Biz_MenuInfo();


        objMenuInfo.Menu_ref_id            = DataTypeUtility.GetToInt32(this.txtMenuRefID.Text.Trim());
        objMenuInfo.Up_menu_id             = DataTypeUtility.GetToInt32(this.hdfUpMenuID.Value);
        objMenuInfo.Menu_name              = txtMenuName.Text.Trim();
        objMenuInfo.Menu_dir               = txtMenuDir.Text.Trim();
        objMenuInfo.Menu_page_name         = txtMenuPageName.Text.Trim();
        objMenuInfo.Menu_param             = txtMenuParam.Text.Trim();
        objMenuInfo.Menu_full_path         = txtMenuFullPath.Text.Trim();
        objMenuInfo.Menu_desc              = txtMenuDesc.Text.Trim();
        objMenuInfo.Menu_priority          = DataTypeUtility.GetToInt32(txtMenuPriority.Text.Trim());
        objMenuInfo.Menu_auth_type         = WebUtility.GetByValueDropDownList(ddlMenuAuthType);
        objMenuInfo.Menu_type              = WebUtility.GetByValueDropDownList(ddlMenuType);
        objMenuInfo.Menu_name_image_path   = txtMenuNameImagePath.Text.Trim();
        objMenuInfo.Menu_name_image_path_u = txtMenuNameImagePathU.Text.Trim();
        objMenuInfo.Menu_prev_icon_path    = txtMenuPrevIconPath.Text.Trim();
        objMenuInfo.Show_left_menu         = WebUtility.GetByValueDropDownList(ddlShowLeftMenu);

        bool result = objMenuInfo.AddMenuinfo(objMenuInfo.Menu_ref_id
                                              , objMenuInfo.Up_menu_id
                                              , objMenuInfo.Menu_name
                                              , objMenuInfo.Menu_dir
                                              , objMenuInfo.Menu_page_name
                                              , objMenuInfo.Menu_param
                                              , objMenuInfo.Menu_full_path
                                              , objMenuInfo.Menu_desc
                                              , objMenuInfo.Menu_priority
                                              , objMenuInfo.Menu_auth_type
                                              , objMenuInfo.Menu_type
                                              , objMenuInfo.Menu_name_image_path
                                              , objMenuInfo.Menu_name_image_path_u
                                              , objMenuInfo.Menu_prev_icon_path
                                              , DateTime.Now
                                              , objMenuInfo.Show_left_menu);


        if (result)
        {
            this.IType = "U";
            this.SetFormData();
            this.SetButton();

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("메뉴등록이 성공되었습니다.", this.ICCB1, true);
        }
        else
        {
            hdfMenuRefID.Value = "";

            ltrScript.Text = JSHelper.GetAlertScript("메뉴등록이 실패했습니다.", false);
        }
    }
예제 #9
0
 protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
 {
     if (Request["MODE"].Equals("NUMBER"))
     {
         if (Request["TYPE"].Equals("NEW"))
         {
             LowDemensionNumbers number = new LowDemensionNumbers();
             number.AddLowDemensionNumber(Request["KPI_CODE"], txtDimensionName.Text);
             ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnNumber", true);
         }
         else if (Request["TYPE"].Equals("MODIFY"))
         {
             LowDemensionNumbers number = new LowDemensionNumbers();
             number.ModifyLowDemensionNumber(int.Parse(Request["SEQ"]), txtDimensionName.Text);
             ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnNumber", true);
         }
     }
     else if (Request["MODE"].Equals("NAME"))
     {
         if (Request["TYPE"].Equals("NEW"))
         {
             LowDemensionNames number = new LowDemensionNames();
             number.AddLowDemensionName(Request["KPI_CODE"], txtDimensionName.Text);
             ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnName", true);
         }
         else if (Request["TYPE"].Equals("MODIFY"))
         {
             LowDemensionNames number = new LowDemensionNames();
             number.ModifyLowDemensionName(int.Parse(Request["SEQ"]), txtDimensionName.Text);
             ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnName", true);
         }
     }
 }
예제 #10
0
    private void ReUsedWorkExec()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        this.IType = "RU";
        MicroBSC.BSC.Biz.Biz_Bsc_Work_Exec objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Work_Exec();
        objBSC.Iestterm_ref_id  = this.IEstterm_Ref_ID;
        objBSC.Iest_dept_ref_id = this.IEst_Dept_Ref_ID;
        objBSC.Iwork_ref_id     = this.IWork_Ref_ID;
        objBSC.Iexec_ref_id     = this.IExec_Ref_ID;
        objBSC.Itxr_user        = gUserInfo.Emp_Ref_ID;

        int intRtn = objBSC.ReUsedData(objBSC.Iestterm_ref_id,
                                       objBSC.Iest_dept_ref_id,
                                       objBSC.Iwork_ref_id,
                                       objBSC.Iexec_ref_id,
                                       objBSC.Itxr_user);

        if (objBSC.Transaction_Result == "Y")
        {
            //            this.TxrWorkPoolQuestion();
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
            this.IType     = "U";
            this.SetFormData();
            this.SetButton();
        }
    }
예제 #11
0
    protected void iBtnInsert_Click(object sender, ImageClickEventArgs e)
    {
        Biz_Bsc_Kpi_Result bizResult = new Biz_Bsc_Kpi_Result();
        DataSet            dsResult  = bizResult.GetKpiResultDataScheme();

        for (int i = 0; i < ugrdResult.Rows.Count; i++)
        {
            if (ugrdResult.Rows[i].Cells.FromKey("CHECK_YN").Text == "Y")
            {
                DataRow updateRow = dsResult.Tables[0].NewRow();
                updateRow["ESTTERM_REF_ID"] = ugrdResult.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value;
                updateRow["KPI_REF_ID"]     = ugrdResult.Rows[i].Cells.FromKey("KPI_REF_ID").Value;
                updateRow["YMD"]            = ugrdResult.Rows[i].Cells.FromKey("YMD").Value.ToString().Replace("/", "");

                updateRow["RESULT_MS"] = ugrdResult.Rows[i].Cells.FromKey("RESULT_MS").Value;
                updateRow["RESULT_TS"] = ugrdResult.Rows[i].Cells.FromKey("RESULT_TS").Value;

                string tName = "0" + (i + 1).ToString();
                if (tName.Length == 3)
                {
                    tName = tName.Substring(1, 2);
                }

                updateRow["CAUSE_TEXT_MS"]   = ((TextBox)this.FindControl("txtCAUSE_TEXT_MS_" + tName)).Text;
                updateRow["CAUSE_TEXT_TS"]   = ((TextBox)this.FindControl("txtCAUSE_TEXT_TS_" + tName)).Text;
                updateRow["MEASURE_TEXT_MS"] = ((TextBox)this.FindControl("txtMEASURE_TEXT_MS_" + tName)).Text;
                updateRow["MEASURE_TEXT_TS"] = ((TextBox)this.FindControl("txtMEASURE_TEXT_TS_" + tName)).Text;

                updateRow["CHECKSTATUS"] = ugrdResult.Rows[i].Cells.FromKey("CHECKSTATUS").Value;

                updateRow["UPDATE_DATE"] = DateTime.Now;
                updateRow["UPDATE_USER"] = EMP_REF_ID;

                dsResult.Tables[0].Rows.Add(updateRow);
            }
        }

        if (dsResult.Tables[0].Rows.Count > 0)
        {
            bool isOK = bizResult.UpdateKpiResultDataByAdmin(dsResult.Tables[0]);

            if (isOK)
            {
                DoBinding();
                string msg = "정상적으로 저장하였습니다.";
                ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(msg, "lnkRefresh", true);
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
            }
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("수정된 데이터가 없습니다.");
        }
    }
예제 #12
0
    protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
    {
        if (txtMoveDeptID.Text.Equals(""))
        {
            Literal1.Text = JSHelper.GetAlertScript("이동하실 부서경로를 선택 하세요.", false);
            return;
        }

        DeptInfos dept = new DeptInfos();

        dept.MoveDeptPath(int.Parse(Request["estterm_ref_id"]), int.Parse(ltrHiddenDeptID.Text), int.Parse(txtMoveDeptID.Text), int.Parse(txtMoveLevel.Text) + 1);
        //Response.Redirect("ctl2302.aspx?estterm_ref_id=" + Request["estterm_ref_id"]);
        //Literal1.Text = JSHelper.GetAlertOpenerReflashSelfRedirectScript("정상적으로 부서명이 이동되었습니다.", "ctl2302.aspx?estterm_ref_id=" + Request["estterm_ref_id"]);
        Literal1.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 부서명이 이동되었습니다.", this.ICCB1, true);
    }
예제 #13
0
    /// <summary>
    /// 기안, 재기안, 수정기안
    /// </summary>
    public void SetDraft()
    {
        Biz_Com_Approval_Info objApp = new Biz_Com_Approval_Info();

        //결재완결처리 결재선이 하나인경우 완결처리
        string sAppStatus = (ugrdAppLine.Rows.Count == 1) ? Biz_Type.app_status_complete : Biz_Type.app_status_draft;

        //기안
        if (this.IDraft_Status == Biz_Type.app_draft_first)         //최초기안
        {
            bool blnRtn = objApp.TxrDraft(Server.HtmlEncode(divArea_M.InnerHtml), txtTitle.Text, this.IBiz_Type, sAppStatus, Biz_Type.app_draft_first, "", this.IDraftEmpID
                                          , this.GetAPPLine(), Request.Params);
        }
        else if (this.IDraft_Status == Biz_Type.app_draft_redraft)  // 재기안
        {
            bool blnRtn = objApp.TxrReDraft(this.IApp_Ref_Id, Server.HtmlEncode(divArea_M.InnerHtml), txtTitle.Text, this.IBiz_Type, sAppStatus, Biz_Type.app_draft_redraft, "", this.IDraftEmpID
                                            , this.GetAPPLine(), Request.Params);
        }
        else if (this.IDraft_Status == Biz_Type.app_draft_rewrite)  // 재작성
        {
            bool blnRtn = objApp.TxrReWrite(this.IApp_Ref_Id, this.IVersion_No, Server.HtmlEncode(divArea_M.InnerHtml), txtTitle.Text, this.IBiz_Type, sAppStatus, Biz_Type.app_draft_rewrite, "", this.IDraftEmpID
                                            , this.GetAPPLine(), Request.Params);
        }
        else if (this.IDraft_Status == Biz_Type.app_draft_modify)   // 수정기안
        {
            bool blnRtn = objApp.TxrMoDraft(this.IApp_Ref_Id, Server.HtmlEncode(divArea_M.InnerHtml), txtTitle.Text, this.IBiz_Type, sAppStatus, Biz_Type.app_draft_modify, "", this.IDraftEmpID
                                            , this.GetAPPLine(), Request.Params);
        }

        if (objApp.Transaction_Result == "Y")
        {
            this.IApp_Ref_Id = objApp.IApp_Ref_Id;
            this.IVersion_No = objApp.IVersion_No;

            if (this.IHISTORY_YN == "Y")
            {
                DoInsertUpdateReason();
            }
            bool bRtn = this.SendMail(false);
        }
        else
        {
            this.IApp_Ref_Id = 0;
            this.IVersion_No = 0;
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objApp.Transaction_Message, this.IAPP_CCB, true);
    }
예제 #14
0
    protected void iBtnSaveOpinion_Click(object sender, ImageClickEventArgs e)
    {
        bool isSuccessed = SaveQuestionData();

        if (!isSuccessed)
        {
            if (ltrScript.Text.Equals(""))
            {
                ltrScript.Text = JSHelper.GetAlertScript("의견상신이 정상적으로 처리되지 않았습니다.", false);
            }

            return;
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 의견상신이 되었습니다.", "lbnReload", true);
    }
예제 #15
0
    protected void ibtnRemove_Click(object sender, ImageClickEventArgs e)
    {
        bool          isRemoved = false;
        ApprovalLines app       = new ApprovalLines();

        isRemoved = app.RemoveApprovalLine(biz_type_code, EmpID);

        if (!isRemoved)
        {
            Literal1.Text = JSHelper.GetAlertScript("삭제할 결제선이 없습니다.", false);
        }
        else
        {
            Literal1.Text = JSHelper.GetAlertOpenerControlCallBackScript("결제선이 삭제 되었습니다.", "ibtnSearch", false);
        }
        DataLoad();
    }
예제 #16
0
    private void ReUsedStgData()
    {
        if (!this.CheckFormData())
        {
            return;
        }

        this.IType = "RU";
        MicroBSC.BSC.Biz.Biz_Bsc_Stg_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Stg_Info();

        int intRtn = objBSC.ReUsedData(this.IEstTermRefID
                                       , this.IStgRefID
                                       , gUserInfo.Emp_Ref_ID);


        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
    }
예제 #17
0
    protected void ibnFeedbackAgree_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton ibn         = ((ImageButton)sender);
        string      commandName = ibn.CommandName;

        bool isSuccessed = SaveQuestionData(commandName);

        if (!isSuccessed)
        {
            if (ltrScript.Text.Equals(""))
            {
                ltrScript.Text = JSHelper.GetAlertScript("질의동의가 실패하였습니다.", false);
            }

            return;
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 질의평가에 동의하셨습니다.", "lbnReload", true);
    }
예제 #18
0
    protected void ibtnDraft_Click(object sender, ImageClickEventArgs e)
    {
        DataTable dtAppLine = new DataTable("APP_LINE");

        dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
        dtAppLine.Columns.Add("VERSION_NO", typeof(int));
        dtAppLine.Columns.Add("LINE_STEP", typeof(int));
        dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));
        dtAppLine.Columns.Add("COMMENTS", typeof(string));

        for (int i = 0; i < ugrdDraft.Rows.Count; i++)
        {
            if (DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("APP_REF_ID").Value) < 1 ||
                DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("VERSION_NO").Value) < 1 ||
                DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("LINE_STEP").Value) < 1)
            {
                this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
                return;
            }

            DataRow drAppLine = dtAppLine.NewRow();
            drAppLine["APP_REF_ID"] = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("APP_REF_ID").Value);
            drAppLine["VERSION_NO"] = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("VERSION_NO").Value);
            drAppLine["LINE_STEP"]  = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("LINE_STEP").Value);
            drAppLine["APP_EMP_ID"] = this.IDraftEmpID;
            drAppLine["COMMENTS"]   = txtAppOpinion.Text.Trim();

            dtAppLine.Rows.Add(drAppLine);
        }

        Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
        int iRtn = objPrc.Approval(dtAppLine);

        if (iRtn > 0)
        {
            SendMailBatch(false);
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.ICCB1, true);
        return;
    }
예제 #19
0
    private void UpdateViewData()
    {
        if (!this.CheckFormData())
        {
            return;
        }


        Biz_RoleInfos objRoleInfo = new Biz_RoleInfos(_irole_ref_id);


        objRoleInfo.Role_Name         = this.txtRoleName.Text.Trim();
        objRoleInfo.Role_Desc         = this.txtRoleDesc.Text.Trim();
        objRoleInfo.Sys_Type          = "";
        objRoleInfo.Sort_Order        = DataTypeUtility.GetToInt32(this.txtSortOrder.Text.Trim());
        objRoleInfo.Delete_Enabled_YN = "Y";



        bool result = objRoleInfo.ModifyRoleInfo(objRoleInfo.Role_Ref_ID
                                                 , objRoleInfo.Role_Name
                                                 , objRoleInfo.Role_Desc
                                                 , objRoleInfo.Sys_Type
                                                 , objRoleInfo.Sort_Order
                                                 , objRoleInfo.Delete_Enabled_YN);

        if (result)
        {
            this.IType = "U";
            this.SetFormData();
            this.SetButton();

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("권한수정 성공되었습니다.", this.ICCB1, true);
        }
        else
        {
            hdfRoleRefID.Value = "";

            ltrScript.Text = JSHelper.GetAlertScript("권한수정이 실패했습니다.", false);
        }
    }
예제 #20
0
    protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
    {
        if (Request["MODE"].Equals("STRING"))
        {
            if (Request["TYPE"].Equals("NEW"))
            {
                iBtnUpdate.ImageUrl = "../images/btn/b_156.gif";
                LowDemensionStrings number = new LowDemensionStrings();
                number.AddLowDemensionString(Request["KPI_CODE"], Request["DEMENSION_POSITION"], txtCode.Text, txtCodeName.Text);
                ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnString", true);
            }
            else if (Request["TYPE"].Equals("MODIFY"))
            {
                iBtnUpdate.ImageUrl = "../images/btn/b_002.gif";

                LowDemensionStrings number = new LowDemensionStrings();
                number.ModifyLowDemensionString(int.Parse(Request["SEQ"]), txtCode.Text, txtCodeName.Text);
                ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적 처리되었습니다.", "lBtnString", true);
            }
        }
    }
예제 #21
0
    private void SaveQuestionData_TGT_ID()
    {
        Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData();
        Biz_Prj_Data         datas         = new Biz_Prj_Data();
        DataTable            dtQData       = questionDatas.GetDataTableSchema();

        dtQData = GetQuestionDataTable(dtQData, DataList1);
        dtQData = GetQuestionSubDataTable(dtQData, DataList2);

        DataTable dtPrjData = AddNewPrjDataRow(datas.GetDataTableSchema(), dtQData);

        bool isSuccessed = questionDatas.SaveQuestionData_TGT_ID(dtQData, dtPrjData);

        if (!isSuccessed)
        {
            ltrScript.Text = JSHelper.GetAlertScript("데이터 저장 중 실패하였습니다.", false);
            return;
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 저장되었습니다.", "lbnReload", true);
    }
예제 #22
0
    protected void iBtnModify_Click(object sender, ImageClickEventArgs e)
    {
        UnitTypeInfos unitInfo = new UnitTypeInfos();

        GetData();
        bool isOK = false;

        try
        {
            isOK = unitInfo.ModifyUnitTypeInfo(_unitgroup, _unit, _formatstring, _decimalpoint, _roundingtype, _use, _user, _unit_id);
        }
        catch (Exception ex)
        {
            ltrScript.Text = JSHelper.GetAlertScript("수정 중 오류가 발생했습니다.", false);
            return;
        }

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("수정 완료되었습니다", this.ICCB1, true);
        }
    }
예제 #23
0
    protected void ibnConfirmAssingDeptPoint_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton ibn = ((ImageButton)sender);

        bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID
                                                             , EST_ID
                                                             , ESTTERM_REF_ID
                                                             , ESTTERM_SUB_ID
                                                             , ESTTERM_STEP_ID
                                                             , EST_JOB_ID
                                                             , ibn
                                                             , null
                                                             , "Y"
                                                             , DateTime.Now
                                                             , EMP_REF_ID
                                                             , ltrScript);

        if (isJobOK)
        {
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 부서점수를 수기 작업을 확정하였습니다.", "lbnReload", true);
        }
    }
예제 #24
0
    protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
    {
        string sErr = "";

        if (!IsMandatory(out sErr, false))
        {
            PageUtility.ExecuteScript(string.Format("{0}", sErr));
            return;
        }

        //bool returnVal = Utils.FileExtensionValidator(fileSign.PostedFile);
        if (mode.ToUpper() == "NEW")
        {
            if (Utils.FileExtensionValidator(fileSign.PostedFile) && Utils.FileExtensionValidator(fileStamp.PostedFile))
            {
                NewEmp();
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("유효하지 않은 파일입니다.");
            }
        }
        else if (mode.ToUpper() == "MODIFY")
        {
            if (Utils.FileExtensionValidator(fileSign.PostedFile) && Utils.FileExtensionValidator(fileStamp.PostedFile))
            {
                ModifyEmp(Convert.ToInt32(empId));
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("유효하지 않은 파일입니다.");
            }
        }

        ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 저장되었습니다.", this.ICCB1, true);
    }
예제 #25
0
    /// <summary>
    /// 승인
    /// </summary>
    public void SetApproval()
    {
        if (this.IApp_Ref_Id > 0 && this.IVersion_No > 0 && this.ILine_Step > 0)
        {
            DataTable dtAppLine = new DataTable("APP_LINE");
            dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
            dtAppLine.Columns.Add("VERSION_NO", typeof(int));
            dtAppLine.Columns.Add("LINE_STEP", typeof(int));
            dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));
            dtAppLine.Columns.Add("COMMENTS", typeof(string));

            DataRow drAppLine = dtAppLine.NewRow();
            drAppLine["APP_REF_ID"] = this.IApp_Ref_Id;
            drAppLine["VERSION_NO"] = this.IVersion_No;
            drAppLine["LINE_STEP"]  = this.ILine_Step;
            drAppLine["APP_EMP_ID"] = this.IDraftEmpID;
            drAppLine["COMMENTS"]   = txtAppOpinion.Text;

            dtAppLine.Rows.Add(drAppLine);

            Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
            int iRtn = objPrc.Approval(dtAppLine);

            if (objPrc.Transaction_Result == "Y")
            {
                bool bRtn = SendMail(false);
            }

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.IAPP_CCB, true);
            return;
        }
        else
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
        }
    }
예제 #26
0
    protected void ibnCtrlConfirm_Click(object sender, ImageClickEventArgs e)
    {
        DataTable dataTable = null;
        bool      isOK      = false;

        Biz_Datas data = new Biz_Datas(COMP_ID
                                       , EST_ID
                                       , ESTTERM_REF_ID
                                       , ESTTERM_SUB_ID
                                       , ESTTERM_STEP_ID
                                       , EST_DEPT_ID
                                       , EST_EMP_ID
                                       , TGT_DEPT_ID
                                       , TGT_EMP_ID);

        if (POINT_GRADE_TYPE.Equals("PNT"))
        {
            Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas();
            dataTable = ctrlPointData.GetDataTableSchema();

            dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
                                                                  , "ckbCtrlConfirm"
                                                                  , "CTRL_CONFIRM"
                                                                  , new string[] { "CTRL_SEQ", "CTRL_POINT" }
                                                                  , dataTable);

            if (dataTable.Rows.Count == 0)
            {
                ltrScript.Text = JSHelper.GetAlertScript("점수 조정확정 체크박스에 선택된 항목이 없습니다.");
                return;
            }
            else if (dataTable.Rows.Count > 1)
            {
                ltrScript.Text = JSHelper.GetAlertScript("두개 이상 항목이 체크될 수 없습니다.");
                return;
            }

            isOK = data.CtrlPoint(COMP_ID
                                  , EST_ID
                                  , ESTTERM_REF_ID
                                  , ESTTERM_SUB_ID
                                  , ESTTERM_STEP_ID
                                  , EST_DEPT_ID
                                  , EST_EMP_ID
                                  , TGT_DEPT_ID
                                  , TGT_EMP_ID
                                  , CTRL_EMP_ID
                                  , DataTypeUtility.GetToInt32(dataTable.Rows[0]["CTRL_SEQ"])
                                  , data.Point
                                  , DataTypeUtility.GetToFloat(dataTable.Rows[0]["CTRL_POINT"])
                                  , DateTime.Now
                                  , DateTime.Now
                                  , EMP_REF_ID);

            if (isOK)
            {
                ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 점수조정이 확정되었습니다.", "lbnReload", true);
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("점수조정 확정 중 오류가 발생하였습니다.");
            }
        }
        else if (POINT_GRADE_TYPE.Equals("GRD"))
        {
            Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas();
            dataTable = ctrlGradeData.GetDataTableSchema();

            dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
                                                                  , "ckbCtrlConfirm"
                                                                  , "CTRL_CONFIRM"
                                                                  , new string[] { "CTRL_SEQ", "CTRL_GRADE_ID" }
                                                                  , dataTable);

            if (dataTable.Rows.Count == 0)
            {
                ltrScript.Text = JSHelper.GetAlertScript("등급 조정확정 체크박스에 선택된 항목이 없습니다.");
                return;
            }
            else if (dataTable.Rows.Count > 1)
            {
                ltrScript.Text = JSHelper.GetAlertScript("두개 이상 항목이 체크될 수 없습니다.");
                return;
            }

            isOK = data.CtrlGrade(COMP_ID
                                  , EST_ID
                                  , ESTTERM_REF_ID
                                  , ESTTERM_SUB_ID
                                  , ESTTERM_STEP_ID
                                  , EST_DEPT_ID
                                  , EST_EMP_ID
                                  , TGT_DEPT_ID
                                  , TGT_EMP_ID
                                  , CTRL_EMP_ID
                                  , DataTypeUtility.GetToInt32(dataTable.Rows[0]["CTRL_SEQ"])
                                  , data.Grade_ID
                                  , DataTypeUtility.GetValue(dataTable.Rows[0]["CTRL_GRADE_ID"])
                                  , DateTime.Now
                                  , DateTime.Now
                                  , EMP_REF_ID);

            if (isOK)
            {
                ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 등급조정이 확정되었습니다.", "lbnReload", true);
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("등급조정 확정 중 오류가 발생하였습니다.");
            }
        }
    }
예제 #27
0
    protected void ibnSave_Click(object sender, ImageClickEventArgs e)
    {
        UltraGridRow row;

        Biz_Datas data      = new Biz_Datas();
        DataTable dataTable = data.GetDataTableSchema();

        for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
        {
            row = UltraWebGrid1.Rows[i];
            TemplatedColumn ckb_col   = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
            CheckBox        ckbSelect = (CheckBox)((CellItem)ckb_col.CellItems[row.BandIndex]).FindControl("cBox");

            TemplatedColumn txt_col  = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_POINT");
            TextBox         txtPoint = (TextBox)((CellItem)txt_col.CellItems[row.BandIndex]).FindControl("txtPoint");

            if (ckbSelect.Checked)
            {
                if (txtPoint.Text.Trim().Equals(""))
                {
                    row.Cells.FromKey("POINT").Value = DBNull.Value;
                }
                else
                {
                    row.Cells.FromKey("POINT").Value = DataTypeUtility.GetToDouble(txtPoint.Text);
                }
            }
        }

        dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
                                                              , "cBox"
                                                              , "selchk"
                                                              , new string[] { "TGT_DEPT_ID"
                                                                               , "POINT" }
                                                              , dataTable);

        dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "POINT IS NOT NULL");

        foreach (DataRow dataRow in dataTable.Rows)
        {
            dataRow["COMP_ID"]         = COMP_ID;
            dataRow["EST_ID"]          = EST_ID;
            dataRow["ESTTERM_REF_ID"]  = ESTTERM_REF_ID;
            dataRow["ESTTERM_SUB_ID"]  = ESTTERM_SUB_ID;
            dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
            dataRow["EST_DEPT_ID"]     = BizUtility.GetDeptID(EMP_REF_ID);
            dataRow["EST_EMP_ID"]      = EMP_REF_ID;
            dataRow["TGT_EMP_ID"]      = -1;
            dataRow["POINT_ORG"]       = dataRow["POINT"];
            dataRow["DIRECTION_TYPE"]  = "SM";
            dataRow["POINT_ORG_DATE"]  = DateTime.Now;
            dataRow["POINT_DATE"]      = DateTime.Now;
            dataRow["STATUS_ID"]       = "E";
            dataRow["STATUS_DATE"]     = DateTime.Now;
            dataRow["DATE"]            = DateTime.Now;
            dataRow["USER"]            = EMP_REF_ID;
        }

        bool isOK = data.SaveData(dataTable, AllowUpdate);

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 부서점수를 수기 등록하였습니다.", "lbnReload", true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
        }
    }
예제 #28
0
    /* 다면평가 평가 거부 프로세스
     * 1. 현재 피평가자 기준의 평가자 리스트가 평가 최소 인원(middle) 보다 큰가?
     * 2. 만약 1번을 만족하면 평가자 삭제만 한다.
     * 3. 그렇지 않으면 풀에 데이터가 잇는지를 판단한다.
     * 4. 풀에 데이터가 있다면 평가 거부와 동시에 풀에서 데이터를 랜덤으로 가져온다.
     *
     * */

    protected void iBtnReject_Click(object sender, ImageClickEventArgs e)
    {
        MicroBSC.Integration.MUL.Biz.Biz_Mul_Basic_Info bizMulBasicInfo = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Basic_Info();

        DataTable dtMulBasicInfo = bizMulBasicInfo.Get_Mul_Basic_Info(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID);

        int max    = 0;
        int middle = 0;
        int min    = 0;

        if (dtMulBasicInfo.Rows.Count > 0)
        {
            max    = DataTypeUtility.GetToInt32(dtMulBasicInfo.Rows[0]["MAX_EST_EMP_CNT"]);
            middle = DataTypeUtility.GetToInt32(dtMulBasicInfo.Rows[0]["MID_EST_EMP_CNT"]);
            min    = DataTypeUtility.GetToInt32(dtMulBasicInfo.Rows[0]["MIN_EST_EMP_CNT"]);
        }

        MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();

        // 현재 평가 갯수(피평가자 기준)
        DataTable dtEstData = bizEstData.GetEstData(COMP_ID
                                                    , EST_ID
                                                    , ESTTERM_REF_ID
                                                    , ESTTERM_SUB_ID
                                                    , ESTTERM_STEP_ID
                                                    , ConstDIRECTION_TYPE
                                                    , 0
                                                    , TGT_EMP_ID);


        MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Target_Pool bizEstTargetPool = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Target_Pool();

        DataTable dtEstTargetPool = bizEstTargetPool.GetMulEstTargetPool_DB(COMP_ID
                                                                            , EST_ID
                                                                            , ESTTERM_REF_ID
                                                                            , ESTTERM_SUB_ID
                                                                            , TGT_EMP_ID
                                                                            , "N");

        string msg = string.Empty;

        //1.
        if (dtEstData.Rows.Count > middle)
        {
            msg = bizEstData.RemoveEstData(COMP_ID
                                           , EST_ID
                                           , ESTTERM_REF_ID
                                           , ESTTERM_SUB_ID
                                           , ESTTERM_STEP_ID
                                           , EST_EMP_ID
                                           , TGT_EMP_ID
                                           , ConstDIRECTION_TYPE);
        }
        else //2.
        {
            //3.
            if (dtEstTargetPool.Rows.Count <= 0)
            {
                ltrScript.Text = JSHelper.GetAlertScript("다면평가을 위한 평가자 피평가자 풀에 데이터가 없습니다.", false);
                return;
            }

            //4.
            if (dtEstData.Rows.Count <= min)
            {
                ltrScript.Text = JSHelper.GetAlertScript(string.Format("평가 최소 인원이 {0}명 되지 못하여 평가거부 할 수 없습니다. 관리자에게 문의하세요 ", min), false);
                return;
            }
            else
            {
                Random rnd    = new Random();
                int    rndCnt = rnd.Next(0, dtEstTargetPool.Rows.Count - 1);

                int rnd_est_dept_id = DataTypeUtility.GetToInt32(dtEstTargetPool.Rows[rndCnt]["DEPT_REF_ID"]); // 평가자 부서
                int rnd_est_emp_id  = DataTypeUtility.GetToInt32(dtEstTargetPool.Rows[rndCnt]["EST_EMP_ID"]);  // 평가자

                MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizEstEmpTargetMap = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map();

                DataTable dtEstEmpTargetMap = bizEstEmpTargetMap.GetEstEmpEstTargetMap_DB(COMP_ID
                                                                                          , ESTTERM_REF_ID
                                                                                          , ESTTERM_SUB_ID
                                                                                          , ESTTERM_STEP_ID
                                                                                          , EST_ID
                                                                                          , TGT_EMP_ID);

                msg = bizEstData.RemoveEstDataWithRandomEstEmp(dtEstEmpTargetMap
                                                               , COMP_ID
                                                               , EST_ID
                                                               , ESTTERM_REF_ID
                                                               , ESTTERM_SUB_ID
                                                               , ESTTERM_STEP_ID
                                                               , EST_DEPT_ID
                                                               , EST_EMP_ID
                                                               , TGT_DEPT_ID
                                                               , TGT_EMP_ID
                                                               , rnd_est_dept_id
                                                               , rnd_est_emp_id
                                                               , ConstDIRECTION_TYPE
                                                               , DateTime.Now
                                                               , this.gUserInfo.Emp_Ref_ID);
            }
        }

        if (msg.Equals(""))
        {
            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 처리 되었습니다.", "lbnReload", true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(msg, false);
        }
    }
예제 #29
0
    protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
    {
        bool         isSuccessed  = false;
        int          grid2_rowcnt = this.UltraWebGrid2.Rows.Count;
        UltraGridRow row;

        ApprovalLines app = null;

        if (txtEmpID.Text != null && txtEmpID.Text.Length > 0)
        {
            //if (Request["mode"].Equals("New"))
            //{
            for (int i = 0; i < grid2_rowcnt; i++)
            {
                app         = new ApprovalLines();
                row         = this.UltraWebGrid2.Rows[i];
                isSuccessed = app.AddApprovaLline(
                    (int)row.Cells.FromKey("APP_STEP").Value
                    , (string)row.Cells.FromKey("BIZ_TYPE_CODE").Value
                    , int.Parse(txtEmpID.Text)
                    , (int)row.Cells.FromKey("APP_EMP_ID").Value);
            }

            if (isSuccessed)
            {
                Literal1.Text = JSHelper.GetAlertOpenerControlCallBackScript("결재선 지정이 완료되었습니다.", "ibtnSearch", true);
            }
            else
            {
                Literal1.Text = JSHelper.GetAlertOpenerReflashScript("결재선 지정 시 오류가 발생하였습니다.", false);
            }
            // 이하 부분 2006-06-21 박면 수정 작업 했음

            //}

            /*else if (Request["mode"].Equals("Modify"))
             * {
             *  app = new ApprovalLines();
             *  bool isRemoved = app.RemoveApprovalLine(Request["biz_type_code"], int.Parse(Request["EmpID"]));
             *
             *  if (isRemoved)
             *  {
             *      for (int i = 0; i < grid2_rowcnt; i++)
             *      {
             *          app = new ApprovalLines();
             *          row = this.UltraWebGrid2.Rows[i];
             *          isSuccessed = app.AddApprovaLline(
             *              (int)row.Cells.FromKey("APP_STEP").Value
             *              , (string)row.Cells.FromKey("BIZ_TYPE_CODE").Value
             *              , int.Parse(txtEmpID.Text)
             *              , (int)row.Cells.FromKey("APP_EMP_ID").Value);
             *      }
             *
             *      if (isSuccessed)
             *          Literal1.Text = JSHelper.GetAlertOpenerReflashScript("수정이 완료되었습니다.", true);
             *      else
             *          Literal1.Text = JSHelper.GetAlertOpenerReflashScript("수정 중 실패 하였습니다.", false);
             *
             *      return;
             *  }
             *  else
             *  {
             *      Literal1.Text = JSHelper.GetAlertOpenerReflashScript("수정 중 실패 하였습니다.", false);
             *  }
             * }*/
        }
        else
        {
            Literal1.Text = JSHelper.GetAlertOpenerReflashScript("결재 승인자를 선택하여야 합니다.", false);
        }
    }
예제 #30
0
    /// <summary>
    /// 기안, 재기안, 수정기안
    /// </summary>
    public void SetDraft()
    {
        string KPI_REF_ID            = Request["KPI_REF_ID"].ToString();
        string ymd                   = GetRequest("YMD", "");
        Biz_Com_Approval_Info objApp = new Biz_Com_Approval_Info();
        bool blnRtn                  = false;
        //결재완결처리 결재선이 하나인경우 완결처리
        string sAppStatus = (ugrdAppLine.Rows.Count == 1) ? Biz_Type.app_status_complete : Biz_Type.app_status_draft;

        //기안
        if (this.IDraft_Status == Biz_Type.app_draft_first)         //최초기안
        {
            if (GetRequest("KPI_REF_ID", "").Split(',').Length < 1)
            {
                ltrScript.Text = JSHelper.GetAlertScript("결재처리할 KPI코드를 확인하세요!");
                return;
            }

            IDbConnection conn = MicroBSC.Data.DbAgentHelper.CreateDbConnection();
            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            string strTermid = GetRequest("ESTTERM_REF_ID");

            //현재 시점에 결재여부 재확인
            MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objkpi = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();

            DataSet dsKPI = new DataSet();
            if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
            {
                dsKPI = objkpi.GetKpiListForBatchDraft(DataTypeUtility.GetToInt32(strTermid)
                                                       , "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID"));
            }
            else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
            {
                dsKPI = objkpi.GetKpiResultListForBatchDraft(DataTypeUtility.GetToInt32(strTermid)
                                                             , ymd, "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID"));
            }
            else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
            {
                dsKPI = objkpi.GetKpiResultListForBatchDraft(DataTypeUtility.GetToInt32(strTermid)
                                                             , ymd, "", "", "N", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID"));
            }
            if (dsKPI.Tables[0].Rows.Count > 0)
            {
                if (dsKPI.Tables[0].Rows.Count != KPI_REF_ID.Split(',').Length)
                {
                    trx.Rollback();
                    conn.Close();
                    conn.Dispose();
                    this.IApp_Ref_Id = 0;
                    this.IVersion_No = 0;
                    ltrScript.Text   = JSHelper.GetAlertScript("결재대상 KPI상태를 확인하세요!", true);
                    return;
                }
                if (dsKPI.Tables[0].Select("APP_STATUS NOT IN('NFT', 'MFT', 'AFT', 'RFT')").Length > 0)
                {
                    trx.Rollback();
                    conn.Close();
                    conn.Dispose();
                    this.IApp_Ref_Id = 0;
                    this.IVersion_No = 0;
                    ltrScript.Text   = JSHelper.GetAlertScript("결재대상 KPI상태를 확인하세요!", true);
                    return;
                }
            }
            else
            {
                trx.Rollback();
                conn.Close();
                conn.Dispose();
                this.IApp_Ref_Id = 0;
                this.IVersion_No = 0;
                ltrScript.Text   = JSHelper.GetAlertScript("결재대상 KPI상태를 확인하세요!", true);
                return;
            }

            foreach (string strKpiRefId in KPI_REF_ID.Split(','))
            {
                blnRtn = false;
                try
                {
                    NameValueCollection nvc = new NameValueCollection();
                    nvc.Add("ESTTERM_REF_ID", strTermid);
                    nvc.Add("KPI_REF_ID", strKpiRefId);
                    nvc.Add("YMD", ymd);
                    string strTitle = "";
                    if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
                    {
                        blnRtn = objApp.GetOriDocTitle(Biz_Type.biz_type_kpi_doc, nvc, out strTitle);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
                    {
                        blnRtn = objApp.GetOriDocTitle(Biz_Type.biz_type_kpi_rst, nvc, out strTitle);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
                    {
                        blnRtn = objApp.GetOriDocTitle(Biz_Type.biz_type_target_result, nvc, out strTitle);
                    }
                    if (blnRtn)
                    {
                        txtTitle.Text = strTitle;
                    }
                    else
                    {
                        trx.Rollback();
                        conn.Close();
                        conn.Dispose();
                        this.IApp_Ref_Id = 0;
                        this.IVersion_No = 0;
                        ltrScript.Text   = JSHelper.GetAlertScript("결재처리 중 결재원문을 알수 없습니다.", true);
                        return;
                    }

                    string queryURL = string.Empty;

                    string strFullPath = "";
                    string strPath     = "";
                    string strParam    = string.Empty;

                    if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
                    {
                        strParam = "ESTTERM_REF_ID=" + strTermid + "&KPI_REF_ID=" + strKpiRefId + "&BIZ_TYPE=" + Biz_Type.biz_type_kpi_doc + "&APP_REF_ID=0&DRAFT_EMP_ID=" + gUserInfo.Emp_Ref_ID.ToString();
                        strPath  = Biz_Com_Approval_Info.GetDraftPagePath(Biz_Type.biz_type_kpi_doc);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
                    {
                        strParam = "ESTTERM_REF_ID=" + strTermid + "&KPI_REF_ID=" + strKpiRefId + "&YMD=" + ymd + "&BIZ_TYPE=" + Biz_Type.biz_type_kpi_rst + "&APP_REF_ID=0&DRAFT_EMP_ID=" + gUserInfo.Emp_Ref_ID.ToString();
                        strPath  = Biz_Com_Approval_Info.GetDraftPagePath(Biz_Type.biz_type_kpi_rst);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
                    {
                        strParam = "ESTTERM_REF_ID=" + strTermid + "&KPI_REF_ID=" + strKpiRefId + "&YMD=" + ymd + "&BIZ_TYPE=" + Biz_Type.biz_type_target_result + "&APP_REF_ID=0&DRAFT_EMP_ID=" + gUserInfo.Emp_Ref_ID.ToString();
                        strPath  = Biz_Com_Approval_Info.GetDraftPagePath(Biz_Type.biz_type_kpi_rst);
                    }


                    string strVPath = Request.ApplicationPath;
                    string strSHost = Request.Url.Host;
                    string strSPort = Request.Url.Port.ToString();
                    string strProto = Request.Url.Scheme;

                    strVPath = (strVPath == "/") ? "" : strVPath;

                    strFullPath = strProto + "://" + strSHost + ":" + strSPort + strVPath + strPath + "?" + strParam;

                    string strHtml = Server.HtmlDecode(Biz_Com_Approval_Info.GetHtmlSource(strFullPath));
                    string strPos  = "{^0^}";
                    int    iSPos   = strHtml.IndexOf(strPos) + strPos.Length;
                    int    iEPos   = strHtml.LastIndexOf(strPos);

                    divArea_M.InnerHtml = strHtml.Substring(iSPos, iEPos - iSPos);

                    NameValueCollection nvc2 = new NameValueCollection();
                    nvc2.Add("ESTTERM_REF_ID", strTermid);
                    nvc2.Add("KPI_REF_ID", strKpiRefId);
                    if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
                    {
                        nvc2.Add("BIZ_TYPE", Biz_Type.biz_type_kpi_doc);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
                    {
                        nvc2.Add("BIZ_TYPE", Biz_Type.biz_type_kpi_rst);
                        nvc2.Add("YMD", ymd);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
                    {
                        nvc2.Add("BIZ_TYPE", Biz_Type.biz_type_target_result);
                        nvc2.Add("YMD", ymd);
                    }
                    nvc2.Add("APP_REF_ID", "0");
                    nvc2.Add("DRAFT_EMP_ID", gUserInfo.Emp_Ref_ID.ToString());

                    if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
                    {
                        blnRtn = objApp.TxrDraftBatch(conn, trx, Server.HtmlEncode(divArea_M.InnerHtml)
                                                      , txtTitle.Text
                                                      , Biz_Type.biz_type_kpi_doc
                                                      , sAppStatus
                                                      , Biz_Type.app_draft_first
                                                      , ""
                                                      , gUserInfo.Emp_Ref_ID
                                                      , this.GetAPPLine(), nvc2);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
                    {
                        blnRtn = objApp.TxrDraftBatch(conn, trx, Server.HtmlEncode(divArea_M.InnerHtml)
                                                      , txtTitle.Text
                                                      , Biz_Type.biz_type_kpi_rst
                                                      , sAppStatus
                                                      , Biz_Type.app_draft_first
                                                      , ""
                                                      , gUserInfo.Emp_Ref_ID
                                                      , this.GetAPPLine(), nvc2);
                    }
                    else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
                    {
                        blnRtn = objApp.TxrDraftBatch(conn, trx, Server.HtmlEncode(divArea_M.InnerHtml)
                                                      , txtTitle.Text
                                                      , Biz_Type.biz_type_target_result
                                                      , sAppStatus
                                                      , Biz_Type.app_draft_first
                                                      , ""
                                                      , gUserInfo.Emp_Ref_ID
                                                      , this.GetAPPLine(), nvc2);
                    }



                    if (!blnRtn)
                    {
                        trx.Rollback();
                        conn.Close();
                        conn.Dispose();
                        this.IApp_Ref_Id = 0;
                        this.IVersion_No = 0;
                        ltrScript.Text   = JSHelper.GetAlertScript("결재 일괄처리 중 오류가 발생하였습니다.");
                        ltrScript.Text   = JSHelper.GetAlertOpenerControlCallBackScript(objApp.Transaction_Message, this.IAPP_CCB, true);
                        return;
                    }

                    this.IApp_Ref_Id = objApp.IApp_Ref_Id;
                    this.IVersion_No = objApp.IVersion_No;
                    if (this.IHISTORY_YN == "Y")
                    {
                        DoInsertUpdateReason();
                    }
                }
                catch
                {
                    trx.Rollback();
                    conn.Close();
                    conn.Dispose();
                    this.IApp_Ref_Id = 0;
                    this.IVersion_No = 0;
                    ltrScript.Text   = JSHelper.GetAlertScript("결재 일괄처리 중 오류가 발생하였습니다.");
                    ltrScript.Text   = JSHelper.GetAlertOpenerControlCallBackScript(objApp.Transaction_Message, this.IAPP_CCB, true);
                    return;
                }
            }

            trx.Commit();
            conn.Close();
            conn.Dispose();

            try
            {
                bool bRtn = this.SendMailBatch(false);
            }
            catch
            {
            }

            ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objApp.Transaction_Message, this.IAPP_CCB, true);
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("결재형식이 올바르지 않습니다!");
            return;
        }
    }