/// <summary>
/// 获取参与人名字
/// </summary>
/// <param name="businessUuid"></param>
/// <returns></returns>
private static string SelectName(Guid businessUuid)
{
var systemUserName = "";
using var c1 = new HaikanCRMContext();
var participantIds = c1.Business.Where(x => x.BusinessUuid == businessUuid).ToList()[0].SystemUserUuid;//参与人uuid
if (string.IsNullOrEmpty(participantIds))
{
return(systemUserName);
}
var patCount = participantIds.Split(',');
for (var i = 0; i < patCount.Length; i++)
{
if (patCount[i] != "")
{
systemUserName += c1.SystemUser.Where(x => x.SystemUserUuid == Guid.Parse(patCount[i])).ToList()[0]
.RealName + ",";
}
}
return(systemUserName);
}
/// <summary>
/// 获取参与人名字
/// </summary>
/// <param name="contactBusName"></param>
/// <param name="context"></param>
/// <returns></returns>
private static string SelectNameLog(string contactBusName, HaikanCRMContext context)
{
string systemUserName;
//var response = ResponseModelFactory.CreateResultInstance;
if (contactBusName.Substring(contactBusName.Length - 1) == ",")
{
contactBusName = contactBusName.Substring(0, contactBusName.Length - 1);
}
var ids = contactBusName.Split(',');
for (int i = 0; i < ids.Length; i++)
{
ids[i] = "'" + ids[i] + "'";
}
var idstr = string.Join(",", ids);
//select stuff((select ',' + ContactName from ContactPerson where ContactPersonUUID in (
var sql = string.Format("select stuff((select ',' + ContactName from ContactPerson where ContactPersonUUID in ({0}) for xml path('')),1,1,'') as Names ", idstr);
var cNames = context.Database.FromSql <CNames>(sql);
systemUserName = cNames[0].Names;
return(systemUserName);
}
/// <summary>
///
/// </summary>
/// <param name="dbContext"></param>
/// <param name="mapper"></param>
public UserController(HaikanCRMContext dbContext, IMapper mapper, IOptions <MdDesEncrypt> mdDesEncrypt, IOptions <AppAuthenticationSettings> appSettings)
{
_appSettings = appSettings.Value;
_dbContext = dbContext;
_mapper = mapper;
MdDesEncrypt = mdDesEncrypt.Value;
}
/// <summary>
/// 根据uuid查客户经理的名字
/// </summary>
/// <param name="clientUuid"></param>
/// <returns></returns>
private static string CooM(Guid?clientUuid)
{
string clientManager = "";
using (HaikanCRMContext c1 = new HaikanCRMContext())
{
var query = c1.Customer.FirstOrDefault(x => x.ClientUuid == clientUuid);
var query2 = c1.SystemUser.FirstOrDefault(x => x.SystemUserUuid == query.ClientManager);
if (query2 != null)
{
clientManager = query2.RealName;
}
return(clientManager);
}
}
/// <summary>
/// 通过联系人uuid查询联系人名称
/// </summary>
/// <param name="contactPersonUuid"></param>
/// <returns></returns>
private static string SelectName(Guid contactPersonUuid)
{
string contactName = "";
//var response = ResponseModelFactory.CreateResultInstance;
using (HaikanCRMContext c1 = new HaikanCRMContext())
{
var participantids = c1.ContactPerson.FirstOrDefault(x => x.ContactPersonUuid == contactPersonUuid);
var query = c1.Customer.FirstOrDefault(x => x.ClientUuid == participantids.ClientUuid);
if (query != null)
{
if (participantids != null)
{
contactName = participantids.ContactName + "(" + query.ClientName + ")";
}
}
}
return(contactName);
}
/// <summary>
/// 计算用户当天的联系记录数量
/// </summary>
/// <param name="SystemUserUuid"></param>
/// <returns></returns>
private static int Xxdd(Guid SystemUserUuid)
{
int txlu = 0;
using (HaikanCRMContext c1 = new HaikanCRMContext())
{
var que = c1.Customer.Where(x => x.ClientManager == SystemUserUuid);
var d5 = DateTime.Now.ToString("yyyy-MM-dd");
if (que.ToList().Count > 0)
{
for (int i = 0; i < que.ToList().Count; i++)
{
txlu += c1.ContactCallLog.Count(x => x.ClientUuid == que.ToList()[i].ClientUuid && x.CallTime.Substring(0, 10) == d5);
}
}
}
return(txlu);
}
private string GetroleName(string ids)
{
string s = "";
string[] temp = ids.TrimEnd(',').Split(',');
using (HaikanCRMContext cc = new HaikanCRMContext())
{
for (int i = 0; i < temp.Length; i++)
{
if (!string.IsNullOrEmpty(temp[i]))
{
var qu = cc.SystemRole.Where(x => x.SystemRoleUuid == Guid.Parse(temp[i])).Select(x => new { x.RoleName }).ToList();
if (!string.IsNullOrEmpty(qu[0].RoleName))
{
s += qu[0].RoleName + ",";
}
}
}
return(s.TrimEnd(','));
}
}
/// <summary>
///
/// </summary>
/// <param name="appSettings"></param>
public OauthController(IOptions <AppAuthenticationSettings> appSettings, HaikanCRMContext dbContext, IOptions <MdDesEncrypt> mdDesEncrypt)
{
_appSettings = appSettings.Value;
_dbContext = dbContext;
MdDesEncrypt = mdDesEncrypt.Value;
}
/// <summary>
/// 构造函数
/// </summary>
public AppMessageController(HaikanCRMContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
public IndexStatisticsController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}
/// <summary>
///
/// </summary>
/// <param name="dbContext"></param>
/// <param name="mapper"></param>
public PermissionController(HaikanCRMContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
public AppContactController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
public BusinessController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
public AppCustomerController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
/// <param name="hostingEnvironment"></param>
public ContactController(HaikanCRMContext dbContext, IWebHostEnvironment hostingEnvironment)
{
_dbContext = dbContext;
_webHostEnvironment = hostingEnvironment;
}
/// <summary>
///
/// </summary>
/// <param name="dbContext"></param>
/// <param name="mapper"></param>
public RoleController(HaikanCRMContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
/// <summary>
///构造函数
/// </summary>
/// <param name="dbContext"></param>
/// <param name="iWebHostEnvironment"></param>
public GlobalController(HaikanCRMContext dbContext, IWebHostEnvironment iWebHostEnvironment)
{
_dbContext = dbContext;
//_mapper = mapper;
_hostEnv = iWebHostEnvironment;
}
/// <summary>
///
/// </summary>
/// <param name="dbContext"></param>
public AccountController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
/// <param name="hostingEnvironment"></param>
public BusinessDocumentsController(HaikanCRMContext dbContext, IWebHostEnvironment hostingEnvironment)
{
_dbContext = dbContext;
_hostingEnvironment = hostingEnvironment;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="dbContext"></param>
public AppCallLogController(HaikanCRMContext dbContext)
{
_dbContext = dbContext;
}