public UserCompanyInfoVM GetUserComponyInfoByMobile(string mobile) { using (var ctx = new ShtxSms2008Entities()) { var cb = ctx.CustomerBases.FirstOrDefault(o => o.Tel.Contains(mobile) && o.SendInterFace == 102); if (cb != null) { return(new UserCompanyInfoVM() { AppAddressDesc = cb.AppAddressDesc, AppBusinessDesc = cb.AppBusinessDesc, AppCity = cb.AppCity, AppCompanyName = cb.AppCompanyName, AppCompanyPics = cb.AppCompanyPics, AppCustomerName = cb.AppCustomerName, AppIndustry = cb.AppIndustry, AppProduct = cb.AppProduct, AppProvince = cb.AppProvince, AppTel = cb.AppTel, IsOpenMsg = (cb.IsOpenMsg ?? false) }); } else { return(null); } } }
//得到指定 Marketid 的当天所有评论 按倒序排列 public List <AppPingLunVM> GetPinglunByMarketId(int marketId, DateTime start, DateTime end) { var list = new List <AppPingLunVM>(); using (var ctx = new ShtxSms2008Entities()) { var orderdProductIds = ctx.SmsProducts.Where(o => o.MarketId == marketId).Select(o => o.ProductId).ToList(); var pls = ctx.Weixin_Pinglun.Where(o => orderdProductIds.Contains(o.productId) && o.create <end && o.create> start).OrderByDescending(o => o.create); foreach (var pl in pls) { var product = ctx.SmsProducts.FirstOrDefault(o => o.ProductId == pl.productId); var market = ctx.Markets.FirstOrDefault(o => o.MarketId == product.MarketId); var vm = new AppPingLunVM(); vm.Id = pl.productId; vm.Title = pl.title; vm.MarketName = (market == null ? "" : market.MarketName); vm.ProductName = (product == null ? "" : product.ProductName); vm.Icon = pl.icon; vm.Date = pl.create.Value.ToString("yyyy-MM-dd HH:mm:ss fff"); vm.Url = "http://app.shtx.com.cn/StaticHtml/WeixinPingLun.html?&id=" + pl.id; list.Add(vm); } } return(list); }
public List <UserCompanyInfoVM> getUserCompanyInfo(int id) { List <UserCompanyInfoVM> list = new List <UserCompanyInfoVM>(); using (var ctx = new ShtxSms2008Entities()) { var cbs = ctx.CustomerBases.Where(o => o.IsOpenMsg.Value && o.CustomerID > id).OrderBy(o => o.CustomerID).Take(30).ToList(); foreach (var cb in cbs) { var vm = new UserCompanyInfoVM(); vm.AppAddressDesc = cb.AppAddressDesc; vm.AppBusinessDesc = cb.AppBusinessDesc; vm.AppCity = cb.AppCity; vm.AppCompanyName = cb.AppCompanyName; vm.AppCompanyPics = cb.AppCompanyPics; vm.AppCustomerName = cb.AppCustomerName; vm.AppIndustry = cb.AppIndustry; vm.AppProduct = cb.AppProduct; vm.AppProvince = cb.AppProvince; vm.AppTel = cb.AppTel; vm.Id = cb.CustomerID; list.Add(vm); } } return(list); }
private List <int> GetProductIdsByMobileAndMarketId(string mobile, int marketId) { using (var ctx = new ShtxSms2008Entities()) { return(ctx.Gps.Where(o => o.Tel.Contains(mobile) && o.MarketID == marketId).Select(o => o.ProductID.Value).ToList()); } }
public bool SaveUserCompany(string mobile, UserCompanyInfoVM company) { using (var ctx = new ShtxSms2008Entities()) { try { var cb = ctx.CustomerBases.FirstOrDefault(o => o.SendInterFace == 102 && o.Tel.Contains(mobile)); if (cb != null) { cb.AppAddressDesc = company.AppAddressDesc; cb.AppBusinessDesc = company.AppBusinessDesc; cb.AppCity = company.AppCity; cb.AppCompanyName = company.AppCompanyName; cb.AppCompanyPics = company.AppCompanyPics; cb.AppCustomerName = company.AppCustomerName; cb.AppIndustry = company.AppIndustry; cb.AppProduct = company.AppProduct; cb.AppProvince = company.AppProvince; cb.IsOpenMsg = company.IsOpenMsg; cb.AppTel = company.AppTel; ctx.SaveChanges(); return(true); } else { return(false); } } catch (Exception) { return(false); } } }
public bool deleteSupply(int id) { bool flag = false; using (TransactionScope tran = new TransactionScope()) { using (var ctx = new ShtxSms2008Entities()) { var images = ctx.Images.Where(o => o.SupplyID == id).ToList(); foreach (var image in images) { ctx.Images.Remove(image); } var supply = ctx.Supplies.FirstOrDefault(o => o.ID == id); if (supply != null) { ctx.Supplies.Remove(supply); } ctx.SaveChanges(); tran.Complete(); flag = true; } } return(flag); }
public List <MarketGroupVM> GetMarkets(string mobile, int flag, string fla1) { var list = new List <MarketGroupVM>(); using (var ctx = new ShtxSms2008Entities()) { //change:// //var groups = ctx.XHMarketGroups.Where(o => o.Flag == flag && o.IsForApp); var groups = CacheService.GetMarketGroupForApp(flag); foreach (var group in groups) { var groupId = group.GroupID; var vm = new MarketGroupVM() { Id = groupId, Name = group.GroupName }; //change:// //vm.Market = ctx.Markets.Where(o => o.GroupID == groupId).Select(o => new MarketVM { Id = o.MarketId, Name = o.MarketName, Order = (int)o.DisplayOrder }).OrderBy(o => o.Order).ToList(); vm.Market = CacheService.GetMarketByGroupId(groupId).Select(o => new MarketVM { Id = o.MarketId, Name = o.MarketName, Order = (int)o.DisplayOrder }).OrderBy(o => o.Order).ToList(); list.Add(vm); } } return(list); }
public bool CheckTokenByMobile(string tel, string token) { using (var ctx = new ShtxSms2008Entities()) { var cb = ctx.CustomerBases.FirstOrDefault(o => o.SendInterFace == 102 && o.Tel.Contains(tel)); if (cb == null) { return(false); } else { var ce = ctx.CustomerExtend.FirstOrDefault(o => o.Tel == cb.Tel && o.SendInterFace == 102 && (o.Valid ?? false)); if (ce == null) { return(false); } else { var appToken = ctx.AppCustomerTokens.FirstOrDefault(o => o.tel.Contains(tel)); if (appToken.devicetoken != token) { return(false); } else { return(true); } } } } }
public int createSupply(SupplyVM vm) { int ret = 0; using (var tran = new TransactionScope()) { using (var ctx = new ShtxSms2008Entities()) { try { var supply = new Supply(); supply.CatalogID = vm.CatalogId; supply.Quantity = vm.Quantity; supply.Mobile = vm.Mobile; supply.Contact = vm.Contact; supply.Description = vm.Description; supply.DeliveryType = vm.DeliveryType; supply.SupplyType = vm.SupplyType; supply.Product = vm.Product; supply.Creater = vm.Creater; supply.Price = vm.Price; //supply.isChecked = false;初始为空,0拒绝,1同意 var provice = ctx.Provinces.FirstOrDefault(o => o.Name == vm.Provice); if (provice != null) { var city = ctx.Provinces.FirstOrDefault(o => o.ParentID == provice.ID && o.Name == vm.City); if (city != null) { supply.ProviceID = city.ID; } } supply.CreateDate = DateTime.Now; ctx.Supplies.Add(supply); ctx.SaveChanges(); foreach (var imgName in vm.Images) { Image img = new Image(); img.Name = imgName; img.SupplyID = supply.ID; ctx.Images.Add(img); } ctx.SaveChanges(); tran.Complete(); ret = supply.ID; } catch (DbEntityValidationException) { } catch (Exception) { } } } return(ret); }
public bool saveTrade(TradeVM tradeVm, string tradePics) { bool flag = false; using (var tran = new TransactionScope()) { using (var ctx = new ShtxSms2008Entities()) { try { Supply supply = new Supply(); supply.buissnes = tradeVm.Buissnes; //所属行业 supply.Product = tradeVm.Product; //名称 supply.Quantity = tradeVm.Quantity; supply.Price = tradeVm.Price; supply.Contact = tradeVm.Contact; supply.Mobile = tradeVm.ContactTel; supply.Description = tradeVm.Description; supply.DocumentType = tradeVm.DocumentType; supply.provinceName = tradeVm.Province; supply.cityName = tradeVm.City; supply.Creater = tradeVm.Mobile; supply.CreateDate = DateTime.Now; ctx.Supplies.Add(supply); if (!string.IsNullOrWhiteSpace(tradePics)) { string[] pics = tradePics.Split(new string[] { "|||" }, StringSplitOptions.RemoveEmptyEntries); foreach (var pic in pics) { Image image = new Image(); image.SupplyID = supply.ID; image.Name = pic; var path = Path.Combine(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase, "upload"); var picPath = Path.Combine(path, pic); var path1 = Path.GetFileNameWithoutExtension(picPath) + "-1" + Path.GetExtension(picPath); System.Drawing.Image imgOutput = System.Drawing.Bitmap.FromFile(picPath); System.Drawing.Image imgOutput2 = imgOutput.GetThumbnailImage(60, 60, null, IntPtr.Zero); imgOutput2.Save(path1); ctx.Images.Add(image); } } ctx.SaveChanges(); tran.Complete(); flag = true; } catch (Exception) { } } } return(flag); }
public List <SearchPingLunVM> GetSearchPinglunResult(string mobile, string key) { List <SearchPingLunVM> result = new List <SearchPingLunVM>(); var list = new List <AppPingLunVM>(); using (var ctx = new ShtxSms2008Entities()) { var today = DateTime.Today; var start = today.AddDays(-7); var end = today.AddDays(1); var plList = ctx.Weixin_Pinglun.Where(o => o.title.Contains(key) && o.create.Value >= start && o.create <= end).OrderByDescending(o => o.create).ToList(); if (plList.Count > 0) { var orderdProductIds = ctx.Gps.Where(o => o.Tel.Contains(mobile)).Select(o => o.ProductID).ToList(); foreach (var pl in plList) { AppPingLunVM vm = new AppPingLunVM(); vm.Id = pl.id; vm.ProductName = CacheService.GetProductNameById(pl.productId); if (vm.ProductName == string.Empty) { continue; } var market = CacheService.GetMarketByProductId(pl.productId); vm.MarketId = market.Item1; vm.MarketName = market.Item2; vm.Title = pl.title; vm.Icon = pl.icon; vm.Date = pl.create.Value.ToString("yyyy-MM-dd"); vm.Url = "http://app.shtx.com.cn/StaticHtml/WeixinPingLun.html?mobile=" + mobile + "&id=" + pl.id; if (orderdProductIds.Contains(pl.productId)) { vm.IsOrder = "YES"; } else { vm.IsOrder = "NO"; } list.Add(vm); } var group = list.GroupBy(o => o.MarketId); foreach (var g in group) { SearchPingLunVM search = new SearchPingLunVM(); search.MarketId = g.Key; search.MarketName = g.First().MarketName; search.PingLunList = g.ToList(); result.Add(search); } } } return(result); }
public void addCount() { using (var ctx = new ShtxSms2008Entities()) { ApkDownload download = new ApkDownload() { downloadtime = DateTime.Now }; ctx.ApkDownloads.Add(download); ctx.SaveChanges(); } }
//获得所有现货商品最近更新价格信息,,,,更改为mongo后,弃用了. //public List<ProductPriceVM> GetAllMarketLastPrice() public Dictionary <int, ProductPriceVM> GetAllMarketLastPrice() { //var listOrder = new List<ProductPriceVM>(); var listDic = new Dictionary <int, ProductPriceVM>(); using (var ctx = new ShtxSms2008Entities()) {//ctx //inner join var listPrice = from f in (from p in ctx.Prices where !ctx.Prices.Any(es => (es.MarketID == p.MarketID) && (es.ProductID == p.ProductID) && (es.AddDate > p.AddDate)) orderby p.AddDate descending select p) join dist in ctx.SmsProducts on new { mid = (int)f.MarketID, pid = (int)f.ProductID } equals new { mid = (int)dist.MarketId, pid = dist.ProductId } select new { dist.ProductName, dist.SName, f.ProductID, f.LPrice, f.HPrice, f.APrice, f.AddDate, f.PriceChange, f.MarketID }; //IEnumerable<IGrouping<int?, ProductPriceVM>> grouplist = listPrice.ToList().GroupBy(c => c.MarketID); //var g_Mapid = new Dictionary<int, int>(); foreach (var product in listPrice) { if (!listDic.ContainsKey((int)product.MarketID)) { var vm = new ProductPriceVM { ProductId = (int)product.ProductID, ProductName = product.ProductName, }; vm.AddDate = (DateTime)product.AddDate; vm.LPrice = product.LPrice; vm.HPrice = product.HPrice; vm.Change = product.PriceChange; vm.MarketID = (int)product.MarketID; listDic.Add((int)product.MarketID, vm); //listOrder.Add(vm); } } return(listDic); }//ctx }
public List <SupplyViewVM> getSupply(int channelId, string creater) { var list = new List <SupplyViewVM>(); using (var ctx = new ShtxSms2008Entities()) { var today = DateTime.Today; DateTime tom = today.AddDays(1); //DateTime start = today.AddDays(-6); DateTime start = today.AddMonths(-6); //var supplies = ctx.Supplies.Where(o => o.CatalogID == channelId && o.CreateDate >= start && o.CreateDate < tom && o.isChecked == true).OrderByDescending(o => o.CreateDate); //change:// //List<int> catalogIds = ctx.CataLogs.Where(o => o.ChannelId == channelId).Select(o => o.ID).ToList(); List <int> catalogIds = CacheService.GetCataLogByChannelId(channelId).Select(o => o.Id).ToList(); var supplies = ctx.Supplies.Where(o => catalogIds.Contains(o.CatalogID.Value) && o.CreateDate >= start && o.CreateDate < tom && o.isChecked == true).OrderByDescending(o => o.CreateDate); foreach (var supply in supplies) { SupplyViewVM vm = new SupplyViewVM(); vm.Id = supply.ID; vm.Product = supply.Product; vm.SupplyType = supply.SupplyType.Value; vm.Contact = supply.Contact; vm.isChecked = supply.isChecked; vm.Price = supply.Price; var img = ctx.Images.FirstOrDefault(o => o.SupplyID == supply.ID); if (img != null) { vm.Avatar = "http://api.shtx.com.cn/Upload/" + getAvatarName(img.Name); } else { vm.Avatar = "http://api.shtx.com.cn/Upload/default.jpg"; } var city = ctx.Provinces.FirstOrDefault(o => o.ID == supply.ProviceID); var province = ctx.Provinces.FirstOrDefault(o => o.ID == city.ParentID); var address = province.Name + city.Name; vm.Address = address; if (supply.CreateDate >= today) { vm.Date = supply.CreateDate.ToString("HH:mm"); } else { vm.Date = supply.CreateDate.ToString("MM-dd"); } list.Add(vm); } } return(list); }
public Dictionary <int, IEnumerable <Weixin_Pinglun> > TakeNPLEachGroup(int n) { var list = new Dictionary <int, IEnumerable <Weixin_Pinglun> >(); using (var ctx = new ShtxSms2008Entities()) { var query = ctx.Weixin_Pinglun.GroupBy(o => o.productId).Select(g => new { id = g.Key, list = g.OrderByDescending(p => p.create).Take(n) }).ToList(); foreach (var q in query) { list.Add(q.id, q.list); } } return(list); }
public List <OrderVM> GetMyOrder(string mobile) { var list = new List <OrderVM>(); List <int> xhmarketIds = new List <int>(); var xhMarkets = new Dictionary <int, string>(); using (var ctx = new ShtxSms2008Entities()) { //change:// //var groups = ctx.XHMarketGroups.Where(o => (o.Flag == 1 || o.Flag == 5) && o.IsForApp).Select(o => o.GroupID).ToList(); var groups1 = CacheService.GetMarketGroupForApp(1); var groups5 = CacheService.GetMarketGroupForApp(5); groups1.AddRange(groups5); var groups = groups1.Select(o => o.GroupID).ToList(); CustomerBase cb = ctx.CustomerBases.FirstOrDefault(o => o.Tel.Contains(mobile) && o.SendInterFace == 102); if (cb != null) { mobile = cb.Tel; foreach (var group in groups) { //change:// //var markets = ctx.Markets.Where(o => o.GroupID == group).ToList(); var markets = CacheService.GetMarketByGroupId(group); foreach (var m in markets) { xhmarketIds.Add(m.MarketId); xhMarkets.Add(m.MarketId, m.MarketName); } } var orderIds = ctx.Gps.Where(o => o.Tel == mobile && xhmarketIds.Contains(o.MarketID.Value)).Select(o => o.ProductID.Value).ToList(); foreach (var productId in orderIds) { var product = ctx.SmsProducts.FirstOrDefault(o => o.ProductId == productId); if (product != null) { OrderVM order = new OrderVM(); order.ProductId = product.ProductId; order.ProductName = product.ProductName; order.MarketName = xhMarkets[product.MarketId.Value]; list.Add(order); } } } } return(list.OrderBy(o => o.MarketName).ToList()); }
public List <ProductPriceVM> GetPricesByMobileAndMarketId(string mobile, int marketId) { var listOrder = new List <ProductPriceVM>(); using (var ctx = new ShtxSms2008Entities()) { CustomerBase cb = ctx.CustomerBases.FirstOrDefault(o => o.Tel.Contains(mobile) && o.SendInterFace == 102); if (cb != null) { mobile = cb.Tel; //change:// //var products = ctx.SmsProducts.Where(o => o.MarketId == marketId).OrderBy(p => p.DisplayOrder).ToList(); var products = CacheService.GetProductByMarketId(marketId).OrderBy(p => p.DisplayOrder).ToList(); var orderIds = ctx.Gps.Where(o => o.Tel == mobile && o.MarketID == marketId).Select(o => o.ProductID.Value).ToList(); foreach (var product in products) { var vm = new ProductPriceVM { ProductId = product.ProductId, ProductName = product.ProductName, ParentName = product.parentName, Comment = product.comment, Spec = product.spec }; if (orderIds.Contains(product.ProductId)) { vm.IsOrder = "YES"; } else { vm.IsOrder = "NO"; } //mongo: //Price price = ctx.Prices.OrderByDescending(o => o.AddDate).FirstOrDefault(o => o.ProductID == product.ProductId); Price price = MongoDBService.GetLastPricesByProductId(product.ProductId); if (price != null) { vm.LPrice = price.LPrice; vm.HPrice = string.IsNullOrEmpty(price.HPrice) ? price.LPrice : price.HPrice; vm.Date = price.AddDate.Value.ToString("yyyy-MM-dd"); vm.Change = CommonService.ChangePrice(price.PriceChange); vm.AddDate = price.AddDate.Value; listOrder.Add(vm); } } } return(listOrder); } }
private static Tuple <int, string, int, string> GetProductAndMarketByProductId(int productId) { using (var ctx = new ShtxSms2008Entities()) { var product = ctx.SmsProducts.FirstOrDefault(o => o.ProductId == productId); if (product == null) { return(Tuple.Create(0, "", 0, "")); } var marketId = product.MarketId.Value; var marketName = GetMarketNameById(marketId); return(Tuple.Create(productId, product.ProductName, marketId, marketName)); } }
public static List <SmsProduct> GetSmsProductByMarketId(int marketId) { if (smsProductCache.ContainsKey(marketId)) { return(smsProductCache[marketId]); } else { using (var ctx = new ShtxSms2008Entities()) { var products = ctx.SmsProducts.Where(o => o.MarketId == marketId).OrderBy(p => p.DisplayOrder).ToList(); smsProductCache.Add(marketId, products); return(products); } } }
public static List <SmsProduct> GetProductByMarketId(int marketId) { if (productCache.ContainsKey(marketId)) { return(productCache[marketId]); } else { using (var ctx = new ShtxSms2008Entities()) { var list = ctx.SmsProducts.Where(o => o.MarketId == marketId).ToList(); productCache.Add(marketId, list); return(list); } } }
public static string GetMarketNameById(int id) { if (marketNameCache.ContainsKey(id)) { return(marketNameCache[id]); } else { using (var ctx = new ShtxSms2008Entities()) { var name = ctx.Markets.Single(o => o.MarketId == id).MarketName; marketNameCache.Add(id, name); return(name); } } }
public SupplyDetailVM getDeliver(int id) { using (var ctx = new ShtxSms2008Entities()) { Supply supply = ctx.Supplies.FirstOrDefault(o => o.ID == id); SupplyDetailVM vm = new SupplyDetailVM(); if (supply == null) { vm.ErrorCode = "error"; return(vm); } else { vm.ErrorCode = "ok"; } vm.Id = supply.ID; vm.Product = supply.Product; vm.SupplyType = supply.SupplyType.Value; vm.Contact = supply.Contact; var city = ctx.Provinces.FirstOrDefault(o => o.ID == supply.ProviceID); var province = ctx.Provinces.FirstOrDefault(o => o.ID == city.ParentID); var address = province.Name + city.Name; vm.Address = address; vm.Quantity = supply.Quantity; vm.Mobile = supply.Mobile; vm.Description = supply.Description; vm.DeliveryType = supply.DeliveryType.Value; vm.Price = supply.Price; var imgs = ctx.Images.Where(o => o.SupplyID == supply.ID).ToList(); var list = new List <string>(); if (imgs.Count > 0) { foreach (var img in imgs) { list.Add(img.Name); } } else { list.Add("default.jpg"); } vm.Date = supply.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"); vm.Avatar = list; return(vm); } }
private string getMsg(string mobile, string pwd) { using (var ctx = new ShtxSms2008Entities()) { var smsRoles = ctx.SmsRoles.FirstOrDefault(o => o.RoleType == 106); if (smsRoles != null) { var str = smsRoles.RoleDesc; str = str.Replace("CustomerMobile", mobile).Replace("AppPassWord", pwd); return(str); } else { return("您好,欢迎使用同鑫资讯移动客户端, 用户名:" + mobile + " 密码:" + pwd); } } }
public static List <Market> GetMarketByGroupId(int groupId) { if (marketCache.ContainsKey(groupId)) { return(marketCache[groupId]); } else { using (var ctx = new ShtxSms2008Entities()) { var markets = ctx.Markets.Where(o => o.GroupID == groupId).ToList(); //marketCache[groupId] = markets; marketCache.Add(groupId, markets); return(markets); } } }
public static string GetProductNameById(int id) { if (productNameCache.ContainsKey(id)) { return(productNameCache[id].Item2); } else { using (var ctx = new ShtxSms2008Entities()) { var obj = GetProductAndMarketByProductId(id); var name = obj.Item2; productNameCache.Add(id, obj); return(name); } } }
public static Tuple <int, string> GetMarketByProductId(int id) { if (productNameCache.ContainsKey(id)) { return(Tuple.Create(productNameCache[id].Item3, productNameCache[id].Item4)); } else { using (var ctx = new ShtxSms2008Entities()) { var obj = GetProductAndMarketByProductId(id); var tuple = Tuple.Create(obj.Item3, obj.Item4); productNameCache.Add(id, obj); return(tuple); } } }
public UserInfoVM GetUserInfoByMobile(string mobile) { using (var ctx = new ShtxSms2008Entities()) { CustomerExtend ce = ctx.CustomerExtend.FirstOrDefault(o => o.SendInterFace == 102 && o.Tel.Contains(mobile)); UserInfoVM userInfo = new UserInfoVM() { EndDate = ce.EndDate.Value.ToString("yyyy-MM-dd") }; var appCustomer = ctx.AppCustomerTokens.FirstOrDefault(o => o.tel == mobile); if (appCustomer != null) { userInfo.IsSound = appCustomer.isSound ?? false; } return(userInfo); } }
public static List <int> GetGroupsForApp(int flag) { if (defaultAppGroupsCache.ContainsKey(flag)) { return(defaultAppGroupsCache[flag]); } else { using (var ctx = new ShtxSms2008Entities()) { var list = ctx.XHMarketGroups.Where(o => o.Flag == flag && o.IsForApp && (o.IsDefault ?? false) && o.GroupID != 102 && o.GroupID != 103).Select(o => o.GroupID).ToList(); //defaultAppGroupsCache[flag] = list; defaultAppGroupsCache.Add(flag, list); return(list); } } }
public static List <XHMarketGroup> GetMarketGroupForApp(int flag) { if (marketGroupForAppCache.ContainsKey(flag)) { return(marketGroupForAppCache[flag]); } else { using (var ctx = new ShtxSms2008Entities()) { var groups = ctx.XHMarketGroups.Where(o => o.Flag == flag && o.IsForApp && o.GroupID != 102 && o.GroupID != 103).ToList(); marketGroupForAppCache.Add(flag, groups); //marketGroupForAppCache[flag] = groups; return(groups); } } }
public TrialError canotAdd(string mobile) { //手机号是否合法 string dianxin = @"^1[3578][01379]\d{8}$"; Regex dReg = new Regex(dianxin); //联通手机号正则 string liantong = @"^1[34578][01256]\d{8}$"; Regex tReg = new Regex(liantong); //移动手机号正则 string yidong = @"^(134[012345678]\d{7}|1[34578][012356789]\d{8})$"; Regex yReg = new Regex(yidong); if (mobile.Length < 11) { return(TrialError.Invalid); } if (!dReg.IsMatch(mobile.Substring(0, 11)) && !tReg.IsMatch(mobile.Substring(0, 11)) && !yReg.IsMatch(mobile.Substring(0, 11))) { return(TrialError.Invalid); } using (var ctx = new ShtxSms2008Entities()) { //var count = ctx.CustomerBases.Count(o => o.Tel.Contains(mobile) && o.SendInterFace == 102); //if (count > 0) // return TrialError.Registered; App_user user = ctx.App_user.FirstOrDefault(o => o.Tel == mobile); if (user != null) { if (user.applyCount >= 1) { return(TrialError.TooManyTrial); } else { return(TrialError.OK); } } else { return(TrialError.OK); } } }