/// <summary>
/// Search data from GENERAL_AUT_USERROLE table
/// </summary>
/// <param name="dt"></param>
/// <param name="URoleID"></param>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public DataTable Search(DataTable dt, string URoleID)
{
clsCommon common = new clsCommon();
string strSql = "SELECT UROLE_ID, ROLE_NAME FROM GENERAL_AUT_USERROLE ";
StringBuilder sb = new StringBuilder();
if(URoleID != null && URoleID.Length > 0)
{
sb.Append(string.Format(" UROLE_ID LIKE '{0}' ", common.EncodeKeyword(URoleID)));
}
if(sb.Length > 0)
strSql = strSql + " WHERE " + sb.ToString();
return dao.GetDataTable(dt, strSql);
}
/// <summary>
/// Search data from
/// </summary>
/// <param name="dt"></param>
/// <param name="userName"></param>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="email"></param>
/// <param name="roleID"></param>
/// <param name="status"></param>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public DataTable Search(DataTable dt, string userName, string firstName, string lastName, string email, string roleID, string status)
{
clsCommon common = new clsCommon();
string strSql = "SELECT USERNAME, PASSWORD, FIRSTNAME, LASTNAME, EMAIL, ADDRESS, PHONE, START_DATE, END_DATE, PWD_CHG_DATE, STATUS, UROLE_ID, DESCRIPTION FROM GENERAL_AUT_USER";
StringBuilder sb = new StringBuilder();
if(userName != null && userName.Length > 0)
{
sb.Append(string.Format(" AND USERNAME LIKE '{0}' ", common.EncodeKeyword(userName)));
}
if(roleID != null && roleID.Length > 0)
{
sb.Append(string.Format(" AND UROLE_ID = '{0}' ", common.EncodeString(roleID)));
}
if(status != null && status.Length > 0)
{
sb.Append(string.Format(" AND STATUS = '{0}' ", common.EncodeString(status)));
}
if(firstName != null && firstName.Length > 0)
{
sb.Append(string.Format(" AND FIRSTNAME LIKE '{0}' ", common.EncodeKeyword(firstName)));
}
if(lastName != null && lastName.Length > 0)
{
sb.Append(string.Format(" AND LASTNAME LIKE '{0}' ", common.EncodeKeyword(lastName)));
}
if(email != null && email.Length > 0)
{
sb.Append(string.Format(" AND EMAIL LIKE '{0}' ", common.EncodeKeyword(email)));
}
if(sb.Length > 0)
strSql = strSql + " WHERE " + sb.ToString(4, sb.Length - 4);
return dao.GetDataTable(dt, strSql);
}