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);
}