public ActionResult InvIndex(string userId) { marketShopApp shopApp = new marketShopApp(); List <marketSalesShopEntity> shops = new List <marketSalesShopEntity>(); shops.AddRange(shopApp.getShopByUserId(userId)); marketSalesApp userapp = new marketSalesApp(); UserInfoResultModel userinfo = userapp.GetUserInfo(userId); shops.AddRange(shopApp.getAllShopByEmpCode(userinfo.SalesNo)); var t = from e in shops group e by new { Code = e.CUSTOMER_CODE, Name = e.CUSTOMER_NAME } into g select new CusModel { CustomerCode = g.Key.Code, CustomerName = g.Key.Name }; /* * marketShopApp shopApp = new marketShopApp(); * List<marketSalesShopEntity> shops = shopApp.getShopByUserId(userId); * List<CusModel> vModel = new List<CusModel>(); * foreach (var shop in shops) * { * if (vModel.Find(p => p.CustomerCode.Equals(shop.CUSTOMER_CODE)) == null) * { * vModel.Add(new CusModel() { CustomerCode = shop.CUSTOMER_CODE, CustomerName = shop.CUSTOMER_NAME }); * } * }*/ ViewData["vModel"] = t.OrderBy(p => p.CustomerName).ToList();; ViewData["userId"] = userId; return(View("InvQinView")); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="access_token"></param> /// <param name="openid"></param> /// <returns></returns> public static UserInfoResultModel GetUserInfo(string access_token, string openid) { string url = "https://api.weixin.qq.com/sns/userinfo"; url += "?access_token=" + access_token; url += "&openid=" + openid; url += "&lang=zh_CN"; string res = new HttpUtil( ).Get(url); Log.Logger.Log("[wx: GetUserInfo] " + url + "#" + res); try { UserInfoResultModel wx_token = JsonUtil.FromJson <UserInfoResultModel>(res); if (wx_token != null && wx_token.errcode == 0) { return(wx_token); } else { Log.Logger.Log("[wx: GetUserInfo Failed] " + url + "#" + res); return(null); } } catch (Exception ex) { Log.Logger.Log("[wx: GetUserInfo Exception] " + url + "#" + ex.Message); return(null); } }
public UserInfoModel GetUserInfo() { try { marketSalesApp app = new marketSalesApp(); UserInfoResultModel t = app.GetUserInfo(User.Identity.GetUserId()); UserInfoModel model = new UserInfoModel { No = t.No, Name = t.Name, PhoneNumber = t.PhoneNumber, SalesNo = t.SalesNo , POP_TYPE_CODE = t.POP_TYPE_CODE, id = User.Identity.GetUserId(), PICUrl = "https://iretailerapp.flnet.com/userPic.jpg" /// ShopNo = t.ShopNo }; String appKey = "y745wfm8y1y6v"; String appSecret = "njmewTIin5p"; RongCloud rongcloud = RongCloud.getInstance(appKey, appSecret); JsonSerializer serializer = new JsonSerializer(); // 获取 Token 方法 TokenReslut usergetTokenResult = rongcloud.user.getToken(model.id, model.Name, model.PICUrl); if (usergetTokenResult.getCode() == 200) { model.IMToken = usergetTokenResult.getToken(); } marketShopApp shopApp = new marketShopApp(); List <marketSalesShopEntity> shops = shopApp.getShopByUserId(User.Identity.GetUserId()); model.Shops = new List <UserShopInfoModel>(); foreach (marketSalesShopEntity shop in shops) { UserShopInfoModel shopmodel = new UserShopInfoModel() { CustomerCode = shop.CUSTOMER_CODE, CustomerName = shop.CUSTOMER_NAME, ShopCode = shop.SHOP_CODE, ShopName = shop.SHOP_NAME, LATITUDE = shop.LATITUDE.Value, LONGITUDE = shop.LONGITUDE.Value }; model.Shops.Add(shopmodel); } return(model); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(ex.ToString()), ReasonPhrase = "error" }; throw new HttpResponseException(resp); } }
public UserInfoModel UserInfoTest() { marketSalesApp app = new marketSalesApp(); UserInfoResultModel t = app.GetUserInfo(); UserInfoModel model = new UserInfoModel { No = t.No, /// ShopNo = t.ShopNo }; return(model); }
public PartialViewResult CustomerView(string userId) { marketShopApp shopApp = new marketShopApp(); List <marketSalesShopEntity> shops = new List <marketSalesShopEntity>(); shops.AddRange(shopApp.getShopByUserId(userId)); marketSalesApp userapp = new marketSalesApp(); UserInfoResultModel userinfo = userapp.GetUserInfo(userId); shops.AddRange(shopApp.getAllShopByEmpCode(userinfo.SalesNo)); var t = from e in shops group e by new { Code = e.CUSTOMER_CODE, Name = e.CUSTOMER_NAME } into g select new CusModel { CustomerCode = g.Key.Code, CustomerName = g.Key.Name }; return(PartialView("_InvQinCustomerPartialPage", t.OrderBy(p => p.CustomerName).ToList())); }
public UserInfoResultModel GetUserInfoBySalesNo(string salesNo) { var ents = dbcontext.Set <aspnetusersEntity>().Where(p => p.EMPLOYEE_CODE.Equals(salesNo) && p.active == 1); if (ents.Count() > 0) { var ent = ents.First(); UserInfoResultModel model = new UserInfoResultModel() { id = ent.Id, Name = ent.EMPLOYEE_NAME, No = ent.EMPLOYEE_CODE, PhoneNumber = ent.PhoneNumber, POP_TYPE_CODE = "", SalesNo = ent.EMPLOYEE_CODE }; var ent2 = this.IQueryable().Where(p => p.sales_No.Equals(ent.EMPLOYEE_CODE) && p.Active == 1); if (ent2.Count() > 0) { model.POP_TYPE_CODE = ent2.First().POP_TYPE_CODE; return(model); } var ent3 = dbcontext.Set <PsiSalesEmpOrgEntity>().Where(p => p.EMPLOYEE_CODE.Equals(ent.EMPLOYEE_CODE) && p.ACTIVE_FLAG == 1); if (ent3.Count() > 0) { model.POP_TYPE_CODE = ent3.First().JOB_CODE; return(model); } return(model); } return(null); /* * var t = from p in dbcontext.Set<marketSalesEntity>() * join c in dbcontext.Set<aspnetusersEntity>() on new { PhoneNumber = p.sales_PhoneNumber } equals new { PhoneNumber = c.PhoneNumber } * where p.sales_No.Equals(salesNo) && p.Active == 1 * select new UserInfoResultModel * { * Name = p.sales_Name, * No = p.sales_No, * PhoneNumber = p.sales_PhoneNumber, * SalesNo = p.sales_No, * POP_TYPE_CODE = p.POP_TYPE_CODE * , id=c.Id * * }; * if (t != null && t.Count() > 0) * { * return t.First(); * } * else * { * var x = from p in dbcontext.Set<PsiSalesEmpOrgEntity>() * join c in dbcontext.Set<aspnetusersEntity>() on new { UserName = p.EMPLOYEE_CODE } equals new { UserName = c.UserName } * where p.EMPLOYEE_CODE.Equals(salesNo) && p.ACTIVE_FLAG == 1 * select new UserInfoResultModel * { * Name = p.EMPLOYEE_NAME, * No = p.EMPLOYEE_CODE, * PhoneNumber = p.EMPLOYEE_CODE, * SalesNo = p.EMPLOYEE_CODE, * POP_TYPE_CODE = p.JOB_CODE, * id = c.Id * * }; * if (x != null && x.Count() > 0) * { * return x.First(); * } * else * { * return null; * } * } **/ //dbcontext.Set<marketSalesEntity>().Join(dbcontext.Entry<AreaEntity>.Set<AreaEntity>(),p=> p.test= ) }