public C_TEMES_STATION_MAPPING GetDataObject() { C_TEMES_STATION_MAPPING DataObject = new C_TEMES_STATION_MAPPING(); DataObject.MES_STATION = this.MES_STATION; DataObject.TE_STATION = this.TE_STATION; DataObject.TEGROUP = this.TEGROUP; DataObject.ID = this.ID; return(DataObject); }
public C_TEMES_STATION_MAPPING GetTeMesStationMapping(OleExec DB, string TeStation, string TeGroup) { C_TEMES_STATION_MAPPING RES = new C_TEMES_STATION_MAPPING(); T_C_TEMES_STATION_MAPPING tabel = new T_C_TEMES_STATION_MAPPING(DB, DB_TYPE_ENUM.Oracle); Row_C_TEMES_STATION_MAPPING row = (Row_C_TEMES_STATION_MAPPING)tabel.NewRow(); string sql = $@" SELECT * FROM C_TEMES_STATION_MAPPING WHERE TEGROUP=:TEGROUP AND TE_STATION=:TE_STATION "; OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("TEGROUP", OleDbType.VarChar, 10), new OleDbParameter("TE_STATION", OleDbType.VarChar, 30), }; parameters[0].Value = TeGroup; parameters[1].Value = TeStation; DataTable dt = DB.ExecSelect(sql, parameters).Tables[0]; if (dt.Rows.Count > 0) { row.loadData(dt.Rows[0]); RES = row.GetDataObject(); } return(RES); }