Example #1
0
    protected void btnSave_Click(object sender, ImageClickEventArgs e)
    {
        GridViewRow gridRow      = null;
        GridView    grid_sub     = null;
        GridViewRow grid_sub_Row = null;

        RadioButtonList rBtnColSys_Sub     = null;
        DropDownList    ddlColSys_Sub      = null;
        Literal         ltrSysKey_Sub      = null;
        Literal         ltrSysCtrlType_Sub = null;

        empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID);

        IDbConnection conn = DbAgentHelper.CreateDbConnection();

        conn.Open();
        IDbTransaction trx = conn.BeginTransaction();

        try
        {
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                gridRow  = GridView1.Rows[i];
                grid_sub = gridRow.Cells[1].FindControl("gView_Sub") as GridView;

                for (int k = 0; k < grid_sub.Rows.Count; k++)
                {
                    grid_sub_Row       = grid_sub.Rows[k];
                    rBtnColSys_Sub     = grid_sub_Row.Cells[2].FindControl("rBtnColSys_Sub") as RadioButtonList;
                    ddlColSys_Sub      = grid_sub_Row.Cells[2].FindControl("ddlColSys_Sub") as DropDownList;
                    ltrSysKey_Sub      = grid_sub_Row.Cells[2].FindControl("ltrSysKey_Sub") as Literal;
                    ltrSysCtrlType_Sub = grid_sub_Row.Cells[2].FindControl("ltrSysCtrlType_Sub") as Literal;

                    if (ltrSysCtrlType_Sub.Text.Equals("RADIO_BUTTON"))
                    {
                        empSysInfo.SetEmpSysDetailUpdate(Convert.ToInt32(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue);
                        empSysInfo.SetEmpSysDetail(conn, trx, int.Parse(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue);
                    }
                    else if (ltrSysCtrlType_Sub.Text.Equals("DROPDOWNLIST"))
                    {
                        empSysInfo.SetEmpSysDetailUpdate(Convert.ToInt32(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue);
                        empSysInfo.SetEmpSysDetail(conn, trx, int.Parse(ltrSysKey_Sub.Text), ddlColSys_Sub.SelectedValue);
                    }
                }
            }

            trx.Commit();
        }
        catch (SqlException ex)
        {
            trx.Rollback();
            conn.Close();
            ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.", false);
            return;
        }
        finally
        {
            conn.Close();
        }

        ltrScript.Text = JSHelper.GetAlertScript("정상적으로 설정되었습니다.", false);

        DataBindingGrid();
    }
Example #2
0
 private void DataBindingGrid()
 {
     empSysInfo           = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID);
     GridView1.DataSource = empSysInfo.GetEmpSysCategory();
     GridView1.DataBind();
 }
Example #3
0
    private void SetQueryStringData()
    {
        _empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID);

        if (GetRequest("ESTTERM_REF_ID").Equals(""))
        {
            TermInfos term = new TermInfos();
            DataView  dw   = term.GetAllTermInfo().Tables[0].DefaultView;

            for (int i = 0; i < dw.Table.Rows.Count; i++)
            {
                if (Convert.ToInt32(dw.Table.Rows[i]["EST_STATUS"]) == 1)
                {
                    ESTTERM_REF_ID = int.Parse(dw.Table.Rows[i]["ESTTERM_REF_ID"].ToString());
                    return;
                }
            }
        }
        else
        {
            ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID");
        }

        if (GetRequest("EST_DEPT_REF_ID").Equals(""))
        {
            EST_DEPT_REF_ID = _estDeptInfo.GetRootEstDeptID(ESTTERM_REF_ID);
        }
        else
        {
            EST_DEPT_REF_ID = GetRequestByInt("EST_DEPT_REF_ID");
        }

        MAP_VERSION_ID = GetRequestByInt("MAP_VERSION_ID");

        if (GetRequest("TMCODE").Equals(""))
        {
            MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
            TMCODE = objTerm.GetReleasedMonth();
        }
        else
        {
            TMCODE = GetRequest("TMCODE");
        }

        string lineType    = "";
        string showKpiList = "";

        if (GetRequest("LINE_TYPE").Equals(""))
        {
            lineType = _empSysInfo.GetSysValueByEmpID(1000);
        }
        else
        {
            lineType = GetRequest("LINE_TYPE");
        }

        if (GetRequest("SHOW_KPI_LIST").Equals(""))
        {
            showKpiList = _empSysInfo.GetSysValueByEmpID(1002);
        }
        else
        {
            showKpiList = GetRequest("SHOW_KPI_LIST");
        }

        ENUMLINETYPE  = (lineType == "0") ? LineType.Diagonal : LineType.Straight;
        ISKPILISTVIEW = (showKpiList == "1") ? true : false;
        DRAWING_YN    = GetRequest("DRAWING_YN", "N");

        if (!IsPostBack)
        {
            IWORKINGMAP_YN = GetRequest("WORKINGMAPYN", "N");
        }

        FULLSCREEN = GetRequest("FULLSCREEN", "N");
    }