public c_station_action GetActionByID(string ID, OleExec DB) { string sql = string.Empty; DataTable dt = new DataTable(); c_station_action stationaction = new c_station_action(); sql = $@"SELECT * FROM C_Station_Action where ID='{ID}' AND ROWNUM=1 "; dt = DB.ExecSelect(sql).Tables[0]; foreach (DataRow dr in dt.Rows) { stationaction = CreatecstationactionClass(dr); } return(stationaction); }
public c_station_action GetDataObject() { c_station_action DataObject = new c_station_action(); DataObject.ID = this.ID; DataObject.ACTION_TYPE = this.ACTION_TYPE; DataObject.ACTION_NAME = this.ACTION_NAME; DataObject.DLL_NAME = this.DLL_NAME; DataObject.CLASS_NAME = this.CLASS_NAME; DataObject.FUNCTION_NAME = this.FUNCTION_NAME; DataObject.DESCRIPTION = this.DESCRIPTION; DataObject.EDIT_TIME = this.EDIT_TIME; DataObject.EDIT_EMP = this.EDIT_EMP; DataObject.BU = this.BU; DataObject.USE_STATION = this.USE_STATION; DataObject.SORTING = this.SORTING; return(DataObject); }