66 lines
2.4 KiB
C#
66 lines
2.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using WX.CRM.BLL.Application.UserComBox;
|
|
using WX.CRM.Common;
|
|
using WX.CRM.DAL.Res;
|
|
using WX.CRM.IBLL.Res;
|
|
using WX.CRM.Model.DTO;
|
|
using WX.CRM.Model.Entity;
|
|
using WX.CRM.Model.MAP;
|
|
|
|
namespace WX.CRM.BLL.Res
|
|
{
|
|
public class RES_SCENE_BL : DbContextRepository<RES_SCENE>, IRES_SCENE
|
|
{
|
|
private readonly RES_SCENE_DAL _dal = new RES_SCENE_DAL();
|
|
|
|
public List<ResSceneView> GetList(ref Pager pager, QueryUserComboDto usercomboDto, string nickName, decimal? sceneType, DateTime? sTime, DateTime? eTime)
|
|
{
|
|
List<decimal> ALLdeptIDS = new List<decimal>();
|
|
List<decimal> ALLgidS = new List<decimal>();
|
|
if (string.IsNullOrEmpty(usercomboDto.groupIds) && !string.IsNullOrEmpty(usercomboDto.deptId))
|
|
{
|
|
var depts = OperationUtil.ConvertToDecimal(usercomboDto.deptId.Split(','));
|
|
|
|
UserServices userservices = new UserServices();
|
|
foreach (var item in depts)
|
|
{
|
|
List<decimal> deptIDS = new List<decimal>();
|
|
List<decimal> gidS = new List<decimal>();
|
|
userservices.GetAllDeptIDOrGidByDeptId(item, ref deptIDS, ref gidS);//获取所有的组别和gid
|
|
ALLdeptIDS.AddRange(deptIDS);
|
|
ALLgidS.AddRange(gidS);
|
|
}
|
|
ALLdeptIDS.AddRange(ALLgidS);
|
|
usercomboDto.deptId = string.Join(",", ALLdeptIDS);//所有的部门ID和销售组ID
|
|
|
|
}
|
|
var ds = _dal.List(ref pager, usercomboDto, nickName, sceneType, sTime, eTime);
|
|
var list = ds.Tables[0].ToList<ResSceneView>();
|
|
if (list.Any())
|
|
{
|
|
var row = list.FirstOrDefault(p => p.ResId == "rowcount");
|
|
pager.totalRows = Convert.ToInt32(row.rn);
|
|
list.Remove(row);
|
|
}
|
|
return list;
|
|
}
|
|
|
|
public List<ResSceneType> GetSceneType()
|
|
{
|
|
using (var db = new crmContext())
|
|
{
|
|
var q = (from a in db.RES_SCENE
|
|
group a by new { a.SCENETYPE, a.SCENETITLE } into g
|
|
select new ResSceneType { SCENETYPE = g.Key.SCENETYPE, SCENETITLE = g.Key.SCENETITLE }
|
|
).ToList();
|
|
|
|
return q;
|
|
}
|
|
}
|
|
}
|
|
}
|