private bool putCoins(XCGameManaDeviceStoreType deviceStoreType, string xcGameDBName, string mobile, int balance, int coins, int icCardId, string segment, string deviceId, int deviceIdentityId, out int lastBalance, out string errMsg)
{
errMsg = string.Empty;
lastBalance = 0;
//提币数据库操作
if (deviceStoreType == XCGameManaDeviceStoreType.Store)
{
XCCloudService.BLL.IBLL.XCGame.Iflw_485_coinService coinService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.Iflw_485_coinService>(xcGameDBName);
XCCloudService.BLL.IBLL.XCGame.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IMemberService>(xcGameDBName);
var memberModel = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.t_member>();
memberModel.Balance = Convert.ToInt32(memberModel.Balance) - coins;
lastBalance = (int)(memberModel.Balance);
XCCloudService.Model.XCGame.flw_485_coin coinModel = new Model.XCGame.flw_485_coin();
coinModel.Balance = Convert.ToInt32(memberModel.Balance) - coins;
coinModel.ICCardID = icCardId;
coinModel.Segment = segment;
coinModel.HeadAddress = "";
coinModel.Coins = coins;
coinModel.CoinType = "3";
coinModel.RealTime = System.DateTime.Now;
coinModel.SN = 0;
using (var transactionScope = new System.Transactions.TransactionScope(TransactionScopeOption.RequiresNew))
{
coinService.Add(coinModel);
memberService.Update(memberModel);
transactionScope.Complete();
}
return(true);
}
else if (deviceStoreType == XCGameManaDeviceStoreType.Merch)
{
XCCloudService.BLL.IBLL.XCCloudRS232.Iflw_485_coinService coinService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.Iflw_485_coinService>(xcGameDBName);
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>(xcGameDBName);
var memberModel = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCCloudRS232.t_member>();
memberModel.Balance = Convert.ToInt32(memberModel.Balance) - coins;
lastBalance = (int)(memberModel.Balance);
XCCloudService.Model.XCCloudRS232.flw_485_coin coinModel = new XCCloudService.Model.XCCloudRS232.flw_485_coin();
coinModel.Balance = Convert.ToInt32(memberModel.Balance) - coins;
coinModel.ICCardID = icCardId;
coinModel.DeviceID = deviceIdentityId;
coinModel.Coins = coins;
coinModel.CoinType = 3;
using (var transactionScope = new System.Transactions.TransactionScope(TransactionScopeOption.RequiresNew))
{
coinService.Add(coinModel);
memberService.Update(memberModel);
transactionScope.Complete();
}
return(true);
}
else
{
return(false);
}
}
public static bool IsEffectiveStore(string mobile, ref XCCloudService.Model.XCCloudRS232.t_member memberModel, out string errMsg)
{
errMsg = string.Empty;
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
var model = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCCloudRS232.t_member>();
if (model == null)
{
errMsg = "会员信息不存在";
return(false);
}
else if (model.Lock == 1)
{
errMsg = "会员已被锁定";
return(false);
}
else
{
memberModel = model;
return(true);
}
}
private bool Recharge(XCGameManaDeviceStoreType deviceStoreType, string mobile, string xcGameDBName, string storeId, int icCardId, int memberLevelId, int foodId, string orderId, string money, int coins, int balance, string paymentype, string deviceId, int deviceIdentityId, out string foodName, out string errMsg)
{
foodName = string.Empty;
errMsg = string.Empty;
balance += coins;
if (deviceStoreType == XCGameManaDeviceStoreType.Store)
{
//验证套餐信息
XCCloudService.BLL.IBLL.XCGame.IFoodsService foodservice = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFoodsService>(xcGameDBName);
var foodModel = foodservice.GetModels(p => p.FoodID == foodId).FirstOrDefault <XCCloudService.Model.XCGame.t_foods>();
if (foodModel == null)
{
errMsg = "套餐明细不存在";
return(false);
}
foodName = foodModel.FoodName;
//验证班次信息
XCCloudService.BLL.IBLL.XCGame.IScheduleService scheduleService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IScheduleService>(xcGameDBName);
var schedulelist = scheduleService.GetModels(p => p.State.Equals("0", StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCGame.flw_schedule>();
if (schedulelist == null)
{
errMsg = "相关班次不存在";
return(false);
}
string sql = "exec RechargeFood @Balance,@ICCardID,@FoodID,@CoinQuantity,@Point,@MemberLevelID,@UserID,@ScheduleID,@WorkStation,@MacAddress,@OrderID,@FoodName,@Money,@Paymentype,@Return output ";
SqlParameter[] parameters = new SqlParameter[15];
parameters[0] = new SqlParameter("@Balance", balance);
parameters[1] = new SqlParameter("@ICCardID", icCardId);
parameters[2] = new SqlParameter("@FoodID", foodId);
parameters[3] = new SqlParameter("@CoinQuantity", coins);
parameters[4] = new SqlParameter("@Point", "0");
parameters[5] = new SqlParameter("@MemberLevelID", memberLevelId);
parameters[6] = new SqlParameter("@UserID", Convert.ToInt32(schedulelist.UserID));
parameters[7] = new SqlParameter("@ScheduleID", schedulelist.ID.ToString());
parameters[8] = new SqlParameter("@WorkStation", schedulelist.WorkStation);
parameters[9] = new SqlParameter("@MacAddress", "");
parameters[10] = new SqlParameter("@OrderID", orderId);
parameters[11] = new SqlParameter("@FoodName", foodModel.FoodName);
parameters[12] = new SqlParameter("@Money", money);
parameters[13] = new SqlParameter("@Paymentype", paymentype);
parameters[14] = new SqlParameter("@Return", 0);
parameters[14].Direction = System.Data.ParameterDirection.Output;
XCCloudService.BLL.IBLL.XCGame.IFoodsaleService foodsale = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFoodsaleService>(xcGameDBName);
XCCloudService.Model.XCGame.flw_food_sale member = foodsale.SqlQuery(sql, parameters).FirstOrDefault <XCCloudService.Model.XCGame.flw_food_sale>();
}
else if (deviceStoreType == XCGameManaDeviceStoreType.Merch)
{
XCCloudService.BLL.IBLL.XCCloudRS232.IFoodSaleService foodsale = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IFoodSaleService>();
XCCloudService.Model.XCCloudRS232.flw_food_sale flwFood = new Model.XCCloudRS232.flw_food_sale();
flwFood.OrderID = orderId;
flwFood.MerchID = int.Parse(storeId);
flwFood.ICCardID = icCardId;
flwFood.DeviceID = deviceIdentityId;
flwFood.FlowType = 1;
flwFood.CoinQuantity = coins;
flwFood.TotalMoney = decimal.Parse(money);
flwFood.Point = 0;
flwFood.Balance = balance;
flwFood.Note = string.Empty;
flwFood.PayType = PayBusiness.GetPaymentTypeId(paymentype);
flwFood.PayTime = System.DateTime.Now;
flwFood.PayState = 1;
flwFood.PayTotal = 0;
XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService memberService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCCloudRS232.IMemberService>();
var memberModel = memberService.GetModels(p => p.Mobile.Equals(mobile, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XCCloudService.Model.XCCloudRS232.t_member>();
memberModel.Balance = Convert.ToInt32(memberModel.Balance) + coins;
using (var transactionScope = new System.Transactions.TransactionScope(TransactionScopeOption.RequiresNew))
{
foodsale.Add(flwFood);
memberService.Update(memberModel);
transactionScope.Complete();
}
return(true);
}
else
{
errMsg = "门店类型不正确";
}
return(true);
}
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 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;
}
}
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 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;
}
}
