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= )
}
