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>");
}
}
