private void DeleteQuestionProjectMapGrid()
{
Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap();
DataTable dataTable = objQuestionPrjMap.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(ugrdPrjList
, "cBox"
, "selchk"
, new string[] { "PRJ_REF_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["Q_OBJ_ID"] = hdfQObjID.Value;
}
bool isOK = objQuestionPrjMap.RemoveQuestionProjectMap(dataTable);
if (!isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
}
else
{
BindQuestionProjectMapGrid();
}
}
private void AddPrjectData()
{
Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap();
DataTable dataTable = objQuestionPrjMap.GetDataTableSchema();
string[] prj_values = hdfPrjRefID.Value.Split(',');
for (int i = 0; i < prj_values.Length; i++)
{
if (!objQuestionPrjMap.IsExist(COMP_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, EST_ID, Q_OBJ_ID, DataTypeUtility.GetToInt32(prj_values[i])))
{
DataRow dataRow = null;
dataRow = dataTable.NewRow();
dataRow["COMP_ID"] = COMP_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["Q_OBJ_ID"] = Q_OBJ_ID;
dataRow["PRJ_REF_ID"] = prj_values[i];
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
dataTable.Rows.Add(dataRow);
}
}
bool isOK = objQuestionPrjMap.AddQuestionProjectMap(dataTable);
if (isOK)
{
BindQuestionProjectMapGrid();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("프로젝트 추가에 실패하였습니다.", false);
}
}
private void BindQuestionProjectMapGrid()
{
Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap();
ugrdPrjList.Clear();
DataSet ds = null;
ds = objQuestionPrjMap.GetQuestionProjectMapping(COMP_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_ID
, Q_OBJ_ID
, 0);
// hdfEstDept.Value = WebUtility.GetValueForSplit(ds.Tables[0]
// , "TGT_DEPT_ID"
// , ",");
ugrdPrjList.DataSource = ds;
ugrdPrjList.DataBind();
}
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 = "";
}
