public object GetOrdersChart(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
DateTime now = DateTime.Now;
DateTime start = new DateTime(now.Year, now.Month, 1);
DateTime end = start.AddMonths(1).AddDays(-1);
TimeSpan ts = end.Subtract(start);
int num = ts.Days;
List <Store_CheckDateChartModel> store_CheckDateChart = new List <Store_CheckDateChartModel>();
var base_StoreInfo = BLLContainer.Resolve <IBase_StoreInfoService>().GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)).Select(o => o.StoreID);
var store_CheckDate = BLLContainer.Resolve <IStore_CheckDateService>().GetModels(p => base_StoreInfo.Contains(p.StoreID) && System.Data.Entity.DbFunctions.DiffMonths(p.CheckDate, DateTime.Now) == 0);
for (int i = 0; i <= num; i++)
{
DateTime da = start.AddDays(i).Date;
var query = store_CheckDate.Where(p => System.Data.Entity.DbFunctions.DiffDays(p.CheckDate, da) == 0);
Store_CheckDateChartModel store_CheckDateModel = new Store_CheckDateChartModel();
store_CheckDateModel.CheckDate = da;
store_CheckDateModel.AliPay = (decimal)query.Sum(s => s.AliPay).GetValueOrDefault();
store_CheckDateModel.Wechat = (decimal)query.Sum(s => s.Wechat).GetValueOrDefault();
store_CheckDateChart.Add(store_CheckDateModel);
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, store_CheckDateChart));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetUserGroupList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string logId = string.Empty;
int userId = (dicParas.ContainsKey("userId") && Utils.isNumber(dicParas["userId"])) ? Convert.ToInt32(dicParas["userId"]) : 0;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
logId = userTokenKeyModel.DataModel.MerchID;
}
//EF左关联
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup).Namespace);
var base_UserGroup = (from a in dbContext.Set <Base_UserGroup>()
join b in dbContext.Set <Base_UserInfo>().Where(p => p.UserID == userId) on a.ID equals b.UserGroupID into t
from b in t.DefaultIfEmpty()
where a.MerchID.Equals(logId, StringComparison.OrdinalIgnoreCase)
select new UserGroupModel
{
ID = a.ID,
GroupName = a.GroupName,
Note = a.Note,
UserState = (b.UserID > 0 ? 1 : 0)
}).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_UserGroup));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetProjectInfoList(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
var data_ProjectInfoService = BLLContainer.Resolve <IData_ProjectInfoService>(resolveNew: true);
var dict_SystemService = BLLContainer.Resolve <IDict_SystemService>(resolveNew: true);
int FeeTypeId = dict_SystemService.GetModels(p => p.DictKey.Equals("计费方式")).FirstOrDefault().ID;
var linq = from a in data_ProjectInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.ProjectStatus == 1)
join b in dict_SystemService.GetModels(p => p.PID == FeeTypeId) on(a.FeeType + "") equals b.DictValue into b1
from b in b1.DefaultIfEmpty()
select new
{
ID = a.ID,
ProjectName = a.ProjectName,
ProjectStatusStr = a.ProjectStatus == 1 ? "有效" : "无效",
FeeCycle = a.FeeCycle,
FeeDeposit = a.FeeDeposit,
SignOutEnStr = a.SignOutEN == 1 ? "需要签出" : "单次扣费",
WhenLockStr = a.WhenLock == 1 ? "是" : "否",
RegretTime = a.RegretTime,
Note = a.Note,
FeeTypeStr = b != null ? b.DictKey : string.Empty
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, linq.ToList()));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object checkOpenCard(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty;
if (!userTokenDataModel.StoreId.Equals(storeId))
{
ResponseModel responseModel = new ResponseModel(Return_Code.T, "", Result_Code.F, "门店信息不正确");
return(responseModel);
}
string storedProcedure = "CheckStoreCanOpenCard";
SqlParameter[] sqlParameter = new SqlParameter[4];
sqlParameter[0] = new SqlParameter("@StoreId", SqlDbType.VarChar, 15);
sqlParameter[0].Value = storeId;
sqlParameter[1] = new SqlParameter("@Mobile", SqlDbType.VarChar, 11);
sqlParameter[1].Value = mobile;
sqlParameter[2] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200);
sqlParameter[2].Direction = ParameterDirection.Output;
sqlParameter[3] = new SqlParameter("@Return", SqlDbType.Int);
sqlParameter[3].Direction = ParameterDirection.ReturnValue;
XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, sqlParameter);
if (sqlParameter[3].Value.ToString() == "1")
{
return(new ResponseModel(Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(new ResponseModel(Return_Code.T, "", Result_Code.F, sqlParameter[2].Value.ToString()));
}
}
public object getMember(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
if (string.IsNullOrEmpty(icCardId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡号无效"));
}
if (string.IsNullOrEmpty(storeId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号无效"));
}
string storedProcedure = "GetMember";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@ICCardID", icCardId);
parameters[1] = new SqlParameter("@StoreID", storeId);
parameters[2] = new SqlParameter("@Result", SqlDbType.Int);
parameters[2].Direction = System.Data.ParameterDirection.Output;
parameters[3] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200);
parameters[3].Direction = System.Data.ParameterDirection.Output;
System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, parameters);
if (parameters[2].Value.ToString() == "1")
{
var baseMemberModel = Utils.GetModelList <BaseMemberModel>(ds.Tables[0]).ToList()[0];
return(ResponseModelFactory <BaseMemberModel> .CreateModel(isSignKeyReturn, baseMemberModel));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员信息不存在"));
}
public object GetGameHeadInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string gameIndexId = dicParas.ContainsKey("gameIndexId") ? Convert.ToString(dicParas["gameIndexId"]) : string.Empty;
int iGameIndexId = 0;
int.TryParse(gameIndexId, out iGameIndexId);
IData_HeadService data_HeadService = BLLContainer.Resolve <IData_HeadService>();
Dictionary <int, string> gameHeadInfo = data_HeadService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.GameIndexID == iGameIndexId).Select(o => new
{
ID = o.ID,
HeadName = o.HeadName
}).Distinct().ToDictionary(d => d.ID, d => d.HeadName);
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, gameHeadInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getFoodDetail(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string foodId = dicParas.ContainsKey("foodId") ? dicParas["foodId"].ToString() : string.Empty;
if (string.IsNullOrEmpty(foodId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "套餐名不能为空"));
}
string sql = "exec GetFoodDetail @StoreId,@FoodId ";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId);
parameters[1] = new SqlParameter("@FoodId", foodId);
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
List <FoodDetailModel> list1 = Utils.GetModelList <FoodDetailModel>(ds.Tables[0]).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
}
public object GetMemberDic(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
IBase_StoreInfoService base_StoreInfoService = BLLContainer.Resolve <IBase_StoreInfoService>(resolveNew: true);
IBase_MemberInfoService base_MemberInfoService = BLLContainer.Resolve <IBase_MemberInfoService>(resolveNew: true);
IData_Member_CardService data_Member_CardService = BLLContainer.Resolve <IData_Member_CardService>(resolveNew: true);
IData_Member_Card_StoreService data_Member_Card_StoreService = BLLContainer.Resolve <IData_Member_Card_StoreService>(resolveNew: true);
var linq = from a in base_StoreInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase))
join b in data_Member_Card_StoreService.GetModels() on a.StoreID equals b.StoreID
join c in data_Member_CardService.GetModels() on b.CardID equals c.ID
join d in base_MemberInfoService.GetModels() on c.MemberID equals d.ID
select new
{
MemberID = d.ID,
MemberName = d.UserName
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, linq));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryWorkstation(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.* from Data_Workstation a where a.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_WorkstationService data_WorkstationService = BLLContainer.Resolve <IData_WorkstationService>();
var data_Workstation = data_WorkstationService.SqlQuery(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Workstation));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryJackpotInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[1];
string sqlWhere = string.Empty;
parameters[0] = new SqlParameter("@MerchId", merchId);
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.* from Data_JackpotInfo a where a.MerchInfo=@MerchId";
sql = sql + sqlWhere;
IData_JackpotInfoService data_JackpotInfoService = BLLContainer.Resolve <IData_JackpotInfoService>();
var data_JackpotInfo = data_JackpotInfoService.SqlQuery <Data_JackpotInfo>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_JackpotInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetMemberLevelInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string memberLevelID = dicParas.ContainsKey("memberLevelID") ? dicParas["memberLevelID"].ToString() : string.Empty;
if (string.IsNullOrEmpty(memberLevelID))
{
errMsg = "会员级别ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iMemberLevelID = Convert.ToInt32(memberLevelID);
IData_MemberLevelService data_MemberLevelService = BLLContainer.Resolve <IData_MemberLevelService>();
if (!data_MemberLevelService.Any(a => a.MemberLevelID == iMemberLevelID))
{
errMsg = "该会员级别不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var data_MemberLevelModel = data_MemberLevelService.GetModels(p => p.MemberLevelID == iMemberLevelID).FirstOrDefault();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_MemberLevelModel));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getOrderContain(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string orderFlwId = dicParas.ContainsKey("orderFlwId") ? dicParas["orderFlwId"].ToString() : string.Empty;
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
if (string.IsNullOrEmpty(orderFlwId))
{
return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单Id参数无效"));
}
string storedProcedure = "GetOrderContainById";
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@StoreId", SqlDbType.VarChar);
sqlParameter[0].Value = userTokenDataModel.StoreId;
sqlParameter[1] = new SqlParameter("@OrderFlwId", SqlDbType.Int);
sqlParameter[1].Value = orderFlwId;
System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, sqlParameter);
if (ds != null && ds.Tables.Count == 2 && ds.Tables[0].Rows.Count > 0)
{
OrderMainModel main = Utils.GetModelList <OrderMainModel>(ds.Tables[0]).ToList()[0];
List <OrderDetailModel> detail = Utils.GetModelList <OrderDetailModel>(ds.Tables[1]).ToList();
OrderInfoModel model = new OrderInfoModel(main, detail);
return(ResponseModelFactory.CreateSuccessModel <OrderInfoModel>(isSignKeyReturn, model));
}
else
{
return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单信息不存在"));
}
}
public object QueryPushRule(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.GameID, b.GameName, a.ID, a.MemberLevelName, a.Week, a.Allow_Out, a.Allow_In, a.Coin, a.Level, a.StartTime as ST, a.EndTime as ET from Data_Push_Rule a " +
" inner join Data_GameInfo b on a.GameIndexID=b.ID " +
" where b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>();
var data_Push_Rule = data_Push_RuleService.SqlQuery <Data_Push_RuleList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Push_Rule));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getFoodList(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string customerType = dicParas.ContainsKey("customerType") ? dicParas["customerType"].ToString() : string.Empty;
string memberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty;
string foodTypeStr = dicParas.ContainsKey("foodTypeStr") ? dicParas["foodTypeStr"].ToString() : string.Empty;
if (string.IsNullOrEmpty(memberLevelId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员等级无效"));
}
string sql = "exec GetFoodListInfo @StoreId,@CustomerType,@MemberLevelId,@FoodTypeStr ";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId);
parameters[1] = new SqlParameter("@CustomerType", customerType);
parameters[2] = new SqlParameter("@MemberLevelId", memberLevelId);
parameters[3] = new SqlParameter("@FoodTypeStr", foodTypeStr);
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
List <FoodInfoModel> list1 = Utils.GetModelList <FoodInfoModel>(ds.Tables[0]).ToList();
for (int i = 0; i < list1.Count; i++)
{
List <FoodInfoPriceModel> listFoodInfoPriceModel = new List <FoodInfoPriceModel>();
FoodInfoPriceModel foodInfoModel = new FoodInfoPriceModel(0, list1[i].FoodPrice);
listFoodInfoPriceModel.Add(foodInfoModel);
if (list1[i].AllowCoin == 1)
{
foodInfoModel = new FoodInfoPriceModel(1, list1[i].Coins);
listFoodInfoPriceModel.Add(foodInfoModel);
}
if (list1[i].AllowPoint == 1)
{
foodInfoModel = new FoodInfoPriceModel(2, list1[i].Points);
listFoodInfoPriceModel.Add(foodInfoModel);
}
if (list1[i].AllowLottery == 1)
{
foodInfoModel = new FoodInfoPriceModel(3, list1[i].Lottery);
listFoodInfoPriceModel.Add(foodInfoModel);
}
list1[i].priceListModel = listFoodInfoPriceModel;
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
public object GetDigitDestroy(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string destroyTime = dicParas.ContainsKey("destroyTime") ? (dicParas["destroyTime"] + "") : string.Empty;
string iCardID = dicParas.ContainsKey("iCardID") ? (dicParas["iCardID"] + "") : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
if (!string.IsNullOrEmpty(destroyTime))
{
try
{
Convert.ToDateTime(destroyTime);
}
catch
{
errMsg = "销毁时间参数格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
IData_DigitCoinDestroyService data_DigitCoinDestroyService = BLLContainer.Resolve <IData_DigitCoinDestroyService>();
var query = data_DigitCoinDestroyService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase));
if (!string.IsNullOrEmpty(destroyTime))
{
var dt = Convert.ToDateTime(destroyTime);
query = query.Where(w => DbFunctions.DiffDays(w.DestroyTime, dt) == 0);
}
if (!string.IsNullOrEmpty(iCardID))
{
query = query.Where(w => w.ICCardID.Contains(iCardID));
}
IBase_UserInfoService base_UserInfoService = BLLContainer.Resolve <IBase_UserInfoService>();
var linq = base_UserInfoService.GetModels(p => p.UserType == (int)UserType.Store).Select(o => new { UserID = o.UserID, LogName = o.LogName, RealName = o.RealName });
var result = query.ToList().Select(o => new
{
ID = o.ID,
StoreID = o.StoreID,
ICardID = o.ICCardID,
DestroyTime = o.DestroyTime,
UserID = o.UserID,
Note = o.Note,
LogName = linq.SingleOrDefault(p => p.UserID == o.UserID).LogName,
RealName = linq.SingleOrDefault(p => p.UserID == o.UserID).RealName
});
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result.ToList()));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object DelMerch(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string merchId = dicParas.ContainsKey("merchId") ? dicParas["merchId"].ToString() : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string createUserId = userTokenKeyModel.LogId;
#region 验证参数
if (string.IsNullOrWhiteSpace(merchId))
{
errMsg = "商户编号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(merchId) && merchId.Length > 11)
{
errMsg = "商户编号不能超过11个字符";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
IBase_MerchantInfoService base_MerchantInfoService = BLLContainer.Resolve <IBase_MerchantInfoService>();
if (base_MerchantInfoService.Any(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)))
{
var base_MerchantInfoModel = base_MerchantInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (base_MerchantInfoModel.CreateType == (int)CreateType.Agent && !base_MerchantInfoModel.CreateUserID.Equals(createUserId, StringComparison.OrdinalIgnoreCase)) //代理商创建
{
errMsg = "该商户只有所属代理商能删除";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
base_MerchantInfoModel.MerchStatus = (int)MerchState.Stop;
if (!base_MerchantInfoService.Update(base_MerchantInfoModel))
{
errMsg = "删除商户信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
else
{
errMsg = "该商户信息不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//更新缓存
MerchBusiness.Init();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetBindDeviceList(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string type = dicParas.ContainsKey("type") ? (dicParas["type"] + "") : string.Empty;
string mcuId = dicParas.ContainsKey("mcuId") ? (dicParas["mcuId"] + "") : string.Empty;
var bindDeviceIDs = dicParas.ContainsKey("bindDeviceIDs") ? ((object[])dicParas["bindDeviceIDs"]).Cast <int>() : null;
if (!string.IsNullOrEmpty(type) && !Utils.isNumber(type))
{
errMsg = "设备类型格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserInfo).Namespace);
var data_Project_Device = from a in dbContext.Set <Data_Project_Device>()
join b in dbContext.Set <Data_ProjectInfo>() on a.ProjectID equals b.ID
where b.ProjectStatus == 1
select a.DeviceID;
var base_DeviceInfo = dbContext.Set <Base_DeviceInfo>().Where(p => p.DeviceStatus == (int)DeviceStatus.Normal && p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && !data_Project_Device.Contains(p.ID));
if (!string.IsNullOrEmpty(type))
{
int iType = Convert.ToInt32(type);
base_DeviceInfo = base_DeviceInfo.Where(w => w.type == iType);
}
if (!string.IsNullOrEmpty(mcuId))
{
base_DeviceInfo = base_DeviceInfo.Where(w => w.MCUID.Contains(mcuId));
}
if (bindDeviceIDs != null)
{
base_DeviceInfo = base_DeviceInfo.Where(w => !bindDeviceIDs.Contains(w.ID));
}
int DeviceTypeId = dbContext.Set <Dict_System>().Where(p => p.DictKey.Equals("设备类型")).FirstOrDefault().ID;
var linq = from a in base_DeviceInfo
join b in dbContext.Set <Dict_System>().Where(p => p.PID == DeviceTypeId) on(a.type + "") equals b.DictValue into b1
from b in b1.DefaultIfEmpty()
select new
{
ID = a.ID,
DeviceName = a.DeviceName,
typeStr = b != null ? b.DictKey : string.Empty,
MCUID = a.MCUID
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, linq.ToList()));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetUnChainStoreList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
string ruleType = dicParas.ContainsKey("ruleType") ? (dicParas["ruleType"] + "") : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(ruleType))
{
errMsg = "规则类别不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(ruleType))
{
errMsg = "规则类别格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iRuleType = Convert.ToInt32(ruleType);
IBase_StoreInfoService base_StoreInfoService = BLLContainer.Resolve <IBase_StoreInfoService>(resolveNew: true);
IBase_ChainRuleService base_ChainRuleService = BLLContainer.Resolve <IBase_ChainRuleService>(resolveNew: true);
IBase_ChainRule_StoreService base_ChainRule_StoreService = BLLContainer.Resolve <IBase_ChainRule_StoreService>(resolveNew: true);
var result = from a in base_StoreInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase))
join b in
(
from a in base_ChainRuleService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase) && p.RuleType == iRuleType)
join b in base_ChainRule_StoreService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) on a.RuleGroupID equals b.RuleGroupID
join c in base_ChainRule_StoreService.GetModels() on b.RuleGroupID equals c.RuleGroupID
select c
) on a.StoreID equals b.StoreID into b1
from b in b1.DefaultIfEmpty()
where string.IsNullOrEmpty(b.StoreID)
select new
{
StoreID = a.StoreID,
StoreName = a.StoreName
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetUserGroup(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string errMsg = string.Empty;
string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty;
if (string.IsNullOrEmpty(groupId))
{
errMsg = "groupId参数不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
string sql = string.Empty;
SqlParameter[] parameters = new SqlParameter[0];
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
string merchId = userTokenKeyModel.DataModel.MerchID;
sql = " exec SelectUserGroupGrant @GroupID,@MerchID";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@GroupID", groupId);
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@MerchID", merchId);
}
else if (userTokenKeyModel.LogType == (int)RoleType.XcAdmin)
{
sql = " exec SelectFunctionForXA @GroupID";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@GroupID", groupId);
}
//返回商户信息和功能菜单信息
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
if (ds.Tables.Count != 2)
{
errMsg = "获取数据异常";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//实例化一个根节点
var userGroupModel = Utils.GetModelList <UserGroupModel>(ds.Tables[0]).FirstOrDefault() ?? new UserGroupModel();
UserGroupGrantModel rootRoot = new UserGroupGrantModel();
rootRoot.ParentID = 0;
TreeHelper.LoopToAppendChildren(Utils.GetModelList <UserGroupGrantModel>(ds.Tables[1]), rootRoot);
userGroupModel.UserGroupGrants = rootRoot.Children;
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, userGroupModel));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryFreeRule(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select c.ID, b.GameID, b.GameName, d.MemberLevelName as MemberLevelName, (case c.RuleType when 0 then '模拟机' when 1 then '博彩机' else '' end) as RuleTypeStr, " +
" c.NeedCoin, c.FreeCoin, c.ExitCoin, c.StartTime as ST, c.EndTime as ET, c.State from Data_GameFreeRule_List a " +
" inner join Data_GameInfo b on a.GameIndexID=b.ID " +
" inner join Data_GameFreeRule c on a.RuleID=c.ID " +
" left join Data_MemberLevel d on c.MemberLevelID=d.MemberLevelID" +
" where b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_GameFreeRuleService data_GameFreeRuleService = BLLContainer.Resolve <IData_GameFreeRuleService>();
var data_GameFreeRule = data_GameFreeRuleService.SqlQuery <Data_GameFreeRuleList>(sql, parameters).ToList();
var linq = from a in data_GameFreeRule
group a by new { ID = a.ID } into g
select new {
g.Key.ID,
GameID = string.Join("|", g.Select(p => p.GameID)),
GameName = string.Join("|", g.Select(p => p.GameName)),
MemberLevelName = g.Max(p => p.MemberLevelName),
RuleTypeStr = g.Max(p => p.RuleTypeStr),
NeedCoin = g.Max(p => p.NeedCoin),
FreeCoin = g.Max(p => p.FreeCoin),
ExitCoin = g.Max(p => p.ExitCoin),
StartTime = g.Max(p => p.StartTime),
EndTime = g.Max(p => p.EndTime),
State = g.Max(p => p.State)
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, linq));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetMerchList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
//代理商仅能查所属商户，普通商户或大客户只能查自己，莘宸管理员可以查所有商户
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
var merchIdDataModel = userTokenKeyModel.DataModel as MerchDataModel;
Array.Resize(ref parameters, parameters.Length + 1);
if (merchIdDataModel.MerchType == (int)MerchType.Agent)
{
parameters[parameters.Length - 1] = new SqlParameter("@logId", userTokenKeyModel.LogId);
sqlWhere = sqlWhere + " and a.CreateUserID=@logId";
}
else
{
parameters[parameters.Length - 1] = new SqlParameter("@merchId", merchIdDataModel.MerchID);
sqlWhere = sqlWhere + " and a.MerchID=@merchId";
}
}
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.MerchID, a.MerchName, a.Mobil, b.DictKey as MerchTypeStr, a.MerchAccount, d.DictKey as AllowCreateSubStr, a.AllowCreateCount, c.DictKey as MerchStatusStr from Base_MerchantInfo a " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户类别' and a.PID=0) b on convert(varchar, a.MerchType)=b.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户状态' and a.PID=0) c on convert(varchar, a.MerchStatus)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='创建子账号' and a.PID=0) d on convert(varchar, a.AllowCreateSub)=d.DictValue " +
" where 1=1 ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_MerchantInfo).Namespace);
var base_MerchantInfo = dbContext.Database.SqlQuery <Base_MerchantInfoListModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_MerchantInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object AddCoinStorage(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storageCount = dicParas.ContainsKey("storageCount") ? (dicParas["storageCount"] + "") : string.Empty;
string note = dicParas.ContainsKey("note") ? (dicParas["note"] + "") : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
int userId = Convert.ToInt32(userTokenKeyModel.LogId);
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
if (string.IsNullOrEmpty(storageCount))
{
errMsg = "入库数量不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(storageCount))
{
errMsg = "入库数量参数格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iStorageCount = Convert.ToInt32(storageCount);
if (iStorageCount < 0)
{
errMsg = "入库数量必不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
IData_CoinStorageService data_CoinStorageService = BLLContainer.Resolve <IData_CoinStorageService>();
Data_CoinStorage data_CoinStorage = new Data_CoinStorage();
data_CoinStorage.DestroyTime = DateTime.Now;
data_CoinStorage.Note = note;
data_CoinStorage.StorageCount = iStorageCount;
data_CoinStorage.UserID = userId;
data_CoinStorage.StoreID = storeId;
if (!data_CoinStorageService.Add(data_CoinStorage))
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getMemberLevel(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string storedProcedure = "GetMemberLevel";
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId);
System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, parameters);
List <Data_MemberLevelModel> list = Utils.GetModelList <Data_MemberLevelModel>(ds.Tables[0]);
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list));
}
public object getMemberOpenCardFoodInfo(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel);
string MemberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty;
string sql = "exec GetMemberOpenCardFoodInfo @StoreId,@MemberLevelId";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId);
parameters[1] = new SqlParameter("@MemberLevelId", MemberLevelId);
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
List <OpenCardFoodInfoModel> list1 = Utils.GetModelList <OpenCardFoodInfoModel>(ds.Tables[0]).ToList();
//for (int i = 0; i < list1.Count; i++)
//{
// List<FoodInfoPriceModel> listFoodInfoPriceModel = new List<FoodInfoPriceModel>();
// FoodInfoPriceModel foodInfoModel = new FoodInfoPriceModel(0, list1[i].FoodPrice);
// listFoodInfoPriceModel.Add(foodInfoModel);
// if (list1[i].AllowCoin == 1)
// {
// foodInfoModel = new FoodInfoPriceModel(1, list1[i].Coins);
// listFoodInfoPriceModel.Add(foodInfoModel);
// }
// if (list1[i].AllowPoint == 1)
// {
// foodInfoModel = new FoodInfoPriceModel(2, list1[i].Points);
// listFoodInfoPriceModel.Add(foodInfoModel);
// }
// if (list1[i].AllowLottery == 1)
// {
// foodInfoModel = new FoodInfoPriceModel(3, list1[i].Lottery);
// listFoodInfoPriceModel.Add(foodInfoModel);
// }
// list1[i].priceListModel = listFoodInfoPriceModel;
//}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
public object getMemberRepeatCode(Dictionary <string, object> dicParas)
{
XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]);
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
if (string.IsNullOrEmpty(storeId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号不能为空"));
}
StoreInfoCacheModel storeInfo = null;
if (!XCCloudStoreBusiness.IsEffectiveStore(storeId, ref storeInfo))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号无效"));
}
if (string.IsNullOrEmpty(icCardId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡号无效"));
}
//获取会员信息
string storedProcedure = "GetMemberRepeatCode";
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@ICCardID", icCardId);
parameters[1] = new SqlParameter("@StoreID", storeId);
parameters[2] = new SqlParameter("@RepeatCode", SqlDbType.Int);
parameters[2].Direction = System.Data.ParameterDirection.Output;
parameters[3] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200);
parameters[3].Direction = System.Data.ParameterDirection.Output;
parameters[4] = new SqlParameter("@Return", SqlDbType.Int);
parameters[4].Direction = System.Data.ParameterDirection.ReturnValue;
XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, parameters);
if (parameters[4].Value.ToString() == "1")
{
var obj = new {
repeatCode = parameters[2].Value.ToString()
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡无效"));
}
}
public static string SetUserToken(string logId, int logType, TokenDataModel dataModel = null)
{
//设置用户token
string newToken = System.Guid.NewGuid().ToString("N");
string token = string.Empty;
if (GetUserTokenModel(logId, logType, out token))
{
XCCloudUserTokenCache.Remove(token);
}
XCCloudUserTokenModel tokenModel = new XCCloudUserTokenModel(logId, Utils.ConvertDateTimeToLong(DateTime.Now), logType, dataModel);
XCCloudUserTokenCache.AddToken(newToken, tokenModel);
return(newToken);
}
public object GetDigitCoin(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
IData_DigitCoinService data_DigitCoinService = BLLContainer.Resolve <IData_DigitCoinService>();
var data_DigitCoin = data_DigitCoinService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.Status != (int)DigitStatus.Cancel).OrderBy(or => or.ICardID).Select(o => o.ICardID).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_DigitCoin));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetJackpotDic(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
IData_JackpotInfoService data_JackpotInfoService = BLLContainer.Resolve <IData_JackpotInfoService>();
Dictionary <int, string> pJackpotList = data_JackpotInfoService.GetModels(p => p.MerchInfo.Equals(merchId, StringComparison.OrdinalIgnoreCase))
.Select(o => new { ID = o.ID, ActiveName = o.ActiveName }).Distinct()
.ToDictionary(d => d.ID, d => d.ActiveName);
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, pJackpotList));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetOrders(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@merchId", merchId);
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "b.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.ID, a.StoreID, a.StoreName, b.OrderID, b.FoodCount, b.OrderSource, b.CreateTime, b.PayType, b.OrderStatus," +
" c.DictKey as OrderSourceStr, d.DictKey as PayTypeStr, e.DictKey as OrderStatusStr, f.FoodName from Base_StoreInfo a " +
" inner join Flw_Order b on a.StoreID=b.StoreID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单来源' and a.PID=0) c on convert(varchar, b.OrderSource)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='支付通道' and a.PID=0) d on convert(varchar, b.PayType)=d.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单状态' and a.PID=0) e on convert(varchar, b.OrderStatus)=e.DictValue " +
" left join (select top 1 a.ID as OrderFlwID, d.FoodName from Flw_Order a inner join Flw_Order_Detail b on a.ID=b.OrderFlwID " +
" inner join Flw_Food_Sale c on b.FoodFlwID=c.ID " +
" inner join Data_FoodInfo d on c.FoodID=d.FoodID) f on b.ID=f.OrderFlwID " +
" where a.MerchID=@merchId ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Flw_Order).Namespace);
var flw_Orders = dbContext.Database.SqlQuery <Flw_OrdersModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, flw_Orders));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetNodes(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string merchId = dicParas.ContainsKey("merchId") ? dicParas["merchId"].ToString() : string.Empty;
string dictKey = dicParas.ContainsKey("dictKey") ? dicParas["dictKey"].ToString() : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
merchId = userTokenKeyModel.DataModel.MerchID;
}
string sql = " exec SP_DictionaryNodes @MerchID,@DictKey,@RootID output ";
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@MerchID", merchId);
parameters[1] = new SqlParameter("@DictKey", dictKey);
parameters[2] = new SqlParameter("@RootID", 0);
parameters[2].Direction = System.Data.ParameterDirection.Output;
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
if (ds.Tables.Count == 0)
{
errMsg = "没有找到节点信息";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dictionaryResponse = Utils.GetModelList <DictionaryResponseModel>(ds.Tables[0]).ToList();
int rootId = 0;
int.TryParse(parameters[2].Value.ToString(), out rootId);
//实例化一个根节点
DictionaryResponseModel rootRoot = new DictionaryResponseModel();
rootRoot.ID = rootId;
TreeHelper.LoopToAppendChildren(dictionaryResponse, rootRoot);
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, rootRoot.Children));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
