/// <summary>
/// 下拉框绑定
/// </summary>
private void ddlBind()
{
Pager mPager = null;
#region 宿舍区
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
this.ddlDormArea.DataValueField = TB_DormArea.col_ID;
this.ddlDormArea.DataTextField = TB_DormArea.col_Name;
this.ddlDormArea.DataSource = mDormAreaBLL.GetTable(new TB_DormArea()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID)
}, ref mPager);
this.ddlDormArea.DataBind();
this.ddlDormArea.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
#endregion
#region 楼栋
this.ddlBuildingName.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
#endregion
#region 单元
this.ddlUnit.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
#endregion
}
private void InitPageData()
{
string strUserID = Request.QueryString["id"];
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
TB_User mTB_User = null;
UserBLL mUserBLL = new UserBLL();
RoleBLL mRoleBLL = new RoleBLL();
TB_Role mTB_Role = new TB_Role()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
};
Pager pager = null;
this.ddlRole.DataTextField = TB_Role.col_Name;
this.ddlRole.DataValueField = TB_Role.col_ID;
this.ddlRole.DataSource = mRoleBLL.GetPagerData(mTB_Role, ref pager);
this.ddlRole.DataBind();
this.ddlRole.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
DataTable dtLeft = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
DataTable dtRight = null;
if (null != strUserID && !string.IsNullOrEmpty(strUserID))
{
mTB_User = mUserBLL.Get(Convert.ToInt32(strUserID));
this.txtADAccount.Text = mTB_User.ADAccount;
this.txtEmployeeNo.Text = mTB_User.EmployeeNo;
this.txtCName.Text = mTB_User.CName;
this.txtEName.Text = mTB_User.EName;
this.ddlRole.SelectedValue = mTB_User.RoleID.ToString();
dtRight = mDormAreaBLL.GetTableByUserID(Convert.ToInt32(strUserID));
DataRow[] drFilter = null;
for (int i = dtLeft.Rows.Count - 1; i >= 0; i--)
{
drFilter = dtRight.Select("ID=" + dtLeft.Rows[i][TB_DormArea.col_ID] + "");
if (drFilter.Length > 0)
{
dtLeft.Rows.Remove(dtLeft.Rows[i]);
}
}
}
ViewState["dtLeft"] = dtLeft;
gdvLeft.DataSource = dtLeft;
gdvLeft.DataBind();
ViewState["dtRight"] = dtRight;
gdvRight.DataSource = dtRight;
gdvRight.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strID = Request.QueryString["id"];
int intID;
TB_DormArea mTB_DormArea = null;
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
if (Int32.TryParse(strID, out intID))
{
mTB_DormArea = mDormAreaBLL.Get(intID);
this.txtDormAreaName.Text = mTB_DormArea.Name;
}
}
}
/// <summary>
/// 下拉框绑定
/// </summary>
private void ddlBind()
{
Pager mPager = null;
#region 宿舍区
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
this.ddlDormArea.DataValueField = TB_DormArea.col_ID;
this.ddlDormArea.DataTextField = TB_DormArea.col_Name;
this.ddlDormArea.DataSource = mDormAreaBLL.GetTable(new TB_DormArea()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID)
}, ref mPager);
this.ddlDormArea.DataBind();
#endregion
}
private void Bind(int intCurrentIndex)
{
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_DormArea.Name = txtDormAreaName.Text;
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
GridView1.DataSource = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
private void BindSelect()
{
var lst = new List <TNameVal>();
lst.Add(new TNameVal("All", "0"));
lst.Add(new TNameVal("新入住", "1"));
lst.Add(new TNameVal("复入住", "2"));
lst.Add(new TNameVal("调房", "3"));
ddlRequiredType.DataSource = lst;
ddlRequiredType.DataValueField = "Value";
ddlRequiredType.DataTextField = "Name";
ddlRequiredType.DataBind();
ddlRequiredType.SelectedIndex = 0;
lst = new List <TNameVal>();
lst.Add(new TNameVal("All", "-1"));
lst.Add(new TNameVal("等待处理", "0"));
lst.Add(new TNameVal("批准", "1"));
lst.Add(new TNameVal("拒绝", "2"));
ddlStatus.DataSource = lst;
ddlStatus.DataValueField = "Value";
ddlStatus.DataTextField = "Name";
ddlStatus.DataBind();
ddlStatus.SelectedIndex = 0;
Pager mPager = null;
#region 宿舍区
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
this.ddlDormArea.DataValueField = TB_DormArea.col_ID;
this.ddlDormArea.DataTextField = TB_DormArea.col_Name;
this.ddlDormArea.DataSource = mDormAreaBLL.GetTable(new TB_DormArea()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID)
}, ref mPager);
this.ddlDormArea.DataBind();
this.ddlDormArea.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
string strDormAreaName = Request.Params["DormAreaName"];
string strID = Request.Params["ID"];
int intID;
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
Int32.TryParse(strID, out intID);
TB_DormArea mTB_DormArea = new TB_DormArea()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
ID = intID,
Name = strDormAreaName.Trim(),
UpdateBy = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount),
Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount),
};
mDormAreaBLL.Edit(mTB_DormArea);
Response.Write(mDormAreaBLL.ErrMessage);
mDormAreaBLL.ErrMessage = string.Empty;
Response.End();
}
private void BindSelect()
{
var lst = new List <TNameVal>();
lst.Add(new TNameVal("批准", "1"));
lst.Add(new TNameVal("拒绝", "2"));
ddlHandle.DataSource = lst;
ddlHandle.DataValueField = "Value";
ddlHandle.DataTextField = "Name";
ddlHandle.DataBind();
ddlHandle.SelectedIndex = 0;
//
var mTB_DormArea = new TB_DormArea();
var mDormAreaBLL = new DormAreaBLL();
Framework.Pager page = null;
var dt = mDormAreaBLL.GetTable(mTB_DormArea, ref page);
ddlDormArea.DataSource = dt;
ddlDormArea.DataValueField = "ID";
ddlDormArea.DataTextField = "Name";
ddlDormArea.DataBind();
}
