private void DeleteViewData()
{
#region 기본정보 삭제
Biz_Prj_Info objPrj = new Biz_Prj_Info();
objPrj.IPrj_Ref_Id = this.IPrjRefID;
int intRtn = objPrj.DeleteData(objPrj.IPrj_Ref_Id
, gUserInfo.Emp_Ref_ID
);
ltrScript.Text = JSHelper.GetAlertScript(objPrj.Transaction_Message, false);
if (objPrj.Transaction_Result == "Y")
{
ltrScript.Text = JSHelper.GetAlertScript("사업정보가 삭제되었습니다.");
this.IType = "D";
this.SetFormData();
this.SetButton();
}
else
{
}
#endregion
}
public void InitForm()
{
WebCommon.FillComDeptTree(trvDept);
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IKey);
this.txtTitle.Text = "[" + Biz_Type.biz_type_prm_doc_name + "]" + objPrj.IPrj_Name;
}
public void SetPrjList()
{
Biz_Prj_Info objPrj = new Biz_Prj_Info();
string iprj_code = txtPrjCode.Text.Trim();
string iprj_name = txtPrjName.Text.Trim();
int iowner_dept_id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
string iowner_emp_name = txtOwnerEmpName.Text.Trim();
string iprj_type = WebUtility.GetByValueDropDownList(ddlPrjType);
DateTime iplan_start_date = (DateTime)wdcPlanStartDate.Value;
DateTime iplan_end_date = (DateTime)wdcPlanEndDate.Value;
int iowner_emp_id = (User.IsInRole(ROLE_ADMIN)) ? 0 : gUserInfo.Emp_Ref_ID;
string sSDate = iplan_start_date.Year.ToString() + "-" + iplan_start_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_start_date.Day.ToString().PadLeft(2, '0') + " 00:00:00";
string sEDate = iplan_end_date.Year.ToString() + "-" + iplan_end_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_end_date.Day.ToString().PadLeft(2, '0') + " 23:59:59";
DataSet rDs = objPrj.GetUserAllList(iprj_code
, iprj_name
, iowner_dept_id
, iowner_emp_name
, iprj_type
, Convert.ToDateTime(sSDate)
, Convert.ToDateTime(sEDate)
, iowner_emp_id);
ugrdPrjList.Clear();
ugrdPrjList.DataSource = rDs;
ugrdPrjList.DataBind();
lblRowCount.Text = rDs.Tables[0].Rows.Count.ToString();
}
public void SetPrjList()
{
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Info bizPrjInfo = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Info();
Biz_Prj_Info objPrj = new Biz_Prj_Info();
string iprj_code = ""; //txtPrjCode.Text.Trim();
string iprj_name = ""; // txtPrjName.Text.Trim();
int iowner_dept_id = 0; // WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
string iowner_emp_name = ""; // txtOwnerEmpName.Text.Trim();
string iprj_type = ""; // WebUtility.GetByValueDropDownList(ddlPrjType);
object iplan_start_date = base.GetStartDayofCurrent();
object iplan_end_date = base.GetEndDayofCurrent();
//DataSet rDs = objPrj.GetAllList(iprj_code
// , iprj_name
// , iowner_dept_id
// , iowner_emp_name
// , iprj_type
// , iplan_start_date
// , iplan_end_date);
DataTable dt = bizPrjInfo.Get_Prj_Info_Not_In_Question_Map(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
ugrdPrjList.Clear();
ugrdPrjList.DataSource = dt;
ugrdPrjList.DataBind();
}
private void SetPrjInfoData()
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(IPrjRefID);
Biz_Com_Code_Info objPrjPriority = new Biz_Com_Code_Info("PM001", objPrjInfo.IPriority);
Biz_Com_Code_Info objPrjType = new Biz_Com_Code_Info("PM002", objPrjInfo.IPrj_Type);
lblPRJCode.Text = objPrjInfo.IPrj_Code;
lblPRJName.Text = objPrjInfo.IPrj_Name;
lblPRJDefinition.Text = objPrjInfo.IDefinition;
lblPlanStartDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IPlan_Start_Date);
lblPlanEndDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IPlan_End_Date);
lblActualStartDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IActual_Start_Date);
lblActualEndDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IActual_End_Date);
hdfPrjType.Value = objPrjInfo.IPrj_Type;
lblPRJTypeName.Text = objPrjType.Icode_name;
hdfOwnerDeptID.Value = objPrjInfo.IOwner_Dept_Id.ToString();
lblOwnerDeptName.Text = objPrjInfo.IOwner_Dept_Name;
hdfOwnerEmpID.Value = objPrjInfo.IOwner_Emp_Id.ToString();
lblOwnerEmpName.Text = objPrjInfo.IOwner_Emp_Name;
lblRequestDept.Text = objPrjInfo.IRequest_Dept;
lblPriorityName.Text = objPrjPriority.Icode_name;
hdfPriority.Value = objPrjInfo.IPriority;
lblTotalBudget.Text = objPrjInfo.ITotal_Budget.ToString("###,##0") + " 원";
lblInterested.Text = objPrjInfo.IInterested_Parties;
lblRefStg.Text = objPrjInfo.IRef_Stg;
lblEffectiveness.Text = objPrjInfo.IEffectiveness;
lblRange.Text = objPrjInfo.IRange;
}
public void SetFormData()
{
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID);
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;
}
public void SetPrjList()
{
Biz_Prj_Info objPrj = new Biz_Prj_Info();
string iprj_code = txtPrjCode.Text.Trim();
string iprj_name = txtPrjName.Text.Trim();
int iowner_dept_id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
string iowner_emp_name = txtOwnerEmpName.Text.Trim();
string iprj_type = WebUtility.GetByValueDropDownList(ddlPrjType);
DateTime iplan_start_date = (DateTime)wdcPlanStartDate.Value;
DateTime iplan_end_date = (DateTime)wdcPlanEndDate.Value;
int iowner_emp_id = (User.IsInRole(ROLE_ADMIN)) ? 0 : EMP_REF_ID;
string sSDate = iplan_start_date.Year.ToString() + "-" + iplan_start_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_start_date.Day.ToString().PadLeft(2, '0') + " 00:00:00";
string sEDate = iplan_end_date.Year.ToString() + "-" + iplan_end_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_end_date.Day.ToString().PadLeft(2, '0') + " 23:59:59";
//int iTxrUser = (User.IsInRole(ROLE_ADMIN)) ? 0 : EMP_REF_ID;
DataSet rDs = objPrj.GetTotalStateList(iprj_code
, iprj_name
, iowner_dept_id
, iowner_emp_name
, iprj_type
, Convert.ToDateTime(sSDate)
, Convert.ToDateTime(sEDate)
, iowner_emp_id);
if (rDs.Tables.Count > 0)
{
rDs.Tables[0].DefaultView.Sort = "PRJ_CODE ASC";
ugrdPrjList.Clear();
ugrdPrjList.DataSource = rDs.Tables[0].DefaultView;
ugrdPrjList.DataBind();
}
else
{
ugrdPrjList.Clear();
}
lblRowCount.Text = rDs.Tables[0].Rows.Count.ToString();
//DataSet ds = objPrj.GetExcelDownList(iprj_code
// , iprj_name
// , iowner_dept_id
// , iowner_emp_name
// , iprj_type
// , iplan_start_date
// , iplan_end_date
// , gUserInfo.Emp_Ref_ID);
//UltraWebGrid1.Clear();
//UltraWebGrid1.DataSource = ds;
//UltraWebGrid1.DataBind();
}
//===================================: 비용관리 조회
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 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";
}
}
private bool CheckFormData()
{
bool isCheck = false;
Biz_Prj_Info objPrj = new Biz_Prj_Info();
objPrj.IPrj_Code = txtPRJ_CODE.Text.Trim();
objPrj.IPrj_Name = txtPRJ_NAME.Text.Trim();
isCheck = objPrj.IsExist(objPrj.IPrj_Code, objPrj.IPrj_Name);
return(isCheck);
}
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();
}
protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID);
this.ITotalBudget = objPrj.ITotal_Budget;
// 비용금액 체크
if (GetPlanSumBudGet() > this.ITotalBudget)
{
ltrScript.Text = JSHelper.GetAlertScript("계획예산금액이 총예산금액보다 큽니다. 다시 예산을 책정해주세요.");
return;
}
this.UpdateViewData();
}
private void GridDoLayout(UltraWebGrid grid)
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info();
_iprjType = WebUtility.GetByValueDropDownList(ddlPrjType);
_iprjCode = txtPrjCode.Text.Trim();
_iprjName = txtPrjName.Text.Trim();
DataTable dt = objPrjInfo.GetTotalFootInfo(_iprjCode
, _iprjName
, _iprjType).Tables[0];
UltraGridRow row = new UltraGridRow();
grid.Rows.Add(row);
UltraGridRow row2 = new UltraGridRow();
grid.Rows.Add(row2);
UltraGridRow row3 = new UltraGridRow();
grid.Rows.Add(row3);
row.Cells.FromKey("KPI_NAME").Value = "<B>소요예산 : </B>";
row2.Cells.FromKey("KPI_NAME").Value = "<B>집행현황 : </B>";
row3.Cells.FromKey("KPI_NAME").Value = "<B>진행율(%): </B>";
foreach (UltraGridColumn col in grid.Columns)
{
foreach (DataRow dr in dt.Rows)
{
if (col.Header.Column.Key == dr["PRJ_REF_ID"].ToString())
{
double dTotalBudget = DataTypeUtility.GetToDouble(dr["TOTAL_BUDGET"]);
row.Cells.FromKey(col.Header.Column.Key).Value = dTotalBudget.ToString("###,##0.#0");
double dExecAmount = DataTypeUtility.GetToDouble(dr["EXEC_AMOUNT"]);
row2.Cells.FromKey(col.Header.Column.Key).Value = dExecAmount.ToString("###,##0.#0");
double dTotalRate = DataTypeUtility.GetToDouble(dr["RATE"]);
row3.Cells.FromKey(col.Header.Column.Key).Value = dTotalRate.ToString("##0.#0");
}
}
}
}
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;
}
}
private void UpdateComplete(string icompleteYN)
{
Biz_Prj_Info objPrj = new Biz_Prj_Info();
objPrj.IPrj_Ref_Id = this.IPrjRefID;
objPrj.IComplete_YN = icompleteYN;
int intRtn = objPrj.UpdateComplete(objPrj.IPrj_Ref_Id
, objPrj.IComplete_YN
, gUserInfo.Emp_Ref_ID
);
if (intRtn > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("사업정보 마감정보가 변경되었습니다.");
this.IType = "U";
this.SetFormData();
this.SetButton();
}
}
private void ReUsedViewData()
{
Biz_Prj_Info objPrj = new Biz_Prj_Info();
objPrj.IPrj_Ref_Id = this.IPrjRefID;
int intRtn = objPrj.ReUsedData(objPrj.IPrj_Ref_Id
, gUserInfo.Emp_Ref_ID
);
ltrScript.Text = JSHelper.GetAlertScript(objPrj.Transaction_Message, false);
if (objPrj.Transaction_Result == "Y")
{
this.IType = "U";
this.SetFormData();
this.SetButton();
}
else
{
}
}
protected void iBtnAddRow_Click(object sender, ImageClickEventArgs e)
{
this.IPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName);
if (this._iPrjRefID == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("사업명을 먼저 선택하여 주세요.");
return;
}
Biz_Prj_Info objInfo = new Biz_Prj_Info(IPrjRefID);
UltraGridRow row = new UltraGridRow(new object[] { "", "A", 0, objInfo.IPrj_Ref_Id, objInfo.IPrj_Code, objInfo.IPrj_Name, objInfo.IOwner_Emp_Id, objInfo.IOwner_Emp_Name, "", "", DateTime.Now.ToShortDateString(), "0" });
int cntRow = 0;
ugrdPrjList.Rows.Add(row);
cntRow = ugrdPrjList.Rows.Count - 1;
//ugrdPrjList.Rows[cntRow].Cells.FromKey("ITYPE").Value = "A";
}
private void FormDataBind()
{
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule(this.IPrjRefID, this.ITaskRefID);
Biz_Prj_Info objInfo = new Biz_Prj_Info(this.IPrjRefID);
Biz_Prj_Schedule objUpSchedule = new Biz_Prj_Schedule(this.IPrjRefID, objSchedule.IUp_Task_Ref_Id);
Biz_Prj_Task_Owner objTaskOwner = new Biz_Prj_Task_Owner();
Biz_Prj_Task_Share objTaskShare = new Biz_Prj_Task_Share();
txtPrjName.Text = objInfo.IPrj_Name;
txtPrjPeriod.Text = DataTypeUtility.GetToDateTimeText(objInfo.IPlan_Start_Date) + " ~ " + DataTypeUtility.GetToDateTimeText(objInfo.IPlan_End_Date);
txtTaskCode.Text = objSchedule.ITask_Code;
txtTaskName.Text = objSchedule.ITask_Name;
txtUpTaskName.Text = objUpSchedule.ITask_Name;
hdfUpTaskRefID.Value = objSchedule.IUp_Task_Ref_Id.ToString();
this.ITaskWeight = objSchedule.ITask_Weight;
wdcSchPlanStartDate.Value = objSchedule.IPlan_Start_Date;
wdcSchPlanEndDate.Value = objSchedule.IPlan_End_Date;
wdcSchActualStartDate.Value = objSchedule.IActual_Start_Date;
wdcSchActualEndDate.Value = objSchedule.IActual_End_Date;
txtProceedRate.Text = objSchedule.IProceed_Rate.ToString("##0.#0");
hdfAttachNo.Value = objSchedule.IAtt_File;
hdfNodeDepth.Value = objSchedule.INode_Depth.ToString();
txtDesction.Text = objSchedule.IDesction;
SetUploadFileInfo(hdfAttachNo.Value, ddlFileUpload);
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();
}
protected void Page_Load(object sender, EventArgs e)
{
bizPrjInfo = new Biz_Prj_Info();
bizPrjData = new Biz_Prj_Data();
if (!IsPostBack)
{
DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
DropDownListCommom.BindEstTerm(ddlEstTermRefID);
DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N");
}
COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID);
ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);
ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
ESTTERM_STEP_ID = 2;
EST_ID = "3P"; //프로젝트 평가
DIRECTION_TYPE = "DN"; //하향식평가
STATUS_ID = "E"; //점수 산정 완료
ltrScript.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
quizWeight = new DataTable();
}
COMP_ID = WebUtility.GetRequestByInt("COMP_ID");
EST_ID = WebUtility.GetRequest("EST_ID");
ESTTERM_REF_ID = WebUtility.GetRequestByInt("ESTTERM_REF_ID");
ESTTERM_SUB_ID = WebUtility.GetRequestByInt("ESTTERM_SUB_ID");
ESTTERM_STEP_ID = WebUtility.GetRequestByInt("ESTTERM_STEP_ID");
EST_DEPT_ID = WebUtility.GetRequestByInt("EST_DEPT_ID");
EST_EMP_ID = WebUtility.GetRequestByInt("EST_EMP_ID");
PRJ_REF_ID = WebUtility.GetRequestByInt("PRJ_REF_ID");
EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE", "EST");
TGT_DEPT_ID = WebUtility.GetRequestByInt("TGT_DEPT_ID", 0);
TGT_EMP_ID = WebUtility.GetRequestByInt("TGT_EMP_ID", 0);
READ_ONLY_YN = WebUtility.GetRequest("READ_ONLY_YN", "N");
_estInfos = new Biz_EstInfos(COMP_ID, EST_ID);
_q_item_desc_use_yn = _estInfos.Q_Item_Desc_Use_YN;
//PRJ_TYPE
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(PRJ_REF_ID);
PRJ_TYPE = objPrjInfo.IPrj_Type;
if (READ_ONLY_YN.Equals("N"))
{
Biz_TermInfos termInfos = new Biz_TermInfos(ESTTERM_REF_ID);
Biz_TermSubs termSubs = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID);
Biz_TermSteps termSteps = new Biz_TermSteps(COMP_ID, ESTTERM_STEP_ID);
Biz_EmpInfos estEmpInfos = new Biz_EmpInfos(EST_EMP_ID);
Biz_EmpInfos tgtEmpInfos = new Biz_EmpInfos(TGT_EMP_ID);
//Biz_DeptInfos estDeptInfo = new Biz_DeptInfos(EST_DEPT_ID);
MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info bizComDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(EST_DEPT_ID);
MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info tgtDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(TGT_DEPT_ID);
//Biz_Prj_Data data = new Biz_Prj_Data(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_DEPT_ID
// , EST_EMP_ID
// , PRJ_REF_ID);
_status_style_id = _estInfos.Status_Style_ID;
Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap(COMP_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, 0
, EST_ID
, ""
, PRJ_REF_ID);
if (objQuestionPrjMap.Q_Obj_ID == null)
{
ltrScript.Text = JSHelper.GetAlertScript("프로젝트사업명에 대한 평가질의서가 매핑되지 않았습니다.", true);
return;
}
// 창을 띄은 사람이 평가자 인지 체크
if (EST_EMP_ID == EMP_REF_ID)
{
_status_id = "P";
ibnSaveEst.Visible = true;
}
//else
//{
// ibnSaveEst.Visible = false;
// // 롤에 따른 버튼 권한이 있는지 확인
// //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnSaveEst);
//}
Q_OBJ_ID = objQuestionPrjMap.Q_Obj_ID;
EST_NAME = _estInfos.Est_Name;
ESTTERM_REF_NAME = termInfos.EstTerm_Name;
ESTTERM_SUB_NAME = termSubs.EstTerm_Sub_Name;
ESTTERM_STEP_NAME = termSteps.EstTerm_Step_Name;
EST_EMP_NAME = estEmpInfos.Emp_Name;
EST_DEPT_NAME = bizComDeptInfo.DEPT_NAME; //estDeptInfo.Dept_Name;
TGT_EMP_NAME = tgtEmpInfos.Emp_Name;
TGT_DEPT_NAME = tgtDeptInfo.DEPT_NAME; //tgtDeptInfo.Dept_Name;
PRJ_NAME = objPrjInfo.IPrj_Name;
PRJ_CODE = objPrjInfo.IPrj_Code;
}
else
{
Q_OBJ_ID = WebUtility.GetRequest("Q_OBJ_ID");
ibnSaveEst.Visible = false;
}
if (!Page.IsPostBack)
{
SetLabelText();
//임의수정
Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DataTable dt = bizPrjData.GetPrjData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, EST_DEPT_ID, EST_EMP_ID, TGT_DEPT_ID, TGT_EMP_ID, PRJ_REF_ID, "", "").Tables[0];
string Status_ID = "";
if (dt != null && dt.Rows.Count > 0)
{
Status_ID = dt.Rows[0]["STATUS_ID"].ToString();
}
if (Status_ID.Equals("E"))
{
ibnSaveEst.Visible = false;
}
DataListBinding(dt);
ibnSaveEst.Attributes.Add("onclick", "if(confirm('평가내용을 저장하시겠습니까?')) return ConfirmQuesiton();else return false;");
}
ltrScript.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
bizPrjInfo = new Biz_Prj_Info();
bizComEmpRoleRel = new Biz_Com_Emp_Role_Rel();
EST_ID = "3Q";
EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE");
EST_EMP_ID = 0;
if (EST_TGT_TYPE.Equals("EST"))
{
EST_EMP_ID = gUserInfo.Emp_Ref_ID;
}
int role_ref_id = 9;//성과평가관리자
if (bizComEmpRoleRel.IsMatch_EmpRole(gUserInfo.Emp_Ref_ID, role_ref_id))
{
EST_EMP_ID = 0;
}
if (!IsPostBack)
{
DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
DropDownListCommom.BindEstTerm(ddlEstTermRefID);
DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N");
this.prj_sDate.Value = System.DateTime.Now.AddMonths(-1);
this.rdo_prj_select.Checked = false;
this.rdo_prj_est.Checked = true;
}
COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID);
ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);
ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
ltrScript.Text = "";
if (this.rdo_prj_select.Checked)
{
this.ibnSetTarget.Enabled = true;
this.ibnSetTarget.Visible = true;
}
else
{
this.ibnSetTarget.Enabled = false;
this.ibnSetTarget.Visible = false;
}
if (!IsPostBack)
{
doBind();
}
}
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>");
}
}
private void SetButton()
{
// 프로젝트 책임자가 아닐경우
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID);
bool bIsOwner = objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID);
if (this.IType == "A")
{
iBtnInsert.Visible = true;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
iBtnDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReqModify.Visible = false;
}
else if (this.IType == "U")
{
//iBtnInsert.Visible = false;
//iBtnUpdate.Visible = (this.IType == "D") ? false : true;
//iBtnDelete.Visible = (this.IType == "D") ? false : true;
//iBtnReUsed.Visible = (this.IType == "D") ? true : false;
iBtnComplete_Y.Visible = false;
iBtnComplete_N.Visible = false;
switch (this.IApp_Status)
{
case "": // 결재상태 없음
iBtnDraft.Visible = (bIsOwner) ? true : false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_nodraft: // 결재상태 없음
iBtnDraft.Visible = (bIsOwner) ? true : false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_draft: // 상신
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_ondraft: // 결재중
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_return: // 반려
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = (bIsOwner) ? true : false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_recall: // 결재회수
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = (bIsOwner) ? true : false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (bIsOwner) ? true : false;
iBtnDelete.Visible = (bIsOwner) ? true : false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_onmodify: // 수정결재
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = (bIsOwner) ? true : false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
break;
case Biz_Type.app_status_complete: // 결재완료
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = (bIsOwner) ? true : false;
iBtnReWrite.Visible = false;
iBtnInsert.Visible = false;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
if (objPrj.IComplete_YN == "Y")
{
iBtnComplete_Y.Visible = false;
iBtnComplete_N.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
}
else
{
iBtnComplete_Y.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false;
iBtnComplete_N.Visible = false;
}
break;
default:
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
break;
}
}
else if (this.IType == "D")
{
iBtnInsert.Visible = false;
iBtnUpdate.Visible = (this.IType == "D") ? false : true;
iBtnDelete.Visible = (this.IType == "D") ? false : true;
iBtnReUsed.Visible = (this.IType == "D") ? true : false;
iBtnDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReqModify.Visible = false;
}
else if (this.IType == "S")
{
iBtnInsert.Visible = false;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
iBtnDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnComplete_Y.Visible = false;
iBtnComplete_N.Visible = false;
}
else
{
iBtnInsert.Visible = false;
iBtnUpdate.Visible = false;
iBtnDelete.Visible = false;
iBtnReUsed.Visible = false;
iBtnDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReqModify.Visible = false;
}
if (this.IType == "A")
{
iBtnInsert.Visible = true;
}
}
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);
}
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();
}
private void InitializeGrid(UltraWebGrid grid)
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info();
objPrjInfo.IPrj_Code = this.txtPrjCode.Text.Trim();
objPrjInfo.IPrj_Name = this.txtPrjName.Text.Trim();
objPrjInfo.IPrj_Type = WebUtility.GetByValueDropDownList(ddlPrjType);
DataTable dt = objPrjInfo.GetList(objPrjInfo.IPrj_Code
, objPrjInfo.IPrj_Name
, 0
, ""
, EMP_REF_ID
, objPrjInfo.IPrj_Type).Tables[0];
_prjNameCount = dt.Rows.Count;
grid.Columns.Clear();
AddColumn(ugrdPrjList
, "ESTTERM_REF_ID"
, "ESTTERM_REF_ID"
, "ESTTERM_REF_ID"
, "Left"
, 100
, true
, false);
AddColumn(ugrdPrjList
, "DEPT_REF_ID"
, "DEPT_REF_ID"
, "DEPT_REF_ID"
, "Left"
, 100
, true
, false);
AddColumn(ugrdPrjList
, "KPI_REF_ID"
, "KPI_REF_ID"
, "KPI_REF_ID"
, "Left"
, 100
, true
, false);
AddColumn(ugrdPrjList
, "부서명"
, "DEPT_NAME"
, "DEPT_NAME"
, "Left"
, 120
, false
, true);
AddColumn(ugrdPrjList
, "지표명"
, "KPI_NAME"
, "KPI_NAME"
, "Left"
, 120
, false
, true);
// 사업명 컬럼 추가
foreach (DataRow row in dt.Rows)
{
AddColumn(ugrdPrjList
, row["PRJ_NAME"].ToString()
, row["PRJ_REF_ID"].ToString()
, row["PRJ_REF_ID"].ToString()
, "Center"
, 150
, false, false);
}
}
