/*更新在用設備資訊*/ 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); }