public object getDeviceInfo(Dictionary <string, object> dicParas) { try { // string MobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty;//获取手机令牌 // if (MobileToken == "") // { // return ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机令牌不能为空"); // } // string mobile = string.Empty; // if (!MobileTokenBusiness.ExistToken(MobileToken, out mobile)) // { // return ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效"); // } // mobile = mobile.Replace("RS232", ""); // string sql = ""; // sql = @"select b.SN,b.Token,b.DeviceName,b.Status from Base_DeviceInfo as b // left join Base_MerchInfo as a on a.ID=b.MerchID where a.State='1' and DeviceType='0' and a.Mobile='" + mobile + "'"; // DataSet ds = XCCloudRS232BLL.ExecuteQuerySentence(sql, null); // DataTable dt = ds.Tables[0]; // if (dt.Rows.Count > 0) // { // var basedeviceinfolist = Utils.GetModelList<BaseDeviceInfoModel>(dt).ToList(); // BaseDeviceInfoModelList baseDeviceInfoModelList = new BaseDeviceInfoModelList(); // baseDeviceInfoModelList.Lists = basedeviceinfolist; // return ResponseModelFactory<BaseDeviceInfoModelList>.CreateModel(isSignKeyReturn, baseDeviceInfoModelList); // } string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } var list = DeviceBusiness.GetDeviceList().Where(t => t.MerchID == merch.ID && (DeviceTypeEnum)(int)t.DeviceType == DeviceTypeEnum.Router && t.Status == 1).ToList(); if (list.IsNull() || list.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据")); } BaseDeviceInfoModelList baseDeviceInfoModelList = new BaseDeviceInfoModelList(); baseDeviceInfoModelList.Lists = new List <BaseDeviceInfoModel>(); foreach (var item in list) { BaseDeviceInfoModel model = new BaseDeviceInfoModel(); model.DeviceName = item.DeviceName ?? item.SN; model.SN = item.SN; model.Token = item.Token; model.Status = DeviceStatusBusiness.GetDeviceState(item.Token); baseDeviceInfoModelList.Lists.Add(model); } return(ResponseModelFactory <BaseDeviceInfoModelList> .CreateModel(isSignKeyReturn, baseDeviceInfoModelList)); } catch (Exception e) { throw e; } }
public object getSegmentList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString() : string.Empty; string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo router = DeviceBusiness.GetDeviceModel(routerToken); if (router.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "控制器令牌无效")); } Data_GameInfo group = GameBusiness.GetGameInfoModel(Convert.ToInt32(groupId)); if (group.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "分组参数无效")); } //分组集合 var groupList = MerchSegmentBusiness.GetMerchSegmentList().Where(t => t.ParentID == router.ID && t.GroupID == group.GroupID).ToList(); GroupInfoModel model = new GroupInfoModel(); model.groupId = group.GroupID; model.groupName = group.GroupName; List <Terminal> Terminals = new List <Terminal>(); foreach (var item in groupList) { Terminal t = new Terminal(); Base_DeviceInfo cDevice = DeviceBusiness.GetDeviceModelById((int)item.DeviceID); t.terminalName = cDevice.DeviceName ?? cDevice.SN; t.terminalToken = cDevice.Token; t.headAddress = item.HeadAddress; t.sn = cDevice.SN; t.deviceType = ((DeviceTypeEnum)cDevice.DeviceType).ToDescription(); t.status = DeviceStatusBusiness.GetDeviceState(cDevice.Token); Terminals.Add(t); } model.Terminals = Terminals; return(ResponseModelFactory <GroupInfoModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
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 object editDeviceName(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; string deviceName = dicParas.ContainsKey("deviceName") ? dicParas["deviceName"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } //设备未绑定 if (device.MerchID.IsNull() || device.MerchID == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备尚未绑定")); } //设备所属商户不是当前商户 if (device.MerchID.IsNull() || device.MerchID == 0 || device.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备属于其他商户,您没有权限查看该设备")); } device.DeviceName = deviceName; DeviceBusiness.UpdateDevice(device); return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } catch (Exception e) { throw e; } }
public object replaceDevice(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string oldDeviceToken = dicParas.ContainsKey("oldDeviceToken") ? dicParas["oldDeviceToken"].ToString() : string.Empty; string newDeviceToken = dicParas.ContainsKey("newDeviceToken") ? dicParas["newDeviceToken"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo oldDevice = DeviceBusiness.GetDeviceModel(oldDeviceToken); if (oldDevice.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "您要替换的设备令牌无效")); } //设备所属商户不是当前商户 if (oldDevice.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备不属于当前商户,没有权限操作该设备")); } //新设备实体 Base_DeviceInfo newDevice = DeviceBusiness.GetDeviceModel(newDeviceToken); if (newDevice.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "当前扫面的设备令牌无效")); } //判断设备类别是否相同 if (oldDevice.DeviceType != newDevice.DeviceType) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备类型不同,不能替换")); } DeviceTypeEnum currDeviceType = (DeviceTypeEnum)oldDevice.DeviceType; int category = 0; switch (currDeviceType) { case DeviceTypeEnum.Router: category = 1; break; case DeviceTypeEnum.SlotMachines: case DeviceTypeEnum.DepositMachine: category = 2; break; case DeviceTypeEnum.Clerk: case DeviceTypeEnum.Terminal: category = 3; break; } if (category != 0) { string sql = "exec ReplaceDevice @oldDeviceId,@newDeviceId,@merchId,@category"; SqlParameter[] parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@oldDeviceId", oldDevice.ID); parameters[1] = new SqlParameter("@newDeviceId", newDevice.ID); parameters[2] = new SqlParameter("@merchId", merch.ID); parameters[3] = new SqlParameter("@category", category); int ret = XCCloudRS232BLL.ExecuteSql(sql, parameters); if (ret == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备替换失败")); } } //修改设备缓存状态 DeviceStatusBusiness.SetDeviceState(oldDevice.Token, DeviceStatusEnum.未激活.ToDescription()); DeviceStatusBusiness.SetDeviceState(newDevice.Token, DeviceStatusEnum.离线.ToDescription()); return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } catch (Exception e) { throw e; } }
public object updateDeviceState(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; string status = dicParas.ContainsKey("status") ? dicParas["status"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } //设备所属商户不是当前商户 if (device.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备属于其他商户,您没有权限查看该设备")); } if (string.IsNullOrWhiteSpace(status)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "参数错误")); } int routerId = 0; string strHeadAddress = string.Empty; //当前设备类型 DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; switch (currDeviceType) { case DeviceTypeEnum.SlotMachines: case DeviceTypeEnum.DepositMachine: { //获取外设绑定关系实体 Data_MerchDevice md = MerchDeviceBusiness.GetMerchDeviceModel(device.ID); if (md.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备未绑定")); } //获取控制器ID routerId = (int)md.ParentID; strHeadAddress = md.HeadAddress; } break; case DeviceTypeEnum.Clerk: case DeviceTypeEnum.Terminal: { //获取终端绑定关系实体 Data_MerchSegment ms = MerchSegmentBusiness.GetMerchSegmentModel(device.ID); if (ms.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备未绑定")); } //获取控制器ID routerId = (int)ms.ParentID; strHeadAddress = ms.HeadAddress; } break; } Base_DeviceInfo router = null; if (routerId != 0) { //获取当前设备所属的控制器实体 router = DeviceBusiness.GetDeviceModelById(routerId); } if (router == null) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取控制器信息失败")); } if (string.IsNullOrWhiteSpace(strHeadAddress)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取设备地址失败")); } //雷达处理指令 switch (status.Trim()) { //启用 case "1": device.DeviceType = (int)DeviceStatusEnum.启用; DeviceBusiness.UpdateDevice(device); DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.离线.ToDescription()); break; //停用 case "2": device.DeviceType = (int)DeviceStatusEnum.停用; DeviceBusiness.UpdateDevice(device); DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.停用.ToDescription()); break; //锁定 case "3": UDPServer.server.机头锁定解锁指令(router.Token, strHeadAddress, true); DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.锁定.ToDescription()); break; //解除锁定 case "4": UDPServer.server.机头锁定解锁指令(router.Token, strHeadAddress, false); DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.在线.ToDescription()); break; //解除报警 case "5": break; ////投币 //case "6": // UDPServer.server.远程投币上分(router.Token, strHeadAddress, "10000010", 5); // break; ////退币 //case "7": // UDPServer.server.远程退币(router.Token, strHeadAddress); // break; } //if (state == DeviceStatusEnum.停用 || state == DeviceStatusEnum.启用) //{ // device.Status = (int)state; // DeviceBusiness.UpdateDevice(device); //} return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } catch (Exception e) { throw e; } }
public object getMerchDeviceInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } //设备所属商户不是当前商户 if (device.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备属于其他商户,您没有权限查看该设备")); } DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; DeviceInfoModel model = new DeviceInfoModel(); model.Router = new Router(); model.Group = new Group(); model.deviceName = device.DeviceName ?? device.SN; model.deviceToken = device.Token; model.deviceType = currDeviceType.ToDescription(); model.deviceSN = device.SN; model.status = DeviceStatusBusiness.GetDeviceState(device.Token); switch (currDeviceType) { case DeviceTypeEnum.SlotMachines: case DeviceTypeEnum.DepositMachine: { //获取外设绑定关系实体 Data_MerchDevice md = MerchDeviceBusiness.GetMerchDeviceModel(device.ID); model.headAddress = md.HeadAddress; //获取控制器实体 Base_DeviceInfo router = DeviceBusiness.GetDeviceModelById((int)md.ParentID); model.Router.routerName = router.DeviceName ?? router.SN; model.Router.routerToken = router.Token; model.Router.sn = router.SN; } break; case DeviceTypeEnum.Clerk: case DeviceTypeEnum.Terminal: { //获取终端绑定关系实体 Data_MerchSegment ms = MerchSegmentBusiness.GetMerchSegmentModel(device.ID); model.headAddress = ms.HeadAddress; //获取分组实体 Data_GameInfo group = GameBusiness.GetGameInfoModel(Convert.ToInt32(ms.GroupID)); model.Group.groupId = group.GroupID; model.Group.groupName = group.GroupName; model.Group.groupType = ((GroupTypeEnum)(int)group.GroupType).ToDescription(); } break; } return(ResponseModelFactory <DeviceInfoModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object removeDevice(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } //设备所属商户不是当前商户 if (device.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备已被其他商户绑定,没有权限操作该设备")); } //开始解除绑定 device.MerchID = 0; device.Status = (int)DeviceStatusEnum.未激活; DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; bool ret = false; switch (currDeviceType) { case DeviceTypeEnum.Router: { string sql = string.Format("exec RemoveMerchRouter {0}", device.ID); XCCloudRS232BLL.ExecuteSql(sql); //ret = DeviceBusiness.UpdateDevice(device); } break; case DeviceTypeEnum.SlotMachines: case DeviceTypeEnum.DepositMachine: { //获取外设绑定关系实体 Data_MerchDevice md = MerchDeviceBusiness.GetMerchDeviceModel(device.ID); using (var transactionScope = new System.Transactions.TransactionScope(TransactionScopeOption.RequiresNew)) { DeviceBusiness.UpdateDevice(device); ret = MerchDeviceBusiness.DeleteMerchDevice(md); transactionScope.Complete(); } } break; case DeviceTypeEnum.Clerk: case DeviceTypeEnum.Terminal: { //获取终端绑定关系实体 Data_MerchSegment ms = MerchSegmentBusiness.GetMerchSegmentModel(device.ID); using (var transactionScope = new System.Transactions.TransactionScope(TransactionScopeOption.RequiresNew)) { DeviceBusiness.UpdateDevice(device); ret = MerchSegmentBusiness.DeleteMerchSegment(ms); transactionScope.Complete(); } } break; } if (ret) { DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.未激活.ToDescription()); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } catch (Exception e) { throw e; } }
public object getDeviceInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString().Trim().ToLower() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } string status = DeviceStatusBusiness.GetDeviceState(device.Token); //当前设备类型 DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; DeviceInfoModel model = new DeviceInfoModel(); model.Router = new Router(); model.Group = new Group(); model.deviceName = device.DeviceName ?? device.SN; model.deviceToken = device.Token; model.deviceType = currDeviceType.ToDescription(); model.deviceSN = device.SN; model.status = DeviceStatusBusiness.GetDeviceState(device.Token); //设备未绑定 if (device.MerchID == 0 || device.MerchID.IsNull()) { model.BindState = (int)DeviceBoundStateEnum.NotBound; return(ResponseModelFactory <DeviceInfoModel> .CreateModel(isSignKeyReturn, model)); } //判断设备绑定的商户是否与当前商户一致 if (device.MerchID != merch.ID) { //与当前商户不一致 return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "没有权限查看该设备信息")); } //Base_DeviceInfo currRouter = null; //if (!string.IsNullOrWhiteSpace(routerToken)) //{ // currRouter = DeviceBusiness.GetDeviceModel(routerToken); //} //1.如果设备绑定的商户与当前商户一致 //2.判断设备是否已与当前商户建立绑定关系 switch (currDeviceType) { case DeviceTypeEnum.Router: model.BindState = (int)DeviceBoundStateEnum.Bound; break; case DeviceTypeEnum.SlotMachines: case DeviceTypeEnum.DepositMachine: { //获取外设绑定关系实体 Data_MerchDevice md = MerchDeviceBusiness.GetMerchDeviceModel(device.ID); if (md.IsNull()) { model.BindState = (int)DeviceBoundStateEnum.NotBound; } else { //获取控制器实体 Base_DeviceInfo router = DeviceBusiness.GetDeviceModelById((int)md.ParentID); if (router.Token.Trim().ToLower() != routerToken) { //设备所属控制器与当前控制器不一致 return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备不属于当前控制器")); } model.BindState = (int)DeviceBoundStateEnum.Bound; model.headAddress = md.HeadAddress; //控制器信息 model.Router.routerName = router.DeviceName ?? router.SN; model.Router.routerToken = router.Token; model.Router.sn = router.SN; } } break; case DeviceTypeEnum.Clerk: case DeviceTypeEnum.Terminal: { //获取终端绑定关系实体 Data_MerchSegment ms = MerchSegmentBusiness.GetMerchSegmentModel(device.ID); if (ms.IsNull()) { model.BindState = (int)DeviceBoundStateEnum.NotBound; } else { //获取控制器实体 Base_DeviceInfo router = DeviceBusiness.GetDeviceModelById((int)ms.ParentID); if (router.Token.Trim().ToLower() != routerToken) { //设备所属控制器与当前控制器不一致 return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备不属于当前控制器")); } model.BindState = (int)DeviceBoundStateEnum.Bound; model.headAddress = ms.HeadAddress; //控制器信息 model.Router.routerName = router.DeviceName ?? router.SN; model.Router.routerToken = router.Token; model.Router.sn = router.SN; //获取分组实体 Data_GameInfo group = GameBusiness.GetGameInfoModel(Convert.ToInt32(ms.GroupID)); model.Group.groupId = group.GroupID; model.Group.groupName = group.GroupName; model.Group.groupType = ((GroupTypeEnum)(int)group.GroupType).ToDescription(); } } break; } //返回设备信息 return(ResponseModelFactory <DeviceInfoModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object bindDevice(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].ToString() : string.Empty; string deviceName = dicParas.ContainsKey("deviceName") ? dicParas["deviceName"].ToString() : string.Empty; string level = dicParas.ContainsKey("level") ? dicParas["level"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString() : string.Empty; string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户令牌无效")); } if (merch.State == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "当前用户已被禁用")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } //设备已被绑定 if (!device.MerchID.IsNull() && device.MerchID != 0 && device.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该设备已被其他商户绑定")); } //设备未绑定,开始绑定 device.MerchID = merch.ID; device.DeviceName = deviceName; device.Status = (int)DeviceStatusEnum.启用; if (string.IsNullOrWhiteSpace(level)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "参数错误")); } DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; switch (level) { case "1": { if (currDeviceType == DeviceTypeEnum.Router) { DeviceBusiness.UpdateDevice(device); return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } else if (currDeviceType == DeviceTypeEnum.SlotMachines || currDeviceType == DeviceTypeEnum.DepositMachine) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请选定控制器后绑定该设备")); } else { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请在分组中绑定该设备")); } } case "2": { if (currDeviceType == DeviceTypeEnum.Router) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请在返回上级绑定")); } else if (currDeviceType == DeviceTypeEnum.SlotMachines || currDeviceType == DeviceTypeEnum.DepositMachine) { if (string.IsNullOrWhiteSpace(routerToken)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取控制器参数错误")); } //获取控制器实体 Base_DeviceInfo router = DeviceBusiness.GetDeviceModel(routerToken); if (router.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取控制器参数错误")); } //获取当前控制器中的外设列表 var list = MerchDeviceBusiness.GetListByParentId(router.ID).OrderBy(m => m.HeadAddress).ToList(); if (list.Count >= 11) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "超出最大绑定数量")); } Data_MerchDevice md = list.FirstOrDefault(m => m.DeviceID == device.ID); if (md.IsNull()) { md = new Data_MerchDevice(); md.ParentID = router.ID; md.DeviceID = device.ID; int index = 0; foreach (var item in list) { string currAddress = string.Format("A{0}", index); //int currIndex = int.Parse(item.HeadAddress, System.Globalization.NumberStyles.AllowHexSpecifier); if (currAddress != item.HeadAddress) { break; } index++; continue; } //md.HeadAddress = Convert.ToString(index, 16).PadLeft(2, '0').ToUpper(); md.HeadAddress = string.Format("A{0}", index); } using (var transactionScope = new System.Transactions.TransactionScope( TransactionScopeOption.RequiresNew)) { DeviceBusiness.UpdateDevice(device); MerchDeviceBusiness.AddMerchDevice(md); transactionScope.Complete(); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } else { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请在分组中绑定该设备")); } } case "3": { if (currDeviceType != DeviceTypeEnum.Clerk && currDeviceType != DeviceTypeEnum.Terminal) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "请在分组中绑定该设备")); } else { if (string.IsNullOrWhiteSpace(groupId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取分组参数错误")); } //获取分组实体 Data_GameInfo group = GameBusiness.GetGameInfoModel(Convert.ToInt32(groupId)); if (group.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取分组参数错误")); } //根据分组获取当前分组的控制器 Base_DeviceInfo router = DeviceBusiness.GetDeviceModelById((int)group.DeviceID); if (router.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "获取控制器参数错误")); } //判断当前分组是否属于当前商户 if (router.MerchID != merch.ID) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "分组信息与当前商户不匹配")); } //获取当前分组中的终端列表 var list = MerchSegmentBusiness.GetListByGroupId(group.GroupID).OrderBy(m => m.HeadAddress).ToList(); if (list.Count >= 99) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "超出最大绑定数量")); } Data_MerchSegment ms = list.FirstOrDefault(m => m.ParentID == group.DeviceID && m.DeviceID == device.ID); if (ms.IsNull()) { ms = new Data_MerchSegment(); ms.ParentID = group.DeviceID; ms.GroupID = group.GroupID; ms.DeviceID = device.ID; int index = 1; foreach (var item in list) { int currIndex = int.Parse(item.HeadAddress, System.Globalization.NumberStyles.AllowHexSpecifier); if (currIndex != index) { break; } index++; continue; } ms.HeadAddress = Convert.ToString(index, 16).PadLeft(2, '0').ToUpper(); } using (var transactionScope = new System.Transactions.TransactionScope( TransactionScopeOption.RequiresNew)) { DeviceBusiness.UpdateDevice(device); MerchSegmentBusiness.AddMerchSegment(ms); transactionScope.Complete(); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } } } DeviceStatusBusiness.SetDeviceState(device.Token, DeviceStatusEnum.离线.ToDescription()); return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "")); } catch (Exception e) { throw e; } }
public object getRouterChildList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString() : string.Empty; Base_MerchInfo merch = MerchBusiness.GetMerchModel(mobileToken); if (merch.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "用户token无效")); } Base_DeviceInfo router = DeviceBusiness.GetDeviceModel(routerToken); if (router.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "控制器token无效")); } //分组集合 var groupList = GameBusiness.GetGameList().Where(t => t.DeviceID == router.ID).ToList(); //外设集合 var peripheralList = MerchDeviceBusiness.GetListByParentId(router.ID).ToList(); RouterModel model = new RouterModel(); model.routerName = string.IsNullOrWhiteSpace(router.DeviceName) ? router.SN : router.DeviceName; model.routerToken = router.Token; model.routerStatus = DeviceStatusBusiness.GetDeviceState(router.Token); model.routerSN = router.SN; model.Groups = groupList.Select(t => new Group { groupId = t.GroupID, groupName = t.GroupName, groupType = ((GroupTypeEnum)t.GroupType).ToDescription() }).ToList(); List <Peripheral> Peripherals = new List <Peripheral>(); foreach (var item in peripheralList) { Peripheral p = new Peripheral(); Base_DeviceInfo cDevice = DeviceBusiness.GetDeviceModelById((int)item.DeviceID); p.peripheralId = (int)item.DeviceID; p.peripheralName = cDevice.DeviceName; p.peripheralToken = cDevice.Token; p.sn = cDevice.SN; p.deviceType = ((DeviceTypeEnum)cDevice.DeviceType).ToDescription(); p.state = DeviceStatusBusiness.GetDeviceState(cDevice.Token); p.headAddress = item.HeadAddress; Peripherals.Add(p); } model.Peripherals = Peripherals; return(ResponseModelFactory <RouterModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object getMemberDetail(Dictionary <string, object> dicParas) { try { string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string memberId = dicParas.ContainsKey("memberId") ? dicParas["memberId"].ToString() : string.Empty; 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, "用户令牌无效")); } if (string.IsNullOrWhiteSpace(memberId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "参数错误")); } MemberDetailModel model = new MemberDetailModel(); DataTable table = AccountBusiness.GetMemberDetail(memberId); if (table.Rows.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "无数据")); } DataRow row = table.Rows[0]; model.ICCardID = row["ICCardID"].ToString(); model.MemberName = row["MemberName"].ToString(); model.Mobile = row["Mobile"].ToString(); model.Birthday = row["Birthday"].ToString(); model.CertificalID = row["CertificalID"].ToString(); model.Balance = string.IsNullOrWhiteSpace(row["Balance"].ToString()) ? "0" : row["Balance"].ToString(); model.Lottery = string.IsNullOrWhiteSpace(row["Lottery"].ToString()) ? "0" : row["Lottery"].ToString(); model.Point = string.IsNullOrWhiteSpace(row["Point"].ToString()) ? "0" : row["Point"].ToString(); switch (row["Type"].ToString()) { case "0": model.Type = "会员卡"; break; case "1": model.Type = "数字币"; break; case "2": model.Type = "临时卡"; break; case "3": model.Type = "返分卡"; break; default: model.Type = "会员卡"; break; } model.JoinTime = row["JoinTime"].IsNull() ? "" : Convert.ToDateTime(row["JoinTime"]).ToString("yyyy-MM-dd HH:mm:ss"); model.EndDate = string.IsNullOrWhiteSpace(row["EndDate"].ToString()) ? "" : Convert.ToDateTime(row["EndDate"]).ToString("yyyy-MM-dd"); model.MemberPassword = row["MemberPassword"].ToString(); model.Note = row["Note"].ToString(); model.Lock = string.IsNullOrWhiteSpace(row["EndDate"].ToString()) || row["EndDate"].ToString() == "0" ? "未锁定" : "已锁定"; model.LockDate = ""; if (model.Lock == "已锁定") { model.LockDate = string.IsNullOrWhiteSpace(row["LockDate"].ToString()) ? "" : Convert.ToDateTime(row["EndDate"]).ToString("yyyy-MM-dd"); } return(ResponseModelFactory <MemberDetailModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object getMemberSummary(Dictionary <string, object> dicParas) { try { string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].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, "用户令牌无效")); } DataSet ds = AccountBusiness.GetMemberSummary(merch.ID, icCardId, sDate, eDate, pageIndex, pageSize); MemberViewModel model = new MemberViewModel(); if (ds.Tables.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "无数据")); } if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; model.MemberTotal = Convert.ToInt32(row["MemberTotal"]); model.BalanceTotal = Convert.ToInt32(row["BalanceTotal"]); model.TodayJoinMembers = Convert.ToInt32(row["TodayJoinMembers"]); model.TodayGameMembers = Convert.ToInt32(row["TodayGameMembers"]); } model.MemberList = new List <MemberListModel>(); if (ds.Tables[1].Rows.Count > 0) { model.MemberList = Utils.GetModelList <MemberListModel>(ds.Tables[1]).ToList(); } return(ResponseModelFactory <MemberViewModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object getFoodSaleRevenue(Dictionary <string, object> dicParas) { try { string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString() : string.Empty; string sDate = dicParas.ContainsKey("sDate") ? dicParas["sDate"].ToString() : string.Empty; string eDate = dicParas.ContainsKey("eDate") ? dicParas["eDate"].ToString() : string.Empty; 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无效")); } int? routerId = null; Base_DeviceInfo router = DeviceBusiness.GetDeviceModel(routerToken); if (!router.IsNull()) { routerId = router.ID; } DataSet ds = AccountBusiness.GetMerchRevenue(merch.ID, routerId, sDate, eDate); MerchRevenueModel model = new MerchRevenueModel(); model.MerchName = merch.MerchName; if (ds.Tables.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "无数据")); } model.Revenues = new List <RevenueDataModel>(); model.Payment = new List <RevenueDataModel>(); if (ds.Tables[0].Rows.Count > 0) { model.Amount = ds.Tables[0].Rows[0]["Amount"].ToString(); model.Revenues.Add(new RevenueDataModel() { Title = "充值总额", Value = ds.Tables[0].Rows[0]["RechargeAmount"].ToString() }); model.Revenues.Add(new RevenueDataModel() { Title = "售币总额", Value = ds.Tables[0].Rows[0]["SaleAmount"].ToString() }); model.Payment.Add(new RevenueDataModel() { Title = "现金", Value = ds.Tables[0].Rows[0]["CashPayAmount"].ToString() }); model.Payment.Add(new RevenueDataModel() { Title = "微信", Value = ds.Tables[0].Rows[0]["WechatPayAmount"].ToString() }); model.Payment.Add(new RevenueDataModel() { Title = "支付宝", Value = ds.Tables[0].Rows[0]["AliPayAmount"].ToString() }); model.Payment.Add(new RevenueDataModel() { Title = "银联", Value = ds.Tables[0].Rows[0]["UnionPayAmount"].ToString() }); } else { model.Revenues.Add(new RevenueDataModel() { Title = "充值总额", Value = "0.00" }); model.Revenues.Add(new RevenueDataModel() { Title = "售币总额", Value = "0.00" }); model.Payment.Add(new RevenueDataModel() { Title = "现金", Value = "0.00" }); model.Payment.Add(new RevenueDataModel() { Title = "微信", Value = "0.00" }); model.Payment.Add(new RevenueDataModel() { Title = "支付宝", Value = "0.00" }); model.Payment.Add(new RevenueDataModel() { Title = "银联", Value = "0.00" }); } model.Coins = new List <RevenueDataModel>(); if (ds.Tables[1].Rows.Count > 0) { model.Coins.Add(new RevenueDataModel() { Title = "存币数", Value = ds.Tables[1].Rows[0]["SaveCoins"].ToString() }); } if (ds.Tables[2].Rows.Count > 0) { model.Coins.Add(new RevenueDataModel() { Title = "售币数", Value = ds.Tables[2].Rows[0]["SaleCoins"].ToString() }); } return(ResponseModelFactory <MerchRevenueModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }
public object getPeripheralRevenue(Dictionary <string, object> dicParas) { try { string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string deviceToken = dicParas.ContainsKey("deviceToken") ? dicParas["deviceToken"].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, "用户令牌无效")); } Base_DeviceInfo device = DeviceBusiness.GetDeviceModel(deviceToken); if (device.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "设备令牌无效")); } PeripheralRevenueModel model = new PeripheralRevenueModel(); model.DeviceName = device.DeviceName; model.SN = device.SN; //当前设备类型 DeviceTypeEnum currDeviceType = (DeviceTypeEnum)device.DeviceType; if (currDeviceType == DeviceTypeEnum.DepositMachine) { DataSet ds = AccountBusiness.GetSaveCoinMachineRevenue(merch.ID, device.ID, sDate, eDate, pageIndex, pageSize); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { RevenueDataModel m = new RevenueDataModel(); m.Title = "存币数"; m.Value = ds.Tables[0].Rows[0]["SaveCoins"].ToString(); model.Coins.Add(m); } if (ds.Tables[1].Rows.Count > 0) { model.CoinSerials = Utils.GetModelList <CoinSerialModel>(ds.Tables[1]).ToList(); } } } else if (currDeviceType == DeviceTypeEnum.SlotMachines) { DataSet ds = AccountBusiness.GetSaleCoinMachineRevenue(merch.ID, device.ID, sDate, eDate, pageIndex, pageSize); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { RevenueDataModel m = new RevenueDataModel(); m.Title = "提币数"; m.Value = ds.Tables[0].Rows[0]["PullCoins"].ToString(); model.Coins.Add(m); m = new RevenueDataModel(); m.Title = "售币数"; m.Value = ds.Tables[0].Rows[0]["SaleCoins"].ToString(); model.Coins.Add(m); m = new RevenueDataModel(); m.Title = "售币金额"; m.Value = ds.Tables[0].Rows[0]["SaleCoinAmount"].ToString(); model.Coins.Add(m); } if (ds.Tables[1].Rows.Count > 0) { model.CoinSerials = Utils.GetModelList <CoinSerialModel>(ds.Tables[1]).ToList(); } } } else { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "无数据")); } return(ResponseModelFactory <PeripheralRevenueModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e.InnerException; } }
public object getRoutersRevenue(Dictionary <string, object> dicParas) { try { string mobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; string routerToken = dicParas.ContainsKey("routerToken") ? dicParas["routerToken"].ToString() : string.Empty; string sDate = dicParas.ContainsKey("sDate") ? dicParas["sDate"].ToString() : string.Empty; string eDate = dicParas.ContainsKey("eDate") ? dicParas["eDate"].ToString() : string.Empty; 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, "用户令牌无效")); } Base_DeviceInfo router = DeviceBusiness.GetDeviceModel(routerToken); if (router.IsNull()) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "控制器令牌无效")); } DataSet ds = AccountBusiness.GetRoutersAmount(merch.ID, router.ID, sDate, eDate); MerchRoutersRevenueModel model = new MerchRoutersRevenueModel(); model.RouterName = router.DeviceName; model.Token = router.Token; if (ds.Tables.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, "无数据")); } model.SaveCoins = new CoinRevenueModel() { Coins = new List <RevenueDataModel>() }; if (ds.Tables[0].Rows.Count > 0) { Int64 coinTotal = 0; foreach (DataRow row in ds.Tables[0].Rows) { string currCoin = row["SaveCoins"].IsNull() ? "0" : row["SaveCoins"].ToString(); model.SaveCoins.Coins.Add(new RevenueDataModel() { Title = row["DeviceName"].ToString(), Value = currCoin }); coinTotal += Convert.ToInt64(currCoin); } model.SaveCoins.CoinsTotal = coinTotal.ToString(); } model.SaleCoins = new CoinRevenueModel() { Coins = new List <RevenueDataModel>() }; if (ds.Tables[1].Rows.Count > 0) { Int64 coinTotal = 0; foreach (DataRow row in ds.Tables[1].Rows) { string currCoin = row["SaleCoins"].IsNull() ? "0" : row["SaleCoins"].ToString(); model.SaleCoins.Coins.Add(new RevenueDataModel() { Title = row["DeviceName"].ToString(), Value = currCoin }); coinTotal += Convert.ToInt64(currCoin); } model.SaleCoins.CoinsTotal = coinTotal.ToString(); } return(ResponseModelFactory <MerchRoutersRevenueModel> .CreateModel(isSignKeyReturn, model)); } catch (Exception e) { throw e; } }