public string UpdateRole(Role role, string userid) { string result = string.Empty; try { ProcParam param = new ProcParam(5); param.ProcedureName = "ADMINISTRATOR_PACK.ROLE_UPD"; param.AddParamInput(0, "strROLE_ID", role.ROLE_ID); param.AddParamInput(1, "strROLE_NAME", role.ROLE_NAME); param.AddParamInput(2, "strREC_STAT", (role.REC_STAT ? "Y" : "N")); param.AddParamInput(3, "strUSER_ID", userid); param.AddParamOutput(4, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK"); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)param.ReturnValue(4); if (!resultDB.IsNull) { result = resultDB.Value; } else { throw GlobalDB.Instance.DataAc.LastException; } } catch (Exception ex) { throw ex; } return(result); }
public List <JobLot> GetJobLotList(string jobNo, string userid) { List <JobLot> lstJobLot = null; JobLot jobLot; try { ProcParam procPara = new ProcParam(3); procPara.ProcedureName = "SCANNER_PACK.GET_JOB_LOT_LIST"; procPara.AddParamRefCursor(0, "io_cursor"); procPara.AddParamInput(1, "strJobNo", jobNo); procPara.AddParamInput(2, "strUserID", userid); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara); this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.OraReader.HasRows) { lstJobLot = new List <JobLot>(); while (OraDataReader.Instance.OraReader.Read()) { jobLot = new JobLot(); jobLot.JOB_LOT = OraDataReader.Instance.GetString("JOB_LOT"); lstJobLot.Add(jobLot); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { throw ex; } return(lstJobLot); }
public string Press_UpdateReplenishConfirm(string serialNo, string mode, int qty, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(5) { ProcedureName = "SCANNER_PACK_PRESS.UPD_QC_NG_CONF" }; procPara.AddParamInput(0, "strSERIAL_NO", serialNo); procPara.AddParamInput(1, "strMODE", mode); procPara.AddParamInput(2, "strQTY", qty); procPara.AddParamInput(3, "strUserID", userid); procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(4); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string Assembly_UpdateNGQty(string jobNo, int lineNo, int nQty, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(5) { ProcedureName = "SCANNER_PACK_ASY.UPD_JOB_LOT_NG_QTY" }; procPara.AddParamInput(0, "strJOB_NO", jobNo); procPara.AddParamInput(1, "strLINE_NO", lineNo); procPara.AddParamInput(2, "strQTY", nQty); procPara.AddParamInput(3, "strUSER_ID", userid); procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(4); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string Assembly_CheckValidationUser(string userid) { string result = string.Empty; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_PACK_ASY.USER_VALIDATION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255); procPara.AddParamInput(1, "strUSER_ID", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; //OracleString objResult = (OracleString)procPara.ReturnValue(0); OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0); if (!objResult.IsNull) { result = UtilityBLL.GetReturnRawData(objResult); } else { result = string.Empty; } } catch (Exception ex) { throw ex; } return(result); }
public string UpdateStatusPlanHDR(string planNo, string status, string userId) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(4) { ProcedureName = "UPLOAD_PLAN.UPDATE_ULPLAN_STATUS" }; param.AddParamInput(0, "strPLAN_NO", planNo); param.AddParamInput(1, "strREC_STAT", status); param.AddParamInput(2, "strU_USER_ID", userId); param.AddParamOutput(3, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } OracleString result = (OracleString)param.ReturnValue(3); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string UpdProductCard(string serialNo, string mcNo, string processMode, int nQty, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(6); procPara.ProcedureName = "SCANNER_PACK_VER.UPD_PC_INFO_PROCESS"; procPara.AddParamInput(0, "strSERIAL_NO", serialNo); procPara.AddParamInput(1, "strPROCESS", processMode); procPara.AddParamInput(2, "strMC_NO", mcNo); procPara.AddParamInput(3, "strQty", nQty); procPara.AddParamOutput(4, "resultmsg", OracleDbType.Varchar2, 255); procPara.AddParamInput(5, "strUser_id", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(4); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
/// <summary> /// Update Machine /// </summary> /// <param name="mc">Machine Entity</param> /// <returns>Result Message</returns> public string UpdateMachine(Machine mc, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(8); param.ProcedureName = "MASTER_PACK.M_MACHINE_UPD"; param.AddParamInput(0, "strMC_NO", mc.MC_NO); param.AddParamInput(1, "strMACHINE_NAME", mc.MACHINE_NAME); param.AddParamInput(2, "strMACHINE_TYPE", mc.MACHINE_TYPE); param.AddParamInput(3, "strMACHINE_SIZE", mc.MACHINE_SIZE); param.AddParamInput(4, "strREMARK", mc.REMARK); param.AddParamInput(5, "strREC_STAT", (mc.REC_STAT ? "Y" : "N")); param.AddParamInput(6, "strUSER_ID", userid); param.AddParamOutput(7, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)param.ReturnValue(7); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string CheckValidationUser(string userid, string ipaddress, string serialno, string scanversion) { string result = string.Empty; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_MAT_CHK_PACK.USER_VALIDATION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255); procPara.AddParamInput(1, "strUSER_ID", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0); if (!objResult.IsNull) { result = UtilityBLL.GetReturnRawData(objResult); } else { result = string.Empty; } } catch (Exception ex) { throw ex; } return(result); }
private Bitmap ProductImage(string proSeqNo) { Bitmap result = null; try { ProcParam param = new ProcParam(2) { ProcedureName = "INFO.MATERIAL_IMAGE" }; param.AddParamReturn(0, "ReturnValue", OracleDbType.Blob, 255); param.AddParamInput(1, "strNo", proSeqNo); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleBlob blobDB = (OracleBlob)param.ReturnValue(0); if (!blobDB.IsNull) { using (MemoryStream ms = new MemoryStream(blobDB.Value)) { result = (Bitmap)Bitmap.FromStream(ms); } return(result); } else { return(null); } } catch (Exception ex) { throw ex; } }
public DataTable GetProductList(string partyid) { DataTable dtbResult; try { ProcParam param = new ProcParam(2) { ProcedureName = "MASTER_PACK.GET_PRATY_PRODUCT_LIST" }; param.AddParamRefCursor(0, "IO_CURSOR"); param.AddParamInput(1, "strPARTY_ID", partyid); dtbResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); } catch (Exception ex) { dtbResult = null; } return(dtbResult); }
public DataTable Doc_SalesOrder_List() { DataTable dtResult = null; try { ProcParam param = new ProcParam(1) { ProcedureName = "QUERY_PACK.DOC_SO_INFO" }; param.AddParamRefCursor(0, "IO_CURSOR"); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public DataTable GetPrintTime(int seq) { DataTable dtResult = null; try { ProcParam param = new ProcParam(2) { ProcedureName = "MTL_IN_PACK.GET_PRINTED_CARD" }; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strSEQ_NO", seq); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public DataTable PostSalesInvoiceInterface(string soNo, string userid, out string seqno) { seqno = string.Empty; DataTable dtResult = null; try { ProcParam param = new ProcParam(4) { ProcedureName = "INTERFACE_PACK.POST_SALES_INVOICE_SAGE50" }; param.AddParamRefCursor(0, "IO_CURSOR"); param.AddParamOutput(1, "strSEQ_NO", OracleDbType.Varchar2, 30); param.AddParamInput(2, "strSO_NO", soNo); param.AddParamInput(3, "strUSER_ID", userid); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); OracleString resultDB = (OracleString)param.ReturnValue(1); if (!resultDB.IsNull) { seqno = resultDB.Value; } else { seqno = string.Empty; } } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public string GenerateJob(string planNo, string userId) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(3) { ProcedureName = "UPLOAD_PLAN.GENERATE_JOB" }; param.AddParamInput(0, "strPLAN_NO", planNo); param.AddParamInput(1, "strUSER_ID", userId); param.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } OracleString result = (OracleString)param.ReturnValue(2); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public ResponseResult CheckJobOrder(string jobno) { response = new ResponseResult(); try { ProcParam procPara = new ProcParam(3) { ProcedureName = "SCANNER_MAT_CHK_PACK.CHK_JOB_ORDER" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Varchar2, 30); procPara.AddParamInput(1, "strJOB_NO", jobno); procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } var returnValue = (OracleString)procPara.ReturnValue(0); var resultMsg = (OracleString)procPara.ReturnValue(2); response.Message = resultMsg.ToString(); response.Data = returnValue.ToString(); } catch (Exception ex) { response.Status = false; response.Message = ex.Message; response.Data = string.Empty; } return(response); }
public string UpdatePalletFinish(string palletno, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(3) { ProcedureName = "SCANNER_PACK_FG.UPD_PALLET_FINISHED" }; procPara.AddParamInput(0, "strPALLET_NO", palletno); procPara.AddParamOutput(1, "RESULTMSG", OracleDbType.Varchar2, 255); procPara.AddParamInput(2, "strUSER_ID", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(1); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string UpdNGQty(string jobNo, string jobLot, int nQty, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(5); procPara.ProcedureName = "SCANNER_PACK.UPD_NG_QTY"; procPara.AddParamInput(0, "strJobNo", jobNo); procPara.AddParamInput(1, "strJobLot", jobLot); procPara.AddParamInput(2, "strQty", nQty); procPara.AddParamInput(3, "strUserID", userid); procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 120); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(4); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string FGPress_UpdateLoadingSeal(string loadNo, string userid) { string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(3) { ProcedureName = "SCANNER_PACK_FG_PRESS.UPD_LOADING_SEAL" }; procPara.AddParamInput(0, "strLOADING_NO", loadNo); procPara.AddParamOutput(1, "resultmsg", OracleDbType.Varchar2, 255); procPara.AddParamInput(2, "strUser_id", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)procPara.ReturnValue(1); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string DeleteTransferOrder(String tono, string userid) { string resultMsg = string.Empty; try { #region "Transaction Header" ProcParam paramHDR = new ProcParam(3); paramHDR.ProcedureName = "TO_PACK.TO_HDR_DEL"; paramHDR.AddParamInput(0, "strTO_NO", tono); paramHDR.AddParamInput(1, "strUSER_ID", userid); paramHDR.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255); #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)paramHDR.ReturnValue(2); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public ResponseResult UpdateMixedQty(string serialno, string mixedno, decimal mixQty) { response = new ResponseResult(); try { ProcParam procPara = new ProcParam(4) { ProcedureName = "SCANNER_MAT_CHK_PACK.UPDATE_MIXED_QTY" }; procPara.AddParamInput(0, "strMIXED_NO", mixedno); procPara.AddParamInput(1, "strSERIAL_NO", serialno); procPara.AddParamInput(2, "strMIXED_QTY", mixQty); procPara.AddParamOutput(3, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } var resultMsg = (OracleString)procPara.ReturnValue(3); response.Message = resultMsg.ToString(); response.Data = string.Empty; } catch (Exception ex) { response.Status = false; response.Message = ex.Message; response.Data = string.Empty; } return(response); }
public DataTable GetCompletedTO(string tono, string userid) { DataTable dtResult = null; try { ProcParam param = new ProcParam(3) { ProcedureName = "TO_PACK.GET_TO_CSV" }; param.AddParamRefCursor(0, "IO_CURSOR"); param.AddParamInput(1, "strTO_NO", tono); param.AddParamInput(2, "strUSER_ID", userid); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public string UserChangePassword(string password, string userid) { string result = string.Empty; try { ProcParam param = new ProcParam(3); param.ProcedureName = "ADMINISTRATOR_PACK.USER_CHANGE_PASSWORD"; param.AddParamInput(0, "strUSER_ID", userid); param.AddParamInput(1, "strNewPwd", password); param.AddParamOutput(2, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK"); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)param.ReturnValue(2); if (!resultDB.IsNull) { result = resultDB.Value; } else { throw GlobalDB.Instance.DataAc.LastException; } } catch (Exception ex) { throw ex; } return(result); }
public DataTable PrintTableResult(string procedureName, string printNo, string tableName) { DataTable dtResult = null; try { ProcParam param = new ProcParam(2); param.ProcedureName = procedureName; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strNo", printNo); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, tableName, 1000); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public DataTable StockAsOnDateDetail_Mtl(string mtl_code) { DataTable dtResult = null; try { ProcParam param = new ProcParam(2) { ProcedureName = "QUERY_PACK.STOCK_AS_ON_DATE_MTL_DTL" }; param.AddParamRefCursor(0, "IO_CURSOR"); param.AddParamInput(1, "strMTL", mtl_code); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public string InsertMTLType(MaterialType mtlType, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(6); param.ProcedureName = "MASTER_PACK.M_MTL_TYPE_INS"; param.AddParamInput(0, "strSEQ_NO", mtlType.SEQ_NO); param.AddParamInput(1, "strNAME", mtlType.NAME); param.AddParamInput(2, "strREMARK", mtlType.REMARK); param.AddParamInput(3, "strREC_STAT", (mtlType.REC_STAT ? "Y" : "N")); param.AddParamInput(4, "strUSER_ID", userid); param.AddParamOutput(5, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)param.ReturnValue(5); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public DataTable JobTrackingDetail(string jobNo, string jobLot) { DataTable dtResult = null; try { ProcParam param = new ProcParam(3); param.ProcedureName = "QUERY_PACK.JOB_TRACKING_DTL"; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strJOB_NO", jobNo); param.AddParamInput(2, "strJOB_LOT", jobLot); 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 product) { DataTable dtResult = null; try { ProcParam param = new ProcParam(3); param.ProcedureName = "QUERY_PACK.STOCK_AS_ON"; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strWH_ID", whid); param.AddParamInput(2, "strPRODUCT", product); dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; } catch (Exception ex) { dtResult = null; throw ex; } return(dtResult); }
public DataSet PrintProductCardReport(List <T_ARRIVAL_DTL> jobOrdNo, string prodSEQNo, List <MaterialCard> lstPrdCard, string userid, out int seqPrint) { //declare dataset and name. string processSEQ = string.Empty; //Bitmap imgProduct = null; seqPrint = -1; DataSet dtsResult = new DataSet("DTS_MATERIAL_CARD"); //int seqPrint = 0; try { // processSEQ = this.ProductProcessSEQ(prodSEQNo); //imgProduct = this.ProductImage(prodSEQNo); seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ(); List <ProcParam> procInsTPrintList = new List <ProcParam>(); ProcParam procInsTPrint = null; foreach (MaterialCard prdCard in lstPrdCard) { procInsTPrint = new ProcParam(4); procInsTPrint.ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS"; procInsTPrint.AddParamInput(0, "strSEQ_NO", seqPrint); procInsTPrint.AddParamInput(1, "strTR1", prdCard.SERIAL_NO); procInsTPrint.AddParamInput(2, "strTR2", DBNull.Value); procInsTPrint.AddParamInput(3, "strTR3", DBNull.Value); procInsTPrintList.Add(procInsTPrint); } //insert value to print transaction. PrintingBuilder.Instance.InsertTransactionPrint(procInsTPrintList); //get print value header DataTable dtHeader = new DataTable("T_ARRIVAL"); dtHeader.Columns.Add(new DataColumn("ARRIVAL_NO")); //dtHeader.Columns.Add(new DataColumn("PROD_IMAGE", typeof(System.Drawing.Bitmap))); //dtHeader.Columns.Add(new DataColumn("PROCESS_SEQ")); DataRow row = dtHeader.NewRow(); foreach (T_ARRIVAL_DTL labelOpt in jobOrdNo) { row["ARRIVAL_NO"] = labelOpt.ARRIVAL_NO; } //row["PROD_IMAGE"] = imgProduct; //row["PROCESS_SEQ"] = processSEQ; //dtHeader.Rows.Add(row); dtHeader.Rows.Add(row); dtHeader.AcceptChanges(); dtsResult.Tables.Add(dtHeader); DataTable dtDetail = this.GetPrintMaterialCard(seqPrint, "T_MATERIAL_CARD"); //dtDetail.Columns.Add(new DataColumn("PROD_IMAGE", typeof(System.Drawing.Bitmap))); //DataRow rowDT = dtDetail.NewRow(); //foreach ( MaterialCard labelOpt in lstPrdCard) //{ // imgProduct = this.ProductImage(labelOpt.MTL_SEQ_NO); // rowDT["PROD_IMAGE"] = imgProduct; // //dtDetail.Rows.Add(rowDT); //} //foreach (DataRow dtRow in dtDetail.Rows) //{ // imgProduct = this.ProductImage((string)dtRow["MTL_SEQ_NO"]); // dtRow["PROD_IMAGE"] = imgProduct; //} dtsResult.Tables.Add(dtDetail); //maping datatable to dataset dtsResult.Relations.Add("T_ARRIVAL_T_MATERIAL_CARD", dtsResult.Tables["T_ARRIVAL"].Columns["ARRIVAL_NO"], dtsResult.Tables["T_MATERIAL_CARD"].Columns["ARRIVAL_NO"], false); dtsResult.AcceptChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } return(dtsResult); }
public List <Material> GetMaterialList(string findAll, string mtl_seq_no, string supplier, string locId) { List <Material> lstMaterail = null; Material material; ProcParam param = null; try { //if (findAll != string.Empty) //{ param = new ProcParam(5) { ProcedureName = "LOV_PACK.GET_MATERIAL_LIST" }; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strFindAll", findAll); param.AddParamInput(2, "strMTL_SEQ_NO", mtl_seq_no); param.AddParamInput(3, "strPARTY_ID", supplier); param.AddParamInput(4, "strLOCATION_ID", locId); //} //else //{ // param = new ProcParam(1) { ProcedureName = "LOV_PACK.GET_MATERIAL_ALL_LIST" }; // param.AddParamRefCursor(0, "io_cursor"); //} OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.OraReader.HasRows) { lstMaterail = new List <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"); lstMaterail.Add(material); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstMaterail = null; throw ex; } return(lstMaterail); }