//�����÷���Ϣ
protected void Modify_OnClick(object sender, EventArgs e)
{
LabMS.Model.Location location = new LabMS.Model.Location();
LabMS.BLL.Location loctioninfo = new LabMS.BLL.Location();
location.ID = int.Parse(ViewState["ID"].ToString());//ID
location.Location_Name = LocationNameTBX.Text;//�÷�����
if (LabDDL.SelectedValue != "0")
{
location.LabID = int.Parse(LabDDL.SelectedValue);// ����ʵ����
}
location.Location_Area = AreaTBX.Text.Trim();// ���
location.Location_Building = BuildingNameTBX.Text.Trim();// ¥����
location.Location_Campus = CampusTBX.Text.Trim();//��
location.Location_Floor = FloorTBX.Text.Trim();//¥��
location.Location_InCharge = ManagerTBX.Text.Trim();//������
location.Location_Name = BuildingNameTBX.Text.Trim();//¥����
location.Location_Phone = TelTBX.Text.Trim();//��ϵ�绰
location.Location_RoomNum = RoomNumTBX.Text.Trim();//�����
location.Location_State = StatusDDL.SelectedValue;//ʹ��״̬
location.Location_Summary = SummaryTBX.Text.Trim();//��ע
location.Location_Usage = UsageTBX.Text.Trim();//��;
if (StudentNumTBX.Text.Trim() != "")
{
int i;
if (int.TryParse(StudentNumTBX.Text.Trim(), out i))
{
location.Location_StudentNum = i;//����ѧ����
}
else
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "", "<script type='text/javascript'>alert('ѧ��������Ϊ����!')</script>");
return;
}
}
loctioninfo.Update(location);//����һ������Ϣ
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('�����÷���Ϣ�ɹ���');refreshParent();this.window.close();</script>");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.Location GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,Location_Name,Location_Campus,Location_Building,Location_Floor,Location_RoomNum,LabID,Location_Usage,Location_StudentNum,Location_Area,Location_InCharge,Location_State,Location_Summary,Location_Phone from Location ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.Location model=new LabMS.Model.Location();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.Location_Name=ds.Tables[0].Rows[0]["Location_Name"].ToString();
model.Location_Campus=ds.Tables[0].Rows[0]["Location_Campus"].ToString();
model.Location_Building=ds.Tables[0].Rows[0]["Location_Building"].ToString();
model.Location_Floor=ds.Tables[0].Rows[0]["Location_Floor"].ToString();
model.Location_RoomNum=ds.Tables[0].Rows[0]["Location_RoomNum"].ToString();
if(ds.Tables[0].Rows[0]["LabID"].ToString()!="")
{
model.LabID=int.Parse(ds.Tables[0].Rows[0]["LabID"].ToString());
}
model.Location_Usage=ds.Tables[0].Rows[0]["Location_Usage"].ToString();
if(ds.Tables[0].Rows[0]["Location_StudentNum"].ToString()!="")
{
model.Location_StudentNum=int.Parse(ds.Tables[0].Rows[0]["Location_StudentNum"].ToString());
}
model.Location_Area=ds.Tables[0].Rows[0]["Location_Area"].ToString();
model.Location_InCharge=ds.Tables[0].Rows[0]["Location_InCharge"].ToString();
model.Location_State=ds.Tables[0].Rows[0]["Location_State"].ToString();
model.Location_Summary=ds.Tables[0].Rows[0]["Location_Summary"].ToString();
model.Location_Phone=ds.Tables[0].Rows[0]["Location_Phone"].ToString();
return model;
}
else
{
return null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
strPagePrivilege.Add("SYYF");
if (UserType == "student" || UserType == "teacher")
{
modifybtn.Visible = false;
DeleteBtn.Visible = false;
}
if (Request.QueryString["ID"] != null)
{
if (!IsPostBack)
{
int ID;
string strID = Request.QueryString["ID"].ToString();
if (int.TryParse(strID, out ID))
{
LabMS.BLL.Location location = new LabMS.BLL.Location();
LabMS.Model.Location Locationinfo = new LabMS.Model.Location();
List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>();
IDHF.Value = ID.ToString();//存储ID值
//获取用房信息 通过ID
Locationinfo = location.GetModel(ID);
LocationNameLbl.Text = Locationinfo.Location_Name;//名称
AreaLbl.Text = Locationinfo.Location_Area;//面积
BuildingNameLbl.Text = Locationinfo.Location_Building;//楼名称
CampusLbl.Text = Locationinfo.Location_Campus;//校区
FloorLbl.Text = Locationinfo.Location_Floor;//楼层
ManagerLbl.Text = Locationinfo.Location_InCharge;//负责人
BuildingNameLbl.Text = Locationinfo.Location_Name;//楼名称
TelLbl.Text = Locationinfo.Location_Phone;//联系电话
RoomNumLbl.Text = Locationinfo.Location_RoomNum;//房间号
SummaryLbl.Text = Locationinfo.Location_Summary.Replace("\r\n", "<br/>");//备注
UsageLbl.Text = Locationinfo.Location_Usage;//用途
StudentNumLbl.Text = Locationinfo.Location_StudentNum.ToString();//容纳学生数
//绑定使用状态
list = DictionaryDropdownlist("117");
StatusDDL.DataSource = list;
StatusDDL.DataBind();
//绑定实验室名
LabDropdowlist();
LabDDL.SelectedValue = Locationinfo.LabID.ToString();
}
else
{
ERRLbl.Text = "系统异常，ID值不合法！";
ERRLbl.Visible = true;
modifybtn.Visible = false;
DeleteBtn.Visible = false;
}
}
}
else
{
ERRLbl.Text = "系统异常，ID值不合法！";
ERRLbl.Visible = true;
modifybtn.Visible = false;
DeleteBtn.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
strPagePrivilege.Add("SYYF");
strPageUserType.Add("mana");
if (Request.QueryString["ID"] == null)
{
if (!IsPostBack)
{
List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>();
//����ʹ��״̬
list = DictionaryDropdownlist("117");
StatusDDL.DataSource = list;
StatusDDL.DataBind();
//������ʵ����
LabDropdowlist();
}
}
else
{
if (!IsPostBack)
{
int ID;
string strID = Request.QueryString["ID"].ToString();
if (int.TryParse(strID, out ID))
{
SaveBtn.Visible = false;
ModifyBtn.Visible = true;
label1.Visible = false;
label2.Visible = true;
LabMS.BLL.Location location = new LabMS.BLL.Location();
LabMS.Model.Location Locationinfo = new LabMS.Model.Location();
List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>();
ViewState["ID"] = ID;//�洢IDֵ
//��ȡ�÷���Ϣ ͨ��ID
Locationinfo = location.GetModel(ID);
LocationNameTBX.Text = Locationinfo.Location_Name;//����
AreaTBX.Text = Locationinfo.Location_Area;//���
BuildingNameTBX.Text = Locationinfo.Location_Building;//¥����
CampusTBX.Text = Locationinfo.Location_Campus;//��
FloorTBX.Text = Locationinfo.Location_Floor;//¥��
ManagerTBX.Text = Locationinfo.Location_InCharge;//������
BuildingNameTBX.Text = Locationinfo.Location_Name;//¥����
TelTBX.Text = Locationinfo.Location_Phone;//��ϵ�绰
RoomNumTBX.Text = Locationinfo.Location_RoomNum;//�����
SummaryTBX.Text = Locationinfo.Location_Summary;//��ע
UsageTBX.Text = Locationinfo.Location_Usage;//��;
StudentNumTBX.Text = Locationinfo.Location_StudentNum.ToString();//����ѧ����
//��ʹ��״̬
list = DictionaryDropdownlist("117");
StatusDDL.DataSource = list;
StatusDDL.DataBind();
//��ʵ������
LabDropdowlist();
LabDDL.SelectedValue = Locationinfo.LabID.ToString();
}
else
{
SaveBtn.Visible = false;
ERRLbl.Text = "ϵͳ�쳣��IDֵ���Ϸ���";
ERRLbl.Visible = true;
}
}
}
}
