private void searchUser(int index) { pagingCom1.PageIndex = index; pagingCom1.PageSize = 10; var dtData = ctrl.getUserList(pagingCom1.PageIndex, pagingCom1.PageSize, -1, textBox1.Text); //获取并设置总记录数 pagingCom1.RecordCount = ctrl.getUserListCount(-1, textBox1.Text); dataGridView1.DataSource = dtData; dataGridView1.ClearSelection(); pagingCom1.reSet(); }
/// <summary> /// 绑定第Index页的数据 /// </summary> /// <param name="Index"></param> private void BindDataWithPage(int Index) { pagingCom1.PageIndex = Index; pagingCom1.PageSize = 10; int roleId = -1; if (this.comboBox1.SelectedValue != null) { roleId = Convert.ToInt32(this.comboBox1.SelectedValue.ToString()); } innerParmas parmas = new innerParmas(pagingCom1.PageIndex, pagingCom1.PageSize, roleId, textBox1.Text);//textBox1.Text dtData = uctrl.getUserList(parmas.pageIndex, parmas.pageSize, parmas.role, parmas.fullName); //获取并设置总记录数 pagingCom1.RecordCount = uctrl.getUserListCount(roleId, textBox1.Text);//Convert.ToInt32(dsData.Tables[1].Rows[0][0]); //dtData = dsData.Tables[0]; //dt = new DataTable(); //DataColumn dcNO = new DataColumn("编号"); //DataColumn dcUName = new DataColumn("用户名"); //DataColumn dcFName = new DataColumn("姓名"); //DataColumn dcRole = new DataColumn("职位"); //DataColumn dcStatus = new DataColumn("状态"); //dt.Columns.Add(dcNO); //dt.Columns.Add(dcUName); //dt.Columns.Add(dcFName); //dt.Columns.Add(dcRole); //dt.Columns.Add(dcStatus); dtData.Columns.Add("status"); for (int i = 0; i < dtData.Rows.Count; i++) { //DataRow dr = dt.NewRow(); //dr[0] = dtData.Rows[i]["id"].ToString(); //dr[1] = dtData.Rows[i]["userName"].ToString(); //dr[2] = dtData.Rows[i]["fullName"].ToString(); //dr[3] = dtData.Rows[i]["name"].ToString(); if (dtData.Rows[i]["isActive"].ToString() == "1") { dtData.Rows[i]["status"] = "激活"; } else { dtData.Rows[i]["status"] = "注销"; } //dr[4] = dtData.Rows[i]["isActive"].ToString(); //dt.Rows.Add(dr); } dataGridView1.DataSource = dtData; pagingCom1.reSet(); }