protected void Btn_Update_Click(object sender, EventArgs e) { UsingDeviceModel usingDevice = new UsingDeviceModel(); int id = Int32.Parse(Request.QueryString["id"]); usingDevice.setId(id); usingDevice.setTypeId(Int32.Parse(this.TypeId.SelectedValue)); usingDevice.setDeviceName(this.DeviceName.Text); usingDevice.setDeviceModel(this.DeviceModel.Text); usingDevice.setDeviceFrom(this.DeviceFrom.Text); usingDevice.setManufacturer(this.Manufacturer.Text); usingDevice.setUseDate(Convert.ToDateTime(this.UseDate.Text)); usingDevice.setDeviceLife(Int32.Parse(this.DeviceLife.Text)); usingDevice.setUsePlace(this.UsePlace.SelectedValue); usingDevice.setDeviceCount(Int32.Parse(this.DeviceCount.Text)); usingDevice.setDeviceState(this.DeviceState.Text); if (UsingDeviceDAO.UpdateUsingDevice(usingDevice)) { Response.Write("<script>alert('更新成功!');location.href='UsingDeviceManage.aspx';</script>"); } else { Response.Write("<script>alert('更新失敗!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Write("<script>alert('請先登入系統!');top.location.href='login.aspx';</script>"); return; } if (!IsPostBack) { DataSet deviceTypeDs = DeviceTypeDAO.QueryAllDeviceType(); for (int i = 0; i < deviceTypeDs.Tables[0].Rows.Count; i++) { DataRow dr = deviceTypeDs.Tables[0].Rows[i]; ListItem li = new ListItem(dr["typeName"].ToString(), dr["typeId"].ToString()); this.TypeId.Items.Add(li); } DataSet placeDs = PlaceDAO.QueryAllPlace(); this.UsePlace.DataSource = placeDs; this.UsePlace.DataBind(); int id = Int32.Parse(Request.QueryString["id"]); UsingDeviceModel usingDevice = UsingDeviceDAO.GetUsingDevice(id); this.TypeId.SelectedValue = usingDevice.getTypeId().ToString(); this.DeviceName.Text = usingDevice.getDeviceName().ToString(); this.DeviceModel.Text = usingDevice.getDeviceModel().ToString(); this.DeviceFrom.Text = usingDevice.getDeviceFrom().ToString(); this.Manufacturer.Text = usingDevice.getManufacturer().ToString(); this.UseDate.Text = usingDevice.getUseDate().ToShortDateString(); this.DeviceLife.Text = usingDevice.getDeviceLife().ToString(); this.UsePlace.SelectedValue = usingDevice.getUsePlace().ToString(); this.DeviceCount.Text = usingDevice.getDeviceCount().ToString(); this.DeviceState.Text = usingDevice.getDeviceState().ToString(); } }
/*添加在用設備資訊*/ public static bool AddUsingDevice(UsingDeviceModel usingDevice) { string insertString = "insert into [t_device_using] (typeId,deviceName,deviceModel,deviceFrom,manufacturer,useDate,deviceLife,usePlace,deviceCount,deviceState) values ("; insertString += usingDevice.getTypeId() + ","; insertString += SqlString.GetQuotedString(usingDevice.getDeviceName()) + ","; insertString += SqlString.GetQuotedString(usingDevice.getDeviceModel()) + ","; insertString += SqlString.GetQuotedString(usingDevice.getDeviceFrom()) + ","; insertString += SqlString.GetQuotedString(usingDevice.getManufacturer()) + ","; insertString += SqlString.GetQuotedString(usingDevice.getUseDate().ToString()) + ","; insertString += usingDevice.getDeviceLife() + ","; insertString += SqlString.GetQuotedString(usingDevice.getUsePlace()) + ","; insertString += usingDevice.getDeviceCount() + ","; insertString += SqlString.GetQuotedString(usingDevice.getDeviceState()) + ")"; DataBase db = new DataBase(); if (db.InsertOrUpdate(insertString) < 0) { return(false); } return(true); }
/*更新在用設備資訊*/ 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); }
/*取得某個在用設備資訊*/ public static UsingDeviceModel GetUsingDevice(int id) { UsingDeviceModel usingDevice = null; string queryString = "select * from [t_device_using] where id=" + id; DataBase db = new DataBase(); DataSet deviceDs = db.GetDataSet(queryString); if (deviceDs.Tables[0].Rows.Count > 0) { usingDevice = new UsingDeviceModel(); DataRow dr = deviceDs.Tables[0].Rows[0]; usingDevice.setTypeId(Convert.ToInt32(dr["typeId"])); usingDevice.setDeviceName(dr["deviceName"].ToString()); usingDevice.setDeviceModel(dr["deviceModel"].ToString()); usingDevice.setDeviceFrom(dr["deviceFrom"].ToString()); usingDevice.setManufacturer(dr["manufacturer"].ToString()); usingDevice.setUseDate(Convert.ToDateTime(dr["useDate"])); usingDevice.setDeviceLife(Convert.ToInt32(dr["deviceLife"])); usingDevice.setUsePlace(dr["usePlace"].ToString()); usingDevice.setDeviceCount(Convert.ToInt32(dr["deviceCount"])); usingDevice.setDeviceState(dr["deviceState"].ToString()); } return(usingDevice); }
protected void Btn_Add_Click(object sender, EventArgs e) { UsingDeviceModel usingDevice = new UsingDeviceModel(); usingDevice.setTypeId(Int32.Parse(this.TypeId.SelectedValue)); usingDevice.setDeviceName(this.DeviceName.Text); usingDevice.setDeviceModel(this.DeviceModel.Text); usingDevice.setDeviceFrom(this.DeviceFrom.Text); usingDevice.setManufacturer(this.Manufacturer.Text); usingDevice.setUseDate(Convert.ToDateTime(this.UseDate.Text)); usingDevice.setDeviceLife(Int32.Parse(this.deviceLife.Text)); usingDevice.setUsePlace(this.UsePlace.SelectedValue); usingDevice.setDeviceCount(Int32.Parse(this.DeviceCount.Text)); usingDevice.setDeviceState(this.DeviceState.Text); if (UsingDeviceDAO.AddUsingDevice(usingDevice)) { Response.Write("<script>alert('在用設備登記成功!');location.href='UsingDeviceAdd.aspx';</script>"); } else { Response.Write("<script>alert('在用設備登記失敗!');location.href='UsingDeviceAdd.aspx';</script>"); } }