public DataTable StockAsOnDateDetail(string whid, string product, DateTime?dateSelect)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "QUERY_PACK.STOCK_AS_ON_DATE_DTL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strWH_ID", whid);
param.AddParamInput(2, "strPRODUCT", product);
if (dateSelect.HasValue)
{
param.AddParamInput(3, "strAsOnDate", dateSelect.Value);
}
else
{
param.AddParamInput(3, "strAsOnDate", DBNull.Value);
}
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockAsOn(string whid, string partyid, string product)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "QUERY_PACK.STOCK_AS_ON_REVISE"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strWH_ID", whid);
param.AddParamInput(2, "strPRODUCT", product);
param.AddParamInput(3, "strCustomer", partyid);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable GetDeliveryOrderDetail(string doNo)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "DO_PACK.GET_DO_DTL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strDO_NO", doNo);
param.AddParamInput(3, "strLINE_NO", DBNull.Value);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockOutSummaryDetail(string refNo, string product, DateTime outDate)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4);
param.ProcedureName = "QUERY_PACK.STOCK_OUT_DTL";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strREF_NO", refNo);
param.AddParamInput(2, "strPRODUCT", product);
param.AddParamInput(3, "strOutDate", outDate);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable GetResultUploadRevision(string seq, string userid)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "INTERFACE_PACK.UP_BOM_LIST"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strSEQ", seq);
param.AddParamInput(2, "strUser_id", userid);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockAsOnDate_Mtl(string location, string partyid, string material)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "QUERY_PACK.STOCK_AS_ON_DATE_MTL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strLOCATION_ID", location);
param.AddParamInput(2, "strPARTY_ID", partyid);
param.AddParamInput(3, "strCustomer", material);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockOutSummaryDetail_Mtl(string refNo, string mtlCode, DateTime outDate)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "QUERY_PACK.STOCK_OUT_MTL_DTL"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strREF_NO", refNo);
param.AddParamInput(2, "strMTL", mtlCode);
param.AddParamInput(3, "strOutDate", outDate);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
private DataTable GetDataToPost2(string procName, string wh, int seq, string userid)
{
DataTable dtb = new DataTable();
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = procName
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strWH", wh);
param.AddParamInput(2, "strSEQ", seq);
param.AddParamInput(3, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
dtb.Load(OraDataReader.Instance.OraReader);
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(dtb);
}
public DataTable GetQCTODetail(string qcReturnNo)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "TO_PACK.GET_TO_DTL";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strTO_NO", qcReturnNo);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockInSummaryDetail_Mtl(string whId, string arrType, string partyName, string mtlCode, DateTime inDate)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(6)
{
ProcedureName = "QUERY_PACK.STOCK_IN_MTL_DTL"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strWH_ID", whId);
param.AddParamInput(2, "strARR_TYPE", arrType);
param.AddParamInput(3, "strPARTY_NAME", partyName);
param.AddParamInput(4, "strMTL_CODE", mtlCode);
param.AddParamInput(5, "strInDate", inDate);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable GetLoadingOrderDetail(string loadingNo)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "LOADING_PACK.GET_LOADING_DTL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strLOADING_NO", loadingNo);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public MaterialCard ScanMat_Stock(string serialno, out string resultMsg)
{
resultMsg = string.Empty;
MaterialCard mtl = null;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_MAT_PACK.SCAN_MAT_STOCK"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strSERIAL_NO", serialno);
procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 30);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize;
while (OraDataReader.Instance.OraReader.Read())
{
mtl = new MaterialCard();
mtl.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
mtl.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
mtl.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mtl.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mtl.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mtl.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mtl.QTY = OraDataReader.Instance.GetDecimal("QTY");
mtl.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
mtl.MIN_QTY = OraDataReader.Instance.GetDecimal("MIN_QTY");
mtl.MAX_QTY = OraDataReader.Instance.GetDecimal("MAX_QTY");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
OracleString resultDB = (OracleString)procPara.ReturnValue(2);
if (!resultDB.IsNull)
{
resultMsg = resultDB.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(mtl);
}
public ProductCard_Status GetProductCardStatus(string serialNo, string userid, out string resultMessage)
{
resultMessage = string.Empty;
ProductCard_Status pcCard = null;
try
{
ProcParam procPara = new ProcParam(4)
{
ProcedureName = "SCANNER_PACK_VER.GET_PC_STATUS"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strSERIAL_NO", serialNo);
procPara.AddParamOutput(2, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(3, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
pcCard = new ProductCard_Status();
pcCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
pcCard.MC_NO = OraDataReader.Instance.GetString("MC_NO");
pcCard.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO");
pcCard.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME");
pcCard.STATUS = OraDataReader.Instance.GetString("STATUS");
if (!OraDataReader.Instance.IsDBNull("PROCESS_DATE"))
{
pcCard.PROCESS_DATE = OraDataReader.Instance.GetDateTime("PROCESS_DATE");
}
pcCard.QTY = OraDataReader.Instance.GetInteger("QTY");
pcCard.NG_QTY = OraDataReader.Instance.GetInteger("NG_QTY");
pcCard.REP_QTY = OraDataReader.Instance.GetInteger("REP_QTY");
}
}
else
{
OracleString result = (OracleString)procPara.ReturnValue(2);
if (!result.IsNull)
{
resultMessage = result.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
pcCard = null;
throw ex;
}
return(pcCard);
}
public List <MaterialSP> GetMaterialSPList(string findAll)
{
List <MaterialSP> lstMaterialSP = null;
MaterialSP material;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MASTER_PACK.GET_M_MATERIAL_SP"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strFindAll", findAll);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstMaterialSP = new List <MaterialSP>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
material = new MaterialSP();
material.SP_GROUP = OraDataReader.Instance.GetString("SP_GROUP");
material.CUST_PROD_NO = OraDataReader.Instance.GetString("CUST_PROD_NO");
material.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
material.N_USER = OraDataReader.Instance.GetString("N_USER");
material.N_DATE = OraDataReader.Instance.GetDateTime("N_DATE");
material.U_USER = OraDataReader.Instance.GetString("U_USER");
try
{
material.U_DATE = OraDataReader.Instance.GetDateTime("U_DATE");
}
catch (Exception)
{
material.U_DATE = null;
}
lstMaterialSP.Add(material);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstMaterialSP = null;
throw ex;
}
return(lstMaterialSP);
}
public ProductCard GetProductCardInfo(string serialNo, string mode, string userid, out string resultMessage)
{
resultMessage = string.Empty;
ProductCard pcCard = null;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_PACK_VER.GET_PC_INFO_PROCESS"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strSERIAL_NO", serialNo);
procPara.AddParamInput(2, "strPROCESS", mode);
procPara.AddParamOutput(3, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(4, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
pcCard = new ProductCard();
pcCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
pcCard.PROD_SEQ_NO = OraDataReader.Instance.GetString("PROD_SEQ_NO");
pcCard.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO");
pcCard.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME");
pcCard.MTL_TYPE = OraDataReader.Instance.GetString("MTL_TYPE");
pcCard.JOB_NO = OraDataReader.Instance.GetString("JOB_NO");
pcCard.SHIFT = OraDataReader.Instance.GetString("SHIFT");
pcCard.LINE_NO = OraDataReader.Instance.GetInteger("LINE_NO");
pcCard.QTY = OraDataReader.Instance.GetInteger("QTY");
pcCard.BOX_SCANNED = OraDataReader.Instance.GetInteger("NO_OF_BOX");
pcCard.BOX_QTY = OraDataReader.Instance.GetInteger("TOT_BOX");
pcCard.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
}
}
else
{
OracleString resultDB = (OracleString)procPara.ReturnValue(3);
if (!resultDB.IsNull)
{
resultMessage = resultDB.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(pcCard);
}
public List <MaterialCard> GetSelectMtlCard(int seqNo)
{
List <MaterialCard> lstMtlCard = null;
MaterialCard mtlCard;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MTL_IN_PACK.GET_MATERIAL_CARD"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strSEQ_NO", seqNo);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstMtlCard = new List <MaterialCard>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
mtlCard = new MaterialCard();
mtlCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
mtlCard.ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO");
mtlCard.LINE_NO = OraDataReader.Instance.GetInteger("LINE_NO");
mtlCard.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mtlCard.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
mtlCard.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mtlCard.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mtlCard.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mtlCard.QTY = OraDataReader.Instance.GetDecimal("QTY");
mtlCard.CARGO_STATUS = OraDataReader.Instance.GetString("CARGO_STATUS");
mtlCard.WH_ID = OraDataReader.Instance.GetString("WH_ID");
//prdCard.BARCODE = OraDataReader.Instance.GetBitmap("BARCODE");
mtlCard.NO_OF_PRINT = OraDataReader.Instance.GetInteger("NO_OF_PRINT");
lstMtlCard.Add(mtlCard);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstMtlCard = null;
throw ex;
}
return(lstMtlCard);
}
public DeliveryOrder GetDeliveryOrder(string doNo)
{
DeliveryOrder delOrd = null;
try
{
ProcParam param = new ProcParam(7)
{
ProcedureName = "DO_PACK.GET_DO_HDR"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strDO_NO", doNo);
param.AddParamInput(3, "strREF_NO", DBNull.Value);
param.AddParamInput(4, "strDO_DT_F", DBNull.Value);
param.AddParamInput(5, "strDO_DT_T", DBNull.Value);
param.AddParamInput(6, "strPROD_TYPE", DBNull.Value);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1;
while (OraDataReader.Instance.OraReader.Read())
{
delOrd = new DeliveryOrder();
delOrd.DO_NO = OraDataReader.Instance.GetString("DO_NO");
if (!OraDataReader.Instance.IsDBNull("DO_DATE"))
{
delOrd.DO_DATE = OraDataReader.Instance.GetDateTime("DO_DATE");
}
delOrd.REF_NO = OraDataReader.Instance.GetString("REF_NO");
delOrd.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE");
delOrd.TO_DEST = OraDataReader.Instance.GetString("TO_DEST");
if (!OraDataReader.Instance.IsDBNull("DELIVERY_DATE"))
{
delOrd.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE");
}
delOrd.REMARK = OraDataReader.Instance.GetString("REMARK");
delOrd.REC_STAT = OraDataReader.Instance.GetString("REC_STAT").Equals("Y");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
delOrd = null;
throw ex;
}
return(delOrd);
}
public ProductCard Horizontal_GetUpdatePC_QCInfo(string serialNo, string qcStatus, string userid, out string resultMessage)
{
resultMessage = string.Empty;
ProductCard pcCard = null;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_PACK_HOZ.GET_UPD_PC_QC"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strSERIAL_NO", serialNo);
procPara.AddParamInput(2, "strQC_STATUS", qcStatus);
procPara.AddParamOutput(3, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(4, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
pcCard = new ProductCard();
pcCard.JOB_NO = OraDataReader.Instance.GetString("JOB_NO");
pcCard.LINE_NO = OraDataReader.Instance.GetInteger("LINE_NO");
pcCard.JOB_LOT = OraDataReader.Instance.GetString("JOB_LOT");
pcCard.PROD_SEQ_NO = OraDataReader.Instance.GetString("PROD_SEQ_NO");
pcCard.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO");
pcCard.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME");
pcCard.MTL_TYPE = OraDataReader.Instance.GetString("MTL_TYPE");
pcCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
pcCard.QTY = OraDataReader.Instance.GetInteger("QTY");
pcCard.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
}
}
else
{
OracleString result = (OracleString)procPara.ReturnValue(3);
if (!result.IsNull)
{
resultMessage = result.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(pcCard);
}
public Pallet GetUpdatePalletLoading(string loadNo, string palletno, string userid, out string resultMessage)
{
resultMessage = string.Empty;
Pallet pallet = null;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_PACK_FG.GET_UPD_PALLET_LOADING"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strPALLET_NO", palletno);
procPara.AddParamInput(2, "strLOADING_NO", loadNo);
procPara.AddParamOutput(3, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(4, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
pallet = new Pallet();
pallet.PALLET_NO = OraDataReader.Instance.GetString("PALLET_NO");
pallet.SO_NO = OraDataReader.Instance.GetString("SO_NO");
pallet.PALLET_SEQ = OraDataReader.Instance.GetInteger("PALLET_SEQ");
pallet.PALLET_TOTAL = OraDataReader.Instance.GetInteger("PALLET_TOTAL");
pallet.PALLET_STATUS = OraDataReader.Instance.GetString("PALLET_STATUS");
pallet.PALLET_BOX = OraDataReader.Instance.GetInteger("PALLET_BOX");
pallet.PALLET_PCS = OraDataReader.Instance.GetInteger("PALLET_PCS");
pallet.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
pallet.ETA = OraDataReader.Instance.GetString("ETA");
}
}
else
{
OracleString result = (OracleString)procPara.ReturnValue(3);
if (!result.IsNull)
{
resultMessage = result.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(pallet);
}
public Material GetMaterialCode(string strMTL_CODE, string strPARTY_ID)
{
//List<Material> lstMaterail = null;
Material material = null;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "LOV_PACK.GET_MATERIAL_CODE"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strMTL_CODE", strMTL_CODE);
param.AddParamInput(2, "strPARTY_ID", strPARTY_ID);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
material = new Material();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
material = new Material();
material.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
material.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
material.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
material.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
material.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
material.STD_QTY = OraDataReader.Instance.GetDecimal("STD_QTY");
material.UNIT = OraDataReader.Instance.GetString("UNIT");
//material.MTL_IMAGE = OraDataReader.Instance.GetBitmap("MTL_IMAGE");
//material.KANBAN = OraDataReader.Instance.GetLong("KANBAN");
//material.LOCATION_ID = OraDataReader.Instance.GetString("LOCATION_ID");
//material.BARCODE_SUPPLIER = OraDataReader.Instance.GetString("BARCODE_SUPPLIER");
//material.REMARK = OraDataReader.Instance.GetString("REMARK");
//material.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
material = null;
throw ex;
}
return(material);
}
private DataTable GetPrintLoadingOrder(string doNo, string userid, string tableName)
{
List <DeliveryOrder> lstLoadingOrd = null;
DeliveryOrder loadingOrd;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "DO_PACK.REP_DO_R1"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strDO_NO", doNo);
param.AddParamInput(2, "strUSER_ID", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstLoadingOrd = new List <DeliveryOrder>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
loadingOrd = new DeliveryOrder();
loadingOrd.DO_NO = OraDataReader.Instance.GetString("DO_NO");
loadingOrd.DO_DATE = OraDataReader.Instance.GetDateTime("DO_DATE");
loadingOrd.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE");
loadingOrd.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE");
loadingOrd.REF_NO = OraDataReader.Instance.GetString("REF_NO");
loadingOrd.TO_DEST = OraDataReader.Instance.GetString("TO_DEST");
loadingOrd.REMARK = OraDataReader.Instance.GetString("REMARK");
//loadingOrd.BARCODE = UtilityBLL.QRCode_Encode(loadingOrd.DO_NO);
lstLoadingOrd.Add(loadingOrd);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstLoadingOrd = null;
throw ex;
}
return(UtilityBLL.ListToDataTable(lstLoadingOrd, tableName));
}
public List <Party> GetPartyList(string findValue)
{
List <Party> lstParty = null;
Party party;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "MASTER_PACK.GET_M_PARTY";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", findValue);
param.AddParamInput(2, "strPARTY_ID", DBNull.Value);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstParty = new List <Party>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
party = new Party();
party.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
party.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
party.PARTY_TYPE = OraDataReader.Instance.GetString("PARTY_TYPE");
party.ADD1 = OraDataReader.Instance.GetString("ADD1");
party.ADD2 = OraDataReader.Instance.GetString("ADD2");
party.ADD3 = OraDataReader.Instance.GetString("ADD3");
party.ADD4 = OraDataReader.Instance.GetString("ADD4");
party.TEL = OraDataReader.Instance.GetString("TEL");
party.FAX = OraDataReader.Instance.GetString("FAX");
party.EMAIL = OraDataReader.Instance.GetString("EMAIL");
party.PIC = OraDataReader.Instance.GetString("PIC");
party.REMARK = OraDataReader.Instance.GetString("REMARK");
party.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
lstParty.Add(party);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstParty = null;
throw ex;
}
return(lstParty);
}
public List <DeliveryBoard> GetDeliveryBoard()
{
List <DeliveryBoard> lstDelivery = null;
DeliveryBoard Delivery = null;
try
{
ProcParam procPara = new ProcParam(1)
{
ProcedureName = "DASHBOARD_NEW_PACK.GET_DELIVERY_BOARD"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstDelivery = new List <DeliveryBoard>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 100;
while (OraDataReader.Instance.OraReader.Read())
{
Delivery = new DeliveryBoard();
Delivery.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
Delivery.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
Delivery.WH_ID = OraDataReader.Instance.GetString("WH_ID");
Delivery.ETD_DATE = OraDataReader.Instance.GetDateTime("ETD_DATE");
Delivery.ETD_TIME = OraDataReader.Instance.GetString("ETD_TIME");
Delivery.STATUS = OraDataReader.Instance.GetString("STATUS");
Delivery.RESPONSIBLE = OraDataReader.Instance.GetString("RESPONSIBLE");
lstDelivery.Add(Delivery);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
if (GlobalDB.Instance.DataAc.LastException != null)
{
throw GlobalDB.Instance.DataAc.LastException;
}
}
catch (Exception ex)
{
lstDelivery = null;
throw ex;
}
return(lstDelivery);
}
public Material GetMaterial(string mtlSeq)
{
Material material = null;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "MASTER_PACK.GET_M_MATERIAL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strMTL_SEQ_NO", mtlSeq);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1;
while (OraDataReader.Instance.OraReader.Read())
{
material = new Material();
material.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
material.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
material.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
material.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
material.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
material.UNIT = OraDataReader.Instance.GetString("UNIT");
material.STD_QTY = OraDataReader.Instance.GetDecimal("STD_QTY");
material.MIN_QTY = OraDataReader.Instance.GetDecimal("MIN_QTY");
material.MAX_QTY = OraDataReader.Instance.GetDecimal("MAX_QTY");
material.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
material.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
material.MTL_IMAGE = OraDataReader.Instance.GetBitmap("MTL_IMAGE");
material.LOCATION_ID = OraDataReader.Instance.GetString("LOCATION_ID");
material.REMARK = OraDataReader.Instance.GetString("REMARK");
material.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
material = null;
throw ex;
}
return(material);
}
public TransferOrderHdr GetTransferOrder(string qcReturnNo)
{
TransferOrderHdr TOhdr = null;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "TO_PACK.GET_TO_HDR"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strTO_NO", qcReturnNo);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1;
while (OraDataReader.Instance.OraReader.Read())
{
TOhdr = new TransferOrderHdr();
TOhdr.TO_NO = OraDataReader.Instance.GetString("TO_NO");
TOhdr.TO_DATE = OraDataReader.Instance.GetDateTime("TO_DATE");
TOhdr.REF_NO = OraDataReader.Instance.GetString("REF_NO");
TOhdr.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE");
TOhdr.TO_DEST = OraDataReader.Instance.GetString("TO_DEST");
TOhdr.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE");
TOhdr.REMARK = OraDataReader.Instance.GetString("REMARK");
TOhdr.ISSUED_BY = OraDataReader.Instance.GetString("ISSUED_BY");
TOhdr.ISSUED_DATE = OraDataReader.Instance.GetDateTime("ISSUED_DATE");
TOhdr.UPDATE_BY = OraDataReader.Instance.GetString("UPDATE_BY");
TOhdr.UPDATE_DATE = OraDataReader.Instance.GetDateTime("UPDATE_DATE");
TOhdr.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
TOhdr.POST_REF = OraDataReader.Instance.GetString("POST_REF");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
TOhdr = null;
throw ex;
}
return(TOhdr);
}
public List <M_Program> GetProgramList(string procType, string procID)
{
List <M_Program> lstProgram = null;
M_Program mProgram;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "ADMINISTRATOR_PACK.GET_PROGRAM_LIST";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strPROG_TYPE", procType);
param.AddParamInput(2, "strPROG_ID", procID);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.HasRows)
{
lstProgram = new List <M_Program>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
mProgram = new M_Program();
mProgram.PROG_ID = OraDataReader.Instance.GetString("PROG_ID");
mProgram.PROG_NAME = OraDataReader.Instance.GetString("PROG_NAME");
mProgram.PROG_TYPE = OraDataReader.Instance.GetString("PROG_TYPE");
if (!OraDataReader.Instance.IsDBNull("ORDER_BY"))
{
mProgram.ORDER_BY = OraDataReader.Instance.GetInteger("ORDER_BY");
}
mProgram.ICON = OraDataReader.Instance.GetString("ICON");
mProgram.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
mProgram.DESCRIPTION = OraDataReader.Instance.GetString("DESCRIPTION");
mProgram.PROG_KEY = OraDataReader.Instance.GetString("PROG_KEY");
lstProgram.Add(mProgram);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstProgram = null;
}
return(lstProgram);
}
public List <Product> LovProductList(string search, string prodtype, string partyid)
{
List <Product> lstProduct = null;
Product product;
try
{
ProcParam param = new ProcParam(5)
{
ProcedureName = "LOV_PACK.GET_PRODUCT_LIST"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", search);
param.AddParamInput(2, "strPROD_SEQ_NO", DBNull.Value);
param.AddParamInput(3, "strPROD_TYPE", prodtype);
param.AddParamInput(4, "strPARTY_ID", partyid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstProduct = new List <Product>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
product = new Product();
product.PROD_SEQ_NO = OraDataReader.Instance.GetString("PROD_SEQ_NO");
product.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO");
product.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME");
product.MATERIAL_NAME = OraDataReader.Instance.GetString("MATERIAL_NAME");
//product.BOX_QTY = OraDataReader.Instance.GetInteger("BOX_QTY");
product.UNIT = OraDataReader.Instance.GetString("UNIT");
// product.FREE_STOCK = OraDataReader.Instance.GetInteger("FREE_STOCK");
//use for unit price
// product.COST_PRICE = OraDataReader.Instance.GetDecimal("UNIT_PRICE");
lstProduct.Add(product);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstProduct = null;
throw ex;
}
return(lstProduct);
}
public List <User> GetUserList(string userID)
{
List <User> lstUser = null;
User user;
try
{
ProcParam param = new ProcParam(2);
param.ProcedureName = "ADMINISTRATOR_PACK.GET_USER_LIST";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strUSER_ID", userID);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.HasRows)
{
lstUser = new List <User>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
//Console.WriteLine(reader.GetInt32(0) + ", " + myReader.GetString(1));
user = new User();
user.USER_ID = OraDataReader.Instance.GetString("USER_ID");
user.USER_NAME = OraDataReader.Instance.GetString("USER_NAME");
user.WARE_ID = OraDataReader.Instance.GetString("WARE_ID");
user.LOGIN = OraDataReader.Instance.GetString("LOGIN");
user.PWD = OraDataReader.Instance.GetString("PWD");
user.EMPLOYEE_ID = OraDataReader.Instance.GetString("EMPLOYEE_ID");
user.ROLE_ID = OraDataReader.Instance.GetString("ROLE_ID");
user.REMARK = OraDataReader.Instance.GetString("REMARK");
user.REC_STAT = OraDataReader.Instance.GetString("REC_STAT").ToUpper().Equals("Y");
user.EMAIL = OraDataReader.Instance.GetString("EMAIL");
user.COMP_ID = OraDataReader.Instance.GetString("COMP_ID");
lstUser.Add(user);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstUser = null;
}
return(lstUser);
}
private List <IF_ControlOrder> GetDataToPost(string procName, string wh, int seq, string userid)
{
//List<IF_ShippingOrder> lstIfShippingOrd = new List<IF_ShippingOrder>();
List <IF_ControlOrder> lstIfShippingOrd = null;
IF_ControlOrder ifShipOrd;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = procName
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strWH", wh);
param.AddParamInput(2, "strSEQ", seq);
param.AddParamInput(3, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstIfShippingOrd = new List <IF_ControlOrder>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
ifShipOrd = new IF_ControlOrder();
ifShipOrd.SEQ = OraDataReader.Instance.GetString("SEQ");
ifShipOrd.SEQ_DATE = OraDataReader.Instance.GetDateTime("SEQ_DATE");
ifShipOrd.FILE_ID = OraDataReader.Instance.GetString("FILE_ID");
ifShipOrd.LINE_NO = OraDataReader.Instance.GetInteger("LINE_NO");
ifShipOrd.TEXT = OraDataReader.Instance.GetString("TEXT");
lstIfShippingOrd.Add(ifShipOrd);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstIfShippingOrd = null;
throw ex;
}
return(lstIfShippingOrd);
}
public PickQty GetPickInfo(string pickNo, string userid, out string resultMessage)
{
resultMessage = string.Empty;
PickQty pickQty = null;
try
{
ProcParam procPara = new ProcParam(4)
{
ProcedureName = "SCANNER_PACK_FG.GET_PICK_INFO"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strPICK_NO", pickNo);
procPara.AddParamOutput(2, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(3, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
pickQty = new PickQty();
pickQty.PICK_NO = OraDataReader.Instance.GetString("PICK_NO");
pickQty.QTY = OraDataReader.Instance.GetInteger("QTY");
pickQty.PICKED_QTY = OraDataReader.Instance.GetInteger("PICKED_QTY");
pickQty.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
}
}
else
{
OracleString result = (OracleString)procPara.ReturnValue(2);
if (!result.IsNull)
{
resultMessage = result.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(pickQty);
}