コード例 #1
0
    //===================================: 사업수행구성원 조회
    private void SetResourceGrid()
    {
        Biz_Prj_Resource prjResource = new Biz_Prj_Resource();

        ugrdResourceList.DataSource = prjResource.GetAllList(this.IPrjRefID, 0).Tables[0].DefaultView;
        ugrdResourceList.DataBind();
    }
コード例 #2
0
ファイル: PRJ0103S2.aspx.cs プロジェクト: schifflee/bscgit
    private void SetPageData()
    {
        Biz_Prj_Resource objResource = new Biz_Prj_Resource();

        UltraWebGrid1.DataSource = objResource.GetAllList(this.IPrjRefID, 0);
        UltraWebGrid1.DataBind();
    }
コード例 #3
0
    //===================================: 비용관리 조회
    private void SetBudgetGrid()
    {
        Biz_Prj_Info     objPrj      = new Biz_Prj_Info(this.IPrjRefID);
        Biz_Prj_Resource prjResource = new Biz_Prj_Resource();
        Biz_Prj_Budget   objBud      = new Biz_Prj_Budget();

        if (this.IPrjRefID == 0)
        {
            return;
        }

        DataSet   ds      = objBud.SelectMonthRateList(this.IPrjRefID);
        DataTable dt      = objBud.GetDataTableSchema();
        DateTime  dtStart = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date);
        DateTime  dtEnd   = DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date);

        for (DateTime date = dtStart; date <= dtEnd;)
        {
            TOTAL_CNT++;

            DataRow dataRow = null;

            dataRow = GetBudGetYM(ds.Tables[0], date.ToString("yyyyMM"));

            if (dataRow == null)
            {
                dataRow = dt.NewRow();

                dataRow["ITYPE"]          = "A";
                dataRow["PRJ_REF_ID"]     = this.IPrjRefID;
                dataRow["BUDGET_YM"]      = date.ToString("yyyyMM");
                dataRow["BUDGET_YM_NAME"] = date.ToString("yyyy년 MM월");
                dataRow["MONTHLY_AMOUNT"] = 0;
                dataRow["AMOUNT"]         = 0;
                dataRow["RATE"]           = 0;

                dt.Rows.Add(dataRow);
            }
            else
            {
                dt.ImportRow(dataRow);
            }

            date = date.AddMonths(1);
        }

        grdBudgetList.DataSource = dt.DefaultView;
        grdBudgetList.DataBind();

        lblTOTAL_MONTHLY_AMOUNT.Text = TOTAL_MONTHLY_AMOUNT.ToString("###,##0");
        lblTOTAL_AMOUNT.Text         = TOTAL_AMOUNT.ToString("###,##0");

        decimal tmpVar = (TOTAL_RATE / TOTAL_CNT);

        lblTOTAL_RATE.Text = tmpVar.ToString("##0.#0");
    }
