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