/// <summary>
/// 数据绑定
/// </summary>
protected void BindData()
{
sqUserName = "******" + UserName.Text.Trim() + "%";
sqLogin_Name = "%" + Login_Name.Text.Trim() + "%";
sqDeptCode = this.Dept_Code.SelectedValue + "%";
SearchStates();
int iCurPageNo = WPager1.CurrentPageIndex;
sSql = @"WITH OrderedOrders AS (select ROW_NUMBER() OVER (ORDER BY Uid) AS 'RowNumber', Uid, Login_name, UserName, Password, Mobile, Contact, Dept, Dept_code, Position_name, Status, Addtime,
Email, TaskText, Purview, DeptPurview, Sex, Duty, LoginStatus, DtLastLogin, t_group.Name As GroupName from t_sysuser
Left join t_group on t_group.SeqId = t_sysuser.Dept_code Where UserName Like @P3 And Login_Name Like @P4
And Dept_code Like @P5) SELECT * FROM OrderedOrders Where RowNumber BETWEEN @p1 AND @p2; ;
Select Count(Uid) From t_sysuser Where UserName Like @P3 And Login_Name Like @P4 And Dept_code Like @P5 ";
object[] arrParas = new object[5] {
(iCurPageNo - 1) * WPager1.PageSize + 1, iCurPageNo *WPager1.PageSize, sqUserName, sqLogin_Name, sqDeptCode
};
_ComData = new CommData(sConnOa);
DataSet _ds = _ComData.GetDs(sSql, arrParas);
_ComData.CloseConn();
GridView1.DataSource = _ds.Tables[0];
WPager1.RecordCount = Convert.ToInt32((_ds.Tables[1].Rows[0][0]));
GridView1.DataBind();
}
protected void RowCmd(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Detelte")
{
sSql = "Delete from t_sysuser Where Uid = @P1";
string[] arrParas = new string[1] {
(string)e.CommandArgument
};
_ComData = new CommData(sConnOa);
_ComData.ExecuteNonQuery(sSql, arrParas);
_ComData.CloseConn();
BindData();
}
}