//===================================: 비용관리 조회
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");
}
private void UpdateViewData()
{
#region 비용관리 저장
Biz_Prj_Budget objBudget = new Biz_Prj_Budget();
int intRtn = objBudget.DeleteData(this.IPrjRefID
, ""
, gUserInfo.Emp_Ref_ID);
foreach (UltraGridRow row in ugrdBudgetList.Rows)
{
objBudget.IPrj_Ref_Id = this.IPrjRefID;
objBudget.IBudget_Ym = DataTypeUtility.GetValue(row.Cells.FromKey("BUDGET_YM").Value);
objBudget.IMonthly_Amount = DataTypeUtility.GetToDecimal(row.Cells.FromKey("MONTHLY_AMOUNT").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objBudget.InsertData(objBudget.IPrj_Ref_Id
, objBudget.IBudget_Ym
, objBudget.IMonthly_Amount
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objBudget.UpdateData(objBudget.IPrj_Ref_Id
, objBudget.IBudget_Ym
, objBudget.IMonthly_Amount
, gUserInfo.Emp_Ref_ID);
}
}
#endregion
if (intRtn > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("비용관리정보가 저장되었습니다.");
this.IType = "U";
this.SetFormData();
this.SetButton();
}
}
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();
}
