void queryWalletAmount() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); int memberId; int agentId; string agentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(agentId_s, out agentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (req["externalId"] ?? "").ToString(); var checkExternalIdExit = memberDefine.CheckMemberExternalIdExist(externalId_s, agentId); if (checkExternalIdExit == false) { result["result"] = "fail"; result["msg"] = "externalId不存在"; result["errorCode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } memberId = memberDefine.GetMemberId(externalId_s, agentId); decimal walletAmount = memberDefine.GetMemberWalletAmount(memberId); result["result"] = "success"; result["msg"] = "查詢完成"; result["walletAmount"] = walletAmount; result["errorcode"] = 0; Response.Write(JsonConvert.SerializeObject(result)); }
void AddAgent() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } if ((int)Session["levelId"] < 8) { result["result"] = "fail"; result["msg"] = "無新增代理權限"; result["column"] = "authorization"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); int agentId = (int)Session["id"]; string username; string password; string title; string nickname; string username_s = (req["username"] ?? "").ToString(); var chkUsernameFmt = memberDefine.UsernameValidate(username_s); if (chkUsernameFmt == 1) { result["result"] = "fail"; result["msg"] = "username長度必須為4~10"; result["column"] = "username"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkUsernameFmt == 2) { result["result"] = "fail"; result["msg"] = "username字元須為英數"; result["column"] = "username"; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkUsernameExist = memberDefine.CheckMemberUsernameExist(username_s); if (chkUsernameExist == true) { result["result"] = "fail"; result["msg"] = "帳號重複"; result["column"] = "username"; Response.Write(JsonConvert.SerializeObject(result)); return; } username = username_s; string password_s = (req["password"] ?? "").ToString(); var chkpassword = memberDefine.PasswordValidate(password_s); if (chkpassword == 1) { result["result"] = "fail"; result["msg"] = "password長度必須為4~10"; result["column"] = "password"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkpassword == 2) { result["result"] = "fail"; result["msg"] = "password字元須為英數"; result["column"] = "password"; Response.Write(JsonConvert.SerializeObject(result)); return; } password = password_s; string title_s = (req["title"] ?? "").ToString(); var chkTitleFmt = memberDefine.TitleValidate(title_s); if (chkTitleFmt == 1) { result["result"] = "fail"; result["msg"] = "title長度必須為1~15"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkTitleFmt == 2) { result["result"] = "fail"; result["msg"] = "title字元須為中文英數"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } title = title_s; string nickname_s = (req["nickname"] ?? "").ToString(); var chkNicknameFmt = memberDefine.TitleValidate(nickname_s); if (chkNicknameFmt == 1) { result["result"] = "fail"; result["msg"] = "nickname長度必須為1~15"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkNicknameFmt == 2) { result["result"] = "fail"; result["msg"] = "nickname字元須為中文英數"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } nickname = nickname_s; Model.Member.Add add = new Model.Member.Add(); Model.Member.Add.AgentStruct s = new Model.Member.Add.AgentStruct(); s.Username = username; s.Password = password; s.ParentId = agentId; s.Title = title; s.Nickname = nickname; add.AgentStructHandle(s); result["result"] = "success"; result["msg"] = "新增完成"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); }
void AgentList() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); Model.Member.View memberView = new Model.Member.View(); int? l8 = null; int? l7 = null; int? levelId = null; string status = null; DateTime?createBeginDateTime = null; DateTime?createEndDateTime = null; string l8_s = (req["l8"] ?? "").ToString(); if (l8_s != "") { int l8Temp; var chkL8fmt = int.TryParse(l8_s, out l8Temp); if (chkL8fmt == false) { result["result"] = "fail"; result["msg"] = "L8格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } l8 = l8Temp; } string l7_s = (req["l7"] ?? "").ToString(); if (l7_s != "") { int l7Temp; var chkL7fmt = int.TryParse(l7_s, out l7Temp); if (chkL7fmt == false) { result["result"] = "fail"; result["msg"] = "L7格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } l7 = l7Temp; } string levelId_s = (req["levelId"] ?? "").ToString(); if (levelId_s != "") { int levelIdTemp; var checkLevelIdFmt = int.TryParse(levelId_s, out levelIdTemp); if (checkLevelIdFmt == false) { result["result"] = "fail"; result["msg"] = "levelId格式錯誤"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } var checkLevelIdExit = Model.Member.Define.MemberLevelsLangMap.ContainsKey(levelIdTemp); if (checkLevelIdExit == false) { result["result"] = "fail"; result["msg"] = "levelId不存在"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } levelId = levelIdTemp; } string status_s = (req["status"] ?? "").ToString(); if (status_s != "") { var chkStatusExist = Model.Member.Define.MemberStautsLangMap.ContainsKey(status_s); if (chkStatusExist == false) { result["result"] = "fail"; result["msg"] = "status不存在"; result["column"] = "status"; Response.Write(JsonConvert.SerializeObject(result)); return; } status = status_s; } string createBeginDateTime_s = (req["createBeginDateTime"] ?? "").ToString(); //時間 string createEndDateTime_s = (req["createEndDateTime"] ?? "").ToString(); if (createBeginDateTime_s != "" && createEndDateTime_s != "") { DateTime createBeginDateTimeTemp; var s = DateTime.TryParse(createBeginDateTime_s, out createBeginDateTimeTemp); if (s == false) { result["result"] = "fail"; result["msg"] = "日期格式錯誤"; result["column"] = "createBeginDateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } createBeginDateTime = createBeginDateTimeTemp; DateTime createEndDateTimeTemp; var e = DateTime.TryParse(createEndDateTime_s, out createEndDateTimeTemp); if (e == false) { result["result"] = "fail"; result["msg"] = "日期格式錯誤"; result["column"] = "createEndDateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } createEndDateTime = createEndDateTimeTemp; } Model.Member.List list = new Model.Member.List(); Model.Member.List.AgentListStruct br = new Model.Member.List.AgentListStruct(); br.L8 = l8; br.L7 = l7; br.status = status; br.LevelId = levelId; br.CreateBeginDateTime = createBeginDateTime; br.CreateEndDateTime = createEndDateTime; var agentListResult = list.AgentListStructHandle(br); result["result"] = 0; result["column"] = 0; result["list"] = agentListResult; Response.Write(JsonConvert.SerializeObject(result)); }
void DeleteAgent() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); int targetAgentId; int agentId = (int)Session["id"]; int agentLevelId = (int)Session["levelId"]; int targetAgentLevelId; string targetAgentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(targetAgentId_s, out targetAgentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["column"] = "agentId"; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(targetAgentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["column"] = "agentId"; Response.Write(JsonConvert.SerializeObject(result)); return; } targetAgentLevelId = memberDefine.GetMemberLevelId(targetAgentId); int?targetAgentLN = memberDefine.GetMemberLN(targetAgentId, agentLevelId); if (agentId != targetAgentLN || agentId == targetAgentId) { result["result"] = "fail"; result["msg"] = "權限不足"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Edit memberEdit = new Model.Member.Edit(); Model.Member.Edit.AgentStruct bs = new Model.Member.Edit.AgentStruct(); bs.AgentId = targetAgentId; bs.Stauts = Model.Member.Define.MemberStauts.Disable; bs.UpdateUserId = agentId; memberEdit.AgentStructHandle(bs); result["result"] = "success"; result["msg"] = "鎖定帳戶成功"; Response.Write(JsonConvert.SerializeObject(result)); }
public void AgentStructHandle(AgentStruct AgentStruct) { string select_str = "select levelId, l9, l8, l7,companyId , betSetting from [lottery].[dbo].[member] with(nolock) "; string where_str = " Where id = @id "; var e = conn.Query <member>(select_str + where_str, new { Id = AgentStruct.ParentId }).FirstOrDefault(); select_str = "select betRate, defaultBetSetting from [lottery].[dbo].[company] with(nolock) "; where_str = " Where principalId = @principalId "; var h = conn.Query <company>(select_str + where_str, new { principalId = AgentStruct.ParentId }).FirstOrDefault(); Define memberDefine = new Define(); member m = new member() { username = AgentStruct.Username, password = AgentStruct.Password, levelId = memberDefine.GetNextLevelId(e.levelId), companyId = 0, parentId = AgentStruct.ParentId, externalId = "", createDateTime = DateTime.Now, l9 = e.l9, l8 = e.l8, l7 = e.l7, betSetting = e.betSetting, status = Define.MemberStauts.Enable, nickname = AgentStruct.Nickname }; dcdc.members.InsertOnSubmit(m); dcdc.SubmitChanges(); int principalId = m.id; company c = new company() { title = AgentStruct.Title, createDateTime = DateTime.Now, principalId = principalId, betRate = h.betRate, defaultBetSetting = h.defaultBetSetting }; dcdc.companies.InsertOnSubmit(c); dcdc.SubmitChanges(); int companyId = c.Id; if (AgentStruct.LevelId == Define.MemberLevels.UpAgent) { m.l8 = principalId; } if (AgentStruct.LevelId == Define.MemberLevels.Agent) { m.l7 = principalId; } m.companyId = companyId; dcdc.SubmitChanges(); }
void GetDefaultBetSetting() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); Model.Company.Define companyDefine = new Model.Company.Define(); int agentId = (int)Session["id"]; int agentLevelId = (int)Session["levelId"]; int targetAgentId; int targetAgentLevelId; JToken defaultBetSetting; string targetAgentId_s = (Request["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(targetAgentId_s, out targetAgentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(targetAgentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } targetAgentLevelId = memberDefine.GetMemberLevelId(targetAgentId); defaultBetSetting = JsonConvert.DeserializeObject <JObject>(companyDefine.GetCompanyDefaultBetSetting(targetAgentId)); int?targetAgentLN = memberDefine.GetMemberLN(targetAgentId, agentLevelId); if (agentId != targetAgentLN) { result["result"] = "fail"; result["msg"] = "權限不足"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } result["result"] = "success"; result["msg"] = "取得成功"; result["column"] = ""; result["betRate"] = defaultBetSetting; Response.Write(JsonConvert.SerializeObject(result)); }
void Login() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); string clientIP = glbf.GetClientIP(); int agentId; int agentLevelId; string agentStatus; string username = (req["username"] ?? "").ToString(); var chkUsernameExit = memberDefine.CheckMemberUsernameExist(username); if (chkUsernameExit == false) { result["result"] = "fail"; result["msg"] = "無此帳號"; result["column"] = "username"; Response.Write(JsonConvert.SerializeObject(result)); return; } agentId = memberDefine.GetMemberId(username); agentLevelId = memberDefine.GetMemberLevelId(agentId); agentStatus = memberDefine.GetMemberStatus(agentId); if (agentLevelId < 7) { result["result"] = "fail"; result["msg"] = "非代理帳號"; result["column"] = "agentId"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (agentStatus == Model.Member.Define.MemberStauts.Disable) { result["result"] = "fail"; result["msg"] = "帳號鎖定"; result["column"] = "status"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (agentStatus == Model.Member.Define.MemberStauts.NeedToChangePassword) { result["result"] = "fail"; result["msg"] = "請修改密碼後再次登入"; result["column"] = "status"; Response.Write(JsonConvert.SerializeObject(result)); return; } string password = (req["password"] ?? "").ToString(); if (password != memberDefine.GetMemberPassword(agentId)) { result["result"] = "fail"; result["msg"] = "密碼錯誤"; result["column"] = "password"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Edit e = new Model.Member.Edit(); Model.Member.Edit.AgentLoginStruct s = new Model.Member.Edit.AgentLoginStruct(); s.AgentId = agentId; s.LoginIP = clientIP; e.AgentLoginStructHandle(s); result["result"] = "success"; result["msg"] = "登入成功"; result["id"] = agentId.ToString(); Response.Write(JsonConvert.SerializeObject(result)); }
void Edit() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); int targetAgentId; string password = null; string title = null; string nickname = null; string targetAgentStatus = null; int targetAgentLevelId; int agentId = (int)Session["id"];; int agentLevelId = (int)Session["levelId"]; string targetAgentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(targetAgentId_s, out targetAgentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(targetAgentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } targetAgentLevelId = memberDefine.GetMemberLevelId(targetAgentId); if (targetAgentLevelId < 7) { result["result"] = "fail"; result["msg"] = "修改對象非代理帳號"; result["column"] = "AgentId"; Response.Write(JsonConvert.SerializeObject(result)); return; } string password_s = (req["password"] ?? "").ToString(); if (password_s != "") { var chkpassword = memberDefine.PasswordValidate(password_s); if (chkpassword == 1) { result["result"] = "fail"; result["msg"] = "password長度必須為4~10"; result["column"] = "password"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkpassword == 2) { result["result"] = "fail"; result["msg"] = "password字元須為英數"; result["column"] = "password"; Response.Write(JsonConvert.SerializeObject(result)); return; } targetAgentStatus = Model.Member.Define.MemberStauts.NeedToChangePassword; password = password_s; } string title_s = (req["title"] ?? "").ToString(); if (title_s != "") { var chktitle = memberDefine.TitleValidate(title_s); if (chktitle == 1) { result["result"] = "fail"; result["msg"] = "title長度必須為1~15"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chktitle == 2) { result["result"] = "fail"; result["msg"] = "title字元須為英數"; result["column"] = "title"; Response.Write(JsonConvert.SerializeObject(result)); return; } title = title_s; } string nickname_s = (req["nickname"] ?? "").ToString(); if (nickname_s != "") { var chkNicknameFmt = memberDefine.TitleValidate(nickname_s); if (chkNicknameFmt == 1) { result["result"] = "fail"; result["msg"] = "nickname長度必須為1~15"; result["column"] = "nickname"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkNicknameFmt == 2) { result["result"] = "fail"; result["msg"] = "nickname字元須為英數"; result["column"] = "nickname"; Response.Write(JsonConvert.SerializeObject(result)); return; } nickname = nickname_s; } int?targetAgentLN = memberDefine.GetMemberLN(targetAgentId, agentLevelId); if (agentId != targetAgentLN || agentId == targetAgentId) { result["result"] = "fail"; result["msg"] = "無修改權限"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Edit.AgentStruct s = new Model.Member.Edit.AgentStruct(); Model.Member.Edit update = new Model.Member.Edit(); s.AgentId = targetAgentId; s.Password = password; s.Title = title; s.Nickname = nickname; s.UpdateUserId = agentId; s.Stauts = targetAgentStatus; update.AgentStructHandle(s); result["result"] = "success"; result["msg"] = "更新成功"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); }
void createMember() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); int agentId; string externalId; int agentLevelId; string agentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(agentId_s, out agentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } agentLevelId = memberDefine.GetMemberLevelId(agentId); if (agentLevelId != 7) { result["result"] = "fail"; result["msg"] = "levelId 錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (req["externalId"] ?? "").ToString(); var chkExternalIdFmt = memberDefine.UsernameValidate(externalId_s); if (chkExternalIdFmt == 1) { result["result"] = "fail"; result["msg"] = "externalId長度必須為4~10"; result["column"] = "externalId"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (chkExternalIdFmt == 2) { result["result"] = "fail"; result["msg"] = "externalId字元須為英數"; result["column"] = "externalId"; Response.Write(JsonConvert.SerializeObject(result)); return; } var checkExternalIdExist = memberDefine.CheckMemberExternalIdExist(externalId_s, agentId); if (checkExternalIdExist == true) { result["result"] = "fail"; result["msg"] = "externalId重複"; result["errorcode"] = ApiErrorCodes.UsernameExist; Response.Write(JsonConvert.SerializeObject(result)); return; } externalId = externalId_s; Model.Member.Add add = new Model.Member.Add(); Model.Member.Add.MemberStruct s = new Model.Member.Add.MemberStruct(); s.ExternalId = externalId; s.AgentId = agentId; add.MemberStructHandle(s); result["result"] = "success"; result["msg"] = "新增完成"; result["errorcode"] = 0; Response.Write(JsonConvert.SerializeObject(result)); }
void EditDefaultBetSetting() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); int agentId = (int)Session["id"]; int targetAgentId; JObject defaultBetSettingObj; int agentLevelId = (int)Session["levelId"]; int targetAgentLevelId; string defaultBetSetting = (req["defaultBetSetting"] ?? "").ToString(); string targetAgentUsername = (req["agentUsername"] ?? "").ToString(); string targetAgentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(targetAgentId_s, out targetAgentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(targetAgentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } targetAgentLevelId = memberDefine.GetMemberLevelId(targetAgentId); try { defaultBetSettingObj = JsonConvert.DeserializeObject <JObject>(defaultBetSetting); } catch (Exception excep) { result["result"] = "fail"; result["msg"] = "betSetting轉換json失敗"; result["column"] = "betSetting"; Response.Write(JsonConvert.SerializeObject(result)); return; } int?targetAgentLN = memberDefine.GetMemberLN(targetAgentId, agentLevelId); if (agentId != targetAgentLN) { result["result"] = "fail"; result["msg"] = "權限不足"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Edit edit = new Model.Member.Edit(); Model.Member.Edit.AgentStruct bs = new Model.Member.Edit.AgentStruct(); bs.AgentId = targetAgentId; bs.DefaultBetSetting = defaultBetSettingObj; bs.UpdateUserId = agentId; edit.AgentStructHandle(bs); result["result"] = "success"; result["msg"] = "修改預設賽事設定完成"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); }
void oneTimeLinkLogin() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); byte[] decbuff = Convert.FromBase64String(Request["post"]); var o = System.Text.Encoding.UTF8.GetString(decbuff); var json = JsonConvert.DeserializeObject <JObject>(o); int memberId; string ip = glbf.GetClientIP(); int agentId; string memberGuid; string agentId_s = (json["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(agentId_s, out agentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (json["externalId"] ?? "").ToString(); var checkExternalIdExit = memberDefine.CheckMemberExternalIdExist(externalId_s, agentId); if (checkExternalIdExit == false) { result["result"] = "fail"; result["msg"] = "externalId不存在"; result["errorCode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } memberId = memberDefine.GetMemberId(externalId_s, agentId); memberGuid = memberDefine.GetMemberGuid(memberId); string guid_s = (json["guid"] ?? "").ToString(); if (guid_s != memberGuid) { result["result"] = "fail"; result["msg"] = "guid錯誤"; result["errorcode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Edit memberEdit = new Model.Member.Edit(); Model.Member.Edit.MemberLoginStruct s = new Model.Member.Edit.MemberLoginStruct(); s.MemberId = memberId; s.LoginIP = ip; memberEdit.MemberLoginStructHandle(s); result["result"] = "success"; result["msg"] = "登入成功"; Response.Redirect("./index"); }
void depositWalletAmount() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); int memberId; decimal memberWalletAmount; string transferType; decimal walletDiff; int agentId; string transferType_s = (req["transferType"] ?? "").ToString(); string walletAmount_s = (req["walletAmount"] ?? "").ToString(); string agentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(agentId_s, out agentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (req["externalId"] ?? "").ToString(); var checkExternalIdExit = memberDefine.CheckMemberExternalIdExist(externalId_s, agentId); if (checkExternalIdExit == false) { result["result"] = "fail"; result["msg"] = "externalId不存在"; result["errorCode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } memberId = memberDefine.GetMemberId(externalId_s, agentId); memberWalletAmount = memberDefine.GetMemberWalletAmount(memberId); bool conversionWalletAmount = decimal.TryParse(walletAmount_s, out walletDiff); if (conversionWalletAmount == false) { result["result"] = "fail"; result["msg"] = "金額格式錯誤"; Response.Write(JsonConvert.SerializeObject(result)); return; } bool checkTransferType = Model.Member.Define.TransactionTypesLangMap.ContainsKey(transferType_s); if (checkTransferType == false) { result["result"] = "fail"; result["msg"] = "交易型態錯誤"; Response.Write(JsonConvert.SerializeObject(result)); return; } transferType = transferType_s; if (transferType == Model.Member.Define.TransactionType.Debits) { if (walletDiff > memberWalletAmount) { result["result"] = "fail"; result["msg"] = "餘額不足"; Response.Write(JsonConvert.SerializeObject(result)); return; } memberWalletAmount -= walletDiff; } else if (transferType == Model.Member.Define.TransactionType.Deposit) { memberWalletAmount += walletDiff; } Model.Member.Edit.BalanceTransferStruct m = new Model.Member.Edit.BalanceTransferStruct(); Model.Member.Edit edit = new Model.Member.Edit(); m.MemberId = memberId; m.WalletAmount = memberWalletAmount; edit.BalanceTransferStructHandle(m); result["result"] = "success"; result["msg"] = "交易成功,交易金額為:" + walletDiff.ToString() + ",目前餘額為:" + memberWalletAmount.ToString(); Response.Write(JsonConvert.SerializeObject(result)); }
void betFormAdd() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 2) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); Model.BetForm.Define betFormDefine = new Model.BetForm.Define(); int memberId = (int)Session["id"]; int parentId = (int)Session["parentId"]; string ip = glbf.GetClientIP(); string periodId = betFormDefine.GetLotteryPeriodId(); JObject chooseBallObj; string betType; string betBranch; string betRemark = null; decimal betAmount; int combo; decimal rate; decimal totalBet; decimal walletAmount = memberDefine.GetMemberWalletAmount(memberId); string betType_s = (req["betType"] ?? "").ToString(); var checkBetTypeExit = Model.BetForm.Define.BetTypesLangMap.ContainsKey(betType_s); if (checkBetTypeExit == false) { result["result"] = "fail"; result["msg"] = "找不到此BetType"; result["column"] = "betType"; Response.Write(JsonConvert.SerializeObject(result)); return; } betType = betType_s; string betBranch_s = (req["betBranch"] ?? "").ToString(); int betBranchTemp; var chkBetBranchTempFmt = int.TryParse(betBranch_s, out betBranchTemp); if (chkBetBranchTempFmt == false) { result["result"] = "fail"; result["msg"] = "betBranch格式錯誤"; result["column"] = "betBranch"; Response.Write(JsonConvert.SerializeObject(result)); return; } betBranch = betBranch_s; string betRemark_s = (req["betRemark"] ?? "").ToString(); if (betRemark_s != "") { var checkBetRemark = memberDefine.TitleValidate(betRemark_s); if (checkBetRemark == 2) { result["result"] = "fail"; result["msg"] = "只能輸入中文或英數"; result["column"] = "betRemark"; Response.Write(JsonConvert.SerializeObject(result)); return; } else if (checkBetRemark == 1) { result["result"] = "fail"; result["msg"] = "字串長度錯誤"; result["column"] = "betRemark"; Response.Write(JsonConvert.SerializeObject(result)); return; } } betRemark = betRemark_s; string betAmount_s = (req["betAmount"] ?? "").ToString(); bool chkBetBetAmountFmt = decimal.TryParse(betAmount_s, out betAmount); if (chkBetBetAmountFmt == false) { result["result"] = "fail"; result["msg"] = "BetAmount格式錯誤"; result["column"] = "betAmount"; Response.Write(JsonConvert.SerializeObject(result)); return; } decimal singleBetMinValue = memberDefine.GetMemberSingleBetMinValue(memberId, betType); if (betAmount < singleBetMinValue) { result["result"] = "fail"; result["msg"] = "小於玩法單注限額"; result["column"] = "betAmount"; Response.Write(JsonConvert.SerializeObject(result)); return; } decimal singleBetMaxValue = memberDefine.GetMemberSingleBetMaxValue(memberId, betType); if (betAmount > singleBetMaxValue) { result["result"] = "fail"; result["msg"] = "大於玩法單注限額"; result["column"] = "betAmount"; Response.Write(JsonConvert.SerializeObject(result)); return; } //bool checkBetTime = define.CheckBetTime(); //if (checkBalance == false) //{ // result["result"] = "fail"; // result["msg"] = "超過時間"; // result["errorcode"] = ApiErrorCodes.OverTime; // Response.Write(JsonConvert.SerializeObject(result)); // return; //} string chooseBall_s = (req["chooseBall"] ?? "").ToString().TrimEnd(',').Replace("\r\n", "").Replace(" ", ""); try { chooseBallObj = JsonConvert.DeserializeObject <JObject>(chooseBall_s); } catch (Exception excep) { result["result"] = "fail"; result["msg"] = "chooseBall轉換json失敗"; result["column"] = "chooseBall"; Response.Write(JsonConvert.SerializeObject(result)); return; } var checkChooseBallCntCorrect = betFormDefine.CheckChooseBallCntCorrect(chooseBallObj, betType); if (checkChooseBallCntCorrect == false) { result["result"] = "fail"; result["msg"] = "chooseBall數量錯誤"; result["column"] = "chooseBall"; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkChooseBallItem = betFormDefine.CheckChooseBallItemCorrect(chooseBallObj, betType, parentId); if (chkChooseBallItem == false) { result["result"] = "fail"; result["msg"] = "賠率異常或球號異常"; result["column"] = "chooseBall"; Response.Write(JsonConvert.SerializeObject(result)); return; } string rate_s = (req["rate"] ?? "").ToString(); var chkRateFmt = decimal.TryParse(rate_s, out rate); if (chkRateFmt == false) { result["result"] = "fail"; result["msg"] = "rate格式錯誤"; result["column"] = "rate"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (rate != betFormDefine.CalcBetFormRate(chooseBallObj, betType)) { result["result"] = "fail"; result["msg"] = "rate錯誤"; result["column"] = "rate"; Response.Write(JsonConvert.SerializeObject(result)); return; } string combo_s = (req["combo"] ?? "").ToString(); int comboTemp; var chkComboFmt = int.TryParse(combo_s, out comboTemp); if (chkComboFmt == false) { result["result"] = "fail"; result["msg"] = "combo格式錯誤"; result["column"] = "combo"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (betFormDefine.CalcBetFormCombo(chooseBallObj, betType) != comboTemp) { result["result"] = "fail"; result["msg"] = "combo錯誤"; result["column"] = "combo"; Response.Write(JsonConvert.SerializeObject(result)); return; } combo = comboTemp; string totalBet_s = (req["totalBet"] ?? "").ToString(); var chkTotalBetFmt = decimal.TryParse(totalBet_s, out totalBet); if (chkTotalBetFmt == false) { result["result"] = "fail"; result["msg"] = "totalBet格式錯誤"; result["column"] = "totalBet"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (totalBet != betAmount * combo) { result["result"] = "fail"; result["msg"] = "totalBet錯誤"; result["column"] = "totalBet"; Response.Write(JsonConvert.SerializeObject(result)); return; } decimal betMaxValueByBetType = memberDefine.GetMemberBetMaxValueByBetType(memberId, betType); decimal agentBetMaxValue = memberDefine.GetMemberAgentBetMaxValue(memberId, betType); decimal totalBetByMember = betFormDefine.GetTotalBetByMember(memberId, periodId, betType); decimal totalBetByAgent = betFormDefine.GetTotalBetByAgent(parentId, periodId); if (totalBet + totalBetByMember > betMaxValueByBetType) { result["result"] = "fail"; result["msg"] = "超過單一玩法限制最大總計金額"; result["column"] = "totalBet"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (totalBet + totalBetByAgent > agentBetMaxValue) { result["result"] = "fail"; result["msg"] = "超過代理限制最大總計金額"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); return; } if (totalBet > walletAmount) { result["result"] = "fail"; result["msg"] = "餘額不足"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); return; } walletAmount -= totalBet; // 錢包餘額扣掉下注總金額 bool checkBetFormExist = betFormDefine.CheckBetFormExist(memberId, chooseBallObj, betType); if (checkBetFormExist == true) { result["result"] = "fail"; result["msg"] = "重複下注"; result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.BetForm.Add betFormAdd = new Model.BetForm.Add(); Model.BetForm.Add.BetFormStruct b = new Model.BetForm.Add.BetFormStruct(); b.memberId = memberId; b.BetType = betType; b.BetBranch = betBranch; // 暫時未使用 b.ChooseBall = JsonConvert.SerializeObject(chooseBallObj); b.Rate = rate; b.Combo = combo; b.BetAmount = betAmount; b.TotalBet = totalBet; b.IP = ip; b.PeriodId = periodId; b.BetRemark = betRemark; betFormAdd.BetFormStructtHandle(b); // add 注單 Model.Member.Edit memberEdit = new Model.Member.Edit(); Model.Member.Edit.BalanceTransferStruct eb = new Model.Member.Edit.BalanceTransferStruct(); eb.MemberId = memberId; eb.WalletAmount = totalBet; memberEdit.BalanceTransferStructHandle(eb); // 修改 walletAmount result["result"] = "success"; result["msg"] = "第" + periodId + "期下注成功,下注金額為:" + totalBet.ToString() + "賠率為:" + rate.ToString() + " ,剩餘金額:" + walletAmount.ToString(); result["column"] = ""; Response.Write(JsonConvert.SerializeObject(result)); }
/// <summary> /// 取得列表 /// </summary> /// <param name="memberid"></param> /// <returns>a:username; b:levelId; c:externalId; d:loginDateTime; e:loginIP; f:createDateTime; g:updatedatetime; h:updateUserId</returns> public JArray AgentListStructHandle(AgentListStruct br) { JArray ja = new JArray(); Define define = new Define(); string select_str = "select * from [lottery].[dbo].[member] with(nolock) "; string where_str = ""; where_str += glbf.GetSQLSameLine(); if (br.L8 != null) { if (where_str != "") { where_str += " and "; } where_str += " l8 = " + br.L8.ToString(); } if (br.L7 != null) { if (where_str != "") { where_str += " and "; } where_str += " l7 = " + br.L7.ToString(); } if (br.LevelId != null) { if (where_str != "") { where_str += " and "; } where_str += " levelId = " + br.LevelId.ToString(); } if (br.CreateBeginDateTime.HasValue) { if (where_str != "") { where_str += " and "; } where_str += " createDateTime >= '" + ((DateTime)br.CreateBeginDateTime).ToString("yyyy/MM/dd HH:mm:ss") + "'"; } if (br.CreateEndDateTime.HasValue) { if (where_str != "") { where_str += " and "; } where_str += " createDateTime <= '" + ((DateTime)br.CreateEndDateTime).ToString("yyyy/MM/dd HH:mm:ss") + "'"; } if (br.status != null) { if (where_str != "") { where_str += " and "; } where_str += " status = '" + br.status + "'"; } List <member> agentList = new List <member>(); if (where_str != "") { agentList.AddRange(conn.Query <member>(select_str + " where " + where_str).ToList()); } else { agentList.AddRange(conn.Query <member>(select_str).ToList()); } foreach (var m in agentList) { JToken jt = new JObject(); jt["a"] = m.username; jt["b"] = m.levelId; jt["c"] = m.companyId; if (m.loginDateTime.HasValue == false) { jt["d"] = ""; } else { jt["d"] = m.loginDateTime.Value.ToString("yyyy/MM/dd HH:mm:ss"); } if (m.loginIP == null) { jt["e"] = ""; } else { jt["e"] = m.loginIP; } jt["f"] = m.createDateTime.Value.ToString("yyyy/MM/dd HH:mm:ss"); if (m.updateDateTime.HasValue == false) { jt["g"] = ""; } else { jt["g"] = m.updateDateTime.Value.ToString("yyyy/MM/dd HH:mm:ss"); } if (m.updateUserId.HasValue) { jt["h"] = ""; } else { jt["h"] = m.updateUserId; } jt["i"] = m.id; jt["j"] = m.l9; jt["k"] = m.l8; jt["l"] = m.l7; jt["m"] = m.l1; jt["n"] = m.status; jt["o"] = m.nickname; ja.Add(jt); } return(ja); }
void ForwardGame() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); int memberId; string guid; int agentId; string agentId_s = (req["agentId"] ?? "").ToString(); var chkAgentIdFmt = int.TryParse(agentId_s, out agentId); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentId); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (req["externalId"] ?? "").ToString(); var checkExternalIdExit = memberDefine.CheckMemberExternalIdExist(externalId_s, agentId); if (checkExternalIdExit == false) { result["result"] = "fail"; result["msg"] = "externalId不存在"; result["errorCode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } memberId = memberDefine.GetMemberId(externalId_s, agentId); guid = Guid.NewGuid().ToString("N"); Model.Member.Edit edit = new Model.Member.Edit(); Model.Member.Edit.ForwardGameStruct fg = new Model.Member.Edit.ForwardGameStruct(); fg.MemberId = memberId; fg.Guid = guid; edit.ForwardGameStructHandle(fg); JToken jtk = new JObject(); jtk["agentId"] = agentId; jtk["externalId"] = externalId_s; jtk["guid"] = guid; string str = JsonConvert.SerializeObject(jtk); byte[] bt = Encoding.UTF8.GetBytes(str); string webaddr = Convert.ToBase64String(bt); result["result"] = "success"; result["errorCode"] = 0; result["agentId"] = agentId; result["externalId"] = externalId_s; result["url"] = "http://192.168.1.131:82/lottery/externalLogin?post=" + webaddr; Response.Write(JsonConvert.SerializeObject(result)); }
void GetMemberReport() { JToken result = new JObject(); if (glbf.GetLoginStatus() != 1) { result["result"] = "fail"; result["msg"] = "未完成登入程序"; result["column"] = "session"; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.Member.Define memberDefine = new Model.Member.Define(); Model.BetForm.Define betFormDefine = new Model.BetForm.Define(); int? l8 = null; int? l7 = null; int? l1 = null; int? levelId = null; string periodId = null; string status = null; string betType = null; bool? isDeliver = null; string reportType; DateTime beginDateTime; DateTime endDateTime; string l8_s = (req["l8"] ?? "").ToString(); if (l8_s != "") { int l8Temp; var chkL8fmt = int.TryParse(l8_s, out l8Temp); if (chkL8fmt == false) { result["result"] = "fail"; result["msg"] = "L8格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } l8 = l8Temp; } string l7_s = (req["l7"] ?? "").ToString(); if (l7_s != "") { int l7Temp; var chkL7fmt = int.TryParse(l7_s, out l7Temp); if (chkL7fmt == false) { result["result"] = "fail"; result["msg"] = "L7格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } l7 = l7Temp; } string l1_s = (req["l1"] ?? "").ToString(); if (l1_s != "") { int l1Temp; var chkL7fmt = int.TryParse(l1_s, out l1Temp); if (chkL7fmt == false) { result["result"] = "fail"; result["msg"] = "L1格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } l1 = l1Temp; } string levelId_s = (req["levelId"] ?? "").ToString(); if (levelId_s != "") { int levelIdTemp; var checkLevelIdFmt = int.TryParse(levelId_s, out levelIdTemp); if (checkLevelIdFmt == false) { result["result"] = "fail"; result["msg"] = "levelId格式錯誤"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } var checkLevelIdExit = Model.Member.Define.MemberLevelsLangMap.ContainsKey(levelIdTemp); if (checkLevelIdExit == false) { result["result"] = "fail"; result["msg"] = "levelId不存在"; result["column"] = "levelId"; Response.Write(JsonConvert.SerializeObject(result)); return; } levelId = levelIdTemp; } string periodId_s = (req["periodId"] ?? "").ToString(); if (periodId_s != "") { int periodIdTemp; var chkperiodIdfmt = int.TryParse(periodId_s, out periodIdTemp); if (chkperiodIdfmt == false) { result["result"] = "fail"; result["msg"] = "periodId格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } periodId = periodId_s; } string betType_s = (req["betType"] ?? "").ToString();//找玩法 if (betType_s != "") { var chkBetTypeExist = Model.BetForm.Define.BetTypesLangMap.ContainsKey(betType_s); if (chkBetTypeExist == false) { result["result"] = "fail"; result["msg"] = "betType不存在"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } betType = betType_s; } string status_s = (req["status"] ?? "").ToString();//找狀態 if (status_s != "") { var chkStatusExist = Model.BetForm.Define.BetFormStatusLangMap.ContainsKey(status_s); if (chkStatusExist == false) { result["result"] = "fail"; result["msg"] = "status不存在"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } status = status_s; } string isDeliver_s = (req["isDeliver"] ?? "").ToString(); if (isDeliver_s != "") { bool isDeliverTemp; var chkIsDeliverExist = bool.TryParse(isDeliver_s, out isDeliverTemp); if (chkIsDeliverExist == false) { result["result"] = "fail"; result["msg"] = "isDeliver格式錯誤"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } isDeliver = isDeliverTemp; } string beginDateTime_s = (req["beginDateTime"] ?? "").ToString(); string endDateTime_s = (req["endDateTime"] ?? "").ToString(); if (beginDateTime_s == "" || endDateTime_s == "") { result["result"] = "fail"; result["msg"] = "日期必須輸入"; result["column"] = "DateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } var s = DateTime.TryParse(beginDateTime_s, out beginDateTime); if (s == false) { result["result"] = "fail"; result["msg"] = "起始日期格式錯誤"; result["column"] = "beginDateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } var e = DateTime.TryParse(endDateTime_s, out endDateTime); if (e == false) { result["result"] = "fail"; result["msg"] = "結束日期格式錯誤"; result["column"] = "endDateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } if (endDateTime < beginDateTime) { result["result"] = "fail"; result["msg"] = "日期不能倒置"; result["column"] = "endDateTime"; Response.Write(JsonConvert.SerializeObject(result)); return; } string reportType_s = (req["reportType"] ?? "").ToString(); var checkReportType = Model.BetForm.Define.ReportTypesLangMap.ContainsKey(reportType_s); if (checkReportType == false) { result["result"] = "fail"; result["msg"] = "報表型態錯誤"; result["column"] = "reportType"; Response.Write(JsonConvert.SerializeObject(result)); return; } reportType = reportType_s; Model.BetForm.List list = new Model.BetForm.List(); JArray brList; if (reportType == "m") { Model.BetForm.List.BetFormSummaryStruct br = new Model.BetForm.List.BetFormSummaryStruct(); br.L8 = l8; br.L7 = l7; br.L1 = l1; br.LevelId = levelId; br.BetType = betType; br.PeriodId = periodId; br.Status = status; br.BeginDateTime = beginDateTime; br.EndDateTime = endDateTime; br.IsDeliver = isDeliver; brList = list.BetFormSummaryStructHandle(br); } else { Model.BetForm.List.BetFormDetailStruct br = new Model.BetForm.List.BetFormDetailStruct(); br.L8 = l8; br.L7 = l7; br.L1 = l1; br.BetType = betType; br.PeriodId = periodId; br.Status = status; br.BeginDateTime = beginDateTime; br.EndDateTime = endDateTime; br.IsDeliver = isDeliver; brList = list.BetFormDetailStructHandle(br); } result["result"] = 0; result["column"] = 0; result["msg"] = ""; result["list"] = brList; Response.Write(JsonConvert.SerializeObject(result)); }
void GetMemberBetForm() { JToken result = new JObject(); Model.Member.Define memberDefine = new Model.Member.Define(); Model.BetForm.Define betFormDefine = new Model.BetForm.Define(); int agentLevelId; int? l7 = null; int? l1 = null; string status = null; DateTime beginDateTime; DateTime endDateTime; string agentId_s = (req["agentId"] ?? "").ToString(); int agentIdTemp; var chkAgentIdFmt = int.TryParse(agentId_s, out agentIdTemp); if (chkAgentIdFmt == false) { result["result"] = "fail"; result["msg"] = "代理帳號格式錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } var chkAgentIdExit = memberDefine.CheckMemberIdExist(agentIdTemp); if (chkAgentIdExit == false) { result["result"] = "fail"; result["msg"] = "代理帳號不存在"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } l7 = agentIdTemp; agentLevelId = memberDefine.GetMemberLevelId(agentIdTemp); if (agentLevelId != 7) { result["result"] = "fail"; result["msg"] = "levelId 錯誤"; result["errorCode"] = ApiErrorCodes.AgentIdExistFalse; Response.Write(JsonConvert.SerializeObject(result)); return; } string externalId_s = (req["externalId"] ?? "").ToString(); if (externalId_s != "") { var checkExternalIdExit = memberDefine.CheckMemberExternalIdExist(externalId_s, agentIdTemp); if (checkExternalIdExit == false) { result["result"] = "fail"; result["msg"] = "externalId不存在"; result["errorCode"] = ApiErrorCodes.NotFindUsername; Response.Write(JsonConvert.SerializeObject(result)); return; } l1 = memberDefine.GetMemberId(externalId_s, agentIdTemp); } string status_s = (req["status"] ?? "").ToString();//找狀態 if (status_s != "") { var chkStatusExist = Model.BetForm.Define.BetFormStatusLangMap.ContainsKey(status_s); if (chkStatusExist == false) { result["result"] = "fail"; result["msg"] = "status不存在"; result["errorCode"] = ApiErrorCodes.UsernameFormatError; Response.Write(JsonConvert.SerializeObject(result)); return; } status = status_s; } string beginDateTime_s = (req["beginDateTime"] ?? "").ToString(); string endDateTime_s = (req["endDateTime"] ?? "").ToString(); if (beginDateTime_s == "" || endDateTime_s == "") { result["result"] = "fail"; result["msg"] = "日期必須輸入"; result["errorCode"] = ApiErrorCodes.DateNull; Response.Write(JsonConvert.SerializeObject(result)); return; } var s = DateTime.TryParse(beginDateTime_s, out beginDateTime); if (s == false) { result["result"] = "fail"; result["msg"] = "beginDateTime格式錯誤"; result["errorCode"] = ApiErrorCodes.DateTimeError; Response.Write(JsonConvert.SerializeObject(result)); return; } var e = DateTime.TryParse(endDateTime_s, out endDateTime); if (e == false) { result["result"] = "fail"; result["msg"] = "endDateTime格式錯誤"; result["errorCode"] = ApiErrorCodes.DateTimeError; Response.Write(JsonConvert.SerializeObject(result)); return; } var i = new TimeSpan(endDateTime.Ticks - beginDateTime.Ticks).TotalMinutes; if (i > 30000) { result["result"] = "fail"; result["msg"] = "日期區間間隔必須小於30分鐘"; result["errorCode"] = ApiErrorCodes.DateTimeInterval30; Response.Write(JsonConvert.SerializeObject(result)); return; } Model.BetForm.List list = new Model.BetForm.List(); Model.BetForm.List.BetFormDetailStruct br = new Model.BetForm.List.BetFormDetailStruct(); br.L7 = l7; br.L1 = l1; br.Status = status; br.BeginDateTime = beginDateTime; br.EndDateTime = endDateTime; var brList = list.BetFormDetailStructHandle(br); result["result"] = 0; result["errorCode"] = 0; result["msg"] = ""; result["list"] = brList; Response.Write(JsonConvert.SerializeObject(result)); }