public object deviceControl(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string token = dicParas.ContainsKey("token") ? dicParas["token"].ToString() : string.Empty;
string mcuid = dicParas.ContainsKey("mcuid") ? dicParas["mcuid"].ToString() : string.Empty;
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
string action = dicParas.ContainsKey("controlAction") ? dicParas["controlAction"].ToString() : string.Empty;
string coins = dicParas.ContainsKey("coins") ? dicParas["coins"].ToString() : string.Empty;
UDPClientItemBusiness.ClientItem item = XCCloudService.SocketService.UDP.ClientList.ClientListObj.Where <UDPClientItemBusiness.ClientItem>(p => p.gID.Equals(token)).FirstOrDefault <UDPClientItemBusiness.ClientItem>();
if (item == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "雷达token不存在"));
}
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeCacheModel = null;
if (!storeBusiness.IsEffectiveStore(item.StoreID, ref storeCacheModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店不存在"));
}
IMemberService memberService = BLLContainer.Resolve <IMemberService>(storeCacheModel.StoreDBName);
var memberlist = memberService.GetModels(x => x.ICCardID.ToString() == icCardId).FirstOrDefault <t_member>();
if (memberlist == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机号码无效"));
}
//判断设备状态是否为启用状态
XCCloudService.BLL.IBLL.XCGame.IDeviceService ids = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IDeviceService>(storeCacheModel.StoreDBName);
var menlist = ids.GetModels(p => p.MCUID.Equals(mcuid, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.t_device>();
if (menlist == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备不存在"));
}
if (menlist.state != "启用")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备未启用"));
}
string sn = UDPSocketAnswerBusiness.GetSN();
string orderId = System.Guid.NewGuid().ToString("N");
DeviceControlRequestDataModel deviceControlModel = new DeviceControlRequestDataModel(item.StoreID, memberlist.Mobile, icCardId, item.Segment, mcuid, action, int.Parse(coins), sn, orderId, storeCacheModel.StorePassword, 0, "");
MPOrderBusiness.AddTCPAnswerOrder(orderId, memberlist.Mobile, int.Parse(coins), action, icCardId, item.StoreID);
if (!DataFactory.SendDataToRadar(deviceControlModel, out errMsg))
{
ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.F, "", Result_Code.T, errMsg);
}
var obj = new { orderId = orderId, sn = sn };
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
public object radarHeat(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string token = dicParas.ContainsKey("token") ? dicParas["token"].ToString() : string.Empty;
UDPClientItemBusiness.ClientItem item = XCCloudService.SocketService.UDP.ClientList.ClientListObj.Where <UDPClientItemBusiness.ClientItem>(p => p.gID.Equals(token)).FirstOrDefault <UDPClientItemBusiness.ClientItem>();
if (item == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "雷达token不存在"));
}
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeCacheModel = null;
if (!storeBusiness.IsEffectiveStore(item.StoreID, ref storeCacheModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店不存在"));
}
ClientService service = new ClientService();
service.Connection();
RadarHeartbeatRequestDataModel dataModel = new RadarHeartbeatRequestDataModel(token, "");
byte[] data = DataFactory.CreateRequesProtocolData(TransmiteEnum.雷达心跳, dataModel);
service.Send(data);
var obj = new { token = token };
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
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 getMobileToken(Dictionary <string, object> dicParas)
{
try
{
string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString().Trim() : "";
string smsCode = dicParas.ContainsKey("smsCode") ? dicParas["smsCode"].ToString().Trim() : "";
string key = mobile + "_" + smsCode;
if (!FilterMobileBusiness.IsTestSMS)
{
if (!SMSCodeCache.IsExist(key))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "短信验证码无效"));
}
}
if (SMSCodeCache.IsExist(key))
{
SMSCodeCache.Remove(key);
}
string token = MobileTokenBusiness.SetMobileToken(mobile);
MobileTokenResponseModel tokenModel = new MobileTokenResponseModel(mobile, token);
return(ResponseModelFactory <MobileTokenResponseModel> .CreateModel(isSignKeyReturn, tokenModel));
}
catch (Exception e)
{
throw e;
}
}
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 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 login(Dictionary <string, object> dicParas)
{
string userMobile = dicParas.ContainsKey("userMobile") ? dicParas["userMobile"].ToString() : string.Empty;
string password = dicParas.ContainsKey("password") ? dicParas["password"].ToString() : string.Empty;
string imgCode = dicParas.ContainsKey("imgCode") ? dicParas["imgCode"].ToString() : string.Empty;
//验证码
if (!ValidateImgCache.Exist(imgCode.ToUpper()))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "验证码无效"));
}
ValidateImgCache.Remove(imgCode.ToUpper());
IAdminUserService adminUserService = BLLContainer.Resolve <IAdminUserService>();
var model = adminUserService.GetModels(p => p.Mobile.Equals(userMobile)).FirstOrDefault <t_AdminUser>();
if (model == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户不存在"));
}
else
{
if (model.Password.Equals(password))
{
string token = XCGameManaAdminUserTokenBusiness.SetToken(model.Mobile, model.Id);
var obj = new { token = token };
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "密码不正确"));
}
}
}
public object addTicket(Dictionary <string, object> dicParas)
{
StoreCacheModel storeCacheModel = null;
string errMsg = string.Empty;
string tickets = dicParas.ContainsKey("tickets") ? dicParas["tickets"].ToString() : string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
XCCloudService.Business.XCGameMana.StoreBusiness storeBusiness = new XCCloudService.Business.XCGameMana.StoreBusiness();
XCCloudService.BLL.IBLL.XCGameManager.ITicketService ticketService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGameManager.ITicketService>();
if (storeBusiness.IsEffectiveStore(storeId, ref storeCacheModel, out errMsg))
{
string[] ticketArr = tickets.Split(',');
for (int i = 0; i < ticketArr.Length; i++)
{
string curTicketNo = ticketArr[i];
if (ticketService.GetModels(p => p.StoreId.Equals(storeId) && p.TicketNo.Equals(curTicketNo)).Count <t_ticket>() == 0)
{
t_ticket ticket = new t_ticket();
ticket.TicketNo = ticketArr[i];
ticket.StoreId = storeId;
ticket.CreateTime = System.DateTime.Now;
ticketService.Add(ticket);
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, ""));
}
else
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, ""));
}
}
public object GetUserGroup(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
int userId, authorId;
string workId = dicParas.ContainsKey("workId") ? dicParas["workId"].ToString() : string.Empty;
if (!checkParas(dicParas, out userId, out authorId, out errMsg))
{
LogHelper.SaveLog("错误:" + errMsg);
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
string sql = " exec SelectUserGroup @UserID";
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@UserID", userId);
System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters);
System.Data.DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
var list = Utils.GetModelList <Base_UserGroup>(ds.Tables[0]).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list));
}
else
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, "工作组列表为空"));
}
}
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 GetWxUserInfoBatch(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string nextOpenId = dicParas.ContainsKey("nextOpenId") ? dicParas["nextOpenId"].ToString() : string.Empty;
UserInfoCollection <UserInfoDetailModel> userInfoCollection = null;
if (!getWxFans <UserInfoDetailModel>("员工组", nextOpenId, out userInfoCollection, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (userInfoCollection != null && userInfoCollection.UserInfoList != null)
{
var subscribeusers = userInfoCollection.UserInfoList.Exists(p => p.Subscribe.Equals(1)) ?
userInfoCollection.UserInfoList.Where(w => w.Subscribe.Equals(1)).ToList <UserInfoDetailModel>() : default(List <UserInfoDetailModel>);
//绑定UserID
UserInfoCacheModel userInfoCacheModel = null;
foreach (var su in subscribeusers)
{
if (UserBusiness.IsEffectiveXcUser(su.OpenID, out userInfoCacheModel))
{
su.UserID = userInfoCacheModel.UserID;
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, subscribeusers));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
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 DelChainStore(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
if (string.IsNullOrEmpty(id))
{
errMsg = "门店连锁规则ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iId = Convert.ToInt32(id);
IBase_ChainRule_StoreService base_ChainRule_StoreService = BLLContainer.Resolve <IBase_ChainRule_StoreService>();
if (!base_ChainRule_StoreService.Any(a => a.ID == iId))
{
errMsg = "该门店连锁规则不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_ChainRule_StoreModel = base_ChainRule_StoreService.GetModels(p => p.ID == iId).FirstOrDefault();
if (!base_ChainRule_StoreService.Delete(base_ChainRule_StoreModel))
{
errMsg = "删除接收余额的门店失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object deleteGroup(Dictionary <string, object> dicParas)
{
try
{
string MobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; //获取手机令牌
string GroupID = dicParas.ContainsKey("groupID") ? dicParas["groupID"].ToString() : string.Empty; //获取分组ID
if (GroupID == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "分组ID不能为空"));
}
if (MobileToken == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机令牌不能为空"));
}
string mobile = string.Empty;
if (!MobileTokenBusiness.ExistToken(MobileToken, out mobile))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效"));
}
string sql = "exec deleteDataGameInfo @GroupID,@Return output";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@GroupID", GroupID);
parameters[1] = new SqlParameter("@Return", 0);
parameters[1].Direction = System.Data.ParameterDirection.Output;
XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
catch (Exception e)
{
throw e;
}
}
public object getGroup(Dictionary <string, object> dicParas)
{
try
{
string MobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; //获取手机令牌
string GroupID = dicParas.ContainsKey("groupID") ? dicParas["groupID"].ToString() : string.Empty; //获取分组ID
if (GroupID == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "分组ID不能为空"));
}
if (MobileToken == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机令牌不能为空"));
}
string mobile = string.Empty;
if (!MobileTokenBusiness.ExistToken(MobileToken, out mobile))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效"));
}
int GroupIDs = int.Parse(GroupID);
IDataGameInfoService dataGameInfoService = BLLContainer.Resolve <IDataGameInfoService>("XCCloudRS232");
var menlist = dataGameInfoService.GetModels(x => x.GroupID == GroupIDs).ToList <Data_GameInfo>();
if (menlist.Count > 0)
{
List <DataGameInfoModel> gameinfolist = Utils.GetCopyList <DataGameInfoModel, Data_GameInfo>(menlist);
return(ResponseModelFactory <List <DataGameInfoModel> > .CreateModel(isSignKeyReturn, gameinfolist));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
catch (Exception e)
{
throw e;
}
}
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 getUpdatePassWord(Dictionary <string, object> dicParas)
{
string UserToken = dicParas.ContainsKey("UserToken") ? dicParas["UserToken"].ToString() : string.Empty;
string PassWord = dicParas.ContainsKey("PassWord") ? dicParas["PassWord"].ToString() : string.Empty;
string NewsPassWord = dicParas.ContainsKey("NewsPassWord") ? dicParas["NewsPassWord"].ToString() : string.Empty;
if (string.IsNullOrEmpty(PassWord))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入密码"));
}
if (string.IsNullOrEmpty(NewsPassWord))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入新密码"));
}
string UserName = string.Empty;
//验证token
if (!MobileTokenBusiness.ExistToken(UserToken, out UserName))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户token无效"));
}
PassWord = Utils.MD5(PassWord);
IUserRegisterService userervice = BLLContainer.Resolve <IUserRegisterService>();
var menlist = userervice.GetModels(p => p.UserName == UserName && p.PassWord == PassWord).ToList();
if (menlist.Count > 0)
{
NewsPassWord = Utils.MD5(NewsPassWord);
menlist[0].PassWord = NewsPassWord;
userervice.Update(menlist[0]);
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "原密码输入有误"));
}
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 DeletePicture(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string fileName = dicParas.ContainsKey("fileName") ? dicParas["fileName"].ToString() : string.Empty;
if (fileName == null)
{
errMsg = "图片名称不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
string picturePath = System.Configuration.ConfigurationManager.AppSettings["UploadImageUrl"].ToString() + "/XCCloud/";
string path = System.Web.HttpContext.Current.Server.MapPath(picturePath);
IData_BillInfoService data_BillInfoService = BLLContainer.Resolve <IData_BillInfoService>();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@PicturePath", picturePath + fileName);
data_BillInfoService.ExecuteSqlCommand("update Data_BillInfo set PicturePath='' where PicturePath=@PicturePath", parameters);
if (File.Exists(path + fileName))
{
File.Delete(path + fileName);
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getLoginUser(Dictionary <string, object> dicParas)
{
string UserName = dicParas.ContainsKey("UserName") ? dicParas["UserName"].ToString() : string.Empty;
string PassWord = dicParas.ContainsKey("PassWord") ? dicParas["PassWord"].ToString() : string.Empty;
if (string.IsNullOrEmpty(UserName))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入用户名"));
}
if (string.IsNullOrEmpty(PassWord))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入密码"));
}
string Pass = Utils.MD5(PassWord);
IUserRegisterService userervice = BLLContainer.Resolve <IUserRegisterService>();
var menulist = userervice.GetModels(p => p.UserName == UserName && p.PassWord == Pass).ToList();
if (menulist.Count > 0)
{
if (menulist[0].State != 1)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该用户正在审核中"));
}
string key = UserName;
string token = System.Guid.NewGuid().ToString("N");
if (!MobileTokenCache.ExistTokenByKey(key))
{
MobileTokenCache.AddToken(key, token);
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, token, Result_Code.T, ""));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户名或密码有误"));
}
public object getDeviceInfo(Dictionary <string, object> dicParas)
{
try
{
// string MobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty;//获取手机令牌
// if (MobileToken == "")
// {
// return ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机令牌不能为空");
// }
// string mobile = string.Empty;
// if (!MobileTokenBusiness.ExistToken(MobileToken, out mobile))
// {
// return ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效");
// }
// mobile = mobile.Replace("RS232", "");
// string sql = "";
// sql = @"select b.SN,b.Token,b.DeviceName,b.Status from Base_DeviceInfo as b
// left join Base_MerchInfo as a on a.ID=b.MerchID where a.State='1' and DeviceType='0' and a.Mobile='" + mobile + "'";
// DataSet ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, null);
// DataTable dt = ds.Tables[0];
// if (dt.Rows.Count > 0)
// {
// var basedeviceinfolist = Utils.GetModelList<BaseDeviceInfoModel>(dt).ToList();
// BaseDeviceInfoModelList baseDeviceInfoModelList = new BaseDeviceInfoModelList();
// baseDeviceInfoModelList.Lists = basedeviceinfolist;
// return ResponseModelFactory<BaseDeviceInfoModelList>.CreateModel(isSignKeyReturn, baseDeviceInfoModelList);
// }
string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty;
Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken);
if (merch.IsNull())
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效"));
}
var list = DeviceBusiness.GetDeviceList().Where(t => t.MerchID == merch.ID && (DeviceTypeEnum)(int)t.DeviceType == DeviceTypeEnum.Router && t.Status == 1).ToList();
if (list.IsNull() || list.Count == 0)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
BaseDeviceInfoModelList baseDeviceInfoModelList = new BaseDeviceInfoModelList();
baseDeviceInfoModelList.Lists = new List <BaseDeviceInfoModel>();
foreach (var item in list)
{
BaseDeviceInfoModel model = new BaseDeviceInfoModel();
model.DeviceName = item.DeviceName ?? item.SN;
model.SN = item.SN;
model.Token = item.Token;
model.Status = DeviceStatusBusiness.GetDeviceState(item.Token);
baseDeviceInfoModelList.Lists.Add(model);
}
return(ResponseModelFactory <BaseDeviceInfoModelList> .CreateModel(isSignKeyReturn, baseDeviceInfoModelList));
}
catch (Exception e)
{
throw e;
}
}
public object getSAppUserSession(Dictionary <string, object> dicParas)
{
WeiXinSAppSessionModel sessionModel = null;
string errMsg = string.Empty;
string serverSessionKey = string.Empty;
string code = Utils.GetDictionaryValue <string>(dicParas, "code").ToString();
if (WeiXinUserMana.GetWeiXinSAppUserSession(code, ref sessionModel, out serverSessionKey, out errMsg))
{
var dataObj = new {
serverSessionKey = serverSessionKey
};
//openId写入t_mobileToken
try
{
MobileTokenModel mobileTokenModel = (MobileTokenModel)(dicParas[Constant.MobileTokenModel]);
MobileTokenBusiness.UpdateOpenId(mobileTokenModel.Mobile, sessionModel.OpenId);
}
catch
{
}
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, dataObj));
}
else
{
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, errMsg));
}
}
public object DelGoodsInfo(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
if (string.IsNullOrEmpty(id))
{
errMsg = "商品ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iId = Convert.ToInt32(id);
IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>();
if (!base_GoodsInfoService.Any(a => a.ID == iId))
{
errMsg = "该商品信息不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_GoodsInfo = base_GoodsInfoService.GetModels(p => p.ID == iId).FirstOrDefault();
base_GoodsInfo.Status = 0;
if (!base_GoodsInfoService.Update(base_GoodsInfo))
{
errMsg = "删除游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetGoodsInfo(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
if (string.IsNullOrEmpty(id))
{
errMsg = "商品ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iId = Convert.ToInt32(id);
IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>();
if (!base_GoodsInfoService.Any(a => a.ID == iId))
{
errMsg = "该商品信息不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var result = from a in base_GoodsInfoService.GetModels(p => p.ID == iId).FirstOrDefault().AsDictionary()
select new
{
name = a.Key,
value = a.Value
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, result));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object getStore(Dictionary <string, object> dicParas)
{
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
IStoreService storeService = BLLContainer.Resolve <IStoreService>();
var store = storeService.GetModels(p => p.id.ToString().Equals(storeId)).FirstOrDefault <t_store>();
if (store == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店不存在"));
}
else
{
var obj = new {
id = store.id,
companyname = store.companyname,
province = store.province,
address = store.address,
boss = store.boss,
phone = store.phone,
telphone = store.telphone,
client_level = store.client_level,
createtime = Convert.ToDateTime(store.createtime).ToString("yyyy-MM-dd HH:mm:ss"),
updatetime = Convert.ToDateTime(store.updatetime).ToString("yyyy-MM-dd HH:mm:ss"),
power_due_date = Convert.ToDateTime(store.power_due_date).ToString("yyyy-MM-dd"),
note = store.note,
parentid = store.parentid,
developer = store.developer,
store_password = store.store_password,
store_dbname = store.store_dbname,
wxfee = store.wxfee * 1000
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
}
public object getstorepassword(Dictionary <string, object> dicParas)
{
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string Dogid = dicParas.ContainsKey("dogid") ? dicParas["dogid"].ToString() : string.Empty;
StoreBusiness store = new StoreBusiness();
string xcGameDBName = string.Empty;
string password = string.Empty;
string errMsg = string.Empty;
if (!store.IsExistDog(storeId, Dogid))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "加密不合法"));
}
if (storeId == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "店号不能为空"));
}
if (!store.IsEffectiveStore(storeId, out xcGameDBName, out password, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
storeId = storeId.PadRight(8, '0');
string pass = Utils.EncryptDES(password, storeId);
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, pass));
}
public object removeStore(Dictionary <string, object> dicParas)
{
try
{
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
IStoreService storeService = BLLContainer.Resolve <IStoreService>();
var storeModel = storeService.GetModels(p => p.id.ToString().Equals(storeId)).FirstOrDefault <t_store>();
if (storeModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店不存在"));
}
if (storeService.Delete(storeModel))
{
List <StoreCacheModel> list = StoreCache.GetStore();
StoreCacheModel storeCacheModel = list.Where <StoreCacheModel>(p => p.StoreID == int.Parse(storeId)).FirstOrDefault <StoreCacheModel>();
if (storeCacheModel != null)
{
list.Remove(storeCacheModel);
}
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
catch (Exception e)
{
throw e;
}
}
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 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 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 static void Initialize(TestContext cont)
{
modelFactory = new ResponseModelFactory();
modelFactory.MapBothWays<Country, CountryResponseModel>();
modelFactory.MapBothWays<UserRating, HitmanRatingResponseModel>();
modelFactory.MapBothWays<Image, ImageResponseModel>();
modelFactory.MapBothWays<User, UserResponseModel>();
modelFactory.MapBothWays<UserRating, UserRatingResponseModel>();
Mapper.CreateMap<Contract, ContractResponseModel>()
.ForMember(c => c.HitmanId, opts => opts.MapFrom(c => c.HitmanId))
.ForMember(c => c.ClientId, opts => opts.MapFrom(c => c.ClientId))
.ForMember(c => c.Status, opts => opts.MapFrom(c => (int)c.Status));
MyWebApi.IsRegisteredWith(WebApiConfig.Register);
}
protected void Application_Start()
{
DatabaseConfig.Initialize();
GlobalConfiguration.Configure(WebApiConfig.Register);
var modelFactory = new ResponseModelFactory();
modelFactory.MapBothWays<Country, CountryResponseModel>();
modelFactory.MapBothWays<UserRating, HitmanRatingResponseModel>();
modelFactory.MapBothWays<Image, ImageResponseModel>();
modelFactory.MapBothWays<User, UserResponseModel>();
modelFactory.MapBothWays<UserRating, UserRatingResponseModel>();
Mapper.CreateMap<Contract, ContractResponseModel>()
.ForMember(c => c.HitmanId, opts => opts.MapFrom(c => c.HitmanId))
.ForMember(c => c.ClientId, opts => opts.MapFrom(c => c.ClientId))
.ForMember(c => c.Status, opts => opts.MapFrom(c => (int)c.Status))
.ForMember(c => c.TargetName, opts => opts.MapFrom(c => c.TargetName))
.ForMember(c => c.Location, opts => opts.MapFrom(c => c.Location));
}
