144 lines
4.9 KiB
C#
144 lines
4.9 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using WX.CRM.BLL.Base;
|
||
using WX.CRM.BLL.Util;
|
||
using WX.CRM.Common;
|
||
using WX.CRM.IBLL.Soft;
|
||
|
||
namespace WX.CRM.BLL.Soft
|
||
{
|
||
public class SOFT_MODULE_BL : ISOFT_MODULE, ISOFT_MODULE_Q
|
||
{
|
||
public bool Create(ref ValidationErrors errors, WX.CRM.Model.Entity.SOFT_MODULE model)
|
||
{
|
||
try
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
var entry = db.SOFT_MODULE.FirstOrDefault(m => m.MODULEID == model.MODULEID);
|
||
if (entry != null)
|
||
{
|
||
errors.Add("这个ID已被占用！");
|
||
return false;
|
||
}
|
||
model.PKID = new SEQUENCES_BL().Seq_base_get();
|
||
db.SOFT_MODULE.Add(model);
|
||
return db.SaveChanges().GetResult();
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
errors.Add(ex.Message);
|
||
return false;
|
||
}
|
||
}
|
||
|
||
public bool Update(ref ValidationErrors errors, WX.CRM.Model.Entity.SOFT_MODULE model)
|
||
{
|
||
try
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
|
||
var entry = db.SOFT_MODULE.FirstOrDefault(m => m.MODULEID == model.MODULEID && m.PKID != model.PKID);
|
||
if (entry != null)
|
||
{
|
||
errors.Add("这个ID已被占用！");
|
||
return false;
|
||
}
|
||
entry = db.SOFT_MODULE.FirstOrDefault(m => m.PKID == model.PKID);
|
||
if (entry == null)
|
||
{
|
||
errors.Add("找不到数据！");
|
||
return false;
|
||
}
|
||
entry.MODULEID = model.MODULEID;
|
||
entry.MODULENAME = model.MODULENAME;
|
||
entry.DEFAULTDAYS = model.DEFAULTDAYS;
|
||
entry.CREATEUSER = model.CREATEUSER;
|
||
entry.UTIME = model.UTIME;
|
||
entry.UPDATEUSER = model.UPDATEUSER;
|
||
db.SaveChanges();
|
||
return true;
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
errors.Add(ex.Message);
|
||
return false;
|
||
}
|
||
}
|
||
|
||
public WX.CRM.Model.Entity.SOFT_MODULE GetModuleById(decimal id)
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
WX.CRM.Model.Entity.SOFT_MODULE entry = db.SOFT_MODULE.FirstOrDefault(m => m.MODULEID == id);
|
||
return entry;
|
||
}
|
||
}
|
||
|
||
public List<WX.CRM.Model.Entity.SOFT_MODULE> GetAllModule()
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
return db.SOFT_MODULE.ToList();
|
||
}
|
||
}
|
||
|
||
public List<WX.CRM.Model.Entity.SOFT_MODULE> GetModuleList(string modeuleName)
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
var list = db.SOFT_MODULE.AsQueryable();
|
||
if (!string.IsNullOrEmpty(modeuleName))
|
||
{
|
||
list = list.Where(p => p.MODULENAME.Contains(modeuleName));
|
||
}
|
||
return list.OrderByDescending(p => p.CTIME).ToList();
|
||
}
|
||
}
|
||
|
||
|
||
|
||
public DateTime GetServiceLastExecTime()
|
||
{
|
||
DateTime rdate = System.DateTime.Now;
|
||
try
|
||
{
|
||
WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext();
|
||
var par = db.BAS_PARAMETER.FirstOrDefault(p => p.PARAKEY.Trim() == "GetResbyAgentIdServiceLastTime" && p.GROUPID.Trim() == "SysServiceExecTime");
|
||
if (par != null)
|
||
rdate = DateTime.Parse(par.PARAVALUE);
|
||
else
|
||
throw new Exception("GetResbyAgentIdServiceLastTime参数错误");
|
||
}
|
||
catch
|
||
{
|
||
rdate = System.DateTime.Now;
|
||
}
|
||
return rdate;
|
||
}
|
||
public void UpdateExecLastTime(DateTime lastTime)
|
||
{
|
||
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
||
{
|
||
var par = db.BAS_PARAMETER.FirstOrDefault(p => p.PARAKEY.Trim() == "GetResbyAgentIdServiceLastTime" && p.GROUPID.Trim() == "SysServiceExecTime");
|
||
if (par == null)
|
||
{
|
||
throw new Exception("GetResbyAgentIdServiceLastTime参数错误");
|
||
}
|
||
par.PARAVALUE = lastTime.ToString();
|
||
db.SaveChanges();
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
}
|
||
}
|