90 lines
2.9 KiB
C#
90 lines
2.9 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using WX.CRM.BLL.Util;
|
|
using WX.CRM.Common;
|
|
using WX.CRM.DAL.WeWork;
|
|
using WX.CRM.IBLL.WeWork;
|
|
using WX.CRM.Model.Entity;
|
|
using WX.CRM.Model.MAP;
|
|
using WX.CRM.Model.QueryMap;
|
|
using WX.CRM.Model.SSO;
|
|
|
|
namespace WX.CRM.BLL.WeWork
|
|
{
|
|
public class WW_EXTUSER_BL : DbContextRepository<WW_EXTUSER>, IWW_EXTUSER
|
|
{
|
|
private ExtUser_DAL extUser_DAL = new ExtUser_DAL();
|
|
public DataTable CountByDayReport(DateTime? beginTime, DateTime? endTime)
|
|
{
|
|
return extUser_DAL.CountByDayReport(beginTime, endTime);
|
|
}
|
|
|
|
public DataTable CountByUserAndDay(DateTime beginTime, DateTime endTime)
|
|
{
|
|
return extUser_DAL.CountByUserAndDay(beginTime, endTime);
|
|
}
|
|
|
|
public decimal GetDistinctWeWorkFriendCount(string day)
|
|
{
|
|
return extUser_DAL.GetDistinctWeWorkFriendCount(day);
|
|
}
|
|
|
|
public List<WW_EXTUSER_Extend> GetList(string userId, DateTime? day)
|
|
{
|
|
using (var db = new crmContext())
|
|
{
|
|
var query = db.WW_EXTUSER.AsQueryable();
|
|
if (day.HasValue)
|
|
{
|
|
var day2 = day.Value.AddDays(1);
|
|
query = query.Where(p => p.CTIME >= day.Value && p.CTIME < day2);
|
|
}
|
|
var data = from q in query
|
|
join r in db.WW_USER_EXTUSER on q.USERID equals r.EXTUSERID
|
|
where r.USERID == userId
|
|
select new WW_EXTUSER_Extend()
|
|
{
|
|
WW_ExtUser = q,
|
|
WorkUserId = r.USERID
|
|
};
|
|
return data.ToList();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 客户资料和企业微信绑定获取
|
|
/// </summary>
|
|
/// <param name="resid"></param>
|
|
/// <returns></returns>
|
|
public string[] ExtUserBandGet(string resid)
|
|
{
|
|
return new ExtUser_DAL().ExtUserBandGet(resid);
|
|
}
|
|
public string[] ExtUserBandGetNew(string resid)
|
|
{
|
|
List<HHUserDto> res = new List<HHUserDto>();
|
|
try
|
|
{
|
|
var url = new CACHE_BL().GetValue_Parameter("HgWebUrl");
|
|
url = $"{url}Order/GetHHUserByResId";
|
|
var para = $"resid={resid}";
|
|
var data = Utility.GetData(url, para, Encoding.Default);
|
|
var apiData = Utility.ToObject<CRMApiData<HHUserDto>>(data);
|
|
res = apiData.Data;
|
|
if (res == null)
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error($"获取订单列表失败【{resid}】{ex.Message}");
|
|
}
|
|
return res.Select(n => n.userid).ToArray();
|
|
}
|
|
}
|
|
}
|