public static IEnumerable <UserInfo> GetStoreUsers(string storeId, StoreOperateAuth storeOperateAuth, int companyId)
{
var auth = ((int)storeOperateAuth).ToString();
var query = CurrentRepository.Entities.Where(o => ("|" + o.OperateAuth + "|").Contains("|" + storeId + "," + auth + "|") && o.CompanyId == companyId).Select(o => new UserInfo()
{
FullName = o.FullName,
LoginDT = o.LoginDT,
LoginPwd = o.LoginPwd,
OperateAuth = o.OperateAuth,
Sex = o.Sex,
UID = o.UID,
UserCode = o.UserCode
}).ToList();
return(query);
}
public static IEnumerable <UserInfo> GetStoreManagers(string storeId, StoreOperateAuth storeOperateAuth, int companyId)
{
var auth = ((int)storeOperateAuth).ToString();
var storename = System.Configuration.ConfigurationManager.AppSettings["StoreName"];
var sqlStr = @"select s.*,'" + storename + "' StoreName from SysStoreUserInfo s where '|'+OperateAuth+'|' like '%|" + storeId + "," + auth + "|%'";
return(CurrentRepository._context.Database.SqlQuery <UserInfo>(sqlStr).ToList());
//var query = CurrentRepository.Entities.Where(o => o.OperateAuth.Contains(storeId + "," + auth)).Select(o => new UserInfo()
//{
// FullName = o.FullName,
// LoginDT = o.LoginDT,
// LoginPwd = o.LoginPwd,
// OperateAuth = o.OperateAuth,
// Sex = o.Sex,
// UID = o.UID,
// UserCode = o.UserCode
//}).ToList();
//return result;
}
public IEnumerable <UserInfo> GetStoreUsers(StoreOperateAuth storeOperateAuth)
{
return(SysStoreUserInfoService.GetStoreUsers(StoreId, storeOperateAuth, CompanyId));
}
private static bool VerfyOperateAuth(UserInfo userInfo, string storeId, StoreOperateAuth storeOperateAuth)
{
return(("|" + userInfo.OperateAuth + "|").Contains(string.Format("|{0},{1}|", storeId, (int)storeOperateAuth)));
}
/// <summary>
/// 获取满足条件的用户信息
/// </summary>
/// <param name="storeId"></param>
/// <param name="machineSn"></param>
/// <param name="companyId"></param>
/// <param name="storeOperateAuth"></param>
/// <returns></returns>
public static IEnumerable <UserInfo> GetAuthUsers(string storeId, string machineSn, int companyId, StoreOperateAuth storeOperateAuth)
{
var dataAdapter = DataAdapterFactory.Factory(MachinesSettings.Mode, storeId, machineSn, companyId, DataAdapterFactory.DEFUALT);
var users = dataAdapter.GetStoreUsers(storeOperateAuth);
return(users);
}
