public void InsertDeliveryBoardDetail(List <DeliveryBoardDetail> lstDeliveryBoardDetail, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM DELIVERY_DETAIL"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (DeliveryBoardDetail SQLiteInsert in lstDeliveryBoardDetail) { param = new SQLiteParam(16) { CommandText = StoreProcedure.Instance.GetScript("InsertDeliveryBoardDetail") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@WH_ID", SQLiteInsert.WH_ID); param.ParamDateTime(2, "@ETD_DATE", SQLiteInsert.ETD_DATE); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamInt32(5, "@QTY", SQLiteInsert.QTY); param.ParamStringFixedLength(6, "@UNIT", SQLiteInsert.UNIT); param.ParamInt32(7, "@NO_OF_BOX", SQLiteInsert.NO_OF_BOX); param.ParamInt32(8, "@FREE_STOCK", SQLiteInsert.FREE_STOCK); param.ParamInt32(9, "@ASSIGN_QTY", SQLiteInsert.ASSIGN_QTY); param.ParamInt32(10, "@PICKED_QTY", SQLiteInsert.PICKED_QTY); param.ParamInt32(11, "@LOADED_QTY", SQLiteInsert.LOADED_QTY); param.ParamStringFixedLength(12, "@STATUS", SQLiteInsert.STATUS); param.ParamStringFixedLength(13, "@REMARK", SQLiteInsert.REMARK); param.ParamInt32(14, "@FLAG", flag); param.ParamDateTime(15, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public void InsertDeliveryBoard(List <DeliveryBoard> lstDeliveryBoard, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM DELIVERY_BOARD"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (DeliveryBoard SQLiteInsert in lstDeliveryBoard) { param = new SQLiteParam(9) { CommandText = StoreProcedure.Instance.GetScript("InsertDeliveryBoard") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamDateTime(3, "@ETD_DATE", SQLiteInsert.ETD_DATE); param.ParamStringFixedLength(4, "@ETD_TIME", SQLiteInsert.ETD_TIME); param.ParamStringFixedLength(5, "@STATUS", SQLiteInsert.STATUS); param.ParamStringFixedLength(6, "@RESPONSIBLE", SQLiteInsert.RESPONSIBLE); param.ParamInt32(7, "@FLAG", flag); param.ParamDateTime(8, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public void InsertStockByMinMax(List <StockByMinMax> lstStockByMinMax, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_MINMAX"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByMinMax SQLiteInsert in lstStockByMinMax) { param = new SQLiteParam(20) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByMinMax") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_SEQ_NO", SQLiteInsert.PRODUCT_SEQ_NO); param.ParamStringFixedLength(5, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamStringFixedLength(6, "@PRODUCT_TYPE_ID", SQLiteInsert.PRODUCT_TYPE_ID); param.ParamStringFixedLength(7, "@PRODUCT_TYPE_NAME", SQLiteInsert.PRODUCT_TYPE_NAME); param.ParamInt32(8, "@BOX_QTY", SQLiteInsert.BOX_QTY); param.ParamInt32(9, "@STOCK_PCS", SQLiteInsert.STOCK_PCS); param.ParamInt32(10, "@STOCK_BOX", SQLiteInsert.STOCK_BOX); param.ParamStringFixedLength(11, "@STATUS_RUNNING_MC", SQLiteInsert.STATUS_RUNNING_MC); param.ParamInt32(12, "@PICK_PENDING", SQLiteInsert.PICK_PENDING); param.ParamInt32(13, "@EXPECTED_DELAY", SQLiteInsert.EXPECTED_DELAY); param.ParamInt32(14, "@FORECAST", SQLiteInsert.FORECAST); param.ParamInt32(15, "@MIN_BOX", SQLiteInsert.MIN_BOX); param.ParamInt32(16, "@MAX_BOX", SQLiteInsert.MAX_BOX); param.ParamStringFixedLength(17, "@STATUS", SQLiteInsert.STATUS); param.ParamInt32(18, "@FLAG", flag); param.ParamDateTime(19, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public void InsertStockByCustomer(List <StockByCustomer> lstStockByCustomer, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_CUSTOMER"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByCustomer SQLiteInsert in lstStockByCustomer) { param = new SQLiteParam(12) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByCustomer") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamStringFixedLength(5, "@PRODUCT_TYPE_ID", SQLiteInsert.PRODUCT_TYPE_ID); param.ParamStringFixedLength(6, "@PRODUCT_TYPE_NAME", SQLiteInsert.PRODUCT_TYPE_NAME); param.ParamInt32(7, "@BOX_QTY", SQLiteInsert.BOX_QTY); param.ParamInt32(8, "@QTY", SQLiteInsert.QTY); param.ParamInt32(9, "@NO_OF_BOX", SQLiteInsert.NO_OF_BOX); param.ParamInt32(10, "@FLAG", flag); param.ParamDateTime(11, "@lastupdate", lastupdate); //if (stkUpload.N_USER_DATE.HasValue) // param.ParamDate(9, "@N_USER_DATE", stkUpload.N_USER_DATE.Value); //else // param.ParamNull(9, "@N_USER_DATE"); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public DataTable GetDeliveryDTL(string party, DateTime date, string wh, string status) { try { SQLiteParam param; if (status.ToLower() == "delay") { param = new SQLiteParam(3) { CommandText = StoreProcedure.Instance.GetScript("GetDeliveryBoardDetail_Delay") }; param.ParamStringFixedLength(0, "@strWH_ID", wh); param.ParamStringFixedLength(1, "@strPARTY_ID", party); param.ParamDateTime(2, "@strETD_DATE", date); } else { param = new SQLiteParam(3) { CommandText = StoreProcedure.Instance.GetScript("GetDeliveryBoardDetail") }; param.ParamStringFixedLength(0, "@strWH_ID", wh); param.ParamStringFixedLength(1, "@strPARTY_ID", party); param.ParamDateTime(2, "@strETD_DATE", date); } DataTable dtResult = GlobalSqliteDB.Instance.DataAc.GetDataTable(param); return(dtResult); } catch (Exception ex) { throw ex; } }
public void InsertStockByMachine(List <StockByMachine> lstStockByMachine, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_MACHINE"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByMachine SQLiteInsert in lstStockByMachine) { param = new SQLiteParam(18) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByMachine") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); if (SQLiteInsert.START_DATE.HasValue) { param.ParamDateTime(2, "@START_DATE", SQLiteInsert.START_DATE.Value); } else { param.ParamNull(2, "@START_DATE"); } if (SQLiteInsert.END_DATE.HasValue) { param.ParamDateTime(3, "@END_DATE", SQLiteInsert.END_DATE.Value); } else { param.ParamNull(3, "@END_DATE"); } param.ParamStringFixedLength(4, "@STATUS", SQLiteInsert.STATUS); param.ParamInt32(5, "@PLAN_QTY", SQLiteInsert.PLAN_QTY); param.ParamStringFixedLength(6, "@PRODUCT_TYPE", SQLiteInsert.PRODUCT_TYPE); param.ParamStringFixedLength(7, "@PROD_TYPE_S", SQLiteInsert.PROD_TYPE_S); param.ParamStringFixedLength(8, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(9, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamInt32(10, "@STOCK_PCS", SQLiteInsert.STOCK_PCS); param.ParamInt32(11, "@STOCK_BOX", SQLiteInsert.STOCK_BOX); param.ParamStringFixedLength(12, "@MC_NO", SQLiteInsert.MC_NO); param.ParamStringFixedLength(13, "@MACHINE_NAME", SQLiteInsert.MACHINE_NAME); param.ParamInt32(14, "@MIN_BOX", SQLiteInsert.MIN_BOX); param.ParamInt32(15, "@MAX_BOX", SQLiteInsert.MAX_BOX); param.ParamInt32(16, "@FLAG", flag); param.ParamDateTime(17, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }