/// <summary> /// 绑定列表 /// </summary> private void RptBind() { BLL.wx_hotel_user dcBll = new BLL.wx_hotel_user(); List<Model.wx_hotel_user> hotelAdmins = dcBll.GetModelList("hotelId=" + hotelid); BLL.manager managerBll = new BLL.manager(); DataSet dsData = new DataSet(); if (hotelAdmins.Any()) { string strWhere = string.Empty; for (int index = 0; index <= hotelAdmins.Count - 1; index++) { strWhere += "," + hotelAdmins[index].ManagerId; } strWhere = "(" + strWhere.Substring(1) + ")"; dsData = managerBll.GetList(0, "id in " + strWhere, string.Empty); rptList.DataSource = dsData; } else { rptList.DataSource = new List<Model.manager>(); } rptList.DataBind(); }
/// <summary> /// 绑定列表 /// </summary> private void RptBind() { BLL.wx_hotel_user dcBll = new BLL.wx_hotel_user(); List <Model.wx_hotel_user> hotelAdmins = dcBll.GetModelList("hotelId=" + hotelid); BLL.manager managerBll = new BLL.manager(); DataSet dsData = new DataSet(); if (hotelAdmins.Any()) { string strWhere = string.Empty; for (int index = 0; index <= hotelAdmins.Count - 1; index++) { strWhere += "," + hotelAdmins[index].ManagerId; } strWhere = "(" + strWhere.Substring(1) + ")"; dsData = managerBll.GetList(0, "id in " + strWhere, string.Empty); rptList.DataSource = dsData; } else { rptList.DataSource = new List <Model.manager>(); } rptList.DataBind(); }
private void ShowInfo(int _id) { BLL.department bll = new BLL.department(); Model.department model = bll.GetModel(_id); ddlParentId.SelectedValue = model.parent_id.ToString(); txtSortId.Text = model.sort_id.ToString(); if (model.is_lock == 1) { cbIsLock.Checked = true; } txtTitle.Text = model.department_name; txtTitle.Attributes.Add("ajaxurl", "../../tools/admin_ajax.ashx?action=department_validate&old_name=" + Utils.UrlEncode(model.department_name)); txtTitle.Focus(); //设置焦点,防止JS无法提交 if (model.is_sys == 1) { ddlParentId.Enabled = false; txtTitle.ReadOnly = true; } txtRemark.Text = model.remark; this.page = DTRequest.GetQueryInt("page", 1); //txtKeywords.Text = this.keywords; BLL.manager bllManager = new BLL.manager(); this.rptList.DataSource = bllManager.GetList(this.pageSize, this.page, "department_id=" + _id + "", "add_time asc,id desc", out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("department_edit.aspx", "page={0}&action={1}&id={2}", "__id__", "pagedepartment", _id.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.manager bll = new BLL.manager(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); }
private void BindUser_Code(string strwhere) { BLL.manager userbll = new BLL.manager(); DataTable usertb = userbll.GetList(1000, strwhere, " id").Tables[0]; this.ddlUser_Code.Items.Clear(); this.ddlUser_Code.Items.Add(new ListItem("请选择用车人...", "")); foreach (DataRow dr in usertb.Rows) { this.ddlUser_Code.Items.Add(new ListItem(dr["real_name"].ToString(), dr["user_name"].ToString())); } }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.manager bll = new BLL.manager(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("manager_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void WineryBind(DropDownList ddl, int role_id) { BLL.manager bll = new BLL.manager(); DataTable dt = bll.GetList(0, "role_id=" + role_id, "add_time desc,id asc").Tables[0]; ddl.Items.Clear(); ddl.Items.Add(new ListItem("请选择酒厂...", "")); foreach (DataRow dr in dt.Rows) { if (Convert.ToInt32(dr["role_id"]) >= role_id) { ddl.Items.Add(new ListItem(dr["user_name"].ToString(), dr["id"].ToString())); } } }
protected void Page_Load(object sender, EventArgs e) { Model.manager model = GetAdminInfo(); //取得当前管理员信息 string _action = DTRequest.GetQueryString("action"); if (!string.IsNullOrEmpty(_action) && _action == DTEnums.ActionEnum.Edit.ToString()) { ChkAdminLevel("electricity_list", DTEnums.ActionEnum.Edit.ToString()); //检查权限 tbequipmentId.Enabled = false; this.action = DTEnums.ActionEnum.Edit.ToString(); //修改类型 if (!int.TryParse(Request.QueryString["id"] as string, out this.id)) { JscriptMsg("传输参数不正确!", "back"); return; } if (!new BLL.dt_item().Exists(this.id)) { JscriptMsg("记录不存在或已被删除!", "back"); return; } else if (model.role_type != 1) { Model.dt_item itemmodel = new BLL.dt_item().GetModel(this.id); if (itemmodel.user_id != model.id) { JscriptMsg("记录不存在或已被删除!", "back"); return; } } } else { ChkAdminLevel("electricity_list", DTEnums.ActionEnum.Add.ToString()); //检查权限 } if (!Page.IsPostBack) { string zb = ""; string elng = DTRequest.GetQueryStringValue("elng", ""); string elat = DTRequest.GetQueryStringValue("elat", ""); if (!string.IsNullOrEmpty(elat) && !string.IsNullOrEmpty(elng)) { zb = elng.Replace("D", ".") + "," + elat.Replace("D", "."); } //BLL.dt_area_code bll = new BLL.dt_area_code ddlArea.DataTextField = "name"; ddlArea.DataValueField = "code"; ddlArea.DataSource = ManagePage.arealist; ddlArea.DataBind(); BLL.manager bll = new BLL.manager(); ddlUser.DataTextField = "real_name"; ddlUser.DataValueField = "id"; ddlUser.DataSource = bll.GetList(9999, "", " id asc"); ddlUser.DataBind(); ListItem li = new ListItem(); li.Value = ""; li.Text = "请选择区域"; ddlArea.Items.Insert(0, li); li.Value = ""; li.Text = "请选择用户"; ddlUser.Items.Insert(0, li); if (this.action == DTEnums.ActionEnum.Edit.ToString()) //修改 { ShowInfo(this.id, zb); } else { if (!string.IsNullOrEmpty(zb)) { tbPosition.Text = zb; } } } }