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 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 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 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 GetStoreSales(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string date = dicParas.ContainsKey("date") ? dicParas["date"].ToString() : string.Empty;
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
string searchType = dicParas.ContainsKey("searchType") ? dicParas["searchType"].ToString() : string.Empty;
//验证门店信息
StoreCacheModel storeModel = null;
StoreBusiness store = new StoreBusiness();
if (!store.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
string sn = UDPSocketStoreQueryAnswerBusiness.GetSN();
string radarToken = string.Empty;
if (!DataFactory.SendDataStoreQuery(storeId, date, sn, searchType, icCardId, storeModel.StorePassword, out radarToken, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
int whileCount = 0;
UDPSocketStoreQueryAnswerModel answerModel = null;
while (answerModel == null && whileCount <= 25)
{
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketStoreQueryAnswerBusiness.GetAnswerModel(sn, 2);
}
if (answerModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
List <StoreQueryResultNotifyTableData> list = (List <StoreQueryResultNotifyTableData>)(answerModel.Result);
if (list == null || list.Count == 0)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "营业数据不存在"));
}
else if (list[0].Key.Equals("查询结果") && list[0].Value.Equals("无此营业日期"))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "营业数据不存在"));
}
else
{
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, list));
}
}
public static bool GetParam(string storeId, string requestType, ref ParamQueryResultModel paramQueryResultModel, out string errMsg)
{
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeCacheModel = null;
if (!storeBusiness.IsEffectiveStore(storeId, ref storeCacheModel, out errMsg))
{
return(false);
}
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendDataParamQuery(sn, storeId, storeCacheModel.StorePassword, requestType, out radarToken, out errMsg))
{
}
else
{
return(false);
}
answerModel = null;
while (answerModel == null)
{
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
ParamQueryResultNotifyRequestModel model = (ParamQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
paramQueryResultModel = model.Result_Data;
return(true);
}
else
{
errMsg = model.Result_Msg;
return(false);
}
}
else
{
errMsg = "系统没有响应";
return(false);
}
}
public object radarRegister(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string segment = dicParas.ContainsKey("segment") ? dicParas["segment"].ToString() : string.Empty;
XCGameManaAdminUserTokenModel tokenModel = (XCGameManaAdminUserTokenModel)(dicParas[Constant.XCGameManamAdminUserToken]);
if (tokenModel == null)
{
errMsg = "用户没有授权";
return(false);
}
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeCacheModel = null;
if (!storeBusiness.IsEffectiveStore(storeId, ref storeCacheModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店不存在"));
}
ClientService service = new ClientService();
service.Connection();
RadarRegisterRequestDataModel dataModel = new RadarRegisterRequestDataModel(storeId, segment);
SignKeyHelper.SetSignKey(dataModel, storeCacheModel.StorePassword);
byte[] data = DataFactory.CreateRequesProtocolData(TransmiteEnum.雷达注册授权, dataModel);
service.Send(data);
System.Threading.Thread.Sleep(5000);
int count = 0;
UDPClientItemBusiness.ClientItem item = XCCloudService.SocketService.UDP.ClientList.ClientListObj.Where <UDPClientItemBusiness.ClientItem>(p => p.StoreID.Equals(storeId) && p.Segment.Equals(segment)).FirstOrDefault <UDPClientItemBusiness.ClientItem>();
while (item == null && count < 10)
{
item = XCCloudService.SocketService.UDP.ClientList.ClientListObj.Where <UDPClientItemBusiness.ClientItem>(p => p.StoreID.Equals(storeId) && p.Segment.Equals(segment)).FirstOrDefault <UDPClientItemBusiness.ClientItem>();
System.Threading.Thread.Sleep(1000);
count++;
}
if (item == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "注册失败"));
}
var obj = new { token = item.gID };
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
public bool IsEffectiveStore(string storeId, ref StoreCacheModel storeModel, out string errMsg)
{
errMsg = string.Empty;
List <StoreCacheModel> list = StoreCache.GetStore();
var model = list.Where <StoreCacheModel>(p => p.StoreID.ToString().Equals(storeId)).FirstOrDefault <StoreCacheModel>();
if (model == null)
{
errMsg = "门店信息不存在";
return(false);
}
else
{
storeModel = model;
return(true);
}
}
/// <summary>
/// 会员存币处理
/// </summary>
/// <param name="iccard"></param>
/// <param name="storeId"></param>
/// <param name="balance"></param>
/// <returns></returns>
public static bool PreservationBusiness(int iccard, int storeId, int balance, out int lastBalance, out string storeName, out string mobile)
{
string errMsg = string.Empty;
lastBalance = 0;
storeName = string.Empty;
mobile = string.Empty;
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeModel = null;
if (!storeBusiness.IsEffectiveStore(storeId.ToString(), ref storeModel, out errMsg))
{
errMsg = "门店信息不存在";
return(false);
}
storeName = storeModel.StoreName;
IMemberService memberService = BLLContainer.Resolve <IMemberService>(storeModel.StoreDBName);
var model = memberService.GetModels(p => p.ICCardID == iccard).FirstOrDefault <t_member>();
if (model == null)
{
errMsg = "未查询到该店的会员信息";
return(false);
}
int num = 0;
if (model.Balance == null)
{
num = 0;
}
else
{
num = (int)(model.Balance);
}
num += balance;
model.Balance = num;
lastBalance = (int)(model.Balance);
mobile = model.Mobile;
memberService.Update(model);
return(true);
}
public object foodsale(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeName = string.Empty;
string foodName = string.Empty;
string storePassword = string.Empty;
int icCardId = 0; //会员
int balance = 0; //币余额
int memberLevelId = 0; //会员级别
string state = string.Empty;
string stateName = string.Empty;
string mobile = string.Empty;
string segment = string.Empty;
string mcuId = string.Empty;
string storeId = string.Empty;
string deviceId = string.Empty;
int foodId = 0;
int deviceIdentityId = 0;
string terminalNo = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty;
string type = dicParas.ContainsKey("type") ? dicParas["type"].ToString() : string.Empty;
string paymentype = dicParas.ContainsKey("Paymentype") ? dicParas["Paymentype"].ToString() : string.Empty; //获取支付方式
string foodIdStr = dicParas.ContainsKey("foodid") ? dicParas["foodid"].ToString() : string.Empty; //获取支付方式
string money = dicParas.ContainsKey("money") ? dicParas["money"].ToString() : string.Empty;
string orderId = dicParas.ContainsKey("OrderID") ? dicParas["OrderID"].ToString() : string.Empty;
int coins = int.Parse(dicParas.ContainsKey("Coins") ? dicParas["Coins"].ToString() : string.Empty);
int foodNum = int.Parse(dicParas.ContainsKey("foodNum") ? dicParas["foodNum"].ToString() : "1");
int.TryParse(foodIdStr, out foodId);
XCGameMemberTokenModel memberTokenModel = (XCGameMemberTokenModel)(dicParas[Constant.XCGameMemberTokenModel]);
mobile = memberTokenModel.Mobile;
if (string.IsNullOrEmpty(orderId))
{
orderId = System.Guid.NewGuid().ToString("N");
}
if (type == "购币")
{
string xcGameDBName = string.Empty;
//根据终端号查询终端号是否存在
XCGameManaDeviceStoreType deviceStoreType;
if (!ExtendBusiness.checkXCGameManaDeviceInfo(terminalNo, out deviceStoreType, out storeId, out deviceId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "终端号不存在"));
}
//验证会员令牌的门店号和设备门店号
if (!memberTokenModel.StoreId.Equals(storeId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员令牌不能再此设备上操作"));
}
//验证门店信息和设备状态是否为启用状态
if (!ExtendBusiness.checkStoreDeviceInfo(deviceStoreType, storeId, deviceId, out segment, out mcuId, out xcGameDBName, out deviceIdentityId, out storePassword, out storeName, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证雷达设备缓存状态
if (!ExtendBusiness.checkRadarDeviceState(deviceStoreType, storeId, deviceId, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//获取会员信息
if (!ExtendBusiness.GetMemberInfo(deviceStoreType, mobile, xcGameDBName, out balance, out icCardId, out memberLevelId, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//购币
if (!BuyCoin(deviceStoreType, xcGameDBName, storeId, icCardId, memberLevelId, foodId, orderId, money, coins, balance, paymentype, deviceId, deviceIdentityId, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//请求雷达处理出币
if (!IConUtiltiy.DeviceOutputCoin(deviceStoreType, DevieControlTypeEnum.出币, storeId, mobile, icCardId, orderId, segment, mcuId, storePassword, foodId, coins, string.Empty, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//设置推送消息的缓存结构
string form_id = dicParas.ContainsKey("form_id") ? dicParas["form_id"].ToString() : string.Empty;
MemberFoodSaleNotifyDataModel dataModel = new MemberFoodSaleNotifyDataModel("购币", storeName, mobile, foodName, foodNum, icCardId, decimal.Parse(money), coins);
SAppMessageMana.SetMemberCoinsMsgCacheData(SAppMessageType.MemberFoodSaleNotify, orderId, form_id, mobile, dataModel, out errMsg);
}
else if (type == "充值")
{
StoreCacheModel storeModel = null;
XCGameManaDeviceStoreType deviceStoreType;
//验证门店
StoreBusiness store = new StoreBusiness();
if (!store.IsEffectiveStore(memberTokenModel.StoreId, out deviceStoreType, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//获取会员信息
if (!ExtendBusiness.GetMemberInfo(deviceStoreType, mobile, storeModel.StoreDBName, out balance, out icCardId, out memberLevelId, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//充值
LogHelper.SaveLog(TxtLogType.Api, TxtLogContentType.Debug, TxtLogFileType.Day, "Recharge:" + errMsg);
if (!Recharge(deviceStoreType, mobile, storeModel.StoreDBName, storeId, icCardId, memberLevelId, foodId, orderId, money, coins, balance, paymentype, deviceId, deviceIdentityId, out foodName, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//推送消息
string form_id = dicParas.ContainsKey("form_id") ? dicParas["form_id"].ToString() : string.Empty;
SAppMessageMana.PushMemberFoodSaleMsg("", "", "充值", storeModel.StoreName, mobile, orderId, foodName, foodNum, icCardId, decimal.Parse(money), coins, form_id, out errMsg);
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "类型无效"));
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
catch (Exception e)
{
throw e;
}
}
public object updateStore(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string companyname = dicParas.ContainsKey("companyname") ? dicParas["companyname"].ToString() : string.Empty;
string province = dicParas.ContainsKey("province") ? dicParas["province"].ToString() : string.Empty;
string address = dicParas.ContainsKey("address") ? dicParas["address"].ToString() : string.Empty;
string boss = dicParas.ContainsKey("boss") ? dicParas["boss"].ToString() : string.Empty;
string phone = dicParas.ContainsKey("phone") ? dicParas["phone"].ToString() : string.Empty;
string telphone = dicParas.ContainsKey("telphone") ? dicParas["telphone"].ToString() : string.Empty;
string clienttype = dicParas.ContainsKey("clienttype") ? dicParas["clienttype"].ToString() : string.Empty;
string power_due_date = dicParas.ContainsKey("power_due_date") ? dicParas["power_due_date"].ToString() : string.Empty;
string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty;
string parentid = dicParas.ContainsKey("parentid") ? dicParas["parentid"].ToString() : string.Empty;
string developer = dicParas.ContainsKey("developer") ? dicParas["developer"].ToString() : string.Empty;
string store_password = dicParas.ContainsKey("store_password") ? dicParas["store_password"].ToString() : string.Empty;
string wxfee = dicParas.ContainsKey("wxfee") ? dicParas["wxfee"].ToString() : string.Empty;
if (!CheckAddStore(dicParas, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
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, "门店不存在"));
}
string store_dbname = string.Empty;
store.companyname = companyname;
store.province = province;
store.address = address;
store.boss = boss;
store.phone = phone;
store.telphone = telphone;
store.clienttype = clienttype;
store.createtime = System.DateTime.Now;
store.updatetime = System.DateTime.Now;
store.power_due_date = System.DateTime.Parse(System.DateTime.Parse(power_due_date).ToString("yyyy-MM-dd") + " 00:00:00");
store.note = note;
store.parentid = parentid;
store.developer = developer;
store.store_password = store_password;
store.store_dbname = "xcgamedb" + storeId;
store.wxfee = Convert.ToDecimal(decimal.Parse(wxfee) / 1000);
if (storeService.Update(store))
{
List <StoreCacheModel> list = StoreCache.GetStore();
StoreCacheModel storeCacheModel = list.Where <StoreCacheModel>(p => p.StoreID == int.Parse(storeId)).FirstOrDefault <StoreCacheModel>();
if (storeCacheModel == null)
{
StoreCacheModel model = new StoreCacheModel();
model.StoreID = int.Parse(storeId);
model.StoreName = companyname;
model.StorePassword = store_password;
model.StoreType = Convert.ToInt32(store.StoreType);
model.StoreDBName = store.store_dbname;
list.Add(model);
}
else
{
storeCacheModel.StoreName = companyname;
storeCacheModel.StorePassword = store_password;
storeCacheModel.StoreType = Convert.ToInt32(store.StoreType);
storeCacheModel.StoreDBName = store.store_dbname;
}
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
public object register(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string mobile = string.Empty;
XCGameManaDeviceStoreType deviceStoreType;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
//验证手机token
MobileTokenModel mobileTokenModel = (MobileTokenModel)(dicParas[Constant.MobileTokenModel]);
mobile = mobileTokenModel.Mobile;
//验证门店
StoreCacheModel storeModel = null;
StoreBusiness store = new StoreBusiness();
if (!store.IsEffectiveStore(storeId, out deviceStoreType, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
string meberToken = string.Empty;
if (deviceStoreType == XCGameManaDeviceStoreType.Store)
{
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(storeModel.StoreDBName);
//获取手机号是否存在注册记录
var count = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCGame.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@Mobile", mobile);
parameters[1] = new SqlParameter("@MemberPassword", "888888");
parameters[2] = new SqlParameter("@WXOpenID", "");
parameters[3] = new SqlParameter("@Return", 0);
parameters[3].Direction = System.Data.ParameterDirection.Output;
System.Data.DataSet ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
meberToken = MemberTokenBusiness.SetMemberToken(storeId, mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(storeId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
else
{
//如果已注册，返回会员主要信息
string sql = " exec GetMember @Mobile,@ICCardID";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@Mobile", mobile);
parameters[1] = new SqlParameter("@ICCardID", "0");
System.Data.DataSet ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
meberToken = MemberTokenBusiness.SetMemberToken(storeId, mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(storeId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
}
else if (deviceStoreType == XCGameManaDeviceStoreType.Merch)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
//获取手机号是否存在注册记录
var count = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCCloudRS232.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MerchId,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Mobile", mobile);
parameters[1] = new SqlParameter("@MerchId", storeId);
parameters[2] = new SqlParameter("@MemberPassword", "888888");
parameters[3] = new SqlParameter("@WXOpenID", "");
parameters[4] = new SqlParameter("@Return", 0);
parameters[4].Direction = System.Data.ParameterDirection.Output;
System.Data.DataSet ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
meberToken = MemberTokenBusiness.SetMemberToken(storeId, mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(storeId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
else
{
//如果已注册，返回会员主要信息
string sql = " exec GetMember @Mobile,@MerchId,@ICCardID";
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@Mobile", mobile);
parameters[1] = new SqlParameter("@MerchId", storeId);
parameters[2] = new SqlParameter("@ICCardID", "0");
System.Data.DataSet ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = "使用中";
meberToken = MemberTokenBusiness.SetMemberToken(storeId, mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(storeId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
}
else
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, "店号无效"));
}
}
catch (Exception e)
{
throw e;
}
}
public object update(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string mobile = string.Empty;
StoreBusiness storeBusiness = new StoreBusiness();
StoreCacheModel storeModel = null;
string moblietoken = dicParas.ContainsKey("moblietoken") ? dicParas["moblietoken"].ToString() : string.Empty;
string membername = dicParas.ContainsKey("membername") ? dicParas["membername"].ToString() : string.Empty;
if (membername == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员姓名不能为空"));
}
string gender = dicParas.ContainsKey("gender") ? dicParas["gender"].ToString() : string.Empty;
if (gender == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员性别不能为空"));
}
string MemberPhoto = dicParas.ContainsKey("memberphoto") ? dicParas["memberphoto"].ToString() : string.Empty;
if (!MobileTokenBusiness.ExistToken(moblietoken, out mobile))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效"));
}
IMemberTokenService memberTokenService = BLLContainer.Resolve <IMemberTokenService>();
var membertokenlist = memberTokenService.GetModels(x => x.Phone == mobile).ToList();
if (membertokenlist.Count == 0)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询到会员信息"));
}
//遍历会员表中的所有数据，更新会员信息
for (int i = 0; i < membertokenlist.Count; i++)
{
int iccard = Convert.ToInt32(membertokenlist[i].ICCardID);
int storeid = Convert.ToInt32(membertokenlist[i].StoreId);
if (storeBusiness.IsEffectiveStore(storeid.ToString(), ref storeModel, out errMsg))
{
if (storeModel.StoreType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(storeModel.StoreDBName);
var model = memberService.GetModels(p => p.ICCardID == iccard).FirstOrDefault <XCCloudService.Model.XCGame.t_member>();
if (model != null)
{
model.MemberName = membername;
model.Gender = gender;
model.MemberPhoto = MemberPhoto;
memberService.Update(model);
}
}
else if (storeModel.StoreType == 1)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
var model = memberService.GetModels(p => p.ICCardID == iccard).FirstOrDefault <XCCloudService.Model.XCCloudRS232.t_member>();
if (model != null)
{
model.MemberName = membername;
memberService.Update(model);
}
}
}
}
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
catch (Exception e)
{
throw e;
}
}
public object getInfo2(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
System.Data.DataSet ds = null;
//获取token模式
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
//验证门店
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
//如果是门店模式
string sql = " exec GetMember @Mobile,@ICCardID";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@Mobile", "");
parameters[1] = new SqlParameter("@ICCardID", icCardId);
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
if (ds != null && ds.Tables.Count >= 1)
{
RegisterMemberResponseModel registerMemberResponseModel = Utils.GetModelList <RegisterMemberResponseModel>(ds.Tables[0])[0];
registerMemberResponseModel.StoreId = storeModel.StoreID.ToString();
registerMemberResponseModel.StoreName = storeModel.StoreName;
registerMemberResponseModel.MemberState = MemberBusiness.GetMemberStateName(registerMemberResponseModel.MemberState);
return(ResponseModelFactory <RegisterMemberResponseModel> .CreateModel(isSignKeyReturn, registerMemberResponseModel));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, ""));
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendDataMemberQuery(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, icCardId, out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
while (answerModel == null)
{
//获取应答缓存数据
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
MemberQueryResultNotifyRequestModel model = (MemberQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
RegisterMemberResponseModel registerMemberResponseModel = new RegisterMemberResponseModel();
registerMemberResponseModel.ICCardID = int.Parse(model.Result_Data.ICCardID);
registerMemberResponseModel.MemberName = model.Result_Data.MemberName;
registerMemberResponseModel.Gender = model.Result_Data.Gender;
registerMemberResponseModel.Birthday = model.Result_Data.Birthday;
registerMemberResponseModel.CertificalID = model.Result_Data.CertificalID;
registerMemberResponseModel.Mobile = model.Result_Data.Mobile;
registerMemberResponseModel.Balance = Convert.ToInt32(model.Result_Data.Balance);
registerMemberResponseModel.Point = Convert.ToInt32(model.Result_Data.Point);
registerMemberResponseModel.Deposit = model.Result_Data.Deposit;
registerMemberResponseModel.MemberState = model.Result_Data.MemberState;
registerMemberResponseModel.Lottery = Convert.ToInt32(model.Result_Data.Lottery);
registerMemberResponseModel.Note = model.Result_Data.Note;
registerMemberResponseModel.EndDate = model.Result_Data.EndDate;
registerMemberResponseModel.MemberLevelName = model.Result_Data.MemberLevelName;
registerMemberResponseModel.StoreId = storeModel.StoreID.ToString();
registerMemberResponseModel.StoreName = storeModel.StoreName;
registerMemberResponseModel.MemberState = MemberBusiness.GetMemberStateName(registerMemberResponseModel.MemberState);
return(ResponseModelFactory <RegisterMemberResponseModel> .CreateModel(isSignKeyReturn, registerMemberResponseModel));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "查询数据出错"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "查询数据出错"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店设置错误"));
}
}
catch (Exception e)
{
throw e;
}
}
public object getMemberToken(Dictionary <string, object> dicParas)
{
bool isMember = false;
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
try
{
MobileTokenModel mobileTokenModel = (MobileTokenModel)(dicParas[Constant.MobileTokenModel]);
//获取终端号是否存在
StoreCacheModel storeModel = null;
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//是否注册会员
MemberResponseModel memberResponseModel = null;
System.Data.DataSet ds = null;
if (storeModel.StoreType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(storeModel.StoreDBName);
var count = memberService.GetModels(p => p.Mobile.Equals(mobileTokenModel.Mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCGame.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@Mobile", mobileTokenModel.Mobile);
parameters[1] = new SqlParameter("@MemberPassword", "888888");
parameters[2] = new SqlParameter("@WXOpenID", "");
parameters[3] = new SqlParameter("@Return", 0);
parameters[3].Direction = System.Data.ParameterDirection.Output;
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
}
else
{
string sql = " exec GetMember @Mobile,@ICCardID";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@Mobile", mobileTokenModel.Mobile);
parameters[1] = new SqlParameter("@ICCardID", "0");
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
}
memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
isMember = true;
}
else if (storeModel.StoreType == 1)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
var count = memberService.GetModels(p => p.Mobile.Equals(mobileTokenModel.Mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCCloudRS232.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MerchId,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Mobile", mobileTokenModel.Mobile);
parameters[1] = new SqlParameter("@MerchId", storeId);
parameters[2] = new SqlParameter("@MemberPassword", "888888");
parameters[3] = new SqlParameter("@WXOpenID", "");
parameters[4] = new SqlParameter("@Return", 0);
parameters[4].Direction = System.Data.ParameterDirection.Output;
ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
}
else
{
string sql = " exec GetMember @Mobile,@MerchId,@ICCardID";
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@Mobile", mobileTokenModel.Mobile);
parameters[1] = new SqlParameter("@MerchId", storeId);
parameters[2] = new SqlParameter("@ICCardID", "0");
ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
}
memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = "有效";
isMember = true;
}
else
{
isMember = false;
}
//设置会员token
string token = string.Empty;
if (isMember)
{
token = MemberTokenBusiness.SetMemberToken(storeId, mobileTokenModel.Mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
}
MemberTokenResponseModel memberTokenModel = new MemberTokenResponseModel(storeId, storeModel.StoreName, token, isMember, memberResponseModel);
return(ResponseModelFactory <MemberTokenResponseModel> .CreateModel(isSignKeyReturn, memberTokenModel));
}
catch (Exception e)
{
throw e;
}
}
public object getRegisterSMSCode(Dictionary <string, object> dicParas)
{
try
{
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty;
string imgCode = dicParas.ContainsKey("imgCode") ? dicParas["imgCode"].ToString() : string.Empty;
string errMsg = string.Empty;
//验证码
if (!ValidateImgCache.Exist(imgCode.ToUpper()))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "验证码无效"));
}
ValidateImgCache.Remove(imgCode.ToUpper());
if (string.IsNullOrEmpty(storeId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号码不正确"));
}
if (string.IsNullOrEmpty(mobile))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机号码不正确"));
}
bool isSMSTest = bool.Parse(System.Configuration.ConfigurationManager.AppSettings["isSMSTest"].ToString());
StoreBusiness sb = new StoreBusiness();
StoreCacheModel storeModel = null;
if (!sb.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
//验证用户在分库是否存在
XCCloudService.BLL.IBLL.XCGame.IUserService userService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IUserService>(storeModel.StoreDBName);
var gameUserModel = userService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.u_users>();
if (gameUserModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询到该用户"));
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendDataUserPhoneQuery(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, mobile, out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
UserPhoneQueryResultNotifyRequestModel model = (UserPhoneQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "0")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询到该用户"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店设置不正确"));
}
string templateId = "2";
string key = string.Empty;
if (!isSMSTest && !FilterMobileBusiness.ExistMobile(mobile))
{
string smsCode = string.Empty;
if (SMSBusiness.GetSMSCode(out smsCode))
{
key = mobile + "_" + smsCode;
SMSCodeCache.Add(key, mobile, CacheExpires.SMSCodeExpires);
if (SMSBusiness.SendSMSCode(templateId, mobile, smsCode, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "发送验证码出错"));
}
}
else
{
key = mobile + "_" + "123456";
SMSCodeCache.Add(key, mobile, CacheExpires.SMSCodeExpires);
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
}
catch (Exception e)
{
throw e;
}
}
public object exchangeLottery(Dictionary <string, object> dicParas)
{
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
string barCode = dicParas.ContainsKey("barCode") ? dicParas["barCode"].ToString() : string.Empty;
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
string mobileName = dicParas.ContainsKey("mobileName") ? dicParas["mobileName"].ToString() : string.Empty;
if (string.IsNullOrEmpty(barCode))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入条码编号"));
}
StoreBusiness store = new StoreBusiness();
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IFlwLotteryService lotteryService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFlwLotteryService>(storeModel.StoreDBName);
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(storeModel.StoreDBName);
XCCloudService.BLL.IBLL.XCGame.IScheduleService scheduleService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IScheduleService>(storeModel.StoreDBName);
System.DateTime startTime = System.DateTime.Parse(System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
System.DateTime endTime = System.DateTime.Parse(System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");
var lotteryModel = lotteryService.GetModels(p => p.Barcode.Equals(barCode)).FirstOrDefault <flw_lottery>();
var memberModel = memberService.GetModels(p => p.ICCardID.ToString().Equals(icCardId)).FirstOrDefault <t_member>();
var scheduleModel = scheduleService.GetModels(p => (p.OpenTime >= startTime && p.OpenTime <= endTime && p.UserID == userTokenModel.XCGameUserId && p.State.Equals("0"))).FirstOrDefault <flw_schedule>();
if (scheduleModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户班次信息不存在"));
}
if (lotteryModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "彩票信息不存在"));
}
if (lotteryModel.State == 1)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "当前彩票已使用"));
}
if (memberModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员信息不存在"));
}
XCCloudService.BLL.IBLL.XCGame.IParametersService parametersService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IParametersService>(storeModel.StoreDBName);
var paramDateValidityModel = parametersService.GetModels(p => p.System.Equals("rbnBackDateValidity", StringComparison.OrdinalIgnoreCase)).FirstOrDefault <t_parameters>();
if (paramDateValidityModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "返分卡有效期参数未设置，不能兑换"));
}
DateTime dateTime = Convert.ToDateTime(lotteryModel.PrintTime).AddDays(Convert.ToInt32(paramDateValidityModel.ParameterValue));
if (System.DateTime.Now > dateTime)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "已过期，不能兑换"));
}
using (TransactionScope ts = new TransactionScope())
{
try
{
lotteryModel.State = 1;
lotteryModel.RealTime = System.DateTime.Now;
lotteryModel.ICCardID = int.Parse(icCardId);
lotteryModel.UserID = userTokenModel.XCGameUserId;
lotteryModel.ScheduleID = scheduleModel.ID;
lotteryModel.WorkStation = userTokenModel.Mobile;
memberModel.Lottery = Convert.ToInt32(memberModel.Lottery) + lotteryModel.LotteryCount;
memberModel.ModTime = System.DateTime.Now;
lotteryService.Update(lotteryModel);
memberService.Update(memberModel);
ts.Complete();
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
catch (Exception e)
{
throw e;
}
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
//发送彩票操作
if (DataFactory.SendDataLotteryOperate(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, barCode, icCardId, "0", mobileName, userTokenModel.Mobile, out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
LotteryOperateResultNotifyRequestModel model = (LotteryOperateResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, model.Result_Msg));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.F, "", Result_Code.T, "门店配置无效"));
}
}
/// <summary>
/// 验证门店设备信息
/// </summary>
/// <param name="deviceStoreType"></param>
/// <param name="storeId"></param>
/// <param name="deviceId"></param>
/// <param name="segment"></param>
/// <param name="mcuId"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static bool checkStoreGameDeviceInfo(XCGameManaDeviceStoreType deviceStoreType, string storeId, string deviceId, out string segment, out string mcuId, out string headId, out string gameId, out string xcGameDBName, out string storePassword, out string storeName, out string errMsg)
{
errMsg = string.Empty;
segment = string.Empty;
storeName = string.Empty;
mcuId = string.Empty;
headId = string.Empty;
gameId = string.Empty;
xcGameDBName = string.Empty;
storePassword = string.Empty;
if (deviceStoreType == XCGameManaDeviceStoreType.Store)
{
StoreBusiness store = new StoreBusiness();
StoreCacheModel storeModel = null;
if (!store.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
errMsg = "门店不存在";
return(false);
}
storePassword = storeModel.StorePassword;
xcGameDBName = storeModel.StoreDBName;
storeName = storeModel.StoreName;
//验证头信息
XCCloudService.BLL.IBLL.XCGame.IHeadService headService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IHeadService>(xcGameDBName);
var headModel = headService.GetModels(p => p.MCUID.Equals(deviceId) && p.State.Equals("1")).FirstOrDefault <XCCloudService.Model.XCGame.t_head>();
if (headModel == null)
{
errMsg = "设备门店头部信息不存在";
return(false);
}
//验证游戏机信息
XCCloudService.BLL.IBLL.XCGame.IGameService gameService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IGameService>(xcGameDBName);
var gameModel = gameService.GetModels(p => p.GameID.Equals(headModel.GameID) && p.State.Equals("1")).FirstOrDefault <XCCloudService.Model.XCGame.t_game>();
if (gameModel == null)
{
errMsg = "设备门店头部信息不存在";
return(false);
}
segment = headModel.Segment;
mcuId = headModel.MCUID;
headId = headModel.HeadID;
gameId = headModel.GameID;
return(true);
}
else if (deviceStoreType == XCGameManaDeviceStoreType.Merch)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IBase_DeviceInfoService deviceService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IBase_DeviceInfoService>();
var deviceModel = deviceService.GetModels(p => p.SN.Equals(deviceId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCCloudRS232.Base_DeviceInfo>();
if (deviceModel == null)
{
errMsg = "设备不存在";
return(false);
}
else
{
if (deviceModel.Status != 1)
{
errMsg = "设备未启用";
return(false);
}
else
{
mcuId = deviceModel.SN;
//deviceIdentityId = deviceModel.ID;
return(true);
}
}
}
else
{
return(false);
}
}
public object getCustomCardInfo(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
System.Data.DataSet ds = null;
//获取token模式
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
//验证门店
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
string sql = @" select ICCardID,MemberName,Gender,convert(char(10),Birthday,120) as Birthday,CertificalID,Mobile,Balance,Point,a.Deposit,MemberState,Lottery,Note,convert(char(10),EndDate,120) as EndDate,MemberLevelName from t_member a left join t_memberlevel b on a.MemberLevelID = b.MemberLevelID
where MemberLevelName = '黄牛卡' or MemberLevelName = '收分卡' ";
//如果是门店模式
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, null);
List <CattleMemberCardDetailModel> list = new List <CattleMemberCardDetailModel>();
if (ds != null && ds.Tables.Count >= 1)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CattleMemberCardDetailModel cattleMemberCardDetailModel = Utils.GetModelList <CattleMemberCardDetailModel>(ds.Tables[0])[i];
cattleMemberCardDetailModel.MemberState = MemberBusiness.GetMemberStateName(cattleMemberCardDetailModel.MemberState);
list.Add(cattleMemberCardDetailModel);
}
CattleMemberCardModel cardModel = new CattleMemberCardModel(storeModel.StoreID.ToString(), storeModel.StoreName, list);
return(ResponseModelFactory <CattleMemberCardModel> .CreateModel(isSignKeyReturn, cardModel));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, ""));
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendDataCattleMemberCardQuery(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, "0", out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
while (answerModel == null)
{
//获取应答缓存数据
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
CattleMemberCardQueryResultNotifyRequestModel model1 = (CattleMemberCardQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model1.Result_Code == "1")
{
List <CattleMemberCardDetailModel> list = new List <CattleMemberCardDetailModel>();
for (int i = 0; i < model1.Result_Data.Count; i++)
{
CattleMemberCardDetailModel detailModel = new CattleMemberCardDetailModel();
detailModel.ICCardID = int.Parse(model1.Result_Data[i].ICCardId);
detailModel.MemberName = model1.Result_Data[i].Name;
detailModel.MemberState = model1.Result_Data[i].MemberState;
detailModel.Mobile = model1.Result_Data[i].Phone;
list.Add(detailModel);
}
CattleMemberCardModel cardModel = new CattleMemberCardModel(storeModel.StoreID.ToString(), storeModel.StoreName, list);
return(ResponseModelFactory <CattleMemberCardModel> .CreateModel(isSignKeyReturn, cardModel));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "查询数据出错"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "查询数据出错"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "查询数据出错"));
}
}
public object getfoods(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
TokenType tokenType = TokenType.Member;
StoreCacheModel storeModel = null;
List <XCCloudService.Model.XCGame.t_foods> xcGameFoodsList = null;
List <XCCloudService.Model.XCCloudRS232.t_foods> rs232FoodsList = null;
//获取token模式
MobileTokenModel mobileTokenModel = null;
XCGameMemberTokenModel memberTokenModel = null;
if (!XCCloudService.Business.XCGame.MeberAndMobileTokenBusiness.GetTokenData(dicParas, out tokenType, ref mobileTokenModel, ref memberTokenModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证门店
StoreBusiness store = new StoreBusiness();
if (!store.IsEffectiveStore(memberTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IFoodsService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFoodsService>(storeModel.StoreDBName);
xcGameFoodsList = memberService.GetModels(p => p.FoodState.Equals("1") && p.FoodType.Equals("0") && p.ForeAuthorize.ToString().Equals("0")).ToList <XCCloudService.Model.XCGame.t_foods>();
}
else if (storeModel.StoreType == 1)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IFoodsService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IFoodsService>();
rs232FoodsList = memberService.GetModels(p => p.FoodState == 1).ToList <XCCloudService.Model.XCCloudRS232.t_foods>();
}
//根据查询结果输出
if (xcGameFoodsList == null && rs232FoodsList == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "套餐明细信息不存在"));
}
else
{
if (xcGameFoodsList != null)
{
List <FoodsResponseModel> foodsResponseModel = Utils.GetCopyList <FoodsResponseModel, XCCloudService.Model.XCGame.t_foods>(xcGameFoodsList);
SetFoodsResponseModelList(foodsResponseModel);
return(ResponseModelFactory <List <FoodsResponseModel> > .CreateModel(isSignKeyReturn, foodsResponseModel));
}
else
{
List <FoodsResponseModel> foodsResponseModel = Utils.GetCopyList <FoodsResponseModel, XCCloudService.Model.XCCloudRS232.t_foods>(rs232FoodsList);
SetFoodsResponseModelList(foodsResponseModel);
return(ResponseModelFactory <List <FoodsResponseModel> > .CreateModel(isSignKeyReturn, foodsResponseModel));
}
}
}
catch (Exception e)
{
throw e;
}
}
public object getInfo(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
System.Data.DataSet ds = null;
//获取token模式
XCGameMemberTokenModel memberTokenModel = (XCGameMemberTokenModel)(dicParas[Constant.XCGameMemberTokenModel]);
//验证门店
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(memberTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//如果是门店模式
if (storeModel.StoreType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(storeModel.StoreDBName);
var count = memberService.GetModels(p => p.Mobile.Equals(memberTokenModel.Mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCGame.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@Mobile", memberTokenModel.Mobile);
parameters[1] = new SqlParameter("@MemberPassword", "888888");
parameters[2] = new SqlParameter("@WXOpenID", "");
parameters[3] = new SqlParameter("@Return", 0);
parameters[3].Direction = System.Data.ParameterDirection.Output;
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
string meberToken = MemberTokenBusiness.SetMemberToken(memberTokenModel.StoreId, memberTokenModel.Mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(memberTokenModel.StoreId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
else
{
string sql = " exec GetMember @Mobile,@ICCardID";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@Mobile", memberTokenModel.Mobile);
parameters[1] = new SqlParameter("@ICCardID", "0");
ds = XCGameBLL.ExecuteQuerySentence(sql, storeModel.StoreDBName, parameters);
RegisterMemberResponseModel registerMemberResponseModel = Utils.GetModelList <RegisterMemberResponseModel>(ds.Tables[0])[0];
registerMemberResponseModel.StoreId = storeModel.StoreID.ToString();
registerMemberResponseModel.StoreName = storeModel.StoreName;
registerMemberResponseModel.MemberState = MemberBusiness.GetMemberStateName(registerMemberResponseModel.MemberState);
return(ResponseModelFactory <RegisterMemberResponseModel> .CreateModel(isSignKeyReturn, registerMemberResponseModel));
}
}
//如果是商户模式
else if (storeModel.StoreType == 1)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
var count = memberService.GetModels(p => p.Mobile.Equals(memberTokenModel.Mobile, StringComparison.OrdinalIgnoreCase)).Count <XCCloudService.Model.XCCloudRS232.t_member>();
if (count == 0)
{
string sql = " exec RegisterMember @Mobile,@MerchId,@MemberPassword,@WXOpenID,@Return output ";
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Mobile", memberTokenModel.Mobile);
parameters[1] = new SqlParameter("@MerchId", storeModel.StoreID);
parameters[2] = new SqlParameter("@MemberPassword", "888888");
parameters[3] = new SqlParameter("@WXOpenID", "");
parameters[4] = new SqlParameter("@Return", 0);
parameters[4].Direction = System.Data.ParameterDirection.Output;
ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
MemberResponseModel memberResponseModel = Utils.GetModelList <MemberResponseModel>(ds.Tables[0])[0];
memberResponseModel.MemberState = MemberBusiness.GetMemberStateName(memberResponseModel.MemberState);
string meberToken = MemberTokenBusiness.SetMemberToken(memberTokenModel.StoreId, memberTokenModel.Mobile, memberResponseModel.MemberLevelName, storeModel.StoreName, memberResponseModel.ICCardID.ToString(), memberResponseModel.EndDate);
RegisterMemberTokenResponseModel registerMemberTokenResponseModel = new RegisterMemberTokenResponseModel(memberTokenModel.StoreId, storeModel.StoreName, meberToken, memberResponseModel);
return(ResponseModelFactory <RegisterMemberTokenResponseModel> .CreateModel(isSignKeyReturn, registerMemberTokenResponseModel));
}
else
{
string sql = " exec GetMember @Mobile,@MerchId,@ICCardID";
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@Mobile", memberTokenModel.Mobile);
parameters[1] = new SqlParameter("@MerchId", memberTokenModel.StoreId);
parameters[2] = new SqlParameter("@ICCardID", "0");
ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, parameters);
RegisterMemberResponseModel registerMemberResponseModel = Utils.GetModelList <RegisterMemberResponseModel>(ds.Tables[0])[0];
registerMemberResponseModel.StoreId = storeModel.StoreID.ToString();
registerMemberResponseModel.StoreName = storeModel.StoreName;
registerMemberResponseModel.MemberState = MemberBusiness.GetMemberStateName(registerMemberResponseModel.MemberState);
return(ResponseModelFactory <RegisterMemberResponseModel> .CreateModel(isSignKeyReturn, registerMemberResponseModel));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店类型无效"));
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 验证门店设备信息
/// </summary>
/// <param name="deviceStoreType"></param>
/// <param name="storeId"></param>
/// <param name="deviceId"></param>
/// <param name="segment"></param>
/// <param name="mcuId"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static bool checkStoreDeviceInfo(XCGameManaDeviceStoreType deviceStoreType, string storeId, string deviceId, out string segment, out string mcuId, out string xcGameDBName, out int deviceIdentityId, out string storePassword, out string storeName, out string errMsg)
{
errMsg = string.Empty;
segment = string.Empty;
storeName = string.Empty;
mcuId = string.Empty;
xcGameDBName = string.Empty;
deviceIdentityId = 0;
storePassword = string.Empty;
if (deviceStoreType == XCGameManaDeviceStoreType.Store)
{
StoreBusiness store = new StoreBusiness();
StoreCacheModel storeModel = null;
if (!store.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
errMsg = "门店不存在";
return(false);
}
storePassword = storeModel.StorePassword;
xcGameDBName = storeModel.StoreDBName;
storeName = storeModel.StoreName;
XCCloudService.BLL.IBLL.XCGame.IDeviceService xcGameDeviceService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IDeviceService>(xcGameDBName);
var xcGameDeviceModel = xcGameDeviceService.GetModels(p => p.MCUID.Equals(deviceId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.t_device>();
if (xcGameDeviceModel == null)
{
errMsg = "设备不存在";
return(false);
}
else
{
if (xcGameDeviceModel.state != "启用")
{
errMsg = "设备未启用";
return(false);
}
else
{
segment = xcGameDeviceModel.segment;
mcuId = xcGameDeviceModel.MCUID;
deviceIdentityId = (int)(xcGameDeviceModel.id);
return(true);
}
}
}
else if (deviceStoreType == XCGameManaDeviceStoreType.Merch)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IBase_DeviceInfoService deviceService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IBase_DeviceInfoService>();
var deviceModel = deviceService.GetModels(p => p.SN.Equals(deviceId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCCloudRS232.Base_DeviceInfo>();
if (deviceModel == null)
{
errMsg = "设备不存在";
return(false);
}
else
{
if (deviceModel.Status != 1)
{
errMsg = "设备未启用";
return(false);
}
else
{
mcuId = deviceModel.SN;
deviceIdentityId = deviceModel.ID;
return(true);
}
}
}
else
{
return(false);
}
}
public object transICCardCoins(Dictionary <string, object> dicParas)
{
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
string cardIdOut = dicParas.ContainsKey("cardIdOut") ? dicParas["cardIdOut"].ToString() : string.Empty;
string cardIdOutPassword = dicParas.ContainsKey("cardIdOutPassword") ? dicParas["cardIdOutPassword"].ToString() : string.Empty;
string cardIdIn = dicParas.ContainsKey("cardIdIn") ? dicParas["cardIdIn"].ToString() : string.Empty;
string coins = dicParas.ContainsKey("coins") ? dicParas["coins"].ToString() : string.Empty;
string mobileName = dicParas.ContainsKey("mobileName") ? dicParas["mobileName"].ToString() : string.Empty;
StoreBusiness store = new StoreBusiness();
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
string storeProc = "TransICCardCoins";
SqlParameter[] parameters = new SqlParameter[8];
parameters[0] = new SqlParameter("@CardIdOut", cardIdOut);
parameters[1] = new SqlParameter("@CardIdOutPassword", cardIdOutPassword);
parameters[2] = new SqlParameter("@CardIdIn", cardIdIn);
parameters[3] = new SqlParameter("@Coins", coins);
parameters[4] = new SqlParameter("@UserId", userTokenModel.XCGameUserId);
parameters[5] = new SqlParameter("@Mobile", userTokenModel.Mobile);
parameters[6] = new SqlParameter("@ErrMsg", System.Data.SqlDbType.VarChar, 200);
parameters[6].Direction = System.Data.ParameterDirection.Output;
parameters[7] = new SqlParameter("@Return", 0);
parameters[7].Direction = System.Data.ParameterDirection.ReturnValue;
XCGameBLL.ExecuteStoredProcedureSentence(storeProc, storeModel.StoreDBName, parameters);
if (Convert.ToInt32(parameters[7].Value) == 1)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, parameters[6].Value.ToString()));
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendMemberTransOperate(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, mobileName, userTokenModel.Mobile, cardIdIn, cardIdOut, int.Parse(coins), out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
MemberTransOperateResultNotifyRequestModel model = (MemberTransOperateResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, model.Result_Msg));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店设置错误"));
}
}
public object getLotteryInfo(Dictionary <string, object> dicParas)
{
string gameName = string.Empty;
string headInfo = string.Empty;
string barCode = dicParas.ContainsKey("barCode") ? dicParas["barCode"].ToString() : string.Empty;
if (string.IsNullOrEmpty(barCode))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入条码编号"));
}
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
StoreBusiness store = new StoreBusiness();
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
XCCloudService.BLL.IBLL.XCGame.IFlwLotteryService lotteryService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFlwLotteryService>(storeModel.StoreDBName);
XCCloudService.BLL.IBLL.XCGame.IHeadService headService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IHeadService>(storeModel.StoreDBName);
XCCloudService.BLL.IBLL.XCGame.IGameService gameService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IGameService>(storeModel.StoreDBName);
var lotteryModel = lotteryService.GetModels(p => p.Barcode.Equals(barCode)).FirstOrDefault <flw_lottery>();
if (lotteryModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "彩票信息不存在"));
}
if (!string.IsNullOrEmpty(lotteryModel.HeadID))
{
//var headModel = headService.GetModels(p => p.HeadAddress.Equals(lotteryModel.HeadID)).FirstOrDefault<t_head>();
headInfo = lotteryModel.HeadID;
}
else
{
headInfo = lotteryModel.WorkStation;
}
if (!string.IsNullOrEmpty(lotteryModel.GameID))
{
var gameModel = gameService.GetModels(p => p.GameID.Equals(lotteryModel.GameID)).FirstOrDefault <t_game>();
if (gameModel != null)
{
gameName = gameModel.GameName;
}
else
{
gameName = string.Empty;
}
}
else
{
gameName = string.Empty;
}
XCCloudService.BLL.IBLL.XCGame.IParametersService parametersService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IParametersService>(storeModel.StoreDBName);
var paramDateValidityModel = parametersService.GetModels(p => p.System.Equals("rbnBackDateValidity", StringComparison.OrdinalIgnoreCase)).FirstOrDefault <t_parameters>();
if (paramDateValidityModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "返分卡有效期参数未设置，不能兑换"));
}
int state = Convert.ToInt32(lotteryModel.State);
string stateName = lotteryModel.State == 1 ? "已兑" : "未兑";
if (state != 1)
{
DateTime dateTime = Convert.ToDateTime(lotteryModel.PrintTime).AddDays(Convert.ToDouble(paramDateValidityModel.ParameterValue));
if (System.DateTime.Now > dateTime)
{
state = 2;
stateName = "已过期";
}
}
string printTime = Convert.ToDateTime(lotteryModel.PrintTime).ToString("yyyy-MM-dd HH:mm:ss");
string realTime = Convert.ToDateTime(lotteryModel.RealTime).ToString("yyyy-MM-dd HH:mm:ss");
var obj = new {
id = lotteryModel.id,
lottery = lotteryModel.LotteryCount, //彩票数
gameName = gameName, //游戏机名
headInfo = headInfo, //出票位置
state = stateName, //小票状态
makeTime = printTime.Substring(0, 10) == "0001-01-01" ? "" : printTime, //出票时间
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
//string storeId, string storePassword, string barCode,string icCardId,string mobileName, string phone, string operate, out string errMsg
if (DataFactory.SendDataLotteryQuery(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, barCode, out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
LotteryQueryResultNotifyRequestModel model = (LotteryQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
var obj = new
{
id = model.Result_Data.Id,
lottery = model.Result_Data.Lottery, //彩票数
gameName = model.Result_Data.GameName, //游戏机名
headInfo = model.Result_Data.HeadInfo, //出票位置
state = model.Result_Data.State, //小票状态
makeTime = model.Result_Data.PrintDate //出票时间
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, model.Result_Msg));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店配置无效"));
}
}
public object registerUser(Dictionary <string, object> dicParas)
{
try
{
string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty;
string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty;
string smsCode = dicParas.ContainsKey("smsCode") ? dicParas["smsCode"].ToString() : string.Empty;
string errMsg = string.Empty;
int userId = 0;
if (string.IsNullOrEmpty(storeId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号码不正确"));
}
if (string.IsNullOrEmpty(mobile))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机号码不正确"));
}
if (string.IsNullOrEmpty(smsCode))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请输入验证码"));
}
//验证短信验证码
string key = mobile + "_" + smsCode;
if (!FilterMobileBusiness.IsTestSMS && !FilterMobileBusiness.ExistMobile(mobile))
{
if (!SMSCodeCache.IsExist(key))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "短信验证码无效"));
}
}
if (SMSCodeCache.IsExist(key))
{
SMSCodeCache.Remove(key);
}
//验证门店是否有效
StoreBusiness sb = new StoreBusiness();
StoreCacheModel storeModel = null;
if (!sb.IsEffectiveStore(storeId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
//验证用户在分库是否存在
XCCloudService.BLL.IBLL.XCGame.IUserService userService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IUserService>(storeModel.StoreDBName);
var gameUserModel = userService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.u_users>();
if (gameUserModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询到该用户"));
}
userId = gameUserModel.UserID;
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendDataUserPhoneQuery(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, mobile, out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
UserPhoneQueryResultNotifyRequestModel model = (UserPhoneQueryResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "0")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询到该用户"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
userId = 0;//本地库用0
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店配置无效"));
}
//验证用户在总库是否已注册
XCCloudService.BLL.IBLL.XCGameManager.IUserService userServiceManager = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGameManager.IUserService>();
var userRegisterModel = userServiceManager.GetModels(p => p.Mobile.Equals(mobile) && p.StoreId.Equals(storeId)).FirstOrDefault <XCCloudService.Model.XCGameManager.t_user>();
if (userRegisterModel == null)
{
//添加注册用户
XCCloudService.Model.XCGameManager.t_user t_user = new XCCloudService.Model.XCGameManager.t_user();
t_user.Mobile = mobile;
t_user.StoreId = storeId;
t_user.CreateTime = System.DateTime.Now;
t_user.OpenId = "";
if (!userServiceManager.Add(t_user))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "添加注册用户失败"));
}
}
//获取用户token
//云库不用userId
string token = XCCloudManaUserTokenBusiness.SetToken(mobile, storeId, storeModel.StoreName, userId);
List <XCCloudManaUserTokenResultModel> list = null;
XCCloudManaUserTokenBusiness.GetUserTokenModel(mobile, ref list);
var obj = new
{
userToken = token,
storeList = list
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj));
}
catch (Exception e)
{
throw e;
}
}
