public DataTable GetEstData(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id) { MicroBSC.Integration.PRJ.Dac.Dac_Prj_Schedule dacEstData = new Dac_Prj_Schedule(); return(dacEstData.SelectData_DB(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id)); }
public int RemoveEstData(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_ste_id) { MicroBSC.Integration.PRJ.Dac.Dac_Prj_Schedule dacEstData = new Dac_Prj_Schedule(); return(dacEstData.Delete(null , null , comp_id , est_id , estterm_ref_id , estterm_sub_id)); }
public int ModifyEstData(DataTable dt) { int intTxrCnt = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { MicroBSC.Integration.PRJ.Dac.Dac_Prj_Schedule dacEstData = new Dac_Prj_Schedule(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; intTxrCnt += dacEstData.Update_DB(conn , trx , row["COMP_ID"] , row["EST_ID"] , row["ESTTERM_REF_ID"] , row["ESTTERM_SUB_ID"] , row["ESTTERM_STEP_ID"] , row["POINT"]); } trx.Commit(); } catch { trx.Rollback(); return(0); } finally { conn.Close(); } return(intTxrCnt); }
public int AddData(int iprj_ref_id , int itask_ref_id , string itask_name , string itask_type , int iup_task_ref_id , string itask_code , decimal itask_weight , object iplan_start_date , object iplan_end_date , object iactual_start_date , object iactual_end_date , decimal iproceed_rate , string iatt_file , string icomplete_yn , string iisdelete , int inode_depth , int iafter_task_ref_id , string idesction , int itxr_user) { int affectedRow = 0; MicroBSC.Integration.PRJ.Dac.Dac_Prj_Schedule dacEstData = new Dac_Prj_Schedule(); IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { if (itask_ref_id < 1) { itask_ref_id = _data.SelectMaxTaskRefID(conn, trx, iprj_ref_id); } affectedRow = _data.Insert_DB(conn , trx , iprj_ref_id , itask_ref_id , itask_name , itask_type , iup_task_ref_id , itask_code , itask_weight , iplan_start_date , iplan_end_date , iactual_start_date , iactual_end_date , iproceed_rate , iatt_file , icomplete_yn , iisdelete , inode_depth , iafter_task_ref_id , idesction , itxr_user); trx.Commit(); } catch { trx.Rollback(); return(0); } finally { conn.Close(); } return(affectedRow); }