97 lines
3.0 KiB
C#
97 lines
3.0 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using WX.CRM.BLL.Base;
|
|
using WX.CRM.DAL.Csvr;
|
|
using WX.CRM.IBLL.Csvr;
|
|
using WX.CRM.Model.Entity;
|
|
using WX.CRM.Model.Enum;
|
|
|
|
namespace WX.CRM.BLL.Csvr
|
|
{
|
|
public class CSVR_CALLSTATIS_BL : ICSVR_CALLSTATIS
|
|
{
|
|
public DataTable GetList(DateTime? start, DateTime? end)
|
|
{
|
|
return new CSVR_CALLSTATIS_DAL().GetList(start, end);
|
|
}
|
|
|
|
public IEnumerable<CSVR_CALLSTATIS> GetList(decimal? eid, DateTime? dt)
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
var query = db.CSVR_CALLSTATIS.AsQueryable();
|
|
if (null != eid)
|
|
{
|
|
query = query.Where(item => item.SALESEID == eid);
|
|
}
|
|
if (null != dt)
|
|
{
|
|
query = query.Where(item => item.COUNTDATE == dt);
|
|
}
|
|
return query.ToList();
|
|
}
|
|
}
|
|
|
|
public void Update(List<CSVR_CALLSTATIS> updates)
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
foreach (var item in updates)
|
|
{
|
|
var u = db.CSVR_CALLSTATIS.First(item2 => item2.PKID == item.PKID);
|
|
u.SATISFACTION1 = item.SATISFACTION1;
|
|
u.SATISFACTION2 = item.SATISFACTION2;
|
|
u.SATISFACTION3 = item.SATISFACTION3;
|
|
u.SATISFACTION4 = item.SATISFACTION4;
|
|
}
|
|
db.SaveChanges();
|
|
}
|
|
}
|
|
|
|
public void Add(List<CSVR_CALLSTATIS> updates)
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
foreach (var item in updates)
|
|
{
|
|
item.PKID = new SEQUENCES_BL().Seq_base_get(PKIDType.LargeTable);
|
|
db.CSVR_CALLSTATIS.Add(item);
|
|
}
|
|
db.SaveChanges();
|
|
}
|
|
}
|
|
public void AddModel(CSVR_CALLSTATISDETAIL model)
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
db.CSVR_CALLSTATISDETAIL.Add(model);
|
|
db.SaveChanges();
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 获取最新的插入时间
|
|
/// </summary>
|
|
public DateTime GetLstInsertionTime()
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
return db.CSVR_CALLSTATISDETAIL.Select(item => item.INSERTTIME).DefaultIfEmpty(DateTime.Parse("2000-01-01")).Max();
|
|
}
|
|
}
|
|
|
|
public void AddDetails(List<CSVR_CALLSTATISDETAIL> details)
|
|
{
|
|
using (var db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
foreach (var item in details)
|
|
{
|
|
db.CSVR_CALLSTATISDETAIL.Add(item);
|
|
}
|
|
db.SaveChanges();
|
|
}
|
|
}
|
|
}
|
|
}
|