/*取得某個報廢設備資訊*/

        public static UselessDeviceModel GetUselessDevice(int id)
        {
            UselessDeviceModel uselessDevice = null;
            string             queryString   = "select * from [t_device_useless] where id=" + id;
            DataBase           db            = new DataBase();
            DataSet            deviceDs      = db.GetDataSet(queryString);

            if (deviceDs.Tables[0].Rows.Count > 0)
            {
                uselessDevice = new UselessDeviceModel();
                DataRow dr = deviceDs.Tables[0].Rows[0];
                uselessDevice.setTypeId(Convert.ToInt32(dr["typeId"]));
                uselessDevice.setDeviceName(dr["deviceName"].ToString());
                uselessDevice.setDeviceModel(dr["deviceModel"].ToString());
                uselessDevice.setDeviceFrom(dr["deviceFrom"].ToString());
                uselessDevice.setDeviceCount(Convert.ToInt32(dr["deviceCount"]));
            }
            return(uselessDevice);
        }
        protected void Btn_Add_Click(object sender, EventArgs e)
        {
            UselessDeviceModel uselessDevice = new UselessDeviceModel();

            uselessDevice.setTypeId(Int32.Parse(this.TypeId.SelectedValue));
            uselessDevice.setDeviceName(this.DeviceName.Text);
            uselessDevice.setDeviceModel(this.DeviceModel.Text);
            uselessDevice.setDeviceFrom(this.DeviceFrom.Text);
            uselessDevice.setDeviceCount(Int32.Parse(this.DeviceCount.Text));

            if (UselessDeviceDAO.AddUselessDevice(uselessDevice))
            {
                Response.Write("<script>alert('報廢設備登記成功!');location.href='UselessDeviceAdd.aspx';</script>");
            }
            else
            {
                Response.Write("<script>alert('報廢設備登記失敗!');location.href='UselessDeviceAdd.aspx';</script>");
            }
        }
        protected void Btn_Update_Click(object sender, EventArgs e)
        {
            UselessDeviceModel uselessDevice = new UselessDeviceModel();
            int id = Int32.Parse(Request.QueryString["id"]);

            uselessDevice.setId(id);
            uselessDevice.setTypeId(Int32.Parse(this.TypeId.SelectedValue));
            uselessDevice.setDeviceName(this.DeviceName.Text);
            uselessDevice.setDeviceModel(this.DeviceModel.Text);
            uselessDevice.setDeviceFrom(this.DeviceFrom.Text);
            uselessDevice.setDeviceCount(Int32.Parse(this.DeviceCount.Text));

            if (UselessDeviceDAO.UpdateUselessDevice(uselessDevice))
            {
                Response.Write("<script>alert('更新成功!');location.href='UselessDeviceManage.aspx';</script>");
            }
            else
            {
                Response.Write("<script>alert('更新失败!');</script>");
            }
        }