/// <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(); }
/// <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 }
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(); }