public bool RemovePdtAhpVersion(int ver_id, int estterm_ref_id)
{
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
Biz_AHPEstDeptStgDatas ahpEstDeptStg = new Biz_AHPEstDeptStgDatas();
ahpEstDeptStg.RemoveAHPEstDeptStgData(conn
, trx
, ver_id
, estterm_ref_id
, 0);
Biz_AHPEstDeptStgDatas ahpEstDeptStgDatas = new Biz_AHPEstDeptStgDatas();
ahpEstDeptStgDatas.RemoveAHPEstDeptStgData_Dac(conn
, trx
, ver_id
, estterm_ref_id
, 0
, 0
, 0);
Biz_PDTAndAHPStgEstDeptDatas pdtAndAHPStgEstDeptDatas = new Biz_PDTAndAHPStgEstDeptDatas();
pdtAndAHPStgEstDeptDatas.RemovePDTAndAHPStgEstDeptData(conn
, trx
, ver_id
, estterm_ref_id
, 0
, 0);
RemovePDAAndAHPVersion_Dac(conn, trx, ver_id, estterm_ref_id);
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public bool AddPDTAndAHPStgEstDeptDatas(int ver_id
, int estterm_ref_id
, DataTable stgData
, DataTable estDeptData
, int est_dept_ref_id
, int create_update_user)
{
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
for (int i = 0; i < stgData.Rows.Count; i++)
{
Biz_PDTAndAHPStgInfos pdtAndAhpStgInfo = new Biz_PDTAndAHPStgInfos();
pdtAndAhpStgInfo.AddPDTAndAHPStgInfo_Dac(conn
, trx
, ver_id
, estterm_ref_id
, Convert.ToInt32(stgData.Rows[i]["STG_REF_ID"])
, Convert.ToInt32(stgData.Rows[i]["UP_STG_ID"])
, stgData.Rows[i]["STG_MAP_YN"].ToString()
, stgData.Rows[i]["F_YN"].ToString()
, stgData.Rows[i]["C_YN"].ToString()
, stgData.Rows[i]["P_YN"].ToString()
, stgData.Rows[i]["L_YN"].ToString()
, ""
, DateTime.Now
, create_update_user);
}
Biz_AHPEstDeptStgDatas ahpEstDeptStgDatas = new Biz_AHPEstDeptStgDatas();
ahpEstDeptStgDatas.RemoveAHPEstDeptStgData(conn
, trx
, ver_id
, estterm_ref_id
, est_dept_ref_id);
RemovePDTAndAHPStgEstDeptData(conn
, trx
, ver_id
, estterm_ref_id
, est_dept_ref_id
, 0);
for (int i = 0; i < estDeptData.Rows.Count; i++)
{
if (est_dept_ref_id == Convert.ToInt32(estDeptData.Rows[i]["EST_DEPT_REF_ID"]))
{
AddPDTAndAHPStgEstDeptData_Dac(conn
, trx
, ver_id
, estterm_ref_id
, Convert.ToInt32(estDeptData.Rows[i]["EST_DEPT_REF_ID"])
, Convert.ToInt32(estDeptData.Rows[i]["STG_REF_ID"])
, estDeptData.Rows[i]["CHECK_YN"].ToString()
, ""
, DateTime.Now
, create_update_user);
}
}
trx.Commit();
}
catch (Exception e)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return(true);
}