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