/// <summary> /// 查詢 VDS_CGD_DAILY_SPEC /// </summary> public DataTable QueryVDS_CGD_DAILY_SPEC(ArrayList ParameterList) { try { VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB); return CGD39.QueryVDS_CGD_DAILY_SPEC(ParameterList); } catch (Exception ex) { throw ex; } }
/// <summary> /// C8-> 取《非理貨商品門市資料》區塊的《冊數》欄位合計值 /// C4-> count 資料列數 /// </summary> public DataTable GetPickOutItem(ArrayList ParameterList) { try { VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB); return CGD39.GetPickOutItem(ParameterList); } catch (Exception ex) { throw ex; } }
/// <summary> /// C6 副代理明細資料-數量 /// C7 理貨明細資料-比數 /// </summary> public DataTable QueryDeilyDPSitem(ArrayList ParameterList) { try { VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB); return CGD39.QueryDeilyDPSitem(ParameterList); } catch (Exception ex) { throw ex; } }
//儲存資料 public void SaveData(ArrayList ParameterList, DataTable dtINFO, ArrayList ParameterSPEC, DataTable dtITEM) { //ParameterList //0.PID //1.PICK_DATE //2.PICK_BATCH //3.UID //4.UPDATE_TIME //5.CREATEUID //6.CreateDate //7.V_GET_TIME //8.N_SPEC_ITEMNUM //9.N_CTRL_ITEMNUM //10.N_PICK_ITEMNUM //11.N_AMT //12.OLD_RPT_UPDATEUID //13.OLD_RPT_UPDATE_TIME ArrayList Para = new ArrayList(); try { CGD.VDS_CGD39_DBO CGDM = new VDS_CGD39_DBO(ref USEDB); Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); #region 寫入 VDS_CGD_DAILY_RPT Para.Clear(); Para.Add(ParameterList[1]);//0.D_PICK_DATE in date, Para.Add(ParameterList[2]);//1.V_PICK_BATCH in varchar2, Para.Add(ParameterList[7]);//2.V_GET_TIME in varchar2, Para.Add(ParameterList[8]);//3.N_SPEC_ITEMNUM in number, Para.Add(ParameterList[9]);//4.N_CTRL_ITEMNUM in number, Para.Add(ParameterList[10]);//5.N_PICK_ITEMNUM in number, Para.Add(ParameterList[11]);//6.N_AMT in number, Para.Add(ParameterList[4]);//7.D_UPDATEDATE in date, Para.Add(ParameterList[3]);//8.V_UPDATEUID in varchar2, Para.Add(ParameterList[0]);//9.N_ID in number, Para.Add(ParameterList[13]);//10.D_OLD_UPDATEDATE in date, Para.Add(ParameterList[12]);//11.V_OLD_UPDATEUID in varchar2 CGDM.UpdateVDS_CGD_DAILY_RPT(Para, DBT); #endregion #region 寫入VDS_CGD_DAILY_INFO //先刪除後寫入 Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2 CGDM.DeleteVDS_CGD_DAILY_INFO(Para, DBT); for (int i = 0; i < dtINFO.Rows.Count; i++) { Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(dtINFO.Rows[i]["VENDOR"].ToString()); //3.V_VENDOR in varchar2, Para.Add(DBPara(dtINFO.Rows[i]["SHORTNUM"].ToString(), ParaType.Number)); //4.N_SHORTNUM in number, Para.Add(DBPara(dtINFO.Rows[i]["OVERNUM"].ToString(), ParaType.Number)); //5.N_OVERNUM in number, Para.Add(DBPara(dtINFO.Rows[i]["NORMAOL_STAFFNUM"].ToString(), ParaType.Number)); //6.N_NORMAOL_STAFFNUM in number, Para.Add(DBPara(dtINFO.Rows[i]["ADD_STAFFNUM"].ToString(), ParaType.Number)); //7.N_ADD_STAFFNUM in number, Para.Add(DBPara(dtINFO.Rows[i]["FRONT_STAFFNUM"].ToString(), ParaType.Number)); //8.N_FRONT_STAFFNUM in number, Para.Add(DBPara(dtINFO.Rows[i]["NORMAOL_HR"].ToString(), ParaType.Number)); //9.N_NORMAOL_HR in number, Para.Add(DBPara(dtINFO.Rows[i]["ADD_HR"].ToString(), ParaType.Number)); //10.N_ADD_HR in number, Para.Add(DBPara(dtINFO.Rows[i]["FRONT_HR"].ToString(), ParaType.Number)); //11.N_FRONT_HR in number, if (ParameterList[5].ToString().Trim() == "") { //如果沒有CREATEUID代表新資料 Para.Add(ParameterList[4]); //12.D_CREATEDATE in date, Para.Add(ParameterList[3]); //13.V_CREATEUID in varchar2, } else { //如果有CREATEUID 再把舊的CREATEUID寫回去 Para.Add(ParameterList[6]); //12.D_CREATEDATE in date, Para.Add(ParameterList[5]); //13.V_CREATEUID in varchar2, } Para.Add(ParameterList[4]); //14.D_UPDATEDATE in date, Para.Add(ParameterList[3]); //15.V_UPDATEUID in varchar2 CGDM.InsertVDS_CGD_DAILY_INFO(Para, DBT); } #endregion #region 寫入VDS_CGD_DAILY_SPEC //先刪除後寫入 Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2 CGDM.DeleteVDS_CGD_DAILY_SPEC(Para, DBT); Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(ParameterSPEC[0]); //3.N_SPEC_STORENUM_ALL in number, Para.Add(ParameterSPEC[1]); //4.N_SPEC_STORENUM in number, Para.Add(ParameterSPEC[2]); //5.N_SPEC_PERIODNUM_ALL in number, Para.Add(ParameterSPEC[3]); //6.N_SPEC_PERIODNUM in number, Para.Add(ParameterSPEC[4]); //7.N_SPEC_ITEMNUM in number, Para.Add(ParameterSPEC[5]); //8.N_SPEC_STAFFNUM in number, Para.Add(ParameterSPEC[6]); //9.N_SEPC_HR in number, Para.Add(ParameterSPEC[7]); //10.N_VDS_TRANSNUM in number, Para.Add(ParameterSPEC[8]); //11.N_DPS_TRANSNUM in number, Para.Add(ParameterSPEC[9]); //12.V_NOTES in varchar2 if (ParameterList[5].ToString().Trim() == "") { //如果沒有CREATEUID代表新資料 Para.Add(ParameterList[4]); //13.D_CREATEDATE in date, Para.Add(ParameterList[3]); //14.V_CREATEUID in varchar2, } else { //如果有CREATEUID 再把舊的CREATEUID寫回去 Para.Add(ParameterList[6]); //13.D_CREATEDATE in date, Para.Add(ParameterList[5]); //14.V_CREATEUID in varchar2, } Para.Add(ParameterList[4]); //15.D_UPDATEDATE in date, Para.Add(ParameterList[3]); //16.V_UPDATEUID in varchar2 CGDM.InsertVDS_CGD_DAILY_SPEC(Para, DBT); #endregion #region 寫入VDS_CGD_DAILY_ITEM //先刪除後寫入 Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2 CGDM.DeleteVDS_CGD_DAILY_ITEM(Para, DBT); for (int i = 0; i < dtITEM.Rows.Count; i++) { if ((dtITEM.Rows[i]["ITEM"].ToString().Trim() != "") && (dtITEM.Rows[i]["PERIOD"].ToString() != "")) { Para.Clear(); Para.Add(ParameterList[0]); //0.N_PID in number, Para.Add(ParameterList[1]); //1.D_PICK_DATE in date, Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2, Para.Add(dtITEM.Rows[i]["ITEM"].ToString()); //3.V_ITEM in varchar2, Para.Add(dtITEM.Rows[i]["PERIOD"].ToString()); //4.V_PERIOD in varchar2, Para.Add(dtITEM.Rows[i]["SHORT_NUM"].ToString()); //5.N_SHORT_NUM in number, Para.Add(dtITEM.Rows[i]["OVER_NUM"].ToString()); //6.N_OVER_NUM in number, Para.Add(ParameterList[4]); //7.D_CREATEDATE in date, Para.Add(ParameterList[3]); //8.V_CREATEUID in varchar2, Para.Add(ParameterList[4]); //9.D_UPDATEDATE in date, Para.Add(ParameterList[3]); //10.V_UPDATEUID in varchar2 CGDM.InsertVDS_CGD_DAILY_ITEM(Para, DBT); } } #endregion DBT.Commit(); } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } }