/// <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()); } }
public SearchRevenueButton(WeChatMenuButtonType menuButtonType, WeChatEventHandle eventHandle) { _buttonMenuType = menuButtonType; _eventHandle = eventHandle; _rl = new RevenueLogic(); _cs = new ConfigManageServer(); _ss = new ShortMsgServer(); }
public ShortMsgLogic() { _ss = new ShortMsgServer(); _cs = new ConfigManageServer(); }