public float GetAHPEstDeptStgSumPoint(int ver_id , int estterm_ref_id , int est_dept_ref_id , int target_stg_ref_id) { float sum_point = 0; Biz_PDTAndAHPStgEstDeptDatas pdtAhpEstDept = new Biz_PDTAndAHPStgEstDeptDatas(); DataSet ds = pdtAhpEstDept.GetPDTAndAHPEstDeptStgList(ver_id , estterm_ref_id , est_dept_ref_id , "Y"); IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { foreach (DataRow drRow in ds.Tables[0].Rows) { int stg_ref_id = int.Parse(drRow["STG_REF_ID"].ToString()); float point = 0; if (stg_ref_id == target_stg_ref_id) { point = 1; } else { point = GetAHPEstDeptStgHorizonPoint_Dac(ver_id , estterm_ref_id , est_dept_ref_id , stg_ref_id , target_stg_ref_id); } sum_point += point; } trx.Commit(); } catch (Exception ex) { trx.Rollback(); throw ex; } finally { conn.Close(); } return(sum_point); }
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); }