Example #1
0
    protected void ibnCheckID_Click(object sender, ImageClickEventArgs e)
    {
        if (txtEstScheID.Text.Trim().Length == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("일정 ID를 입력해주세요.");
            return;
        }

        string        strEstScheID = txtEstScheID.Text.Trim();
        Biz_ScheInfos scheInfos    = new Biz_ScheInfos();
        bool          bDuplicate   = scheInfos.IsExist(COMP_ID, strEstScheID);

        if (bDuplicate)
        {
            ltrScript.Text = JSHelper.GetAlertScript("존재하는 일정 ID가 있습니다.");
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("사용가능한 일정 ID 입니다.");
        }
    }
Example #2
0
    protected void ibnDelete_Click(object sender, ImageClickEventArgs e)
    {
        string est_sche_id = hdfEstScheId.Value.Trim();

        if (est_sche_id.Length == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("선택된 일정 ID가 없습니다.");
            return;
        }

        Biz_ScheInfos scheInfos = new Biz_ScheInfos();
        bool          bResult   = scheInfos.RemoveScheInfo(COMP_ID, est_sche_id);

        if (bResult == true)
        {
            BindGrid(COMP_ID);
            ButtonStatusByInit();
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertBackScript("삭제되지 않았습니다.");
            return;
        }
    }
Example #3
0
    private void ViewOne(int comp_id, string est_sche_id)
    {
        Biz_ScheInfos scheInfos    = new Biz_ScheInfos(comp_id, est_sche_id);
        Biz_ScheInfos scheInfos_up = null;

        if (!scheInfos.Up_Est_Sche_ID.Equals(""))
        {
            scheInfos_up        = new Biz_ScheInfos(comp_id, scheInfos.Up_Est_Sche_ID);
            txtUpEstScheID.Text = scheInfos_up.Est_Sche_Name;
        }

        txtEstScheID.Text    = scheInfos.Est_Sche_ID;
        txtEstScheName.Text  = scheInfos.Est_Sche_Name;
        hdfUpEstScheID.Value = scheInfos.Up_Est_Sche_ID;
        hdfEstID.Value       = scheInfos.Est_ID;
        txtEstScheDesc.Text  = scheInfos.Est_Sche_Desc;
        txtSortOrder.Text    = scheInfos.Sort_Order.ToString();

        Biz_EstInfos estInfos = new Biz_EstInfos(comp_id, scheInfos.Est_ID);

        txtEstID.Text = estInfos.Est_Name;

        DropDownListCommom.BindEstJobMapNotIn(ddlEstJobID, COMP_ID, hdfEstID.Value, true);
    }
Example #4
0
    public static void BindJobs(TreeView treeView
                                , bool isCheckBox
                                , TreeNodeSelectAction treeNodeSelectAction
                                , string checkedValues
                                , int comp_id)
    {
        string    valueStr    = "EST_SCHE_ID";
        string    up_valueStr = "UP_EST_SCHE_ID";
        string    textStr     = "EST_SCHE_NAME";
        string    iconStr     = "EST_SCHE_ID";
        string    imageUrlDir = "../images/dept_icon/";
        bool      isExtended  = true;
        DataTable dataTable   = null;

        // 부모 페이지에서 값이 수정되었을 경우를 위해서 체크박스에 대한 값을 처리하기
        // 위해서 추가 되는 부분
        if (isCheckBox && (checkedValues != null || checkedValues == ""))
        {
            dataTable = new DataTable();
            DataRow dr = null;
            dataTable.Columns.Add("VALUE", typeof(string));
            dataTable.Columns.Add("OK_YN", typeof(string));

            string[] values = checkedValues.Split(',');

            foreach (string val in values)
            {
                dr          = dataTable.NewRow();
                dr["VALUE"] = val;
                dr["OK_YN"] = "N";
                dataTable.Rows.Add(dr);
            }
        }

        Biz_ScheInfos scheInfos = new Biz_ScheInfos();
        DataSet       ds        = scheInfos.GetScheInfo(comp_id);

        ds.Relations.Add("NodeRelation"
                         , ds.Tables[0].Columns[valueStr]
                         , ds.Tables[0].Columns[up_valueStr]
                         , false);

        treeView.Nodes.Clear();

        foreach (DataRow dbRow in ds.Tables[0].Rows)
        {
            if (dbRow[up_valueStr] == DBNull.Value)
            {
                TreeNode rootNode = CreateNode(dbRow[valueStr].ToString()
                                               , dbRow[textStr].ToString()
                                               , imageUrlDir + ((dbRow["EST_ID"].ToString().Length != 0) ? "blue/E.gif" : "blue/S.gif")
                                               , isExtended
                                               , treeNodeSelectAction
                                               , isCheckBox);

                if (isCheckBox && (checkedValues != null || checkedValues == ""))
                {
                    TreeNodeCheck(rootNode, dataTable);
                }

                treeView.Nodes.Add(rootNode);
                PopulateEstTreeJob(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
            }
        }
    }
Example #5
0
    protected void ibnSave_Click(object sender, ImageClickEventArgs e)
    {
        string est_sche_id = txtEstScheID.Text.Trim();

        if (est_sche_id.Length == 0)
        {
            est_sche_id = hdfEstScheId.Value.Trim();
        }

        string up_est_sche_id = hdfUpEstScheID.Value.Trim();
        string est_sche_name  = txtEstScheName.Text.Trim();
        string est_sche_desc  = txtEstScheDesc.Text.Trim();
        int    sort_order     = DataTypeUtility.GetToInt32(txtSortOrder.Text);
        string est_id         = hdfEstID.Value.Trim();

        Biz_ScheInfos scheInfos = new Biz_ScheInfos();

        if (PageWriteMode == WriteMode.New)
        {
            bool bDuplicate = scheInfos.IsExist(COMP_ID, est_sche_id);

            if (bDuplicate == true)
            {
                ltrScript.Text = JSHelper.GetAlertScript("존재하는 일정 ID가 있습니다.", false);
                return;
            }

            bool bResult = scheInfos.AddScheInfo(COMP_ID
                                                 , est_sche_id
                                                 , up_est_sche_id
                                                 , est_sche_name
                                                 , est_sche_desc
                                                 , sort_order
                                                 , est_id
                                                 , DateTime.Now
                                                 , gUserInfo.Emp_Ref_ID
                                                 );

            if (bResult == true)
            {
                ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다.");
                BindGrid(COMP_ID);
                ButtonStatusByInit();
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
                return;
            }
        }
        else if (PageWriteMode == WriteMode.Modify)
        {
            bool bIsExist = scheInfos.IsExist(COMP_ID, est_sche_id);

            if (bIsExist == false)
            {
                ltrScript.Text = JSHelper.GetAlertScript("해당 자료가 없습니다.");
                return;
            }

            bool bResult = scheInfos.ModifyScheInfo(COMP_ID
                                                    , est_sche_id
                                                    , up_est_sche_id
                                                    , est_sche_name
                                                    , est_sche_desc
                                                    , sort_order
                                                    , est_id
                                                    , DateTime.Now
                                                    , gUserInfo.Emp_Ref_ID
                                                    );

            if (bResult == true)
            {
                ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되었습니다.");
                BindGrid(COMP_ID);
                ButtonStatusByInit();
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertBackScript("수정되지 않았습니다.");
                return;
            }
        }
    }