public object GetSingleGrievanace([FromBody] ParamMember obj)
{
//get single member info
try
{
CheckUsernamePassword chkUserPassword = new CheckUsernamePassword();
var chkUser = chkUserPassword.ValidateUsernamePassword(obj.UserId, obj.Password);
if (chkUser)
{
MemberBusiness MBusiness = new MemberBusiness();
var grievance = MBusiness.GetSingleGrievanace(obj);
return(grievance);
}
else
{
return(new Result {
IsSucess = false, ResultData = "Username or Password Is Invalid."
});
}
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public ActionResult Create(string ToID,string content,string toName)
{
IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
if ( HotConfig.IsControlMessage == 1&&iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
Message message = new Message();
Member member = MemberBusiness.GetUserInfo();
message.ToID = ToID.UidDescrypt();
message.FromID = member.ID;
message.FromName = member.ShowName;
message.Content = content;
message.ToName = toName;
iMessage.Add(message);
return Content("发送成功");
}
return Content("发送频繁60s以后再来");
}
public ActionResult Create(string ToID, string content, string toName)
{
IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
if (HotConfig.IsControlMessage == 1 && iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
Message message = new Message();
Member member = MemberBusiness.GetUserInfo();
message.ToID = ToID.UidDescrypt();
message.FromID = member.ID;
message.FromName = member.ShowName;
message.Content = content;
message.ToName = toName;
iMessage.Add(message);
return(Content("发送成功"));
}
return(Content("发送频繁60s以后再来"));
}
public ActionResult GetFans(int id)
{
string name;
using (IMemberBusiness iMember = new MemberBusiness(new JustSayEntities()))
{
name = iMember.GetDetail(id).RealName;
}
return PartialView(iRelation.GetFans(name));
}
public object getMemberExpenseDetail(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty;
string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty;
string flowType = dicParas.ContainsKey("flowType") ? dicParas["flowType"].ToString() : string.Empty;
string sDate = dicParas.ContainsKey("sDate") ? dicParas["sDate"].ToString() : string.Empty;
string eDate = dicParas.ContainsKey("eDate") ? dicParas["eDate"].ToString() : string.Empty;
string strPageIndex = dicParas.ContainsKey("pageIndex") ? dicParas["pageIndex"].ToString() : string.Empty;
string strpageSize = dicParas.ContainsKey("pageSize") ? dicParas["pageSize"].ToString() : string.Empty;
int pageIndex = 1, pageSize = 10;
if (!string.IsNullOrWhiteSpace(strPageIndex) && strPageIndex.IsInt())
{
pageIndex = Convert.ToInt32(strPageIndex);
}
if (!string.IsNullOrWhiteSpace(strpageSize) && strpageSize.IsInt())
{
pageSize = Convert.ToInt32(strpageSize);
}
if (mobileToken == "")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机令牌不能为空"));
}
Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken);
if (merch.IsNull())
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户token无效"));
}
t_member member = MemberBusiness.GetMerchModel(icCardId);
if (member.IsNull())
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡号错误"));
}
DataTable table = AccountBusiness.GetMemberExpenseDetail(merch.ID, icCardId, flowType, sDate, eDate, pageIndex, pageSize);
if (table.Rows.Count == 0)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据"));
}
var list = Utils.GetModelList <MemberExpenseDetailModel>(table).ToList();
return(ResponseModelFactory <List <MemberExpenseDetailModel> > .CreateModel(isSignKeyReturn, list));
}
catch (Exception e)
{
throw e;
}
}
public ActionResult GetFans(int id)
{
string name;
using (IMemberBusiness iMember = new MemberBusiness(new JustSayEntities()))
{
name = iMember.GetDetail(id).RealName;
}
return(PartialView(iRelation.GetFans(name)));
}
public ActionResult Create([Bind(Include = "Content,Message,ToEmail,ToPhone,ToName,ImgUrl,FlashUrl,MusicUrl,ViewName")] Confess confess)
{
IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
if (iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
iConfess.Add(confess);
// IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
confess.Member = iMember.GetDetail(Convert.ToInt32(User.Identity.Name));
Relation relation = new Relation
{
FromEmail = confess.Member.Email,
ShowName = confess.Member.ShowName,
MemberID = confess.Member.ID,
FromPhone = confess.Member.Phone,
FromName = confess.Member.RealName,
ToEmail = confess.ToEmail,
ToName = confess.ToName,
ToPhone = confess.ToPhone,
};
ViewBag.IsEmailSuccess = Inform.Email(confess);
ViewBag.IsSMSSuccess = false;
ViewBag.IsSMSMsg = "";
if (!string.IsNullOrEmpty(confess.ToPhone))
{
if (confess.Member.Score > 50)
{
ViewBag.IsSMSSuccess = Inform.SMS(confess);
confess.Member.Score -= 50;
ViewBag.IsSmsSuccess = true;
}
else
{
ViewBag.IsSMSMsg = "节操币不足50，请多发贴，多回贴";
}
}
ViewData["ConfessID"] = confess.ID;
return(View("~/Views/Relation/Create.cshtml", relation));
}
return(View(confess));
}
/// <summary>
/// 读取IC卡信息
/// </summary>
/// <param name="msg"></param>
/// <param name="sessionPool"></param>
/// <param name="sendIP"></param>
public static void GetICCard(string msg, Dictionary <string, Session> sessionPool, string sendIP)
{
string receiveIP = string.Empty;
string dogId = string.Empty;
string answerMsgType = Convert.ToInt32(TCPMessageType.读取IC卡).ToString();
string cardMsg = string.Empty;
string storePassword = string.Empty;
string icCardId = string.Empty;
string repeatCode = string.Empty;
string memberRepeatCode = string.Empty;
string errMsg = string.Empty;
//解析消息对象
SocketDataModel <UserSendObject> socketDataModel = Utils.DataContractJsonDeserializer <SocketDataModel <UserSendObject> >(msg);
UserSendObject sendObj = socketDataModel.SendObject;
//接受信息方是否存在
if (!GetIP(sessionPool, sendObj.UserToken, out receiveIP))
{
SendFailData(answerMsgType, sessionPool, sendIP, "用户未注册");
return;
}
//获取店密码接口
string userToken = sendObj.UserToken;
if (!StoreBusiness.GetStorePassword(userToken, out storePassword, out errMsg))
{
SendFailData(answerMsgType, sessionPool, sendIP, "获取门店信息出错");
return;
}
object result_data = null;
//读取IC卡信息
if (ICCardUtility.GetICCardID(storePassword, out icCardId, out repeatCode, out errMsg))
{
if (MemberBusiness.GetMember(userToken, sendObj.StoreId, icCardId, ref result_data, out errMsg))
{
SendSuccessData(answerMsgType, sessionPool, sendIP, "读取会员信息成功", result_data);
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, errMsg);
}
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, errMsg);
}
}
public object GetComplaintInfo([FromBody] ParamComplaintDetails objMember)
{
try
{
MemberBusiness obj = new MemberBusiness();
var Memberinfo = obj.GetMemberInfo(objMember);
return(Memberinfo);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object UpdateComplaints([FromBody] ParamComplaintDetails PR)
{
try
{
MemberBusiness OBJSAVE = new MemberBusiness();
var result = OBJSAVE.UpdateComp(PR);
return(result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object GetMemberInfo()
{
try
{
MemberBusiness MBusiness = new MemberBusiness();
var member = MBusiness.GetMemberInfo();
return(member);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object DeleteMemberInfo([FromBody] MemberParameter pm)
{
try
{
MemberBusiness mb = new MemberBusiness();
var Result = mb.DeleteMember(pm);
return(Result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object GetMemberInfo([FromBody] MemberParameter objmem)
{
try
{
string status = objmem.DisplayStatus;
MemberBusiness MBusiness = new MemberBusiness();
var member = MBusiness.GetMemberInfo(status);
return(member);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object MemberInfo()
{
try
{
MemberBusiness member = new MemberBusiness();
var Result = member.MemberList();
return(Result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object MemberSave([FromBody] MemberParameter member_para)
{
try
{
MemberBusiness memberbus = new MemberBusiness();
var result = memberbus.SaveMember(member_para);
// bhobj.StudentsMethod(hobj);
return(result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public ActionResult Create([Bind(Include = "ShowName,Title,Content,ConfessID ,ImgUrl ")] Funny funny)
{
IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
if (iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
iFunny.Add(funny);
return(RedirectToAction("New"));
}
return(View(funny));
}
public Response GetApplicationMemberList(MemberCustomModel objMemberModel)
{
_response = new Response();
try
{
MemberBusiness memberService = new MemberBusiness();
_response.responseData = memberService.GetApplicationMemberList(objMemberModel);
_response.message = "Records loaded successfully !!";
_response.success = true;
}
catch (Exception ex)
{
_response.success = false;
_response.message = ex.Message.ToString();
}
finally
{
memberService = null;
}
return(_response);
}
public Response GetMemberProfile(int MemberId)
{
_response = new Response();
try
{
MemberBusiness memberService = new MemberBusiness();
_response.responseData = memberService.GetMemberProfile(MemberId);
_response.message = "Records loaded successfully !!";
_response.success = true;
}
catch (Exception ex)
{
_response.success = false;
_response.message = ex.Message.ToString();
}
finally
{
memberService = null;
}
return(_response);
}
public Response ForgotPassword(ForgotPasswordCustomModel model)
{
_response = new Response();
try
{
MemberBusiness memberService = new MemberBusiness();
_response.responseData = memberService.ForgotPassword(model);
_response.message = "Records loaded successfully !!";
_response.success = true;
}
catch (Exception ex)
{
_response.success = false;
_response.message = ex.Message.ToString();
}
finally
{
MemberService = null;
}
return(_response);
}
//protected virtual void InitUserpower()
//{
// if (this.UserpowerIsReadOnly())
// {
// this.SetEditControlVisible(false);
// }
// else
// {
// this.SetEditControlVisible(true);
// }
//}
//protected enmPageMode GetPageMode()
//{
// if (Request.QueryString["add"] == "1")
// {
// return enmPageMode.新增;
// }
// else if (Request.QueryString["edit"] == "1")
// {
// return enmPageMode.编辑;
// }
// else if (Request.QueryString["view"] == "1")
// {
// return enmPageMode.查看;
// }
// else
// {
// return enmPageMode.无;
// }
//}
/// <summary>
/// 检查用户是否有权限访问该页
/// </summary>
/// <returns></returns>
protected bool CheckUserpower()
{
//Request.Url.AbsolutePath
DataTable dt = MemberBusiness.GetPowerPage(Request.Url.AbsolutePath).Tables[0];
if (dt.Rows.Count > 0)
{
return(true);
}
//this._userpowers = UserroleBusiness.GetUserPower(this.pageid);
//if (this._userpowers.Count != 0)
//{
// return true;
//}
//else
//{
// return false;
//}
return(false);
}
public int GetMemberLastInsertedId()
{
IReader<Member> business = new MemberBusiness();
return business.GetLastInsertedId();
}
public void EditMember(Member element, string username, string password)
{
IManager<Member> business = new MemberBusiness();
business.Edit(element, username, password);
}
public MemberAPIController(MemberBusiness _MemberService)
{
this.MemberService = _MemberService;
}
public Member Login(string username, string password)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
return business.Login(username, password);
}
public ActionResult Create([Bind(Include = "ShowName,Title,Content,ConfessID ,ImgUrl ")]Funny funny)
{
IMemberBusiness iMember=new MemberBusiness(new JustSayEntities());
if (iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
iFunny.Add(funny);
return RedirectToAction("New");
}
return View(funny);
}
public object GetGameInfo(Dictionary <string, object> dicParas)
{
//获取token模式
XCGameMemberTokenModel memberTokenModel = (XCGameMemberTokenModel)(dicParas[Constant.XCGameMemberTokenModel]);
string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty;
StoreBusiness store = new StoreBusiness();
string xcGameDBName = string.Empty;
string password = string.Empty;
string errMsg = string.Empty;
string storeId = string.Empty;
//验证门店信息
if (!store.IsEffectiveStore(memberTokenModel.StoreId, out xcGameDBName, out password, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证设备信息
XCCloudService.Model.XCGameManager.t_device deviceModel = null;
XCCloudService.Model.XCGame.t_member memberModel = null;
if (!DeviceManaBusiness.ExistDevice(deviceToken, ref deviceModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证设备门店信息和会员门店信息
if (!memberTokenModel.StoreId.Equals(deviceModel.StoreId))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证会员信息
if (!MemberBusiness.IsEffectiveStore(memberTokenModel.Mobile, xcGameDBName, ref memberModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
//验证头信息
XCCloudService.BLL.IBLL.XCGame.IHeadService headService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IHeadService>(xcGameDBName);
var headModel = headService.GetModels(p => p.MCUID.Equals(deviceModel.DeviceId)).FirstOrDefault <XCCloudService.Model.XCGame.t_head>();
if (headModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备门店头部信息不存在"));
}
//验证游戏机信息
XCCloudService.BLL.IBLL.XCGame.IGameService gameService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IGameService>(xcGameDBName);
var gameModel = gameService.GetModels(p => p.GameID.Equals(headModel.GameID)).FirstOrDefault <XCCloudService.Model.XCGame.t_game>();
if (gameModel == null)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备门店头部信息不存在"));
}
//获取游戏机投币规则
XCCloudService.BLL.IBLL.XCGame.IPushRuleService pushRuleService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IPushRuleService>(xcGameDBName);
List <XCCloudService.Model.XCGame.t_push_rule> pushRuleModelList = pushRuleService.GetModels(p => p.game_id.Equals(headModel.GameID) && p.member_level_id == memberModel.MemberLevelID).OrderBy(p => p.level).ToList <XCCloudService.Model.XCGame.t_push_rule>();
List <int> pushRuleModelResultList = new List <int>();
//验证会员是否存在优惠记录
List <object> gameFreeRuleObjList = new List <object>();
List <XCCloudService.Model.XCGame.t_game_free_rule> gameFreeRuleModelList = null;
XCCloudService.BLL.IBLL.XCGame.IFlwGameFreeService flwGameFreeService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IFlwGameFreeService>(xcGameDBName);
var flwGameFreeModel = flwGameFreeService.GetModels(p => p.GameID.Equals(headModel.GameID) && p.ICCardID.Equals(memberModel.ICCardID.ToString())).FirstOrDefault <XCCloudService.Model.XCGame.flw_game_free>();
if (flwGameFreeModel == null)
{
//如果不存在优惠记录，则返回优惠信息
XCCloudService.BLL.IBLL.XCGame.IGameFreeRuleService gameFreeRuleService = BLLContainer.Resolve <XCCloudService.BLL.IBLL.XCGame.IGameFreeRuleService>(xcGameDBName);
gameFreeRuleModelList = gameFreeRuleService.GetModels(
p => p.GameID.Equals(headModel.GameID) &&
p.MemberLevelID == memberModel.MemberLevelID &&
p.State == "启用").ToList <XCCloudService.Model.XCGame.t_game_free_rule>();
}
gameFreeRuleModelList = gameFreeRuleModelList.OrderBy(p => p.FreeCoin / decimal.Parse(p.NeedCoin.ToString())).ToList <XCCloudService.Model.XCGame.t_game_free_rule>();
for (int i = 0; i < gameFreeRuleModelList.Count; i++)
{
DateTime currentTime = System.DateTime.Now;
if (currentTime >= gameFreeRuleModelList[i].StartTime && currentTime <= gameFreeRuleModelList[i].EndTime)
{
var obj = new {
id = gameFreeRuleModelList[i].ID,
needCoin = gameFreeRuleModelList[i].NeedCoin,
freeCoin = gameFreeRuleModelList[i].FreeCoin,
exitCoin = gameFreeRuleModelList[i].ExitCoin
};
gameFreeRuleObjList.Add(obj);
}
}
foreach (var pushRuleModel in pushRuleModelList)
{
if (gameModel.PushReduceFromCard > pushRuleModel.coin)
{
pushRuleModelResultList.Add(Convert.ToInt32(gameModel.PushReduceFromCard));
}
}
if (pushRuleModelResultList.Count == 0)
{
pushRuleModelResultList.Add(Convert.ToInt32(gameModel.PushReduceFromCard));
}
var obj2 = new {
gameId = gameModel.GameID,
gameName = gameModel.GameName,
gameType = GetGameType(gameModel.GameType),
price = gameModel.PushReduceFromCard,
discountPrice = pushRuleModelResultList[0],
gameFreeRule = gameFreeRuleObjList
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj2));
}
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 int AddMember(Member element, string username, string password)
{
IManager<Member> business = new MemberBusiness();
return business.Add(element, username, password);
}
public ActionResult Create([Bind(Include = "Content,Message,ToEmail,ToPhone,ToName,ImgUrl,FlashUrl,MusicUrl,ViewName")]Confess confess)
{
IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
if (iMember.IsLimitPost(User.Identity.Name.ToInt()))
{
ViewData["Validate"] = true;
}
else
{
ModelState.Remove("_mvcCaptchaText");
}
if (ModelState.IsValid)
{
iConfess.Add(confess);
// IMemberBusiness iMember = new MemberBusiness(new JustSayEntities());
confess.Member = iMember.GetDetail(Convert.ToInt32(User.Identity.Name));
Relation relation = new Relation
{
FromEmail = confess.Member.Email,
ShowName = confess.Member.ShowName,
MemberID = confess.Member.ID,
FromPhone = confess.Member.Phone,
FromName = confess.Member.RealName,
ToEmail = confess.ToEmail,
ToName = confess.ToName,
ToPhone = confess.ToPhone,
};
ViewBag.IsEmailSuccess = Inform.Email(confess);
ViewBag.IsSMSSuccess = false;
ViewBag.IsSMSMsg = "";
if (!string.IsNullOrEmpty(confess.ToPhone))
{
if (confess.Member.Score > 50)
{
ViewBag.IsSMSSuccess = Inform.SMS(confess);
confess.Member.Score -= 50;
ViewBag.IsSmsSuccess = true;
}
else
{
ViewBag.IsSMSMsg = "节操币不足50，请多发贴，多回贴";
}
}
ViewData["ConfessID"] = confess.ID;
return View("~/Views/Relation/Create.cshtml", relation);
}
return View(confess);
}
public Member GetMember(int code)
{
IReader<Member> business = new MemberBusiness();
return business.Get(code);
}
public void DeleteMember(int code, string username, string password)
{
IManager<Member> business = new MemberBusiness();
business.Delete(code, username, password);
}
public int Register(Member member, string newPassword)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
return business.Register(member, newPassword);
}
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 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 bool ExistsUsername(string username)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
return business.Exists(username);
}
public void RequestLostPassword(string username, string email)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
business.RequestLostPassword(username, email);
}
public void ChangePassword(string username, string oldPassword, string newPassword)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
business.ChangePassword(username, oldPassword, newPassword);
}
public IEnumerable<Member> GetMembersAlumnis(Campus campus)
{
IMemberReader<Member, Campus> business = new MemberBusiness();
return business.GetAlumnis(campus);
}
public void SetNewPasswordAfterLost(string username, string newPassword, string key)
{
ILogin<Member, LostPasswordRequest> business = new MemberBusiness();
business.SetNewPasswordAfterLost(username, newPassword, key);
}
public IEnumerable<Member> GetMembersBureau()
{
IMemberReader<Member, Campus> business = new MemberBusiness();
return business.GetBureau();
}
public static void CreateICCard(string msg, Dictionary <string, Session> sessionPool, string sendIP)
{
string sRepeatCode = (new Random()).Next(0, 255).ToString();
string receiveIP = string.Empty;
string dogId = string.Empty;
string storePassword = string.Empty;
string newICCardId = string.Empty;
string errMsg = string.Empty;
string answerMsgType = Convert.ToInt32(TCPMessageType.办理新IC卡).ToString();
//解析消息对象
SocketDataModel <UserSendObject, MemberRegisterModel> socketDataModel = Utils.DataContractJsonDeserializer <SocketDataModel <UserSendObject, MemberRegisterModel> >(msg);
UserSendObject sendObj = socketDataModel.SendObject;
MemberRegisterModel memberRegisterModel = (MemberRegisterModel)(socketDataModel.Data);
newICCardId = memberRegisterModel.ICCardId;
//接受信息方是否存在
if (!GetIP(sessionPool, sendObj.UserToken, out receiveIP))
{
SendFailData(answerMsgType, sessionPool, sendIP, "用户未注册");
return;
}
//获取店密码接口
string userToken = sendObj.UserToken;
if (!StoreBusiness.GetStorePassword(userToken, out storePassword, out errMsg))
{
SendFailData(answerMsgType, sessionPool, sendIP, "获取门店信息出错");
return;
}
//验证是否可以办卡
if (ICCardUtility.CheckNullCard(storePassword))
{
if (MemberBusiness.CheckMemberCanRegister(userToken, memberRegisterModel.StoreId, memberRegisterModel.Mobile, out errMsg))
{
//办理新卡
if (ICCardUtility.CreateICCard(newICCardId, sRepeatCode, storePassword, out errMsg, true))
{
memberRegisterModel.RepeatCode = sRepeatCode;
object result_data = null;
int repeatCode = 0;
if (MemberBusiness.MemberRegister(memberRegisterModel, out repeatCode, out errMsg, ref result_data))
{
SendSuccessData(answerMsgType, sessionPool, sendIP, "会员卡开通成功", result_data);
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, errMsg);
}
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, errMsg);
}
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, errMsg);
}
}
else
{
SendFailData(answerMsgType, sessionPool, sendIP, "本卡已使用，请插入空卡");
}
}
public IEnumerable<Member> GetMembersByCampus(Campus campus)
{
IMemberReader<Member, Campus> business = new MemberBusiness();
return business.GetBureauAndMembersActives(campus);
}
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 IEnumerable<Member> SearchMembers(string keywords)
{
ISearchable<Member> business = new MemberBusiness();
return business.Search(keywords);
}
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 IEnumerable<Member> GetMembersWaitingForValidation()
{
IMemberReader<Member, Campus> business = new MemberBusiness();
return business.GetWaitingForValidation();
}
