public override void DataBind() { string strSql = " SELECT a.EmpID, a.UserName, a.Pwd, a.EmpName, '' DeptName, c.UserRoleName, HideFlag " + " FROM Employee a " + " Left Join UserRole c On a.UserRoleID = c.UserRoleID " + " Where a.DelFlag = 0 And a.EmpID Not In ('4E975C83-6E7B-4A48-A815-F733094B1234', '4C3E218F-D513-416E-BD10-B4F161717F70') "; DataView dv = Conn.Select(string.Format(strSql + " Order By HideFlag, a.UserName ")); if (dv.Count != 0) { for (int i = 0; i < dv.Count; i++) { dv[i]["DeptName"] = btc.getEmpDeptName(dv[i]["EmpID"].ToString()); } } GridView1.DataSource = dv; GridView1.DataBind(); lblSearchTotal.InnerText = dv.Count.ToString(); }
public override void DataBind() { string strSql = " Select b.IsAdmin From EmpLoyee a, UserRole b Where a.UserRoleID = b.UserRoleID And IsAdmin = 1 And a.EmpID = '" + CurrentUser.ID + "' "; DataView dv2 = Conn.Select(string.Format(strSql)); if (dv2.Count != 0) { strSql = " SELECT a.EmpID, a.UserName, a.Pwd, a.EmpName, '' DeptName, c.UserRoleName, HideFlag " + " FROM Employee a " + " Left Join UserRole c On a.UserRoleID = c.UserRoleID " + " Where a.DelFlag = 0 And a.EmpID Not In ('4E975C83-6E7B-4A48-A815-F733094B1234', '4C3E218F-D513-416E-BD10-B4F161717F70') "; } else { strSql = " SELECT a.EmpID, a.UserName, a.Pwd, a.EmpName, '' DeptName, c.UserRoleName, HideFlag " + " FROM Employee a " + " Left Join UserRole c On a.UserRoleID = c.UserRoleID " + " Where a.DelFlag = 0 AND a.EmpID = '" + CurrentUser.ID + "' " + " And a.EmpID Not In ('4E975C83-6E7B-4A48-A815-F733094B1234', '4C3E218F-D513-416E-BD10-B4F161717F70') "; } if (ddlSearchDept.SelectedIndex != 0) { if (dv2.Count != 0) { strSql = " SELECT a.EmpID, a.UserName, a.Pwd, a.EmpName, '' DeptName, c.UserRoleName, HideFlag " + " FROM Employee a Left Join EmpDept b On a.EmpID = b.EmpID " + " Left Join UserRole c On a.UserRoleID = c.UserRoleID " + " Where a.DelFlag = 0 And a.EmpID Not In ('4E975C83-6E7B-4A48-A815-F733094B1234', '4C3E218F-D513-416E-BD10-B4F161717F70') "; } else { strSql = " SELECT a.EmpID, a.UserName, a.Pwd, a.EmpName, '' DeptName, c.UserRoleName, HideFlag " + " FROM Employee a Left Join EmpDept b On a.EmpID = b.EmpID " + " Left Join UserRole c On a.UserRoleID = c.UserRoleID " + " Where a.DelFlag = 0 AND a.EmpID = '" + CurrentUser.ID + "' " + " And a.EmpID Not In ('4E975C83-6E7B-4A48-A815-F733094B1234', '4C3E218F-D513-416E-BD10-B4F161717F70') "; } strSql = strSql + " And b.DeptCode = '" + ddlSearchDept.SelectedValue + "' "; } if (ddlSearch.SelectedIndex != 0) { strSql = strSql + " And c.UserRoleID = '" + ddlSearch.SelectedValue + "' "; } if (txtSearch.Text != "") { strSql = strSql + " And a.EmpName Like '%" + txtSearch.Text + "%' "; } DataView dv = Conn.Select(string.Format(strSql + " Order By HideFlag, a.UserName ")); if (dv.Count != 0) { for (int i = 0; i < dv.Count; i++) { dv[i]["DeptName"] = btc.getEmpDeptName(dv[i]["EmpID"].ToString()); } } GridView1.DataSource = dv; GridView1.DataBind(); lblSearchTotal.InnerText = dv.Count.ToString(); }