/// <summary>
/// 营收推送营收金额时只推送（司机而且欠款的人员），其他人员不推送
/// </summary>
/// <param name="orgVguid"></param>
/// <param name="labName"></param>
/// <returns></returns>
public string[] GetRevenuePerson(Guid orgVguid, string labName)
{
using (var db = SugarDao_MsSql.GetInstance())
{
var listUser = new List <string>();
ShortMsgServer shortMsgServer = new ShortMsgServer();
var list = db.SqlQuery <Business_Personnel_Information>("exec usp_getOrganization_UserID @orgvguid", new { orgvguid = orgVguid }); //查找该部门下所有的司机
if (!string.IsNullOrEmpty(labName))
{
var labArr = labName.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var query = db.Queryable <Business_PersonnelLabel_Information>().In(i => i.LabelName, labArr).GroupBy(i => i.PersonnelVVGUID).Select(i => i.PersonnelVVGUID).ToList();
list = list.Where(i => query.Contains(i.Vguid)).ToList();
}
foreach (var personModel in list)
{
var driverModel = shortMsgServer.GetDriverMsg(personModel);
var paymentModel = shortMsgServer.GetRevenueMsg(driverModel);
if (paymentModel != null)
{
var accountBalance = (paymentModel.PaidAmount - paymentModel.DueAmount + (paymentModel.DebtAmount * -1)).ToString("F2"); //本期结余
if (decimal.Parse(accountBalance) < 0)
{
listUser.Add(personModel.UserID);
}
}
}
return(listUser.ToArray());
}
}
/// <summary>
/// 获取司机ID和车辆ID
/// </summary>
/// <param name="personModel"></param>
/// <returns></returns>
public Driver GetDriverMsg(Business_Personnel_Information personModel)
{
return(_ss.GetDriverMsg(personModel));
}