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