/*更新在用設備資訊*/
public static bool UpdateUsingDevice(UsingDeviceModel usingDevice)
{
string updateString = "update [t_device_using] set typeId=";
updateString += usingDevice.getTypeId() + ",deviceName=";
updateString += SqlString.GetQuotedString(usingDevice.getDeviceName()) + ",deviceModel=";
updateString += SqlString.GetQuotedString(usingDevice.getDeviceModel()) + ",deviceFrom=";
updateString += SqlString.GetQuotedString(usingDevice.getDeviceFrom()) + ",manufacturer=";
updateString += SqlString.GetQuotedString(usingDevice.getManufacturer()) + ",useDate=";
updateString += SqlString.GetQuotedString(usingDevice.getUseDate().ToString()) + ",deviceLife=";
updateString += usingDevice.getDeviceLife() + ",usePlace=";
updateString += SqlString.GetQuotedString(usingDevice.getUsePlace()) + ",deviceCount=";
updateString += usingDevice.getDeviceCount() + ",deviceState=";
updateString += SqlString.GetQuotedString(usingDevice.getDeviceState());
updateString += " where id=" + usingDevice.getId();
DataBase db = new DataBase();
if (db.InsertOrUpdate(updateString) < 0)
{
return(false);
}
return(true);
}
