//查詢 VDS_CGD_DAILY_RPT public DataTable QueryVDS_CGD_DAILY_RPT(ArrayList ParameterList) { try { VDS_CGD38_DBO CGD38 = new VDS_CGD38_DBO(ref USEDB); return CGD38.QueryVDS_CGD_DAILY_RPT(ParameterList); } catch (Exception ex) { throw ex; } }
/// <summary> /// B5 取得工作站數 /// </summary> public DataTable GetStationCount(ArrayList ParameterList) { try { VDS_CGD38_DBO CGD38 = new VDS_CGD38_DBO(ref USEDB); return CGD38.GetStationCount(ParameterList); } catch (Exception ex) { throw ex; } }
public void CreateBase(ArrayList ParaMaster, DataTable dtBASE, DbTransaction DBT) { CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB); ArrayList Para = new ArrayList(); //先刪除後新增 //0.N_PID in number, //1.V_SCODE in varchar2, Para.Clear(); Para.Add(ParaMaster[0]); //0.N_PID Para.Add(DBNull.Value); CGDM.DeleteVDS_CGD_DAILY_BASE(Para, DBT); for (int i = 0; i < dtBASE.Rows.Count; i++) { //0.N_PID in number, //1.D_PICK_DATE in date, //2.V_SCODE in varchar2, //3.V_X in varchar2, //4.V_Y in varchar2, //5.V_Z in varchar2, //6.D_CREATEDATE in date, //7.V_CREATEUID in varchar2, //8.D_UPDATEDATE in date, //9.V_UPDATEUID in varchar2 Para.Clear(); Para.Add(ParaMaster[0]); //0.N_PID Para.Add(ParaMaster[1]); //1.D_PICK_DATE Para.Add(dtBASE.Rows[i]["SCODE"].ToString()); //2.V_SCODE in varchar2, Para.Add(dtBASE.Rows[i]["X_VALUE"].ToString()); //3.V_X in varchar2, Para.Add(dtBASE.Rows[i]["Y_VALUE"].ToString()); //4.V_Y in varchar2, Para.Add(dtBASE.Rows[i]["Z_VALUE"].ToString()); //5.V_Z in varchar2, Para.Add(ParaMaster[2]); //6.D_CREATEDATE in date, Para.Add(ParaMaster[3]); //7.V_CREATEUID in varchar2, Para.Add(ParaMaster[4]); //8.D_UPDATEDATE in date, Para.Add(ParaMaster[5]); //9.V_UPDATEUID in varchar2 CGDM.InertVDS_CGD_DAILY_BASE(Para, DBT); } }
public void CreateArea(ArrayList ParaMaster, DataTable dtAREA, DbTransaction DBT) { CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB); ArrayList Para = new ArrayList(); //先刪除後新增 //0.N_PID in number, //1.V_SCODE in varchar2, Para.Clear(); Para.Add(ParaMaster[0]); //0.N_PID Para.Add(DBNull.Value); CGDM.DeleteVDS_CGD_DAILY_AREA(Para, DBT); for (int i = 0; i < dtAREA.Rows.Count; i++) { //0.N_PID in number, //1.D_PICK_DATE in date, //2.V_SCODE in varchar2, //3.V_EXPLAIN in varchar2, //4.V_FINISH_TIME in varchar2, //5.D_CREATEDATE in date, //6.V_CREATEUID in varchar2, //7.D_UPDATEDATE in date, //8.V_UPDATEUID in varchar2 Para.Clear(); Para.Add(ParaMaster[0]); //0.N_PID in number, Para.Add(ParaMaster[1]); //1.D_PICK_DATE in date, Para.Add(dtAREA.Rows[i]["SCODE"].ToString()); //2.V_SCODE in varchar2, Para.Add(dtAREA.Rows[i]["EXPLAIN"].ToString()); //3.V_EXPLAIN in varchar2, Para.Add(dtAREA.Rows[i]["FINISH_TIME"].ToString()); //4.V_FINISH_TIME in varchar2, Para.Add(ParaMaster[2]); //5.D_CREATEDATE in date, Para.Add(ParaMaster[3]); //6.V_CREATEUID in varchar2, Para.Add(ParaMaster[4]); //7.D_UPDATEDATE in date, Para.Add(ParaMaster[5]); //8.V_UPDATEUID in varchar2 CGDM.InertVDS_CGD_DAILY_AREA(Para, DBT); } }
//修改資料 public void UpdateData(ArrayList ParameterList, DataTable dtBASE, DataTable dtAREA) { ArrayList Para = new ArrayList(); try { CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB); Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); CGDM.UpdateVDS_CGD_DAILY_RPT(ParameterList, DBT); ArrayList ParaMaster = new ArrayList(); ParaMaster.Clear(); ParaMaster.Add(ParameterList[19]); //ID ParaMaster.Add(ParameterList[0]); //PICK_DATE ParaMaster.Add(ParameterList[17]); //D_CREATEDATE ParaMaster.Add(ParameterList[18]); //V_CREATEUID ParaMaster.Add(ParameterList[17]); //D_UPDATEDATE ParaMaster.Add(ParameterList[18]); //V_UPDATEUID CreateBase(ParaMaster, dtBASE, DBT); CreateArea(ParaMaster, dtAREA, DBT); DBT.Commit(); } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } }