/// <summary>
/// 新增管家
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(MyHouseKeeper model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_MYHOUSEKEEPER>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 根据userID获取有权限的功能点
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="isMenu">是否为菜单</param>
/// <returns></returns>
public List <RoleFunction> GetAuthorizedList(string userID)
{
using (DbContext db = new CRDatabase())
{
if (string.IsNullOrEmpty(userID))
{
return(new List <RoleFunction>());
}
var roleIDList = db.Set <CTMS_SYS_USERROLE>()
.AsNoTracking()
.Where(o => !o.ISDELETED && o.USERID.Equals(userID))
.Select(o => o.ROLEID)
.ToList();
return(db.Set <CTMS_SYS_ROLEFUNCTION>()
.AsNoTracking()
.Where(o => !o.ISDELETED && roleIDList.Contains(o.ROLEID))
.Select(EntityToModel)
.ToList());
}
}
/// <summary>
/// 新增元数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(MetaData model)
{
if (model == null)
{
return(0);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_METADATA>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 新增元数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(ConditionItem model)
{
if (model == null)
{
return(0);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_CONDITIONITEM>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 新增随访方案
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(QATestPaper model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_QA_TESTPAPER>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.TestPaperID);
}
}
/// <summary>
/// 新增我的产品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(MyProduct model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_MYPRODUCT>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 新增元数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(GuideLine model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
model.ID = Guid.NewGuid().ToString();
db.Set <CTMS_GUIDELINE>().Add(ModelToEntity(model));
if (model.MetaDataList != null && model.MetaDataList.Count > 0)
{
foreach (GuideLineData data in model.MetaDataList)
{
data.GuideLineID = model.ID;
db.Set <CTMS_GUIDELINEDATA>().Add(new GuideLineDataBLL().ModelToEntity(data));
}
}
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 新增功能权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(FunctionPermission model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
model.FunctionPermissionID = Guid.NewGuid().ToString();
db.Set <CTMS_SYS_FUNCTIONPERMISSION>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.FunctionPermissionID);
}
}
/// <summary>
/// 根据用户ID，功能编码和权限类型 获取角色功能权限实体
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="authCode">权限编码</param>
/// <param name="permission">权限类型</param>
/// <returns></returns>
public List <RoleFunction> GetAuthorizedList(string userID, string authCode, PermissionType permission)
{
List <RoleFunction> roleFunctionList = new List <RoleFunction>();
if (string.IsNullOrEmpty(authCode) || string.IsNullOrEmpty(authCode))
{
return(roleFunctionList);
}
using (DbContext db = new CRDatabase())
{
var function = db.Set <CTMS_SYS_FUNCTION>().AsNoTracking().Where(o => o.FUNCTIONCODE.Equals(authCode)).ToList();
if (function == null || function.Count() == 0)
{
return(roleFunctionList);
}
string functionid = function[0].FUNCTIONID;
var roleIDList = db.Set <CTMS_SYS_USERROLE>()
.AsNoTracking()
.Where(o => !o.ISDELETED && o.USERID.Equals(userID))
.Select(o => o.ROLEID)
.ToList();
roleFunctionList = db.Set <CTMS_SYS_ROLEFUNCTION>()
.AsNoTracking()
.Where
(
o => !o.ISDELETED &&
roleIDList.Contains(o.ROLEID) &&
o.FUNCTIONID.Equals(functionid) &&
o.PERMISSIONVALUE == (int)permission
)
.Select(EntityToModel)
.ToList();
return(roleFunctionList);
}
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(Role model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
model.RoleID = Guid.NewGuid().ToString();
db.Set <CTMS_SYS_ROLE>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.RoleID);
}
}
/// <summary>
/// 根据ID获取咨询
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public MyQuestion Get(string id)
{
using (DbContext db = new CRDatabase())
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
CTMS_MYQUESTION entity = db.Set <CTMS_MYQUESTION>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
/// <summary>
/// 根据ID获取我的产品
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public MyProduct Get(string id)
{
using (DbContext db = new CRDatabase())
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
CTMS_MYPRODUCT entity = db.Set <CTMS_MYPRODUCT>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
/// <summary>
/// 根据ID获取管家
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public MyHouseKeeper Get(string id)
{
using (DbContext db = new CRDatabase())
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
CTMS_MYHOUSEKEEPER entity = db.Set <CTMS_MYHOUSEKEEPER>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
/// <summary>
/// 根据ID获取账单
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public AccountRecord Get(string id)
{
using (DbContext db = new CRDatabase())
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
CTMS_ACCOUNTRECORD entity = db.Set <CTMS_ACCOUNTRECORD>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
/// <summary>
/// 根据ID获取用户基因信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UserGene Get(string id)
{
if (string.IsNullOrEmpty(id))
{
LogService.WriteInfoLog(logTitle, "试图查找ID为空的UserGene实体!");
return(null);
}
using (DbContext db = new CRDatabase())
{
HR_USERGENE entity = db.Set <HR_USERGENE>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
/// <summary>
/// 添加用户基因
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(UserGene model)
{
if (model == null)
{
return(string.Empty);
}
if (string.IsNullOrEmpty(model.ID))
{
model.ID = Guid.NewGuid().ToString();
}
using (DbContext db = new CRDatabase())
{
db.Set <HR_USERGENE>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 获取查询列表
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public List <MyQuestion> GetList(string keyWord, string userID = "")
{
using (DbContext db = new CRDatabase())
{
var query = db.Set <CTMS_MYQUESTION>().AsNoTracking().Where(o => !o.ISDELETED);
if (!string.IsNullOrEmpty(userID))
{
query = query.Where(o => o.USERID.Equals(userID));
}
if (!string.IsNullOrEmpty(keyWord))
{
query = query.Where(o => o.QUESTION.Contains(keyWord));
}
List <MyQuestion> list = query.ToList().Select(EntityToModel).ToList();
return(list);
}
}
/// <summary>
/// 添加用户基因
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(DrugAllele model)
{
if (model == null)
{
return(string.Empty);
}
if (string.IsNullOrEmpty(model.ID))
{
model.ID = Guid.NewGuid().ToString();
}
using (DbContext db = new CRDatabase())
{
db.Set <GN_DRUGALLELE>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 根据ID获取用户基因信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DrugAllele Get(string id)
{
if (string.IsNullOrEmpty(id))
{
LogService.WriteInfoLog(logTitle, "试图查找ID为空的DrugAllele实体!");
return(null);
}
using (DbContext db = new CRDatabase())
{
GN_DRUGALLELE entity = db.Set <GN_DRUGALLELE>().Find(id);
if (entity == null)
{
return(null);
}
return(EntityToModel(entity));
}
}
public string Add(UserApply model)
{
if (model == null)
{
return(string.Empty);
}
if (string.IsNullOrEmpty(model.ID))
{
model.ID = Guid.NewGuid().ToString();
}
using (var context = new CRDatabase())
{
context.Set <CTMS_USERAPPLY>().Add(ModelToEntity(model));
context.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 检查该手机是否已经被使用
/// </summary>
/// <param name="phone"></param>
/// <returns></returns>
public BaseResult CheckUserPhoneExists(string phone)
{
using (var context = new CRDatabase())
{
BaseResult br = new BaseResult()
{
Succeeded = true, Error = ""
};
var list = context.Set <CTMS_SYS_USERINFO>().Where(p => p.MOBILEPHONE == phone).ToList();
if (list.Any())
{
br.Succeeded = false;
br.Error = "该手机已被注册";
}
return(br);
}
}
/// <summary>
/// 获取查询列表
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public List <MenuInfo> GetList()
{
using (DbContext db = new CRDatabase())
{
var query = db.Set <CTMS_SYS_FUNCTION>().AsNoTracking()
.Where(o => o.ISMENU && !o.ISDELETED && string.IsNullOrEmpty(o.PARENTID))
.OrderBy(m => m.SORT).ToList();
List <MenuInfo> list = new List <MenuInfo>();
foreach (CTMS_SYS_FUNCTION entity in query)
{
MenuInfo model = EntityToModel(entity);
model.ChildrenList = GetChildrenList(model.ID);
list.Add(model);
}
return(list);
}
}
/// <summary>
/// 根据用户ID获取基因
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <DrugAllele> GetList(string drugBankID)
{
List <DrugAllele> list = new List <DrugAllele>();
if (string.IsNullOrEmpty(drugBankID))
{
return(list);
}
using (DbContext db = new CRDatabase())
{
var entityList = db.Set <GN_DRUGALLELE>().AsNoTracking().Where(o => o.DRUGBANKID.Equals(drugBankID));
foreach (GN_DRUGALLELE entity in entityList)
{
DrugAllele DrugAllele = EntityToModel(entity);
list.Add(DrugAllele);
}
}
return(list);
}
/// <summary>
/// 获取查询列表
/// </summary>
/// <param name="keyWord"></param>
/// <returns></returns>
public List <AccountRecord> GetList(string userID, DateTime startDate, DateTime endDate)
{
using (DbContext db = new CRDatabase())
{
DateTime date = endDate.Date.AddDays(1);
return(db.Set <CTMS_ACCOUNTRECORD>()
.AsNoTracking()
.Where
(
o => !o.ISDELETED &&
o.USERID.Equals(userID) &&
o.CREATEDATETIME >= startDate.Date &&
o.CREATEDATETIME < date
)
.OrderByDescending(o => o.CREATEDATETIME)
.Select(EntityToModel)
.ToList());
}
}
public List <MemberModel> GetMemberList()
{
using (var context = new CRDatabase())
{
return
(context.Set <CTMS_MEMBER>()
.AsNoTracking()
.OrderBy(o => o.MEMBERLEVEL)
.ToList()
.Select((p) => new MemberModel()
{
MEMBERID = p.MEMBERID,
MEMBERNAME = p.MEMBERNAME,
MEMBERLEVEL = p.MEMBERLEVEL,
MEMBERPRICE = p.MEMBERPRICE,
MEMBERUNIT = p.MEMBERUNIT,
MEMBERDESCRIPT = p.MEMBERDESCRIPT,
}).ToList());
}
}
public bool DeleteTemplate(string id)
{
if (string.IsNullOrEmpty(id))
{
return(false);
}
using (CRDatabase _context = new CRDatabase())
{
var entity = _context.Set <HR_EXAMINETEMPLATE>().Find(id);
if (entity != null)
{
entity.ISDELETED = "1";
//_context.Set<HR_EXAMINETEMPLATE>().Remove(entity);
//_context.HR_TEMPLATEITEM.Where(p => p.TEMPLATEID == id)
// .ToList()
// .ForEach(k => _context.HR_TEMPLATEITEM.Remove(k));
}
return(_context.SaveChanges() > 0);
}
}
/// <summary>
/// 根据用户ID获取基因
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <UserGene> GetList(string userID)
{
List <UserGene> list = new List <UserGene>();
if (string.IsNullOrEmpty(userID))
{
return(list);
}
using (DbContext db = new CRDatabase())
{
var entityList = db.Set <HR_USERGENE>().AsNoTracking().Where(o => o.USERID.Equals(userID));
foreach (HR_USERGENE entity in entityList)
{
UserGene userGene = EntityToModel(entity);
userGene.GeneModel = string.IsNullOrEmpty(entity.GENEID) ? null : new GeneService().Get(entity.GENEID);
userGene.Allele1Model = string.IsNullOrEmpty(entity.ALLELE1ID) ? null : new GeneAlleleService().Get(entity.ALLELE1ID);
userGene.Allele2Model = string.IsNullOrEmpty(entity.ALLELE2ID) ? null : new GeneAlleleService().Get(entity.ALLELE2ID);
list.Add(userGene);
}
}
return(list);
}
/// <summary>
/// 修改咨询
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(MyQuestion model, string eventID = "")
{
if (string.IsNullOrEmpty(model.ID))
{
LogService.WriteInfoLog(logTitle, "试图修改为空的MyQuestion实体!");
throw new KeyNotFoundException();
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
if (!string.IsNullOrEmpty(eventID))
{
CTMS_USEREVENT userEvent = db.Set <CTMS_USEREVENT>().Find(eventID);
if (userEvent != null)
{
userEvent.ACTIONSTATUS = "3";
userEvent.ENDTIME = model.EditTime;
db.Entry(userEvent).State = EntityState.Modified;
}
}
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 获取指定权限值的权限列表
/// </summary>
/// <param name="permissionValue">加总后的权限值</param>
/// <returns></returns>
public List <Permission> GetListByValue(int permissionValue)
{
if (permissionValue <= 0)
{
return(new List <Permission>());
}
using (DbContext db = new CRDatabase())
{
Char[] permissionArray = Convert.ToString(permissionValue, 2).ToCharArray();
Array.Reverse(permissionArray);
List <int> permissionValueList = new List <int>();
for (int i = 0; i < permissionArray.Length; i++)
{
if (permissionArray[i] == '0')
{
continue;
}
permissionValueList.Add((int)Math.Pow(2, i));
}
IEnumerable <CTMS_SYS_PERMISSION> query = db.Set <CTMS_SYS_PERMISSION>().AsNoTracking().Where(o => !o.ISDELETED && permissionValueList.Contains(o.PERMISSIONVALUE)).ToList();
List <Permission> list = (from m in query select EntityToModel(m)).ToList();
return(list);
}
}
/// <summary>
/// 购买会员
/// </summary>
/// <param name="userID"></param>
/// <param name="MemberID"></param>
/// <returns></returns>
public bool BuyMember(string userID, string memberID)
{
using (DbContext db = new CRDatabase())
{
DateTime now = DateTime.Now;
DateTime startDate = now.Date;
DateTime endDate = now.Date.AddYears(1).AddDays(-1);
UserInfo userInfo = new UserInfoService().GetUserInfoByID(userID);
MemberModel buyMember = new MemberBLL().GetMember(memberID);
if (userInfo == null || buyMember == null)
{
throw new Exception("错误的用户ID或会员ID");
}
//判断余额
if (userInfo.Account < buyMember.MEMBERPRICE.Value)
{
throw new Exception("余额不足,购买失败!");
}
//判断会员等级
if (userInfo.Member.MEMBERLEVEL.Value >= buyMember.MEMBERLEVEL)
{
throw new Exception("不能购买相同或更低级别的会员!");
}
//1.扣钱+升级会员
CTMS_SYS_USERINFO user = db.Set <CTMS_SYS_USERINFO>().Find(userID);
user.ACCOUNT -= buyMember.MEMBERPRICE.Value;
user.MEMBERID = buyMember.MEMBERID;
user.MEMBERSTARTDATE = startDate;
user.MEMBERENDDATE = endDate;
db.Entry(user).State = EntityState.Modified;
//2.添加商品
List <string> productDescList = new List <string>();
foreach (MemberProducts memberProduct in buyMember.menberProductList)
{
if (!memberProduct.PRODUCTNUMBER.HasValue || Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value) <= 0)
{
continue;
}
for (int i = 0; i < Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value); i++)
{
db.Set <CTMS_MYPRODUCT>().Add(new CTMS_MYPRODUCT()
{
CREATEDATETIME = now,
CREATEUSERID = userInfo.UserId,
CREATEUSERNAME = userInfo.LoginName,
ENDDATE = endDate,
ID = Guid.NewGuid().ToString(),
LOGINNAME = userInfo.LoginName,
PRODUCTID = memberProduct.PRODUCTID,
PRODUCTNUM = 1,
STARTDATE = startDate,
USERID = userInfo.UserId
});
}
var product = db.Set <CTMS_PRODUCTS>().Find(memberProduct.PRODUCTID);
if (product != null)
{
productDescList.Add(string.Format("{0}*{1}", product.PRODUCTNAME, Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value)));
}
}
//3.提示记录
db.Set <CTMS_ACCOUNTRECORD>().Add(new CTMS_ACCOUNTRECORD()
{
ACCOUNT = buyMember.MEMBERPRICE.Value,
ACCOUNTDESCRIPTION = string.Format("购买{0}", buyMember.MEMBERNAME),
BALANCE = -1,
CREATEDATETIME = now,
CREATEUSERID = userInfo.UserId,
CREATEUSERNAME = userInfo.LoginName,
ID = Guid.NewGuid().ToString(),
LOGINNAME = userInfo.LoginName,
PRODUCTID = "",
PRODUCTNAME = string.Format("{0}（包含商品/服务：{1}）", buyMember.MEMBERNAME, string.Join(",", productDescList)),
//PRODUCTNAME = string.Format("{0}", buyMember.MEMBERNAME),
SPENDTYPE = (int)SpendType.Buy,
USERID = userInfo.UserId,
});
return(db.SaveChanges() > 0);
}
}
