/// <summary>
/// 查询列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataTable GetTable()
{
string sql = "SELECT [MenuID],[MenuTypeID],[ParentID],[MenuName],[MenuPath],[Sort],[ImagePath],[Description] FROM [QX_Menus]";
return(_commonDbConneciton.ExecuteDataTable(sql, null));
}
/// <summary>
/// 查询模具列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataTable GetTable()
{
string sql = "SELECT [RoleID], [RoleName], [Description] FROM [QX_Roles]";
return(_commonDbConneciton.ExecuteDataTable(sql, null));
}
/// <summary>
/// 查询实体列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataTable GetTable(string strwhere)
{
string sql = "SELECT [UserID],[UserAccount],[Password],[UserName],[Sex],[Birthday],[Phone],[Email],[EmployeeID],[DepartmentID],[EntryDate],[UserType],[DeleteDate],[DeleteReason],[DeleteUserID],(SELECT UserName FROM [QX_Users] WHERE UserID = tab.[DeleteUserID]) [DeleteUserName],[Remark] FROM [QX_Users] tab " + strwhere;
return(_commonDbConneciton.ExecuteDataTable(sql, null));
}