コード例 #4
0
ファイル: PRJ0102S1.aspx.cs プロジェクト: schifflee/bscgit
    private void BindSchedule()
    {
        _iPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName);

        Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();

        objSchedule.IPrj_Ref_Id = IPrjRefID;
        DataSet ds = objSchedule.GetUserAllList(objSchedule.IPrj_Ref_Id, 0, gUserInfo.Emp_Ref_ID);


        if (ds.Tables.Count == 0 && ds.Tables[0].Rows.Count == 0)
        {
            return;
        }

        DataSet tmpDs = ds.Clone();

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

        foreach (DataRow dbRow in ds.Tables[0].Rows)
        {
            if (DataTypeUtility.GetToInt32(dbRow["UP_TASK_REF_ID"]) == 0)
            {
                tmpDs.Tables[0].ImportRow(dbRow);
                PopulateScheduleTree(dbRow, tmpDs);
            }
        }

        _prjScheuldeDataProvider = new PrjScheuldeDataProvider(tmpDs.Tables[0]);
        _prjScheuldeDataProvider.WebScheduleInfo = this.WebScheduleInfo1;

        this.WebScheduleInfo1.AppointmentFormPath = "./PRJ0102M1.aspx?PRJ_REF_ID=" + _iPrjRefID + "&TASK_REF_ID=";
        this.WebScheduleInfo1.ReminderFormPath    = "./PRJ0102M1.aspx?PRJ_REF_ID=" + _iPrjRefID + "&TASK_REF_ID=" + _iTaskRefID;

        this.WebMonthView1.AppointmentFormatString        = "<SUBJECT>";
        this.WebMonthView1.AppointmentTooltipFormatString = "<DESCRIPTION><NEW_LINE><SUBJECT>";


        // 프로젝트 책임자 또는 사업구성원이 아닐경우
        Biz_Prj_Info     objPrj = new Biz_Prj_Info();
        Biz_Prj_Resource objRes = new Biz_Prj_Resource(this._iPrjRefID, gUserInfo.Emp_Ref_ID);

        if (!objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) ||
            (objRes == null))
        {
            _readOnlyYN = "Y";
        }
        else
        {
            _readOnlyYN = "N";
        }
    }
コード例 #5
0
ファイル: PRJ0101A1.aspx.cs プロジェクト: schifflee/bscgit
    private void SetFormData()
    {
        Biz_Prj_Info     objPrj      = new Biz_Prj_Info(this.IPrjRefID);
        Biz_Prj_Resource prjResource = new Biz_Prj_Resource();
        Biz_Prj_Share    objPrjShare = new Biz_Prj_Share();
        Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();

        DataSet actualDs = objSchedule.GetActualDate(this.IPrjRefID);

        this.IApp_Ref_Id           = objPrj.IApp_Ref_Id;
        txtPRJ_CODE.Text           = objPrj.IPrj_Code;
        txtPRJ_NAME.Text           = objPrj.IPrj_Name;
        txtDEFINITION.Text         = objPrj.IDefinition;
        txtEFFECTIVENESS.Text      = objPrj.IEffectiveness;
        txtRANGE.Text              = objPrj.IRange;
        txtOWNER_EMP_ID.Text       = objPrj.IOwner_Emp_Name;
        hdfOWNER_EMP_ID.Value      = objPrj.IOwner_Emp_Id.ToString();
        this.IDraftEmpID           = objPrj.IOwner_Emp_Id;
        txtREF_STG.Text            = objPrj.IRef_Stg;
        txtREQUEST_DEPT.Text       = objPrj.IRequest_Dept;
        txtTotalBudget.Text        = objPrj.ITotal_Budget.ToString("###,##0");
        txtINTERESTED_PARTIES.Text = objPrj.IInterested_Parties;

        WebUtility.FindByValueDropDownList(ddlOwnerDeptID, objPrj.IOwner_Dept_Id);
        WebUtility.FindByValueDropDownList(ddlPRIORITY, objPrj.IPriority);
        WebUtility.FindByValueDropDownList(ddlPrjType, objPrj.IPrj_Type);

        wdcPlanStartDate.Value = objPrj.IPlan_Start_Date;
        wdcPlanEndDate.Value   = objPrj.IPlan_End_Date;

        wdcActualStartDate.Value = actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"];
        wdcActualEndDate.Value   = actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"];

        DataSet dsPSH = objPrjShare.GetAllList(this.IPrjRefID, 0);

        if (dsPSH.Tables.Count > 0)
        {
            dsPSH.Tables[0].DefaultView.Sort = "CREATE_DATE ASC";
            ugrdProjectShareList.Clear();
            ugrdProjectShareList.DataSource = dsPSH.Tables[0].DefaultView;
            ugrdProjectShareList.DataBind();
        }
        else
        {
            ugrdProjectShareList.Clear();
        }

        ugrdResourceList.Clear();
        ugrdResourceList.DataSource = prjResource.GetAllList(this.IPrjRefID, 0);
        ugrdResourceList.DataBind();
    }
