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