예제 #1
0
        /*更新報廢設備資訊*/

        public static bool UpdateUselessDevice(UselessDeviceModel uselessDevice)
        {
            string updateString = "update [t_device_useless] set typeId=";

            updateString += uselessDevice.getTypeId() + ",deviceName=";
            updateString += SqlString.GetQuotedString(uselessDevice.getDeviceName()) + ",deviceModel=";
            updateString += SqlString.GetQuotedString(uselessDevice.getDeviceModel()) + ",deviceFrom=";
            updateString += SqlString.GetQuotedString(uselessDevice.getDeviceFrom()) + ",deviceCount=";
            updateString += uselessDevice.getDeviceCount() + " where id=" + uselessDevice.getId();

            DataBase db = new DataBase();

            if (db.InsertOrUpdate(updateString) > 0)
            {
                return(true);
            }
            return(true);
        }