public object GetStoreWeightList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
IBase_UserInfoService base_UserInfoService = BLLContainer.Resolve <IBase_UserInfoService>(resolveNew: true);
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>(resolveNew: true);
var result = from a in base_UserInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.UserType == (int)UserType.StoreBoss)
join b in base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) on a.UserID equals b.BossID
select new
{
RealName = a.RealName,
LogName = a.LogName,
WeightValue = b.WeightValue,
ID = b.ID
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object DelStoreWeight(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
#region 验证参数
if (string.IsNullOrEmpty(id))
{
errMsg = "门店权重ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>();
int iId = Convert.ToInt32(id);
var base_StoreWeight = base_StoreWeightService.GetModels(p => p.ID == iId).FirstOrDefault();
if (!base_StoreWeightService.Delete(base_StoreWeight))
{
errMsg = "删除门店权重信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_StoreWeight_Game).Namespace);
var base_StoreWeight_Game = dbContext.Set <Base_StoreWeight_Game>().Where(p => p.WeightID == iId).ToList();
foreach (var model in base_StoreWeight_Game)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "删除门店权重游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetStoreWeightUserGameList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
string userId = dicParas.ContainsKey("userId") ? (dicParas["userId"] + "") : string.Empty;
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(userId))
{
errMsg = "用户ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iUserId = Convert.ToInt32(userId);
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>(resolveNew: true);
IBase_StoreWeight_GameService base_StoreWeight_GameService = BLLContainer.Resolve <IBase_StoreWeight_GameService>(resolveNew: true);
IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true);
var result = from a in base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.BossID == iUserId)
join b in base_StoreWeight_GameService.GetModels() on a.ID equals b.WeightID
join c in data_GameInfoService.GetModels() on b.GameID equals c.ID
select new
{
GameName = c.GameName,
GameID = c.ID
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object SaveStoreWeightUserGameInfo(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
string userId = dicParas.ContainsKey("userId") ? (dicParas["userId"] + "") : string.Empty;
string weightType = dicParas.ContainsKey("weightType") ? (dicParas["weightType"] + "") : string.Empty;
var gameIDs = dicParas.ContainsKey("gameIDs") ? ((object[])dicParas["gameIDs"]).Cast <int>() : null;
#region 验证参数
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(userId))
{
errMsg = "门店老板ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(weightType))
{
errMsg = "门店权重类别不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>();
int iWeightType = Convert.ToInt32(weightType);
int iUserId = Convert.ToInt32(userId);
if (!base_StoreWeightService.Any(a => a.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && a.BossID == iUserId))
{
errMsg = "请先分配权重";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_StoreWeight = base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.BossID == iUserId).FirstOrDefault();
base_StoreWeight.WeightType = iWeightType;
if (!base_StoreWeightService.Update(base_StoreWeight))
{
errMsg = "保存权重用户游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (iWeightType == (int)ChainStoreWeightType.Game)
{
if (gameIDs == null)
{
errMsg = "选择的游戏机列表不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//先删除后添加
int iId = base_StoreWeight.ID;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_StoreWeight_Game).Namespace);
var base_StoreWeight_Game = dbContext.Set <Base_StoreWeight_Game>().Where(p => p.WeightID == iId).ToList();
foreach (var model in base_StoreWeight_Game)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
foreach (var gId in gameIDs)
{
var base_StoreWeight_GameModel = new Base_StoreWeight_Game();
base_StoreWeight_GameModel.WeightID = iId;
base_StoreWeight_GameModel.GameID = gId;
dbContext.Entry(base_StoreWeight_GameModel).State = EntityState.Added;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存权重用户游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object AddStoreWeight(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
string userId = dicParas.ContainsKey("userId") ? (dicParas["userId"] + "") : string.Empty;
string weightValue = dicParas.ContainsKey("weightValue") ? (dicParas["weightValue"] + "") : string.Empty;
#region 验证参数
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(userId))
{
errMsg = "门店老板ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(weightValue))
{
errMsg = "门店权重值不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(weightValue))
{
errMsg = "门店权重值格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>();
int bossId = Convert.ToInt32(userId);
if (base_StoreWeightService.Any(a => a.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && a.BossID == bossId))
{
errMsg = "该门店老板权重已分配";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iWeightValue = Convert.ToInt32(weightValue);
int sumWeightValue = base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)).Sum(s => s.WeightValue) ?? 0;
if ((sumWeightValue + iWeightValue) > 100)
{
errMsg = "门店权重之和不得超过100";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_StoreWeight = new Base_StoreWeight();
base_StoreWeight.BossID = bossId;
base_StoreWeight.StoreID = storeId;
base_StoreWeight.WeightType = (int)ChainStoreWeightType.Whole;
base_StoreWeight.WeightValue = iWeightValue;
if (!base_StoreWeightService.Add(base_StoreWeight))
{
errMsg = "添加门店权重信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}