コード例 #6
0
ファイル: PRJ0105M1.aspx.cs プロジェクト: schifflee/bscgit
    private void SetButton()
    {
        // 프로젝트 책임자 또는 사업구성원이 아닐경우
        Biz_Prj_Info     objPrj = new Biz_Prj_Info();
        Biz_Prj_Resource objRes = new Biz_Prj_Resource(this._iPrjRefID, gUserInfo.Emp_Ref_ID);

        if (!objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) ||
            (objRes == null))
        {
            this.iBtnAddRow.Visible = false;
            this.iBtnDelRow.Visible = false;
            this.iBtnUpdate.Visible = false;
        }
        else
        {
            this.iBtnAddRow.Visible = true;
            this.iBtnDelRow.Visible = true;
            this.iBtnUpdate.Visible = true;
        }
    }
コード例 #7
0
    protected void ugrdPrjList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
    {
        DataRowView dr = (DataRowView)e.Data;

        Biz_Prj_Resource objResource = new Biz_Prj_Resource();
        //Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();

        DataSet ds = objResource.GetAllList(DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]), 0);
        //object oRate = objSchedule.GetTotalRate(DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]), 0);
        //double dTotalRate = 0;

        string EMP_NAMES = "";

        foreach (DataRow row in ds.Tables[0].Rows)
        {
            EMP_NAMES += row["EMP_NAME"].ToString() + Environment.NewLine;
        }

        e.Row.Cells.FromKey("TASK_OWNER_NAME").Value = EMP_NAMES;

        //dTotalRate = DataTypeUtility.GetToDouble(oRate);
        //e.Row.Cells.FromKey("PROCEED_RATE").Value = dTotalRate.ToString("###.#0") + " %";
    }
