public DataTable QueryData(ArrayList ParameterList) { try { VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB); DataTable dt = DBO.QueryData(ParameterList); return dt; } catch (Exception ex) { throw ex; } }
//取得最大和最小路線 public DataTable GetRouteRange() { try { VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB); DataTable dt = DBO.GetRouteRange(); return dt; } catch (Exception ex) { throw ex; } }
public bool SaveData(ArrayList ParameterList, DataTable dt) { bool bResult = false; ArrayList Para = new ArrayList(); try { //ParameterList[0] D_CREATEDATE //ParameterList[1] V_CREATEUID VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB); Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["UPDATEDATE"].ToString().Trim() == "") //新增 { //0.STORE VARCHAR2(6) //1.ROUTE VARCHAR2(3) //2.STEP VARCHAR2(3) //3.OLD_STORE VARCHAR2(6) //4.ST_ACCEPT_DATE DATE //5.QTY_BOXNUM NUMBER(5) //6.QTY_BACKBOXNUM NUMBER(5) //7.UPDATEUID VARCHAR2(10) //8.UPDATEDATE DATE Para.Clear(); Para.Add(dt.Rows[i]["STORE"].ToString().Trim()); Para.Add(dt.Rows[i]["ROUTE"].ToString().Trim()); Para.Add(dt.Rows[i]["STEP"].ToString().Trim()); Para.Add(dt.Rows[i]["OLD_STORE"].ToString().Trim()); Para.Add(dt.Rows[i]["ST_ACCEPT_DATE"]); Para.Add(DBPara(dt.Rows[i]["QTY_BOXNUM"].ToString().Trim(),ParaType.Number)); Para.Add(DBPara(dt.Rows[i]["QTY_BACKBOXNUM"].ToString().Trim(), ParaType.Number)); Para.Add(ParameterList[1]); Para.Add(ParameterList[0]); DBO.InsertData(Para, DBT); } else //更新 { //0.STORE VARCHAR2(6) //1.ST_ACCEPT_DATE DATE //2.QTY_BOXNUM NUMBER(5) //3.QTY_BACKBOXNUM NUMBER(5) //4.UPDATEUID VARCHAR2(10) //5.UPDATEDATE DATE //6.OLD_UPDATEUID VARCHAR2(10) //7.OLD_UPDATEDATE DATE Para.Clear(); Para.Add(dt.Rows[i]["STORE"].ToString().Trim()); Para.Add(dt.Rows[i]["ST_ACCEPT_DATE"]); Para.Add(DBPara(dt.Rows[i]["QTY_BOXNUM"].ToString().Trim(),ParaType.Number)); Para.Add(DBPara(dt.Rows[i]["QTY_BACKBOXNUM"].ToString().Trim(), ParaType.Number)); Para.Add(ParameterList[1]); Para.Add(ParameterList[0]); Para.Add(dt.Rows[i]["UPDATEUID"].ToString().Trim()); Para.Add(DBPara(dt.Rows[i]["UPDATEDATE"].ToString().Trim(), ParaType.Date)); DBO.UpdateData(Para, DBT); } } DBT.Commit(); bResult = true; } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) Conn.Close(); } return bResult; }