public void UpdateAntSetting(Structure.AntSetting each)
{
try
{
List <string> AreaList = new List <string>();
OracleDB dbObj = new OracleDB("RFID_DB");
string sqlString = @"select * from rf_rfattenuation t where t.readerip = '" + each.ReaderIP + "' and t.antnumber ='" + each.AntNumber + "'";
DataTable result = dbObj.SelectSQL(sqlString);
if (result.Rows.Count > 0)
{
sqlString = "update rf_rfattenuation t set t.rfattenuation='" + each.Value + "',t.updatetime=sysdate where t.readerip = '" + each.ReaderIP + "' and t.antnumber ='" + each.AntNumber + "'";
dbObj.ExcuteNoQuery(sqlString);
}
else
{
sqlString = "insert into rf_rfattenuation t (t.readerip,t.antnumber,t.rfattenuation,t.updatetime) values('" + each.ReaderIP + "','" + each.AntNumber + "','" + each.Value + "',sysdate)";
dbObj.ExcuteNoQuery(sqlString);
}
}
catch (Exception e)
{
throw e;
}
}
public List <Structure.AntSetting> GetAntSetting(string Fab, string Area)
{
try
{
List <Structure.AntSetting> AntSettingList = new List <Structure.AntSetting>();
OracleDB dbObj = new OracleDB("RFID_DB");
string sqlString = @"select t.fab, t.area, t.gate, t.type, t.readerip, t.antnumber,t1.rfattenuation,to_char(t1.updatetime,'yyyy/mm/dd hh24:mi:ss')updatetime
from rf_antmapping t, rf_rfattenuation t1
where t.readerip = t1.readerip(+)
and t.antnumber = t1.antnumber(+)
and t.antnumber <=3
and t.fab = '" + Fab + @"'
and t.area = '" + Area + @"'
order by t.readerip,t.antnumber";
DataTable result = dbObj.SelectSQL(sqlString);
foreach (DataRow eachRow in result.Rows)
{
Structure.AntSetting eachObj = new Structure.AntSetting();
eachObj.Fab = eachRow["FAB"].ToString();
eachObj.Area = eachRow["AREA"].ToString();
eachObj.Gate = eachRow["GATE"].ToString();
eachObj.Type = eachRow["Type"].ToString();
eachObj.Value = eachRow["rfattenuation"].ToString();
eachObj.AntNumber = eachRow["antnumber"].ToString();
eachObj.ReaderIP = eachRow["readerip"].ToString();
eachObj.UpdateTime = eachRow["updatetime"].ToString();
AntSettingList.Add(eachObj);
}
return(AntSettingList);
}
catch (Exception e)
{
throw e;
}
}
