public void QueryCheck(ArrayList ParameterList, out string V_COUNT) { MaintainStockTakeFreezeDBO dbo = new MaintainStockTakeFreezeDBO(ref USEDB); try { dbo.QueryCheck(ParameterList, out V_COUNT); } catch (Exception ex) { throw ex; } }
public DataTable QueryByFind(ArrayList ParameterList, out string strFreeze, out string strUnFreeze) { MaintainStockTakeFreezeDBO dbo = new MaintainStockTakeFreezeDBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.QueryByFind(ParameterList,out strFreeze,out strUnFreeze); return dtResult; } catch (Exception ex) { throw ex; } }
public DataTable QueryLocateSection(string strNo) { MaintainStockTakeFreezeDBO dbo = new MaintainStockTakeFreezeDBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.QueryLocateSection(strNo); return dtResult; } catch (Exception ex) { throw ex; } }
public DataTable PrintRpt01() { MaintainStockTakeFreezeDBO dbo = new MaintainStockTakeFreezeDBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.PrintRpt01(); return dtResult; } catch (Exception ex) { throw ex; } }
public int UpdFreezeLocateSec(DataTable Dt,string UID, DbTransaction RootDBT) { int result; bool IsRootTranscation = false; DBO.MaintainStockTakeFreezeDBO db = new MaintainStockTakeFreezeDBO(ref USEDB); try { //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion result = 1; for (int i = 0; Dt.Rows.Count > i; i++) { ArrayList aList = new ArrayList(); aList.Add(Dt.Rows[i]["LOCATE_NO"].ToString()); aList.Add(Dt.Rows[i]["LOCATE_SECTION"].ToString()); aList.Add(DBNull.Value); aList.Add(UID); result = db.UpdFreezeLocateSec(aList, DBT); } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion return result; } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }