public DataTable QuerySwitch(QueryType QT, ArrayList ParameterList ) { DBO.MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); DataTable Dt; try { switch (QT) { case QueryType.ALL: Dt = dbo.doQueryAll(); break; case QueryType.CODE: Dt = dbo.doQueryByCode(ParameterList); break; case QueryType.ID: Dt = dbo.doQueryByID(ParameterList); break; case QueryType.Custom: Dt = dbo.doQueryByFind(ParameterList); break; default: Dt = new DataTable(); break; } return Dt; } catch (Exception ex) { throw ex; } }
public DataTable QueryStoreGiftByCode(ArrayList ParameterList) { try { DBO.MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); return dbo.doQueryByCode(ParameterList); } catch (Exception ex) { throw ex; } }
public DataTable QueryStoreGiftByALL() { try { DBO.MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); return dbo.doQueryAll(); } catch (Exception ex) { throw ex; } }
/// <summary> /// 整批刪除VDS_MKT_STOREGIFT /// </summary> /// <param name="ParameterList">刪除變數</param> /// <param name="RootDBT">是否有主交易,無主交易輸入null</param> public void BatchDel(ArrayList ParameterList, DbTransaction RootDBT) { bool IsRootTranscation = false; try { MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion dbo.BatchDel(ParameterList, DBT); #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } 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 } }
/// <summary> /// 新增多筆通路門市贈品 /// </summary> public void CreateStoreGifts(DataTable dt, DbTransaction RootDBT) { bool IsRootTranscation = false; try { DBO.MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion ArrayList ALD = new ArrayList(); for (int i = 0; i < dt.Rows.Count; i++) { ALD.Clear(); ALD.Add(dt.Rows[i]["ITEM"].ToString()); ALD.Add(dt.Rows[i]["PERIOD"].ToString()); ALD.Add(dt.Rows[i]["CHAN_NO"].ToString()); ALD.Add(dt.Rows[i]["STORE"].ToString()); ALD.Add(dt.Rows[i]["VIRTUAL_CODE"].ToString()); ALD.Add(dt.Rows[i]["UPDATEUID"].ToString()); if (QueryExistPk(ALD).Rows.Count > 0) throw new Exception("新增失敗,通路「" + dt.Rows[i]["CHAN_NO"].ToString() + "」、門市代號「" + dt.Rows[i]["STORE"].ToString() + "」資料已存在"); dbo.doCreate(ALD, DBT); } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } 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 } }
/// <summary> /// 取得匯出通路門市贈品主檔資料 /// </summary> /// <param name="ParameterList">品號、期別、通路(起迄)、營業所(起迄)、縣市別(起迄)、商圈別(起迄)、貨架形式(起、迄)</param> /// <returns></returns> public DataTable ExportStoreGift(ArrayList ParameterList) { try { DBO.MKT_StoreGiftDBO dbo = new MKT_StoreGiftDBO(ref USEDB); return dbo.doExportStoreGift(ParameterList); } catch (Exception ex) { throw ex; } }