/// <summary> /// add by chr /// 根据用户名获取本餐厅可用的餐桌负责人列表 /// </summary> /// <returns></returns> public static DataTable GetTableDutyUserListByOrgId(string strOrgId) { int iOrgId = Convert.ToInt32(strOrgId); Parameter parameter = new Parameter(); parameter.SqlString = "SELECT [YWPerson].[UserName],[PT_User].[Nickname],[YWPerson].[OrgId],[PT_ORG].[OrgName] " + "FROM [YWPerson] " + "LEFT JOIN [PT_ORG] ON [YWPerson].[OrgId]=[PT_ORG].[Id] " + "LEFT JOIN [PT_User] ON [YWPerson].[UserName]=[PT_User].[UserName] " + "INNER JOIN [PT_UserLink] ON [YWPerson].[UserName]=[PT_UserLink].[UserName] " + "WHERE [YWPerson].[OrgId]=@OrgId AND [PT_User].[StateId]=1 AND [PT_UserLink].[RoleId]=@RoleId"; SqlParameter[] parameters = { new SqlParameter("@OrgId", SqlDbType.Int, 50) { Value = iOrgId }, new SqlParameter("@RoleId", SqlDbType.Int, 50) { Value = CodeDictionary.UserRole["一般用户(初始默认)"] } }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }
/// <summary> /// add by chr /// 根据餐厅组织机构Id获取获取餐厅所有用户列表 /// </summary> /// <returns></returns> public static DataTable GetRestaurantUserListByOrgId(int iOrgId) { string strAllSubOrgId = PTOrgBLL.GetAllSubOrgIdString(iOrgId.ToString()); Parameter parameter = new Parameter(); parameter.SqlString = "SELECT [PT_User].[UserName],[PT_User].[Nickname],[PT_User].[OrgId],[PT_ORG].[OrgName] " + "FROM [PT_User] " + "LEFT JOIN [PT_ORG] ON [PT_User].[OrgId]=[PT_ORG].[Id] " + "WHERE [PT_User].[OrgId] IN (" + strAllSubOrgId + (strAllSubOrgId.Trim() == "" ? "" : ",") + iOrgId.ToString() + ") AND [PT_User].[StateId]=1"; return(CommonToolsBLL.GetAllListByParams(parameter)); }
/// <summary> /// add by chr /// 根据用户名strUserName来获取该用户所有的角色 /// </summary> /// <param name="strUserName"></param> /// <returns></returns> public static DataTable GetRolesByUserName(string strUserName) { Parameter parameter = new Parameter(); parameter.SqlString = "SELECT [PT_UserLink].[Id] AS [LinkId], [PT_ROLE].[Id] AS [RoleId],[UserName],[RoleName] ,[StateId] "; parameter.SqlString += " FROM [PT_UserLink] LEFT JOIN [PT_ROLE] ON [PT_ROLE].[Id] = [PT_UserLink].[RoleId] WHERE [UserName] = @UserName "; SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) { Value = strUserName }, }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }
/// <summary> /// add by chr /// 根据角色类型获取角色数据列表 /// </summary> /// <param name="strType">0-系统角色 1-业务角色</param> /// <returns></returns> public static DataTable GetRolesByType(string strType) { Parameter parameter = new Parameter(); parameter.SqlString = "SELECT [Id],[RoleName],[GroupId], [StateId],[Alternate1],[Alternate2],[Alternate3],[Alternate4],[Alternate5] "; parameter.SqlString += " FROM [PT_ROLE] WHERE [GroupId] = @GroupId "; SqlParameter[] parameters = { new SqlParameter("@GroupId", SqlDbType.NVarChar, 50) { Value = strType }, }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }
/// <summary> /// add by chr /// </summary> /// <param name="strUserName"></param> /// <returns></returns> public static DataTable GetUserByTel(string strTel) { //构建查询条件 Parameter parameter = new Parameter(); parameter.SqlString = " SELECT [OrgId] FROM [PT_USER] WHERE [Alternate1]=@Alternate1 "; SqlParameter[] parameters = { new SqlParameter("@Alternate1", SqlDbType.NVarChar, 50) { Value = strTel }, }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }
/// <summary> /// add by chr /// 根据功能id和组织机构id,获取相应的用户列表 /// </summary> /// <param name="strFunctionId"></param> /// <param name="iOrgId"></param> /// <returns></returns> public static DataTable GetUserNameByFunctionIdAndOrgId(string strFunctionId, int iOrgId) { Parameter parameter = new Parameter(); parameter.SqlString = "SELECT DISTINCT [PT_User].[UserName] FROM [PT_User],[PT_UserLink],[PT_RoleLink] "; parameter.SqlString += "WHERE [PT_RoleLink].[FunctionId]=@FunctionId AND [PT_User].[OrgId]=@OrgId AND [PT_UserLink].[RoleId] = [PT_RoleLink].[RoleId] AND [PT_User].[UserName] = [PT_UserLink].[UserName] "; SqlParameter[] parameters = { new SqlParameter("@FunctionId", SqlDbType.NVarChar, 50) { Value = strFunctionId }, new SqlParameter("@OrgId", SqlDbType.Int, 50) { Value = iOrgId }, }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉ // 说明:以下区域的代码为设计开发人员所编写,主要为扩展该业务逻辑类的功能,而定义的变量、属性及相关业务逻辑处理方法。 // 注意:用户界面层应当只需调用本层便可完成所有操作,本类对关联的数据访问类调用,应当只通过类中的DataAccess属性实现。 //﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍ /// <summary> /// 根据基本用户信息(PTUsers)的主键“用户名(UserName)”从数据库中获取基本用户信息(PTUsers)的实例。 /// 成功从数据库中取得记录返回新基本用户信息(PTUsers)的实例“,没有取到记录返回null值。 /// </summary> /// <param name="userName">基本用户信息(PTUsers)的主键“用户名(UserName)”</param> public static DataTable GetDataTableByUserName(string userName) { // return DataAccess.GetDataByUserName(userName); //构建查询条件 Parameter parameter = new Parameter(); parameter.SqlString = " SELECT [PT_USER].[Id],[PT_USER].[UserName],[PT_USER].[Password],[PT_USER].[OrgId],[PT_ORG].[OrgName], " + " [PT_USER].[Nickname],[PT_USER].[StateId],[PT_USER].[Alternate1],[PT_USER].[Alternate2], " + " [PT_USER].[Alternate3],[PT_USER].[Alternate4],[PT_USER].[Alternate5] " + " FROM [PT_USER] LEFT JOIN [PT_ORG] ON [PT_USER].[OrgId] = [PT_ORG].[Id] " + " WHERE [PT_USER].[UserName]=@UserName "; SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) { Value = userName }, }; parameter.Parameters = parameters; return(CommonToolsBLL.GetAllListByParams(parameter)); }