public R_WO_HEADER GetDetailByWo(OleExec db, string wo) { DataTable dt = null; R_WO_HEADER wo_header = null; if (DBType == DB_TYPE_ENUM.Oracle) { string sql = $@"select * from {TableName} where aufnr='{wo}' "; try { dt = db.ExecSelect(sql).Tables[0]; if (dt.Rows.Count > 0) { Row_R_WO_HEADER row_header = (Row_R_WO_HEADER)NewRow(); row_header.loadData(dt.Rows[0]); wo_header = row_header.GetDataObject(); } return(wo_header); } catch (Exception ex) { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message })); } } else { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { this.DBType.ToString() })); } }
public R_WO_HEADER GetDataObject() { R_WO_HEADER DataObject = new R_WO_HEADER(); DataObject.ID = this.ID; DataObject.AUFNR = this.AUFNR; DataObject.WERKS = this.WERKS; DataObject.AUART = this.AUART; DataObject.MATNR = this.MATNR; DataObject.REVLV = this.REVLV; DataObject.KDAUF = this.KDAUF; DataObject.GSTRS = this.GSTRS; DataObject.GAMNG = this.GAMNG; DataObject.KDMAT = this.KDMAT; DataObject.AEDAT = this.AEDAT; DataObject.AENAM = this.AENAM; DataObject.MATKL = this.MATKL; DataObject.MAKTX = this.MAKTX; DataObject.ERDAT = this.ERDAT; DataObject.GSUPS = this.GSUPS; DataObject.ERFZEIT = this.ERFZEIT; DataObject.GLTRS = this.GLTRS; DataObject.GLUPS = this.GLUPS; DataObject.LGORT = this.LGORT; DataObject.ABLAD = this.ABLAD; DataObject.ROHS_VALUE = this.ROHS_VALUE; DataObject.FTRMI = this.FTRMI; DataObject.MVGR3 = this.MVGR3; DataObject.WEMNG = this.WEMNG; DataObject.BISMT = this.BISMT; DataObject.CHARG = this.CHARG; DataObject.SAENR = this.SAENR; DataObject.AETXT = this.AETXT; DataObject.GLTRP = this.GLTRP; return(DataObject); }