public string DeleteSource(Structure.Source data)
{
try
{
OracleDB dbObj = new OracleDB("RFID_DB");
string sqlString = @"
delete from rf_sourcemanagement t
where t.id='{0}'";
sqlString = String.Format(sqlString, data.ID);
dbObj.ExcuteNoQuery(sqlString);
return("OK");
}
catch (Exception e)
{
return("NG");
}
}
public string ModifySource(Structure.Source data)
{
try
{
OracleDB dbObj = new OracleDB("RFID_DB");
string sqlString = @"delete from rf_sourcemanagement t
where t.id='{0}' ";
sqlString = string.Format(sqlString, data.ID);
dbObj.ExcuteNoQuery(sqlString);
sqlString = @"insert into rf_sourcemanagement t (t.id,t.name) values('{0}','{1}')";
sqlString = string.Format(sqlString, data.ID, data.NAME);
dbObj.ExcuteNoQuery(sqlString);
return("OK");
}
catch (Exception e)
{
return("NG");
}
}