コード例 #8
0
ファイル: PRJ0101A1.aspx.cs プロジェクト: schifflee/bscgit
    private void UpdateViewData()
    {
        #region 기본정보 저장

        Biz_Prj_Info     objPrj      = new Biz_Prj_Info();
        Biz_Prj_Resource objResource = new Biz_Prj_Resource();
        Biz_Prj_Share    objPrjShare = new Biz_Prj_Share();

        objPrj.IPrj_Ref_Id         = this.IPrjRefID;
        objPrj.IPrj_Code           = txtPRJ_CODE.Text.Trim();
        objPrj.IPrj_Name           = txtPRJ_NAME.Text.Trim();
        objPrj.IDefinition         = txtDEFINITION.Text.Trim();
        objPrj.IRef_Stg            = txtREF_STG.Text.Trim();
        objPrj.IEffectiveness      = txtEFFECTIVENESS.Text.Trim();
        objPrj.IRange              = txtRANGE.Text.Trim();
        objPrj.IOwner_Dept_Id      = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
        objPrj.IOwner_Emp_Id       = DataTypeUtility.GetToInt32(hdfOWNER_EMP_ID.Value);
        objPrj.IRequest_Dept       = txtREQUEST_DEPT.Text.Trim();
        objPrj.IPriority           = WebUtility.GetByValueDropDownList(ddlPRIORITY);
        objPrj.ITotal_Budget       = DataTypeUtility.GetToDecimal(txtTotalBudget.Text);
        objPrj.IPrj_Type           = WebUtility.GetByValueDropDownList(ddlPrjType);
        objPrj.IInterested_Parties = txtINTERESTED_PARTIES.Text.Trim();
        objPrj.IPlan_Start_Date    = wdcPlanStartDate.Value;
        objPrj.IPlan_End_Date      = wdcPlanEndDate.Value;
        objPrj.IActual_Start_Date  = wdcActualStartDate.Value;
        objPrj.IActual_End_Date    = wdcActualEndDate.Value;

        int intRtn = objPrj.UpdateData(objPrj.IPrj_Ref_Id
                                       , objPrj.IPrj_Code
                                       , objPrj.IPrj_Name
                                       , 0
                                       , objPrj.IDefinition
                                       , objPrj.IRef_Stg
                                       , objPrj.IEffectiveness
                                       , objPrj.IRange
                                       , objPrj.IOwner_Dept_Id
                                       , objPrj.IOwner_Emp_Id
                                       , objPrj.IRequest_Dept
                                       , objPrj.IPriority
                                       , objPrj.ITotal_Budget
                                       , objPrj.IPrj_Type
                                       , objPrj.IInterested_Parties
                                       , objPrj.IPlan_Start_Date
                                       , objPrj.IPlan_End_Date
                                       , objPrj.IActual_Start_Date
                                       , objPrj.IActual_End_Date
                                       , gUserInfo.Emp_Ref_ID
                                       );

        //사업정보공유정보저장

        foreach (UltraGridRow row in ugrdProjectShareList.Rows)
        {
            objPrjShare.IPrj_Ref_Id = this.IPrjRefID;
            objPrjShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);

            if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
            {
                intRtn += objPrjShare.InsertData(objPrjShare.IPrj_Ref_Id
                                                 , objPrjShare.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
            {
                intRtn += objPrjShare.DeleteData(objPrjShare.IPrj_Ref_Id
                                                 , objPrjShare.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
        }

        //사업수행구성원저장

        foreach (UltraGridRow row in ugrdResourceList.Rows)
        {
            objResource.IPrj_Ref_Id = this.IPrjRefID;
            objResource.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
            objResource.IRole_Type  = DataTypeUtility.GetValue(row.Cells.FromKey("ROLE_TYPE").Value);
            objResource.INote       = DataTypeUtility.GetValue(row.Cells.FromKey("NOTE").Value);
            objResource.IIsdelete   = DataTypeUtility.GetValue(row.Cells.FromKey("ISDELETE").Value);

            if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
            {
                intRtn += objResource.InsertData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , objResource.IRole_Type
                                                 , objResource.INote
                                                 , objResource.IIsdelete
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
            {
                intRtn += objResource.UpdateData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , objResource.IRole_Type
                                                 , objResource.INote
                                                 , objResource.IIsdelete
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
            {
                intRtn += objResource.DeleteData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
        }

        #endregion

        if (intRtn > 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("사업정보가 저장되었습니다.");
            this.IType     = "U";
            this.SetFormData();
            this.SetButton();
        }
    }
コード例 #9
0
ファイル: PRJ0101A1.aspx.cs プロジェクト: schifflee/bscgit
    private void InsertViewData()
    {
        if (this.CheckFormData())
        {
            ltrScript.Text = JSHelper.GetAlertScript("사업아이디 또는 사업명이 동일한 값이 존재합니다.");
            return;
        }


        #region 기본정보 저장

        Biz_Prj_Info     objPrj      = new Biz_Prj_Info();
        Biz_Prj_Resource objResource = new Biz_Prj_Resource();
        Biz_Prj_Share    objPrjShare = new Biz_Prj_Share();


        objPrj.IPrj_Code           = txtPRJ_CODE.Text.Trim();
        objPrj.IPrj_Name           = txtPRJ_NAME.Text.Trim();
        objPrj.IDefinition         = txtDEFINITION.Text.Trim();
        objPrj.IRef_Stg            = txtREF_STG.Text.Trim();
        objPrj.IEffectiveness      = txtEFFECTIVENESS.Text.Trim();
        objPrj.IRange              = txtRANGE.Text.Trim();
        objPrj.IOwner_Dept_Id      = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
        objPrj.IOwner_Emp_Id       = DataTypeUtility.GetToInt32(hdfOWNER_EMP_ID.Value);
        objPrj.IRequest_Dept       = txtREQUEST_DEPT.Text.Trim();
        objPrj.IPriority           = WebUtility.GetByValueDropDownList(ddlPRIORITY);
        objPrj.ITotal_Budget       = DataTypeUtility.GetToDecimal(txtTotalBudget.Text);
        objPrj.IPrj_Type           = WebUtility.GetByValueDropDownList(ddlPrjType);
        objPrj.IInterested_Parties = txtINTERESTED_PARTIES.Text.Trim();
        objPrj.IPlan_Start_Date    = wdcPlanStartDate.Value;
        objPrj.IPlan_End_Date      = wdcPlanEndDate.Value;
        objPrj.IActual_Start_Date  = wdcActualStartDate.Value;
        objPrj.IActual_End_Date    = wdcActualEndDate.Value;

        int intRtn = objPrj.InsertData(objPrj.IPrj_Code
                                       , objPrj.IPrj_Name
                                       , 0
                                       , objPrj.IDefinition
                                       , objPrj.IRef_Stg
                                       , objPrj.IEffectiveness
                                       , objPrj.IRange
                                       , objPrj.IOwner_Dept_Id
                                       , objPrj.IOwner_Emp_Id
                                       , objPrj.IRequest_Dept
                                       , objPrj.IPriority
                                       , objPrj.ITotal_Budget
                                       , objPrj.IPrj_Type
                                       , objPrj.IInterested_Parties
                                       , objPrj.IPlan_Start_Date
                                       , objPrj.IPlan_End_Date
                                       , objPrj.IActual_Start_Date
                                       , objPrj.IActual_End_Date
                                       , gUserInfo.Emp_Ref_ID
                                       );


        this.IPrjRefID = objPrj.IPrj_Ref_Id;

        //사업정보공유정보저장

        foreach (UltraGridRow row in ugrdProjectShareList.Rows)
        {
            objPrjShare.IPrj_Ref_Id = this.IPrjRefID;
            objPrjShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);

            if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
            {
                intRtn += objPrjShare.InsertData(objPrjShare.IPrj_Ref_Id
                                                 , objPrjShare.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
            {
                intRtn += objPrjShare.DeleteData(objPrjShare.IPrj_Ref_Id
                                                 , objPrjShare.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
        }


        //사업수행구성원저장

        foreach (UltraGridRow row in ugrdResourceList.Rows)
        {
            objResource.IPrj_Ref_Id = this.IPrjRefID;
            objResource.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
            objResource.IRole_Type  = DataTypeUtility.GetValue(row.Cells.FromKey("ROLE_TYPE").Value);
            objResource.INote       = DataTypeUtility.GetValue(row.Cells.FromKey("NOTE").Value);
            objResource.IIsdelete   = DataTypeUtility.GetValue(row.Cells.FromKey("ISDELETE").Value);

            if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
            {
                intRtn += objResource.InsertData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , objResource.IRole_Type
                                                 , objResource.INote
                                                 , objResource.IIsdelete
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
            {
                intRtn += objResource.UpdateData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , objResource.IRole_Type
                                                 , objResource.INote
                                                 , objResource.IIsdelete
                                                 , gUserInfo.Emp_Ref_ID);
            }
            else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
            {
                intRtn += objResource.DeleteData(objResource.IPrj_Ref_Id
                                                 , objResource.IEmp_Ref_Id
                                                 , gUserInfo.Emp_Ref_ID);
            }
        }

        #endregion

        #region 일정관리
        //Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();

        //objSchedule.IPrj_Ref_Id = this.IPrjRefID;
        //objSchedule.IUp_Task_Ref_Id = 0;

        //intRtn += objSchedule.InsertData(objSchedule.IPrj_Ref_Id
        //                        , 0
        //                        , this.txtPRJ_NAME.Text.Trim()
        //                        , "PAS"
        //                        , 0
        //                        , objSchedule.IUp_Task_Ref_Id
        //                        , "1.0"
        //                        , this.wdcPlanStartDate.Value
        //                        , this.wdcPlanEndDate.Value
        //                        , null
        //                        , null
        //                        , 0
        //                        , ""
        //                        , "N"
        //                        , "N"
        //                        , 0
        //                        , -1
        //                        , ""
        //                        , gUserInfo.Emp_Ref_ID);



        MicroBSC.Integration.PRJ.Biz.Biz_Prj_Schedule bizPrjSchedule = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Schedule();

        intRtn += bizPrjSchedule.AddData(this.IPrjRefID
                                         , 0
                                         , this.txtPRJ_NAME.Text.Trim()
                                         , "PAS"
                                         , 0
                                         , "1.0"
                                         , 0
                                         , this.wdcPlanStartDate.Value
                                         , this.wdcPlanEndDate.Value
                                         , null
                                         , null
                                         , 0
                                         , ""
                                         , "N"
                                         , "N"
                                         , 0
                                         , -1
                                         , ""
                                         , gUserInfo.Emp_Ref_ID);

        #endregion

        if (intRtn > 0)
        {
            string url = "./PRJ0101M1.aspx?iType=U&PRJ_REF_ID=" + this.IPrjRefID + "&CCB1=" + ICCB1;
            ltrScript.Text = string.Format("<script language=javascript>parent.location.replace('" + url + "'); </script>");
        }
    }
コード例 #10
0
    public void SetFormData()
    {
        Biz_Prj_Info     objPrj      = new Biz_Prj_Info(this.IPrjRefID);
        Biz_Prj_Resource prjResource = new Biz_Prj_Resource();
        Biz_Prj_Budget   objBud      = new Biz_Prj_Budget();

        this.IApp_Ref_Id = objPrj.IApp_Ref_Id;
        txtPRJ_CODE.Text = objPrj.IPrj_Code;
        txtPRJ_NAME.Text = objPrj.IPrj_Name;
        this.IDraftEmpID = objPrj.IOwner_Emp_Id;


        if (this.IPrjRefID == 0)
        {
            return;
        }


        lblPrjPeriod.Text = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date).ToShortDateString() + " ~ " + DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date).ToShortDateString();

        this.ITotalBudget         = objPrj.ITotal_Budget;
        lblTotalBudgetAmount.Text = this.ITotalBudget.ToString("###,##0");


        ugrdBudgetList.Clear();

        DataSet   ds      = objBud.SelectMonthRateList(this.IPrjRefID);
        DataTable dt      = objBud.GetDataTableSchema();
        DateTime  dtStart = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date);
        DateTime  dtEnd   = DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date);


        for (DateTime date = dtStart; date <= dtEnd;)
        {
            DataRow dataRow = null;

            dataRow = GetBudGetYM(ds.Tables[0], date.ToString("yyyyMM"));

            if (dataRow == null)
            {
                dataRow = dt.NewRow();

                dataRow["ITYPE"]          = "A";
                dataRow["PRJ_REF_ID"]     = this.IPrjRefID;
                dataRow["BUDGET_YM"]      = date.ToString("yyyyMM");
                dataRow["BUDGET_YM_NAME"] = date.ToString("yyyy년 MM월");
                dataRow["MONTHLY_AMOUNT"] = 0;
                dataRow["AMOUNT"]         = 0;
                dataRow["RATE"]           = DBNull.Value;

                dt.Rows.Add(dataRow);
            }
            else
            {
                dt.ImportRow(dataRow);
            }

            date = date.AddMonths(1);
        }

        ugrdBudgetList.DataSource = dt;
        ugrdBudgetList.DataBind();
    }
コード例 #11
0
ファイル: PRJ0102S3.aspx.cs プロジェクト: schifflee/bscgit
    private void SetPageType()
    {
        if (PAGE_TYPE.Equals("P"))
        {
            SetMenuControl(false, false, false);

            IPrjRefID = GetRequestByInt("PRJ_REF_ID", 0);
            PRJ_TYPE  = GetRequest("PRJ_TYPE", "");

            if (IPrjRefID > 0)
            {
                PageUtility.FindByValueDropDownList(ddlPrjType, this.IPrjRefID.ToString());
            }

            Biz_Prj_Info      objPrjInfo = new Biz_Prj_Info(IPrjRefID);
            Biz_Com_Code_Info objComCode = new Biz_Com_Code_Info();

            DataSet   ds = objComCode.GetProjectType(0);
            DataRow[] dr = ds.Tables[0].Select("ETC_CODE='" + PRJ_TYPE + "'");

            //ddlPrjType.Visible = false;
            //ddlPrjName.Visible = false;
            iBtnSearch.Visible = false;

            lblPrjTypeName.Visible = true;
            lblPrjName.Visible     = true;
            ImgClose.Visible       = true;

            lblPrjName.Text     = objPrjInfo.IPrj_Name;
            lblPrjTypeName.Text = dr[0].ItemArray[3].ToString(); //CODE_NAME
            BindGanttChart(IPrjRefID);

            pnlPrjInfo.Visible   = true;
            pnlPrjSearch.Visible = false;
        }
        else
        {
            pnlPrjInfo.Visible   = false;
            pnlPrjSearch.Visible = true;
            BindGanttChart(IPrjRefID);
        }

        // 프로젝트 책임자 또는 사업구성원이 아닐경우
        Biz_Prj_Info     objPrj = new Biz_Prj_Info(this.IPrjRefID);
        Biz_Prj_Resource objRes = new Biz_Prj_Resource(this._iPrjRefID, gUserInfo.Emp_Ref_ID);

        if (!objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) ||
            (objRes == null))
        {
            _readOnlyYN = "Y";
        }
        else if (objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) && objPrj.IComplete_YN == "Y")
        {
            _readOnlyYN = "Y";
        }
        else if (this.PAGE_TYPE == "N")
        {
            _readOnlyYN = "N";
        }
        else
        {
            _readOnlyYN = "N";
        }

        Biz_Prj_Schedule objSch = new Biz_Prj_Schedule();

        lblPROCEED_RATE.Text    = objSch.GetTotalRate(this.IPrjRefID, 0).ToString();
        lblActualEDate.Text     = (objPrj.IActual_End_Date == DBNull.Value)   ? "" : Convert.ToDateTime(objPrj.IActual_End_Date).ToShortDateString();
        lblActualSDate.Text     = (objPrj.IActual_Start_Date == DBNull.Value) ? "" : Convert.ToDateTime(objPrj.IActual_Start_Date).ToShortDateString();
        lblplanEDate.Text       = (objPrj.IPlan_End_Date == DBNull.Value)     ? "" : Convert.ToDateTime(objPrj.IPlan_End_Date).ToShortDateString();
        lblplanSDate.Text       = (objPrj.IPlan_Start_Date == DBNull.Value)   ? "" : Convert.ToDateTime(objPrj.IPlan_Start_Date).ToShortDateString();
        lblOWNER_DEPT_NAME.Text = objPrj.IOwner_Dept_Name;
        lblOWNER_EMP_NAME.Text  = objPrj.IOwner_Emp_Name;

        PageUtility.FindByValueDropDownList(ddlPRIORITY, objPrj.IPriority);
        lblPRIORITY.Text = PageUtility.GetByTextDropDownList(ddlPRIORITY);

        lblTOTAL_BUDGET.Text  = objPrj.ITotal_Budget.ToString();
        lblREF_STG.Text       = objPrj.IRef_Stg;
        lblEFFECTIVENESS.Text = objPrj.IEffectiveness;
        lblRANGE.Text         = objPrj.IRange;
        lblPRJ_TYPE.Text      = PageUtility.GetByTextDropDownList(ddlPrjType);
    }