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)); }
private DataTable GetPrintLoadingOrder(int seqNo, string tableName) { List <LoadingOrder> lstLoadingOrd = null; LoadingOrder loadingOrd; try { ProcParam param = new ProcParam(2) { ProcedureName = "LOADING_PACK.RPT_DELIVERY_HDR" }; 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) { lstLoadingOrd = new List <LoadingOrder>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { loadingOrd = new LoadingOrder(); loadingOrd.WH_ID = OraDataReader.Instance.GetString("WH"); loadingOrd.LOADING_NO = OraDataReader.Instance.GetString("LOADING_NO"); loadingOrd.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE"); loadingOrd.TRUCK_NO = OraDataReader.Instance.GetString("TRUCK_NO"); loadingOrd.REMARK = OraDataReader.Instance.GetString("REMARK"); //loadingOrd.BARCODE = UtilityBLL.QRCode_Encode(loadingOrd.LOADING_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 DataTable GetProductionProcess(string prodSEQ) { List <ProdProcess> lstProdProcess = null; try { ProcParam param = new ProcParam(2) { ProcedureName = "MASTER_PACK.GET_M_PROD_PROCESS" }; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strPROD_SEQ_NO", prodSEQ); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.HasRows) { lstProdProcess = new List <ProdProcess>(); ProdProcess prodProcess; OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { prodProcess = new ProdProcess(); prodProcess.PROD_SEQ_NO = OraDataReader.Instance.GetString("PROD_SEQ_NO"); prodProcess.PROCESS_NO = OraDataReader.Instance.GetString("PROCESS_NO"); prodProcess.PROCESS_NAME = OraDataReader.Instance.GetString("PROCESS_NAME"); prodProcess.STEP_NO = OraDataReader.Instance.GetInteger("STEP_NO"); prodProcess.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); prodProcess.FLAG = OraDataReader.Instance.GetInteger("FLAG"); lstProdProcess.Add(prodProcess); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstProdProcess = null; } return(UtilityBLL.ListToDataTable(lstProdProcess, "M_PROD_PROCESS")); }
public DataTable GetProgramType(string procTypeID) { List <ProgramType> lstProcType = null; ProgramType procType; try { ProcParam param = new ProcParam(2); param.ProcedureName = "ADMINISTRATOR_PACK.GET_PROGRAM_TYPE_LIST"; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strPROG_TYPE", procTypeID); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); // //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.HasRows) { lstProcType = new List <ProgramType>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { //Console.WriteLine(reader.GetInt32(0) + ", " + myReader.GetString(1)); procType = new ProgramType(); procType.PROG_TYPE = OraDataReader.Instance.GetString("PROG_TYPE"); procType.PROG_TYPE_NAME = OraDataReader.Instance.GetString("PROG_TYPE_NAME"); procType.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); procType.ORDER_BY = OraDataReader.Instance.GetInteger("ORDER_BY"); procType.ICON = OraDataReader.Instance.GetString("ICON"); lstProcType.Add(procType); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstProcType = null; } //return lstProcType; return(UtilityBLL.ListToDataTable(lstProcType, "M_PROGRAM_TYPE")); }
public DataTable GetRoleProgramByRole(string roleID) { List <RoleProgram> lstRoleProg = null; try { ProcParam param = new ProcParam(2); param.ProcedureName = "ADMINISTRATOR_PACK.GET_ROLE_PROGRAM_LIST"; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strROLE_ID", roleID); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.HasRows) { lstRoleProg = new List <RoleProgram>(); RoleProgram roleProg; OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { roleProg = new RoleProgram(); roleProg.ROLE_ID = OraDataReader.Instance.GetString("ROLE_ID"); roleProg.PROG_ID = OraDataReader.Instance.GetString("PROG_ID"); roleProg.PROG_NAME = OraDataReader.Instance.GetString("PROG_NAME"); roleProg.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); roleProg.FLAG = OraDataReader.Instance.GetInteger("FLAG"); lstRoleProg.Add(roleProg); } // always call Close when done reading. OraDataReader.Instance.Close(); } } catch (Exception ex) { lstRoleProg = null; } return(UtilityBLL.ListToDataTable(lstRoleProg, "M_ROLE_PROGRAM")); }
private DataTable GetPrintMachineOrder(int seqNo, string tableName) { List <Machine> lstMachine = null; Machine mc; try { ProcParam param = new ProcParam(2); param.ProcedureName = "MASTER_PACK.RPT_M_MACHINE_LIST"; 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) { lstMachine = new List <Machine>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { mc = new Machine(); mc.MC_NO = OraDataReader.Instance.GetString("MC_NO"); mc.MACHINE_NAME = OraDataReader.Instance.GetString("MACHINE_NAME"); //mc.BARCODE = UtilityBLL.QRCode_Encode(mc.MC_NO); lstMachine.Add(mc); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstMachine = null; throw ex; } return(UtilityBLL.ListToDataTable(lstMachine, tableName)); }
public DataTable GetUserRoleByUserID(string userID) { List <UserRole> lstUserRole = null; try { ProcParam param = new ProcParam(2); param.ProcedureName = "ADMINISTRATOR_PACK.GET_USER_ROLE_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) { lstUserRole = new List <UserRole>(); UserRole userRole; OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { userRole = new UserRole(); userRole.ROLE_ID = OraDataReader.Instance.GetString("ROLE_ID"); userRole.ROLE_NAME = OraDataReader.Instance.GetString("ROLE_NAME"); userRole.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); userRole.FLAG = OraDataReader.Instance.GetInteger("FLAG"); lstUserRole.Add(userRole); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstUserRole = null; } return(UtilityBLL.ListToDataTable(lstUserRole, "M_ROLE_PROGRAM")); }
private DataTable GetPrintMaterialCard(int seqNo, string tableName) { List <MaterialCard> lstMCard = null; MaterialCard mCard; try { ProcParam param = new ProcParam(2) { ProcedureName = "MTL_IN_PACK.RPT_MATERIAL_CARD_LABEL" }; 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) { lstMCard = new List <MaterialCard>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { mCard = new MaterialCard(); mCard.ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO"); mCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO"); mCard.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO"); mCard.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE"); mCard.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME"); mCard.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE"); mCard.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR"); mCard.LOCATION_NAME = OraDataReader.Instance.GetString("LOCATION_NAME"); mCard.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME"); if (!OraDataReader.Instance.IsDBNull("LOT_DATE")) { mCard.LOT_DATE = OraDataReader.Instance.GetDateTime("LOT_DATE"); } mCard.QTY = OraDataReader.Instance.GetDecimal("QTY"); mCard.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID"); mCard.NO_OF_LABEL = OraDataReader.Instance.GetString("NO_OF_LABEL"); mCard.MIN_QTY = OraDataReader.Instance.GetDecimal("MIN_QTY"); mCard.MAX_QTY = OraDataReader.Instance.GetDecimal("MAX_QTY"); //prdCard.BARCODE = UtilityBLL.QRCode_Encode(prdCard.SERIAL_NO); //prdCard.BARCODE = OraDataReader.Instance.GetBitmap("BARCODE"); //prdCard.BARCODE.Save(string.Format("C:\\Temp\\PicTemp2D\\{0}.BMP", prdCard.SERIAL_NO)); mCard.MTL_IMAGE = OraDataReader.Instance.GetBitmap("MTL_IMAGE"); lstMCard.Add(mCard); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstMCard = null; throw ex; } //return this.ListToDataTable(lstPrdCard, tableName); //DataTable dt = UtilityBLL.ListToDataTable(lstPrdCard, tableName); return(UtilityBLL.ListToDataTable(lstMCard, tableName)); }
public DataTable PrintTO(int seqNo, string tableName) { List <TransferOrderRpt> lstTO = null; TransferOrderRpt TOrpt; try { ProcParam param = new ProcParam(2) { ProcedureName = "TO_PACK.RPT_TRANSFER_ORDER" }; 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) { lstTO = new List <TransferOrderRpt>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { TOrpt = new TransferOrderRpt(); TOrpt.TO_NO = OraDataReader.Instance.GetString("TO_NO"); TOrpt.PRODUCT_TYPE = OraDataReader.Instance.GetString("PRODUCT_TYPE"); TOrpt.TO_DATE = OraDataReader.Instance.GetDateTime("TO_DATE"); TOrpt.REF_NO = OraDataReader.Instance.GetString("REF_NO"); TOrpt.DESTINATION = OraDataReader.Instance.GetString("DESTINATION"); TOrpt.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE"); TOrpt.HDR_REMARK = OraDataReader.Instance.GetString("HDR_REMARK"); TOrpt.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO"); TOrpt.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME"); TOrpt.QTY = OraDataReader.Instance.GetInteger("QTY"); TOrpt.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID"); TOrpt.QTY_PER_BOX = OraDataReader.Instance.GetInteger("QTY_PER_BOX"); TOrpt.NO_OF_BOX = OraDataReader.Instance.GetInteger("NO_OF_BOX"); //TOrpt.BARCODE = UtilityBLL.QRCode_Encode(TOrpt.TO_NO); TOrpt.DTL_REMARK = OraDataReader.Instance.GetString("DTL_REMARK"); lstTO.Add(TOrpt); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstTO = null; throw ex; } return(UtilityBLL.ListToDataTable(lstTO, tableName)); }