/// <summary>
/// 初始化院别
/// </summary>
protected void initControls()
{
tbDid.Items.Add("全部");
tbDid.Items.AddRange(Yid.getYidItem());
tbBid.Items.Add("全部");
tbBid.Items.AddRange(Building.getItems(tbDid.SelectedValue));
}
/// <summary>
/// 初始化页面显示
/// </summary>
protected void initControls()
{
/// 获取宿舍楼
if (Request["rid"] == null)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('未设置rid!请从查看页面(点击宿舍楼管理根节点)访问本页面！')", true);
return;
}
/// 院信息初始化
tbDid.Items.AddRange(Yid.getYidItem());
/// 获取并显示宿舍信息
DataRow dt = Room.getOne(Request["rid"]);
if (dt == null || dt.IsNull(0))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('非法访问！')", true);
return;
}
tbDid.SelectedValue = lbDid.Text = dt["院名称"].ToString();
tbName.Text = lbName.Text = dt["宿舍名称"].ToString();
tbInfo.Text = dt["备注"].ToString();
lbBid.Text = dt["宿舍楼名称"].ToString();
/// 获取并显示宿舍楼信息
tbBid.Items.AddRange(Building.getItems()); // 添加到宿舍楼下拉选项
tbBid.Items.FindByText(dt["宿舍楼名称"].ToString()).Selected = true;
}
/// <summary>
/// 初始化院别
/// </summary>
protected void initYid()
{
tbDid.Items.Add("全部");
tbDid.Items.AddRange(Yid.getYidItem());
initBid(tbDid.SelectedValue); // 初始化楼信息
initR(0, ""); // 显示所有宿舍信息
}
/// <summary>
/// 初始化页面显示
/// </summary>
protected void initControls()
{
if (Request["did"] == null)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('未设置did!请从查看页面(点击院管理根节点)访问本页面！')", true);
return;
}
var dt = new DataTable();
OleDbCommand cmd = new OleDbCommand("SELECT top 1 * FROM T_Dormitory WHERE 院编号=@did;");
cmd.Parameters.AddWithValue("did", Request["did"].ToString());
//dt = SQL.ExecuteQuery(cmd);
dt = Yid.getYidDataTable(Request["did"]);
if (dt == null || dt.Rows.Count <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('非法访问！')", true);
return;
}
/// 显示
tbId.Text = dt.Rows[0][0].ToString();
tbName.Text = dt.Rows[0][1].ToString();
tbType.SelectedValue = dt.Rows[0][2].ToString();
tbInfo.Text = dt.Rows[0][3].ToString();
}
protected void initControls()
{
YidCount = Yid.Count();
YidCountF = Yid.Count(1);
YidCountM = Yid.Count(2);
BidCount = Building.Count();
BidCountF = Building.Count(2, 0);
BidCountM = Building.Count(2, 1);
RidCount = Room.Count();
RidCountF = Room.Count(4, 0);
RidCountM = Room.Count(4, 1);
}
/// <summary>
/// 初始化页面显示
/// </summary>
protected void initControls()
{
if (Request["did"] == null)
{
return;
}
var dt = new DataTable();
dt = Yid.getYidDataTable(Request["did"].ToString());
if (dt == null || dt.Rows.Count <= 0)
{
return;
}
/// 显示
tbId.Text = lbId.Text = dt.Rows[0][0].ToString();
tbName.Text = lbName.Text = dt.Rows[0][1].ToString();
tbType.SelectedValue = lbType.Text = dt.Rows[0][2].ToString();
tbInfo.Text = dt.Rows[0][3].ToString();
}
/// <summary>
/// 初始化页面显示
/// </summary>
protected void initControls()
{
if (Request["bid"] == null)
{
msgBox.Show(this, "未设置bid!请从查看页面(点击宿舍楼管理根节点)访问本页面！");
return;
}
tbDid.Items.AddRange(Yid.getYidItem());
DataRow dt = Building.getOne(Request["bid"]);
if (dt == null || (dt.IsNull(0)))
{
msgBox.Show(this, "非法访问！");
return;
}
/// 显示
tbDid.Text = lbDid.Text = dt["院名称"].ToString();
tbBid.Text = dt["宿舍楼编号"].ToString();
tbName.Text = lbName.Text = dt["宿舍楼名称"].ToString();
tbInfo.Text = dt["备注"].ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
/// 检测数据输入
if (tbId.Text.Length <= 0 || tbName.Text.Length <= 0 || Convert.ToInt32(tbId.Text) == 0)
{
//ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('院编号不能为0或为空，院名称不能为空')", true);
msgBox.Show(this, "院编号不能为0或为空，院名称不能为空");
return;
}
/*
* /// 创建cmd
* OleDbCommand cmd = new OleDbCommand("INSERT INTO T_Dormitory VALUES(@nid,@nname,@ntype,@info);");
* cmd.Parameters.AddWithValue("nid", tbId.Text.Trim());
* cmd.Parameters.AddWithValue("nname", tbName.Text.Trim());
* cmd.Parameters.AddWithValue("ntype",tbType.SelectedValue);
* cmd.Parameters.AddWithValue("info", info.Text);
* /// 插入数据库
* try
* {
* if (SQL.ExecuteNonQuery(cmd)>=1)
* {
* ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('添加成功！')", true);
* }
* }
* catch (Exception ex)
* {
* ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('添加失败！"+ex.Message+"')", true);
* }*/
if (Yid.Add(Convert.ToInt32(tbId.Text.Trim()), tbName.Text.Trim(), tbType.SelectedValue, info.Text))
{
msgBox.Show(this, "添加成功!");
}
else
{
msgBox.Show(this, "添加失败!");
}
}
/// <summary>
/// 初始化页面显示
/// </summary>
protected void initControls()
{
DataRow dt;
if (Request["rid"] == null)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('未设置bid!请从查看页面(点击宿舍楼管理根节点)访问本页面！')", true);
return;
}
else
{
dt = Room.getOne(Request["rid"]);
if (dt == null || dt.IsNull(0))
{
return;
}
}
tbDid.Items.AddRange(Yid.getYidItem());
/// 显示
tbDid.Text = dt["院名称"].ToString();
tbBid.Text = dt["宿舍楼编号"].ToString();
tbName.Text = dt["宿舍楼名称"].ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Request["did"] == null)
{
return;
}
/// 检测数据输入
if (tbId.Text.Length <= 0 || tbName.Text.Length <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('数据输入有误，请重新输入！')", true);
return;
}
/*
* /// 创建cmd
* OleDbCommand cmd = new OleDbCommand("DELETE FROM T_Dormitory WHERE 院编号=@oid;");
* cmd.Parameters.AddWithValue("oid", Request["did"].ToString());
* /// 插入数据库
* if (SQL.ExecuteNonQuery(cmd)>=1)
* {
* ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('删除成功！')", true);
* Response.Redirect("./");
* }
* else
* {
* ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('删除失败！')", true);
* }*/
if (Yid.Delete(Request["did"]))
{
msgBox.Show(this, "删除成功!");
}
else
{
msgBox.Show(this, "删除失败");
}
}
/// <summary>
/// 初始化院信息显示
/// </summary>
protected void initControls()
{
tbDid.Items.Clear();
tbDid.Items.AddRange(Yid.getYidItem());
initB(tbDid.SelectedValue);
}
/// <summary>
/// 初始化院别List
/// </summary>
protected void initYidList()
{
tbDid.Items.Add("全部");
tbDid.Items.AddRange(Yid.getYidItem());
}
