public Dac_Prj_Schedule(int iprj_ref_id, int itask_ref_id)
{
DataSet ds = this.GetOneList(iprj_ref_id, itask_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
_iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_itask_ref_id = DataTypeUtility.GetToInt32(dr["TASK_REF_ID"]);
_itask_name = DataTypeUtility.GetValue(dr["TASK_NAME"]);
_itask_type = DataTypeUtility.GetValue(dr["TASK_TYPE"]);
_itask_weight = DataTypeUtility.GetToDecimal(dr["TASK_WEIGHT"]);
_iup_task_ref_id = DataTypeUtility.GetToInt32(dr["UP_TASK_REF_ID"]);
_itask_code = DataTypeUtility.GetValue(dr["TASK_CODE"]);
_iplan_start_date = dr["PLAN_START_DATE"];
_iplan_end_date = dr["PLAN_END_DATE"];
_iactual_start_date = dr["ACTUAL_START_DATE"];
_iactual_end_date = dr["ACTUAL_END_DATE"];
_iproceed_rate = DataTypeUtility.GetToDecimal(dr["PROCEED_RATE"]);
_iatt_file = DataTypeUtility.GetValue(dr["ATT_FILE"]);
_icomplete_yn = DataTypeUtility.GetValue(dr["COMPLETE_YN"]);
_iisdelete = DataTypeUtility.GetValue(dr["ISDELETE"]);
_inode_depth = DataTypeUtility.GetToInt32(dr["NODE_DEPTH"]);
_iafter_task_ref_id = DataTypeUtility.GetToInt32(dr["AFTER_TASK_REF_ID"]);
_idesction = DataTypeUtility.GetString(dr["DESCTION"]);
_icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]);
_icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]);
_iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
_iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
}
}
protected void grdBudgetList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.Cells[1].Text != " ")
{
TOTAL_MONTHLY_AMOUNT += DataTypeUtility.GetToDecimal(e.Row.Cells[1].Text);
}
if (e.Row.Cells[2].Text != " ")
{
TOTAL_AMOUNT += DataTypeUtility.GetToDecimal(e.Row.Cells[2].Text);
}
if (e.Row.Cells[3].Text != " ")
{
TOTAL_RATE += DataTypeUtility.GetToDecimal(e.Row.Cells[3].Text);
}
e.Row.Cells[1].Style.Add(HtmlTextWriterStyle.TextAlign, "right");
e.Row.Cells[2].Style.Add(HtmlTextWriterStyle.TextAlign, "right");
e.Row.Cells[3].Style.Add(HtmlTextWriterStyle.TextAlign, "right");
}
else if (e.Row.RowType == DataControlRowType.Header)
{
}
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string strSpace = "";
int intLevel = int.Parse(e.Row.Cells.FromKey("DEPT_LEVEL").Value.ToString());
for (int i = 0; i < intLevel; i++)
{
strSpace += " ";
}
if (intLevel < 4)
{
e.Row.Cells.FromKey("DEPT_NAME").Text = "<b>" + strSpace + e.Row.Cells.FromKey("DEPT_NAME").Text + "<b>";
}
else
{
e.Row.Cells.FromKey("DEPT_NAME").Text = " " + strSpace + e.Row.Cells.FromKey("DEPT_NAME").Text;
}
decimal dWeight = DataTypeUtility.GetToDecimal(e.Row.Cells.FromKey("TOT_WEIGHT").Value);
if (dWeight == 100)
{
e.Row.Cells.FromKey("TOT_WEIGHT").Style.ForeColor = System.Drawing.Color.Blue;
}
else
{
e.Row.Cells.FromKey("TOT_WEIGHT").Style.ForeColor = System.Drawing.Color.Red;
}
}
private decimal GetPlanSumBudGet()
{
decimal sumAmount = 0;
foreach (UltraGridRow row in ugrdBudgetList.Rows)
{
sumAmount += DataTypeUtility.GetToDecimal(row.Cells.FromKey("MONTHLY_AMOUNT").Value);
}
return(sumAmount);
}
protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Execution objExecution = new Biz_Prj_Execution();
//사업비용집행내역
int intRtn = 0;
foreach (UltraGridRow row in ugrdPrjList.Rows)
{
objExecution.IExec_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EXEC_REF_ID").Value);
objExecution.IPrj_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("PRJ_REF_ID").Value);
objExecution.ITask_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("TASK_REF_ID").Value);
objExecution.IExec_Date = row.Cells.FromKey("EXEC_DATE").Value;
objExecution.IAmount = DataTypeUtility.GetToDecimal(row.Cells.FromKey("AMOUNT").Value);
objExecution.IExec_Content = DataTypeUtility.GetValue(row.Cells.FromKey("EXEC_CONTENT").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objExecution.InsertData(objExecution.IPrj_Ref_Id
, objExecution.ITask_Ref_Id
, objExecution.IExec_Date
, objExecution.IAmount
, objExecution.IExec_Content
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objExecution.UpdateData(objExecution.IExec_Ref_Id
, objExecution.IPrj_Ref_Id
, objExecution.ITask_Ref_Id
, objExecution.IExec_Date
, objExecution.IAmount
, objExecution.IExec_Content
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objExecution.DeleteData(objExecution.IExec_Ref_Id, gUserInfo.Emp_Ref_ID);
}
}
if (intRtn > 0)
{
this.BeforeSearch();
}
}
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 Dac_Prj_Execution(int iexec_ref_id)
{
DataSet ds = this.GetOneList(iexec_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
_iexec_ref_id = DataTypeUtility.GetToInt32(dr["EXEC_REF_ID"]);
_iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_itask_ref_id = DataTypeUtility.GetToInt32(dr["TASK_REF_ID"]);
_iexec_date = DataTypeUtility.GetToDateTime(dr["EXEC_DATE"]);
_iamount = DataTypeUtility.GetToDecimal(dr["AMOUNT"]);
_iexec_content = DataTypeUtility.GetValue(dr["EXEC_CONTENT"]);
_icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]);
_icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]);
_iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
_iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
}
}
public Dac_Prj_Info(int iprj_ref_id)
{
DataSet ds = this.GetOneList(iprj_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
_iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_iprj_code = DataTypeUtility.GetValue(dr["PRJ_CODE"]);
_iprj_name = DataTypeUtility.GetValue(dr["PRJ_NAME"]);
_iapp_ref_id = DataTypeUtility.GetToDecimal(dr["APP_REF_ID"]);
_idefinition = DataTypeUtility.GetValue(dr["DEFINITION"]);
_iref_stg = DataTypeUtility.GetValue(dr["REF_STG"]);
_ieffectiveness = DataTypeUtility.GetValue(dr["EFFECTIVENESS"]);
_irange = DataTypeUtility.GetValue(dr["RANGE"]);
_iowner_dept_id = DataTypeUtility.GetToInt32(dr["OWNER_DEPT_ID"]);
_iowner_emp_id = DataTypeUtility.GetToInt32(dr["OWNER_EMP_ID"]);
_iowner_dept_name = DataTypeUtility.GetValue(dr["OWNER_DEPT_NAME"]);
_iowner_emp_name = DataTypeUtility.GetValue(dr["OWNER_EMP_NAME"]);
_irequest_dept = DataTypeUtility.GetValue(dr["REQUEST_DEPT"]);
_ipriority = DataTypeUtility.GetValue(dr["PRIORITY"]);
_itotal_budget = DataTypeUtility.GetToDecimal(dr["TOTAL_BUDGET"]);
_iprj_type = DataTypeUtility.GetValue(dr["PRJ_TYPE"]);
_iinterested_parties = DataTypeUtility.GetValue(dr["INTERESTED_PARTIES"]);
_iplan_start_date = dr["PLAN_START_DATE"];
_iplan_end_date = dr["PLAN_END_DATE"];
_iactual_start_date = dr["ACTUAL_START_DATE"];
_iactual_end_date = dr["ACTUAL_END_DATE"];
_isdelete = DataTypeUtility.GetValue(dr["ISDELETE"]);
_complete_yn = DataTypeUtility.GetValue(dr["COMPLETE_YN"]);
_icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]);
_icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]);
_iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
_iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
}
}
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();
}
}
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>");
}
}
public void SetMBOKpi(string iType)
{
int itxr_user = gUserInfo.Emp_Ref_ID;
CheckBox chk;
UltraGridRow row;
TemplatedColumn col;
UltraWebGrid ugrdKpi = (iType == "ADD") ? ugrdKpiList : ugrdChildKpi;
int cntRow = 0;
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
if (iType == "DEL")
{
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("EMP_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
for (int i = 0; i < ugrdKpi.Rows.Count; i++)
{
row = ugrdKpi.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["EMP_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
if (objBSC.DeleteMBOWeight(dt, gUserInfo.Emp_Ref_ID))
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("삭제하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
return;
}
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
dt.Columns.Add("WEIGHT", typeof(decimal));
dt.Columns.Add("KPI_CLASS_REF_ID", typeof(string));
for (int i = 0; i < ugrdKpi.Rows.Count; i++)
{
row = ugrdKpi.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
if (iType == "ADD")
{
dr["WEIGHT"] = 0;
}
else if (iType == "SET")
{
dr["WEIGHT"] = DataTypeUtility.GetToDecimal(row.Cells.FromKey("WEIGHT").Value);
}
try
{
dr["KPI_CLASS_REF_ID"] = (row.Cells.FromKey("IS_TEAM_KPI").Value.ToString() == "Y" ? "SCO" : "PCO");
}
catch { }
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
if (objBSC.UpdateMBOWeight(gUserInfo.Emp_Ref_ID
, dt))
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("처리하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
return;
}
}
if (cntRow < 1)
{
PageUtility.AlertMessage("항목을 선택하세요.");
}
else
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("삭제하였습니다.");
}
}
protected void ugrdBudgetList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
Biz_Prj_Execution objExecution = new Biz_Prj_Execution();
DataSet ds = objExecution.GetTotalSum(this.IPrjRefID, drw["BUDGET_YM"].ToString(), DataTypeUtility.GetToDecimal(drw["MONTHLY_AMOUNT"]));
if (ds.Tables != null && ds.Tables[0].Rows.Count > 0)
{
e.Row.Cells.FromKey("AMOUNT").Value = ds.Tables[0].Rows[0]["AMOUNT"];
e.Row.Cells.FromKey("RATE").Value = ds.Tables[0].Rows[0]["RATE"];
}
}
protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
Biz_Prj_Task_Owner objTaskOwner = new Biz_Prj_Task_Owner();
Biz_Prj_Task_Share objTaskShare = new Biz_Prj_Task_Share();
string[,] saAttachInfo = TypeUtility.GetSplit(hdfAttachNo.Value);
string strAttach = hdfAttachNo.Value;
if (saAttachInfo.Length / 2 >= 1)
{
if (Convert.ToInt32(saAttachInfo[1, 0]) > 0)
{
strAttach = saAttachInfo[0, 0];
}
}
objSchedule.IPrj_Ref_Id = this.IPrjRefID;
objSchedule.ITask_Ref_Id = this.ITaskRefID;
objSchedule.ITask_Code = txtTaskCode.Text.Trim();
objSchedule.ITask_Name = txtTaskName.Text.Trim();
objSchedule.IUp_Task_Ref_Id = DataTypeUtility.GetToInt32(hdfUpTaskRefID.Value);
objSchedule.ITask_Type = WebUtility.GetByValueDropDownList(ddlTaskType);
objSchedule.IPlan_Start_Date = wdcSchPlanStartDate.Value;
objSchedule.IPlan_End_Date = wdcSchPlanEndDate.Value;
objSchedule.IActual_Start_Date = wdcSchActualStartDate.Value;
objSchedule.IActual_End_Date = wdcSchActualEndDate.Value;
objSchedule.IProceed_Rate = DataTypeUtility.GetToDecimal(txtProceedRate.Text.Trim());
objSchedule.IAtt_File = strAttach;
objSchedule.INode_Depth = DataTypeUtility.GetToInt32(hdfNodeDepth.Value);
objSchedule.IComplete_Yn = "N";
objSchedule.IIsdelete = "N";
objSchedule.IAfter_Task_Ref_Id = -1;
objSchedule.IDesction = this.txtDesction.Text.Trim();
int intRtn = objSchedule.UpdateData(objSchedule.IPrj_Ref_Id
, objSchedule.ITask_Ref_Id
, objSchedule.ITask_Name
, objSchedule.ITask_Type
, this.ITaskWeight
, objSchedule.IUp_Task_Ref_Id
, objSchedule.ITask_Code
, objSchedule.IPlan_Start_Date
, objSchedule.IPlan_End_Date
, objSchedule.IActual_Start_Date
, objSchedule.IActual_End_Date
, objSchedule.IProceed_Rate
, objSchedule.IAtt_File
, objSchedule.IComplete_Yn
, objSchedule.IIsdelete
, objSchedule.INode_Depth
, objSchedule.IAfter_Task_Ref_Id
, objSchedule.IDesction
, gUserInfo.Emp_Ref_ID);
//작업수행담당자 저장
foreach (UltraGridRow row in ugrdTaskOwnerList.Rows)
{
objTaskOwner.IPrj_Ref_Id = this.IPrjRefID;
objTaskOwner.ITask_Ref_Id = this.ITaskRefID;
objTaskOwner.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objTaskOwner.InsertData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, "N"
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objTaskOwner.UpdateData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, "N"
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objTaskOwner.DeleteData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
////일정공유자 저장
//foreach (UltraGridRow row in ugrdTaskShareList.Rows)
//{
// objTaskShare.IPrj_Ref_Id = this.IPrjRefID;
// objTaskShare.ITask_Ref_Id = this.ITaskRefID;
// objTaskShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
// if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
// {
// intRtn += objTaskShare.InsertData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
// else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
// {
// intRtn += objTaskShare.UpdateData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
// else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
// {
// intRtn += objTaskShare.DeleteData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
//}
ugrdTaskOwnerList.Clear();
//ugrdTaskShareList.Clear();
ugrdTaskOwnerList.DataSource = objTaskOwner.GetAllList(this.IPrjRefID, 0, this.ITaskRefID);
ugrdTaskOwnerList.DataBind();
//ugrdTaskShareList.DataSource = objTaskShare.GetAllList(this.IPrjRefID, this.ITaskRefID, 0);
//ugrdTaskShareList.DataBind();
if (intRtn > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("작업정보가 저장되었습니다.", true);
}
}
public bool SendMailBatch(bool isReturn)
{
if (PageUtility.GetAppConfig("Mail.UseDraftMailYN") == "N")
{
return(true);
}
string sC_EMP_MAIL = "";
string sP_EMP_MAIL = "";
string sN_EMP_MAIL = "";
string sFile = "Mail_Draft.htm";
EmpInfos objEmp = new EmpInfos(gUserInfo.Emp_Ref_ID);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
bool bRtn = objPrc.GetSendMailUser(this.IApp_Ref_Id, this.IVersion_No, gUserInfo.Emp_Ref_ID, out sC_EMP_MAIL, out sP_EMP_MAIL, out sN_EMP_MAIL);
if (!bRtn)
{
return(false);
}
if (isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sN_EMP_MAIL)))
{
return(false);
}
if (!isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sP_EMP_MAIL)))
{
return(false);
}
DataTable dtMailParam = new DataTable("PARAM");
dtMailParam.Columns.Add("KEY", typeof(string));
dtMailParam.Columns.Add("VAL", typeof(string));
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objKPI = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtKpi = new DataTable();
if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
{
dtKpi = objKPI.GetKpiListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID", "")).Tables[0];
}
else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
{
dtKpi = objKPI.GetKpiResultListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), GetRequest("YMD"), "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID")).Tables[0];
}
else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
{
dtKpi = objKPI.GetKpiResultListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), GetRequest("YMD"), "", "", "N", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID")).Tables[0];
}
bool rtnValue = false;
foreach (DataRow drKpi in dtKpi.Rows)
{
Biz_Com_Approval_Info objMst = new Biz_Com_Approval_Info(DataTypeUtility.GetToDecimal(drKpi["APP_REF_ID"]), 1);
string strVPath = Request.ApplicationPath;
string strSHost = Request.Url.Host;
string strSPort = Request.Url.Port.ToString();
string strProto = Request.Url.Scheme;
strVPath = (strVPath == "/") ? "" : strVPath;
string strFullPath = strProto + "://" + strSHost + ":" + strSPort + strVPath;
DataRow dr = null;
dr = dtMailParam.NewRow();
dr["KEY"] = "[SITE_URL]";
dr["VAL"] = strFullPath;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[BIZ_TYPE]";
dr["VAL"] = Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_doc);
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[APP_CODE]";
dr["VAL"] = objMst.IApp_Code;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TITLE]";
dr["VAL"] = objMst.ITitle;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[EMP_NAME]";
dr["VAL"] = objEmp.Emp_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DEPT_NAME]";
dr["VAL"] = objEmp.Dept_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TRX_DATE]";
dr["VAL"] = objMst.IUpdate_Date.ToShortDateString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TODAY]";
dr["VAL"] = DateTime.Now.ToString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DRAFT_TYPE]";
dr["VAL"] = (isReturn) ? "반려" : "승인요청";
dtMailParam.Rows.Add(dr);
string sMailTitle = "";
if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_doc) + " 건 알림메일]";
}
else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_rst) + " 건 알림메일]";
}
else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_target_result) + " 건 알림메일]";
}
rtnValue = PageUtility.SendMail(dtMailParam, sC_EMP_MAIL, (isReturn) ? sN_EMP_MAIL : sP_EMP_MAIL, sMailTitle, sFile);
}
return(rtnValue);
}
