public Biz_Boards(string board_id, string board_category_id)
{
DataSet ds = _board.Select(board_id, board_category_id, 0, "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_board_id = DataTypeUtility.GetValue(dr["BOARD_ID"]);
_board_category_id = DataTypeUtility.GetValue(dr["BOARD_CATEGORY_ID"]);
_subject_text = DataTypeUtility.GetValue(dr["SUBJECT_TEXT"]);
_content_text = DataTypeUtility.GetValue(dr["CONTENT_TEXT"]);
_read_count = DataTypeUtility.GetToInt32(dr["READ_COUNT"]);
_attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]);
_p_board_id = DataTypeUtility.GetValue(dr["P_BOARD_ID"]);
_group_id = DataTypeUtility.GetValue(dr["GROUP_ID"]);
_level_id = DataTypeUtility.GetToInt32(dr["LEVEL_ID"]);
_seq_id = DataTypeUtility.GetToInt32(dr["SEQ_ID"]);
_start_date = DataTypeUtility.GetToDateTime(dr["START_DATE"]);
_end_date = DataTypeUtility.GetToDateTime(dr["END_DATE"]);
_menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]);
_pop_up_yn = DataTypeUtility.GetValue(dr["POP_UP_YN"]);
_write_emp_id = DataTypeUtility.GetToInt32(dr["WRITE_EMP_ID"]);
_write_emp_name = DataTypeUtility.GetValue(dr["WRITE_EMP_NAME"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public Biz_Prj_QuestionPrjMap(int comp_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, string est_id
, string q_obj_id
, int prj_ref_id)
{
DataSet ds = null;
ds = _questionPrjMap.Select(comp_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_id
, q_obj_id
, prj_ref_id);
DataRow dr;
if (ds != null && ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
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"]);
}
}
public bool SaveDeptPosScaleAll(DataTable dtDept, DataTable dtScaleData)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
if (dtScaleData.Rows.Count > 0)
{
foreach (DataRow dataRowDept in dtDept.Rows)
{
affectedRow += _deptPosScale.Delete(conn
, trx
, DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["COMP_ID"])
, DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dtScaleData.Rows[0]["EST_ID"])
, 0);
}
}
foreach (DataRow dataRowDept in dtDept.Rows)
{
foreach (DataRow dataRowScaleData in dtScaleData.Rows)
{
affectedRow = _deptPosScale.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRowScaleData["COMP_ID"])
, DataTypeUtility.GetToInt32(dataRowScaleData["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dataRowScaleData["EST_ID"])
, DataTypeUtility.GetToInt32(dataRowScaleData["SEQ"])
, DataTypeUtility.GetValue(dataRowScaleData["POS_ID"])
, DataTypeUtility.GetValue(dataRowScaleData["POS_VALUE"])
, DataTypeUtility.GetValue(dataRowScaleData["SCALE_ID"])
, DataTypeUtility.GetToDateTime(dataRowScaleData["DATE"])
, DataTypeUtility.GetToInt32(dataRowScaleData["USER"]));
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
/// <summary>
/// 날짜설정
/// 줄바꿈 : 데이타 있으면 앞에 <br> 설정
/// </summary>
private string GetDateTime(string strDateTime)
{
if (strDateTime.Length > 0)
{
return("<br>" + DataTypeUtility.GetToDateTime(strDateTime).ToString("yyyy-MM-dd"));
}
return(strDateTime);
}
//===================================: 비용관리 조회
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");
}
public bool UpdateQuestionDeptMap(DataTable dataTable
, int comp_id
, int estterm_ref_id
, int estterm_sub_id
, string est_id
, string q_obj_id)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
affectedRow = _questionDeptEmpMap.Delete(conn
, trx
, comp_id
, estterm_ref_id
, estterm_sub_id
, est_id
, q_obj_id
, 0
, 0);
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _questionDeptEmpMap.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, dataRow["EST_ID"].ToString()
, dataRow["Q_OBJ_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["TGT_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["TGT_EMP_ID"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public Biz_BoardCategories(string board_category_id)
{
DataSet ds = _boardCategory.Select(board_category_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_board_category_id = DataTypeUtility.GetValue(dr["BOARD_CATEGORY_ID"]);
_board_categroy_name = DataTypeUtility.GetValue(dr["BOARD_CATEGROY_NAME"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public int Update(IDbConnection conn
, IDbTransaction trx
, object[] temp)
{
string query = @"UPDATE EST_JOB_DETAIL
SET START_DATE = CASE WHEN @START_DATE IS NULL THEN START_DATE ELSE @START_DATE END
,END_DATE = CASE WHEN @END_DATE IS NULL THEN END_DATE ELSE @END_DATE END
,STATUS_YN = CASE WHEN @STATUS_YN IS NULL THEN STATUS_YN ELSE @STATUS_YN END
,UPDATE_DATE = GETDATE()
,UPDATE_USER = @UPDATE_USER
WHERE COMP_ID = @COMP_ID
AND EST_ID = @EST_ID
AND ESTTERM_REF_ID = @ESTTERM_REF_ID
AND ESTTERM_SUB_ID = @ESTTERM_SUB_ID
AND ESTTERM_STEP_ID = @ESTTERM_STEP_ID
AND EST_JOB_ID = @EST_JOB_ID" ;
IDbDataParameter[] paramArray = CreateDataParameters(10);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = temp[0];
paramArray[1] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 20);
paramArray[1].Value = temp[1];
paramArray[2] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[2].Value = temp[2];
paramArray[3] = CreateDataParameter("@ESTTERM_SUB_ID", SqlDbType.Int);
paramArray[3].Value = temp[3];
paramArray[4] = CreateDataParameter("@ESTTERM_STEP_ID", SqlDbType.Int);
paramArray[4].Value = temp[4];
paramArray[5] = CreateDataParameter("@EST_JOB_ID", SqlDbType.NVarChar, 20);
paramArray[5].Value = temp[5];
paramArray[6] = CreateDataParameter("@START_DATE", SqlDbType.DateTime);
paramArray[6].Value = DataTypeUtility.GetToDateTime(temp[6]);
paramArray[7] = CreateDataParameter("@END_DATE", SqlDbType.DateTime);
paramArray[7].Value = DataTypeUtility.GetToDateTime(temp[7]);
paramArray[8] = CreateDataParameter("@STATUS_YN", SqlDbType.NChar);
paramArray[8].Value = temp[8];
paramArray[9] = CreateDataParameter("@UPDATE_USER", SqlDbType.Int);
paramArray[9].Value = temp[9];
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public Biz_BoardPopupPages(int meun_ref_id)
{
DataSet ds = _boardPopupPage.Select(meun_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]);
_sort_order = DataTypeUtility.GetToInt32(dr["SORT_ORDER"]);
_use_yn = DataTypeUtility.GetValue(dr["POP_UP_YN"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public Biz_Prj_QuestionData(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int est_dept_id
, int est_emp_id
, int tgt_emp_id
, int prj_ref_id
, string q_sbj_id)
{
DataSet ds = _questiondata.Select(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_dept_id
, est_emp_id
, tgt_emp_id
, prj_ref_id
, q_sbj_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_comp_id = DataTypeUtility.GetToInt32(dr["COMP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_dept_id = DataTypeUtility.GetToInt32(dr["EST_DEPT_ID"]);
_est_emp_id = DataTypeUtility.GetToInt32(dr["EST_EMP_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]);
_q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]);
_q_itm_id = DataTypeUtility.GetValue(dr["Q_ITM_ID"]);
_point = DataTypeUtility.GetToFloat(dr["POINT"]);
_grade_id = DataTypeUtility.GetValue(dr["GRADE_ID"]);
_text_value = DataTypeUtility.GetValue(dr["TEXT_VALUE"]);
_opinion = DataTypeUtility.GetValue(dr["OPINION"]);
_attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public Biz_MenuInfo(int menu_ref_id)
{
DataSet ds = _dac_menuinfo.Select(menu_ref_id
, string.Empty
, string.Empty
, string.Empty
);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]);
_up_menu_id = DataTypeUtility.GetToInt32(dr["UP_MENU_ID"]);
_menu_name = DataTypeUtility.GetValue(dr["MENU_NAME"]);
_menu_dir = DataTypeUtility.GetValue(dr["MENU_DIR"]);
_menu_page_name = DataTypeUtility.GetValue(dr["MENU_PAGE_NAME"]);
_menu_param = DataTypeUtility.GetValue(dr["MENU_PARAM"]);
_menu_full_path = DataTypeUtility.GetValue(dr["MENU_FULL_PATH"]);
_menu_desc = DataTypeUtility.GetValue(dr["MENU_DESC"]);
_menu_priority = DataTypeUtility.GetToInt32(dr["MENU_PRIORITY"]);
_menu_auth_type = DataTypeUtility.GetValue(dr["MENU_AUTH_TYPE"]);
_menu_type = DataTypeUtility.GetValue(dr["MENU_TYPE"]);
_menu_name_image_path = DataTypeUtility.GetValue(dr["MENU_NAME_IMAGE_PATH"]);
_menu_name_image_path_u = DataTypeUtility.GetValue(dr["MENU_NAME_IMAGE_PATH_U"]);
_menu_prev_icon_path = DataTypeUtility.GetValue(dr["MENU_PREV_ICON_PATH"]);
_menu_create_date = DataTypeUtility.GetToDateTime(dr["MENU_CREATE_DATE"]);
_show_left_menu = DataTypeUtility.GetValue(dr["SHOW_LEFT_MENU"]);
DataSet Up_ds = _up_menuinfo.Select(_up_menu_id
, string.Empty
, string.Empty
, string.Empty
);
if (Up_ds.Tables != null && Up_ds.Tables[0].Rows.Count == 1)
{
DataRow up_dr = Up_ds.Tables[0].Rows[0];
_up_menu_name = DataTypeUtility.GetValue(up_dr["MENU_NAME"]);
}
}
}
public bool SaveJobColumnMap(DataTable dataTable, int comp_id, string est_id, string col_key)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
affectedRow += _jobColumnMap.Delete(conn
, trx
, comp_id
, est_id
, ""
, col_key);
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _jobColumnMap.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"])
, DataTypeUtility.GetValue(dataRow["EST_JOB_ID"])
, DataTypeUtility.GetValue(dataRow["COL_KEY"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public bool SavePosBizQuestionSbjMap(DataTable dataTable, int comp_id, string est_id, string pos_biz_id)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
affectedRow += _positionBizQuestionSubMap.Delete(conn
, trx
, comp_id
, est_id
, pos_biz_id
, "");
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _positionBizQuestionSubMap.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"])
, DataTypeUtility.GetValue(dataRow["POS_BIZ_ID"])
, DataTypeUtility.GetValue(dataRow["Q_SBJ_ID"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public bool ModifyPosKndBizMap(string pos_knd_id
, DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
if (dataTable.Rows.Count > 0)
{
affectedRow += _posKndBizMap.Delete(conn
, trx
, pos_knd_id
, "");
}
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _posKndBizMap.Insert(conn
, trx
, DataTypeUtility.GetValue(dataRow["POS_KND_ID"])
, DataTypeUtility.GetValue(dataRow["POS_BIZ_ID"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public bool SaveDeptOpinionTgtEmp(DataTable dataTable, int comp_id, string est_id)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
affectedRow += _deptOpinionTgtEmp.Delete( conn
, trx
, comp_id
, est_id
, 0
, 0);
foreach(DataRow dataRow in dataTable.Rows)
{
affectedRow += _deptOpinionTgtEmp.Insert( conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"])
, DataTypeUtility.GetToInt32(dataRow["TGT_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["TGT_EMP_ID"])
, DataTypeUtility.GetValue(dataRow["TGT_OPINION_YN"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch ( Exception ex )
{
trx.Rollback();
return false;
}
finally
{
conn.Close();
}
return (affectedRow > 0) ? true : false;
}
public bool AddPrjEmpEstPrjMap(DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _prjEstPrjMap.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["EST_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_EMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["PRJ_REF_ID"])
, dataRow["STATUS_ID"].ToString()
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public Biz_QuestionDefines(string q_dfn_id, string est_id)
{
DataSet ds = _questionDefine.Select(q_dfn_id, est_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]);
_num = DataTypeUtility.GetString(dr["NUM"]);
_q_dfn_name = DataTypeUtility.GetString(dr["Q_DFN_NAME"]);
_q_dfn_define = DataTypeUtility.GetString(dr["Q_DFN_DEFINE"]);
_q_dfn_notice = DataTypeUtility.GetString(dr["Q_DFN_NOTICE"]);
_q_dfn_desc = DataTypeUtility.GetString(dr["Q_DFN_DESC"]);
_est_id = DataTypeUtility.GetString(dr["EST_ID"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
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 Biz_QuestionSubjects(string q_sbj_id)
{
DataSet ds = _questionsubject.Select(q_sbj_id, "", "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_q_sbj_id = dr["Q_SBJ_ID"].ToString();
_q_obj_id = dr["Q_OBJ_ID"].ToString();
_q_dfn_id = dr["Q_DFN_ID"].ToString();
_num = DataTypeUtility.GetToInt32(dr["NUM"]);
_q_sbj_name = dr["Q_SBJ_NAME"].ToString();
_q_sbj_define = dr["Q_SBJ_DEFINE"].ToString();
_q_sbj_desc = dr["Q_SBJ_DESC"].ToString();
_weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public bool AddCtrlEstMap(DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _ctrlEstMap.Delete(conn
, trx
, DataTypeUtility.GetValue(dataRow["CTRL_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"]));
affectedRow += _ctrlEstMap.Insert(conn
, trx
, DataTypeUtility.GetValue(dataRow["CTRL_ID"])
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public Biz_Prj_Data(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int est_dept_id
, int est_emp_id
, int prj_ref_id)
{
DataSet ds = GetPrjData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_dept_id
, est_emp_id
, prj_ref_id
, ""
, "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_comp_id = DataTypeUtility.GetToInt32(dr["COMP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_dept_id = DataTypeUtility.GetToInt32(dr["EST_DEPT_ID"]);
_est_emp_id = DataTypeUtility.GetToInt32(dr["EST_EMP_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_point = DataTypeUtility.GetToFloat(dr["POINT"]);
_point_date = DataTypeUtility.GetToDateTime(dr["POINT_DATE"]);
_status_id = DataTypeUtility.GetValue(dr["STATUS_ID"]);
_status_date = DataTypeUtility.GetToDateTime(dr["STATUS_DATE"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public bool SaveButtonCommandRoleMap(DataTable dataTable, int role_ref_id)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
affectedRow += _buttonCommandRoleMap.Delete(conn
, trx
, role_ref_id
, "");
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _buttonCommandRoleMap.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["ROLE_REF_ID"])
, DataTypeUtility.GetValue(dataRow["COMMAND_NAME"])
, DataTypeUtility.GetToDateTime(dataRow["DATE"])
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
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 BindGanttChart(int iPrjRefID)
{
IPrjRefID = iPrjRefID;
if (PAGE_TYPE.Equals("N"))
{
_iPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName);
}
if (PAGE_TYPE.Equals("N") && _iPrjRefID < 1)
{
return;
}
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
objSchedule.IPrj_Ref_Id = IPrjRefID;
DataSet ds = objSchedule.GetAllList(objSchedule.IPrj_Ref_Id, 0);
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);
}
}
_dataTable = tmpDs.Tables[0];
// Set Gantt chart type
Chart1.Series["Tasks"].Type = SeriesChartType.Gantt;
Chart1.Series["Progress"].Type = SeriesChartType.Gantt;
Chart1.Legends["Default"].Enabled = true;
Chart1.ChartAreas["Default"].AxisX.MajorGrid.Interval = 2;
Chart1.ChartAreas["Default"].AxisX.LabelsAutoFit = false;
Chart1.ChartAreas["Default"].AxisX.Interval = 1;
Chart1.ChartAreas["Default"].AxisX.Reverse = true;
Chart1.ChartAreas["Default"].AxisY.LabelStyle.Format = "yy.MM.dd";
//Chart1.ChartAreas["Default"].AxisY.MajorGrid.Interval = 28;
//Chart1.ChartAreas["Default"].AxisY.Interval = 10;
Chart1.ChartAreas["Default"].AxisY.LabelsAutoFitStyle ^= LabelsAutoFitStyle.IncreaseFont;
Chart1.ChartAreas["Default"].AxisY.LabelsAutoFit = true;
Chart1.ChartAreas["Default"].Area3DStyle.Enable3D = false;
Chart1.Series["Progress"]["DrawSideBySide"] = "false";
Chart1.Series["Tasks"]["DrawSideBySide"] = "false";
Chart1.Series["Tasks"]["PointWidth"] = "0.7";
Chart1.Series["Progress"]["PointWidth"] = "0.4";
//Chart1.BackColor = Color.White;
//Chart1.BackGradientType = GradientType.None;
//Chart1.BorderColor = Color.Gray;
//Chart1.BorderLineStyle = ChartDashStyle.Solid;
//Chart1.BorderStyle = ChartDashStyle.NotSet;
_htPoints.Clear();
for (int i = 0; i < _dataTable.Rows.Count; i++)
{
DataRow row = _dataTable.Rows[i];
object oPlanStartDate = row["PLAN_START_DATE"];
object oPlanEndDate = row["PLAN_END_DATE"];
object oActualStartDate = row["ACTUAL_START_DATE"];
object oActualEndDate = row["ACTUAL_END_DATE"];
if (oPlanStartDate.ToString() == oPlanEndDate.ToString() && oPlanEndDate != DBNull.Value)
{
oPlanEndDate = (object)DataTypeUtility.GetToDateTime(oPlanEndDate).AddDays(1);
}
if (oActualStartDate.ToString() == oActualEndDate.ToString() && oActualEndDate != DBNull.Value)
{
oActualEndDate = (object)DataTypeUtility.GetToDateTime(oActualEndDate).AddDays(1);
}
if (oPlanStartDate != DBNull.Value && oPlanEndDate != DBNull.Value)
{
Chart1.Series["Tasks"].Points.AddXY(i, oPlanStartDate, oPlanEndDate);
}
else
{
Chart1.Series["Tasks"].Points.AddXY(i, null, null);
}
if (oActualStartDate == DBNull.Value || oActualStartDate == null)
{
oActualStartDate = null;
}
if (oActualEndDate == DBNull.Value || oActualEndDate == null)
{
oActualEndDate = null;
}
if (oActualStartDate == null || oActualEndDate == null)
{
oActualStartDate = null;
oActualEndDate = null;
}
//if (oActualStartDate == DBNull.Value && oActualEndDate != null)
// oActualStartDate = oPlanStartDate;
//if (oActualStartDate != DBNull.Value && (oActualEndDate == null || oActualEndDate == DBNull.Value))
// oActualEndDate = oPlanEndDate;
Chart1.Series["Progress"].Points.AddXY(i, oActualStartDate, oActualEndDate);
//Chart1.Series["Tasks"].Points.AddXY(i, row["PLAN_START_DATE"], row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points.AddXY(i, row["ACTUAL_START_DATE"], row["ACTUAL_END_DATE"]);
Chart1.Series["Tasks"].Points[i].AxisLabel = row["TASK_NAME"].ToString();
Chart1.Series["Progress"].Points[i].AxisLabel = row["TASK_NAME"].ToString();
//Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points[i].ToolTip = "실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
if (DataTypeUtility.GetToInt32(row["UP_TASK_REF_ID"]) > 0)
{
Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
}
else
{
DataSet actualDs = objSchedule.GetActualDate(this.IPrjRefID);
Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"]);
Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"]);
}
if (DataTypeUtility.GetToInt32(row["UP_TASK_REF_ID"]) > 0)
{
Chart1.Series["Tasks"].Points[i].Href = "javascript:OpenSchedule('" + row["TASK_REF_ID"].ToString() + "');";
Chart1.Series["Progress"].Points[i].Href = "javascript:OpenSchedule('" + row["TASK_REF_ID"].ToString() + "');";
}
//Chart1.Series["Tasks"].Points[i].Label = Chart1.Series["Tasks"].Points[i].XValue.ToString();
_htPoints.Add(row["TASK_REF_ID"], Chart1.Series["Tasks"].Points[i]);
}
}
public bool SaveDeptEstWithWeight(DataTable dtWeight)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
object weight;
try
{
foreach (DataRow drItem in dtWeight.Rows)
{
_comp_id = DataTypeUtility.GetToInt32(drItem["COMP_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(drItem["ESTTERM_REF_ID"]);
_dept_ref_id = DataTypeUtility.GetToInt32(drItem["DEPT_REF_ID"]);
_est_id = drItem["EST_ID"].ToString();
if (drItem["WEIGHT"].ToString().Length == 0)
{
weight = DBNull.Value;
}
else
{
weight = DataTypeUtility.GetToFloat(drItem["WEIGHT"]);
}
_update_date = DataTypeUtility.GetToDateTime(drItem["DATE"]);
_update_user = DataTypeUtility.GetToInt32(drItem["USER"]);
if (IsExist(_comp_id, _estterm_ref_id, _dept_ref_id, _est_id, ""))
{
affectedRow += _deptEstDetail.Update(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, DBNull.Value
, DBNull.Value
, weight
, DBNull.Value
, _update_date
, _update_user);
}
else
{
affectedRow += _deptEstDetail.Insert(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, DBNull.Value
, DBNull.Value
, weight
, DBNull.Value
, _update_date
, _update_user);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public bool SaveDeptEstWidthScale(DataTable dtScale)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow drScale in dtScale.Rows)
{
_comp_id = DataTypeUtility.GetToInt32(drScale["COMP_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(drScale["ESTTERM_REF_ID"]);
_dept_ref_id = DataTypeUtility.GetToInt32(drScale["DEPT_REF_ID"]);
_est_id = drScale["EST_ID"].ToString();
_scale_id = drScale["SCALE_ID"].ToString();
_update_date = DataTypeUtility.GetToDateTime(drScale["DATE"]);
_update_user = DataTypeUtility.GetToInt32(drScale["USER"]);
if (IsExist(_comp_id, _estterm_ref_id, _dept_ref_id, _est_id, ""))
{
affectedRow += _deptEstDetail.Update(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, _scale_id
, _update_date
, _update_user);
//affectedRow += _deptEstDetail.Update(null
// , null
// , _comp_id
// , _estterm_ref_id
// , _dept_ref_id
// , _est_id
// , _scale_id
// , DBNull.Value
// , DBNull.Value
// , DBNull.Value
// , _update_date
// , _update_user);
}
else
{
affectedRow += _deptEstDetail.Insert(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, _scale_id
, DBNull.Value
, DBNull.Value
, DBNull.Value
, _update_date
, _update_user);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public Biz_QuestionItems(string q_itm_id, string q_sbj_id, string q_obj_id)
{
DataSet ds = _questionItem.Select(q_itm_id, q_sbj_id, q_obj_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_q_itm_id = (dr["Q_ITM_ID"] == DBNull.Value) ? "" : dr["Q_ITM_ID"].ToString();
_q_sbj_id = (dr["Q_SBJ_ID"] == DBNull.Value) ? "" : dr["Q_SBJ_ID"].ToString();
_num = (dr["NUM"] == DBNull.Value) ? 0 : DataTypeUtility.GetToInt32(dr["NUM"]);
_q_item_name = (dr["Q_ITEM_NAME"] == DBNull.Value) ? "" : dr["Q_ITEM_NAME"].ToString();
_point = (dr["POINT"] == DBNull.Value) ? 0 : DataTypeUtility.GetToDouble(dr["POINT"]);
_weight = (dr["WEIGHT"] == DBNull.Value) ? 0 : DataTypeUtility.GetToDouble(dr["WEIGHT"]);
_comment = (dr["COMMENT"] == DBNull.Value) ? "" : dr["COMMENT"].ToString();
_subject_item_yn = (dr["SUBJECT_ITEM_YN"] == DBNull.Value) ? "" : dr["SUBJECT_ITEM_YN"].ToString();
_update_date = (dr["UPDATE_DATE"] == DBNull.Value) ? DateTime.MinValue : DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = (dr["UPDATE_USER"] == DBNull.Value) ? 0 : DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public bool CopyQuestionObject(DataTable dataTable)
{
int affectedRow = 0;
Dac_QuestionEstMaps questionEstMap = new Dac_QuestionEstMaps();
Dac_QuestionSubjects questionSubject = new Dac_QuestionSubjects();
Dac_QuestionItems questionItem = new Dac_QuestionItems();
Dac_QuestionDatas questionData = new Dac_QuestionDatas();
Dac_KeyGens keyGen = new Dac_KeyGens();
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
//EST_QUESTION_OBJECT - 복사
foreach (DataRow dataRowDT in dataTable.Rows)
{
DataTable dtObj = _questionObject.Select(conn
, trx
, DataTypeUtility.GetValue(dataRowDT["EST_ID"])
, DataTypeUtility.GetValue(dataRowDT["Q_OBJ_ID"])).Tables[0];
DataTable dtEstMap = questionEstMap.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowDT["Q_OBJ_ID"])).Tables[0];
foreach (DataRow dataRowObj in dtObj.Rows)
{
string q_obj_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_OBJECT");
// 질의 그룹 등록
affectedRow += _questionObject.Insert(conn
, trx
, q_obj_id
, "Copy of " + DataTypeUtility.GetValue(dataRowObj["Q_OBJ_NAME"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_TITLE"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_PREFACE"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
// 질의 매핑 등록
foreach (DataRow dataRowEstMap in dtEstMap.Rows)
{
affectedRow += questionEstMap.Insert(conn
, trx
, DataTypeUtility.GetValue(dataRowEstMap["EST_ID"])
, q_obj_id
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
}
DataTable dtSub = questionSubject.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_ID"])
, "").Tables[0];
// 질의 제목 등록
foreach (DataRow dataRowSub in dtSub.Rows)
{
string q_sbj_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_SUBJECT");
affectedRow += questionSubject.Insert(conn
, trx
, q_sbj_id
, q_obj_id
, DataTypeUtility.GetValue(dataRowSub["Q_DFN_ID"])
, DataTypeUtility.GetToInt32(dataRowSub["NUM"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_NAME"])
, DataTypeUtility.GetToDouble(dataRowSub["WEIGHT"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_DEFINE"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_DESC"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
DataTable dtItem = questionItem.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_ID"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_ID"])).Tables[0];
// 질의 항목 등록
foreach (DataRow dataRowItem in dtItem.Rows)
{
string q_itm_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_ITEM");
affectedRow += questionItem.Insert(conn
, trx
, q_itm_id
, q_sbj_id
, DataTypeUtility.GetToInt32(dataRowItem["NUM"])
, DataTypeUtility.GetValue(dataRowItem["Q_ITEM_NAME"])
, DataTypeUtility.GetToDouble(dataRowItem["POINT"])
, DataTypeUtility.GetValue(dataRowItem["COMMENT"])
, DataTypeUtility.GetValue(dataRowItem["SUBJECT_ITEM_YN"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
}
}
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
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();
}
