/// <summary>
/// 添加用药情况
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddDrugUse(DrugUse model)
{
context.CR_DRUGUSE.Add(ModelToEntity(model));
if (model.InterEffect.Any())
{
foreach (var drugEffect2 in model.InterEffect)
{
var item = ModelToEntity(drugEffect2);
item.DISEASEID = model.DISEASEID;
item.DRUGID = model.DRUGID;
context.CR_DRUGEFFECT.Add(item);
}
}
if (model.GeneEffect.Any())
{
foreach (var drugGeneInfo in model.GeneEffect)
{
var item = ModelToEntity(drugGeneInfo);
item.DISEASEID = model.DISEASEID;
item.DRUGID = model.DRUGID;
context.CR_GENEEFFECT.Add(item);
}
}
return(context.SaveChanges() > 0);
}
/// <summary>
/// 新增账单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(AccountRecord model)
{
if (model == null)
{
return(string.Empty);
}
if (string.IsNullOrEmpty(model.AccountDescription))
{
model.AccountDescription = string.Format("{0}{1}", model.SpendTypeText, model.ProductName);
}
using (DbContext db = new CRDatabase())
{
CTMS_SYS_USERINFO user = db.Set <CTMS_SYS_USERINFO>().Find(model.UserID);
if (model.Balance == -1 && model.Account > user.ACCOUNT)
{
throw new Exception("余额不足！");
}
user.ACCOUNT += model.Balance * model.Account;
db.Entry(user).State = EntityState.Modified;
//Todo 对应服务次数加1
db.Set <CTMS_ACCOUNTRECORD>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 添加值设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaseResult AddItemStandVal(ItemStandVal model)
{
BaseResult br = new BaseResult()
{
Succeeded = true
};
using (CRDatabase _context = new CRDatabase())
{
bool flag = !_context.HR_ITEMSTANDVAL.Any(p => p.ITEMNO == model.ITEMNO && p.ISDELETED == "0");
if (flag)
{
try
{
_context.HR_ITEMSTANDVAL.Add(ModelToEntity(model));
_context.SaveChanges();
}
catch (Exception e)
{
br.Succeeded = false;
br.Error = e.Message.ToString();
throw;
}
}
else
{
br.Succeeded = false;
br.Error = "该项已添加标准值返回，请检查";
}
}
return(br);
}
/// <summary>
/// 更新GuideLineFlow
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditGuideLineFlow(GuideLineFlow model)
{
using (CRDatabase _context = new CRDatabase())
{
var entity = _context.CTMS_GUIDELINEFLOW.FirstOrDefault(p => p.ID == model.ID);
if (entity != null)
{
//1.将原先流程状态设置成删除
entity.ISDELETED = true;
GuideLineFlow addModel = new GuideLineFlow();
addModel.ID = Guid.NewGuid().ToString();
addModel.GUIDELINENAME = entity.GUIDELINENAME;
addModel.GUIDELINEINFO = model.GUIDELINEINFO;
addModel.CreateUserID = model.CreateUserID;
addModel.CreateDateTime = model.CreateDateTime;
addModel.EditTime = model.EditTime;
addModel.EditUserID = model.EditUserID;
addModel.IsDeleted = false;
addModel.OwnerID = model.OwnerID;
_context.CTMS_GUIDELINEFLOW.Add(ModelToEntity(addModel));
return(_context.SaveChanges() > 0);
}
return(false);
}
}
/// <summary>
/// 新增咨询
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(MyQuestion model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_MYQUESTION>().Add(ModelToEntity(model));
//待办
db.Set <CTMS_USEREVENT>().Add(new CTMS_USEREVENT()
{
EVENTID = Guid.NewGuid().ToString(),
USERAPPLYID = "",
ACTIONTYPE = "1",
ACTIONINFO = string.Format("您收到了{0}的咨询，请回复", model.LoginName),
RECEIPTTIME = model.CreateDateTime,
ACTIONSTATUS = "1",
FROMUSER = model.UserID,
TOUSER = model.ObjectUserID,
CREATETIME = model.CreateDateTime,
MODELID = model.ID,
LINKURL = "MyQuestion"
});
db.SaveChanges();
return(model.ID);
}
}
/// <summary>
/// 更新会员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMemberList(MemberModel model)
{
using (var context = new CRDatabase())
{
var entity = context.CTMS_MEMBER.FirstOrDefault(p => p.MEMBERID == model.MEMBERID);
if (entity != null)
{
//1.更新主表字段
entity.MEMBERNAME = model.MEMBERNAME;
entity.MEMBERDESCRIPT = model.MEMBERDESCRIPT;
entity.MEMBERLEVEL = model.MEMBERLEVEL;
entity.MEMBERPRICE = model.MEMBERPRICE;
//2.删除原先服务
context.CTMS_MEMBERPRODUCTS.Where(p => p.MEMBERID == model.MEMBERID).ToList().ForEach(k => context.CTMS_MEMBERPRODUCTS.Remove(k));
//3.新增服务
foreach (var item in model.menberProductList)
{
item.MEMBERID = model.MEMBERID;
context.CTMS_MEMBERPRODUCTS.Add(ModelToEntity(item));
}
}
return(context.SaveChanges() > 0);
}
}
public BaseResult DeleteItemStandVal(string id)
{
BaseResult br = new BaseResult()
{
Succeeded = true
};
using (CRDatabase _context = new CRDatabase())
{
var entity = _context.HR_ITEMSTANDVAL.FirstOrDefault(p => p.ID == id);
if (entity != null)
{
entity.ISDELETED = "1";
try
{
_context.Entry(entity).State = EntityState.Modified;
_context.SaveChanges();
}
catch (Exception e)
{
br.Succeeded = false;
br.Error = e.Message.ToString();
}
}
}
return(br);
}
/// <summary>
/// 更新值设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaseResult UpdateItemStandVal(ItemStandVal model)
{
BaseResult br = new BaseResult()
{
Succeeded = true
};
try
{
using (CRDatabase _context = new CRDatabase())
{
var entity = _context.HR_ITEMSTANDVAL.FirstOrDefault(p => p.ID == model.ID);
if (entity != null)
{
entity.NAMEENG = model.NAMEENG;
entity.EDITDATETIME = model.EDITDATETIME;
entity.EDITUSERID = model.EDITUSERID;
entity.MINVALUE = model.MINVALUE;
entity.ITEMMAXVALUE = model.MAXVALUE;
entity.UNIT = model.UNIT;
_context.Entry(entity).State = EntityState.Modified;
_context.SaveChanges();
//_context.Entry(ModelToEntity(model)).State = EntityState.Modified;
//_context.SaveChanges();
}
}
}
catch (Exception e)
{
br.Succeeded = false;
br.Error = e.Message.ToString();
}
return(br);
}
/// <summary>
/// 修改用户角色
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateUserRole(string userid, List <Role> roleList)
{
if (string.IsNullOrEmpty(userid) || roleList == null)
{
LogService.WriteInfoLog(logTitle, "用户ID或实体列表为空!");
return(false);
}
using (DbContext db = new CRDatabase())
{
List <CTMS_SYS_USERROLE> preUserRoleList = db.Set <CTMS_SYS_USERROLE>().Where(o => !o.ISDELETED && o.USERID.Equals(userid)).ToList();
List <string> preRoleIDList = preUserRoleList.Select(p => p.ROLEID).ToList();
List <string> afterRoleIDList = roleList.Select(o => o.RoleID).ToList();
foreach (CTMS_SYS_USERROLE entity in preUserRoleList)
{
entity.ISDELETED = (preUserRoleList.Find(o => afterRoleIDList.Contains(entity.ROLEID)) == null);
db.Entry(entity).State = EntityState.Modified;
}
foreach (string roleID in afterRoleIDList.Where(o => !preRoleIDList.Contains(o)))
{
db.Set <CTMS_SYS_USERROLE>().Add(new CTMS_SYS_USERROLE()
{
USERROLEID = Guid.NewGuid().ToString(), ROLEID = roleID, USERID = userid
});
}
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 添加GuideLineFlow
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddGuideLineFlow(GuideLineFlow model)
{
using (CRDatabase _context = new CRDatabase())
{
_context.CTMS_GUIDELINEFLOW.Add(ModelToEntity(model));
return(_context.SaveChanges() > 0);
}
}
/// <summary>
/// 添加用户待办信息
/// </summary>
public void AddUserEvent(UserEvent model)
{
using (var context = new CRDatabase())
{
context.CTMS_USEREVENT.Add(ModelToEntity(model));
context.SaveChanges();
}
}
/// <summary>
/// 删除角色功能权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DeleteById(string id)
{
using (DbContext db = new CRDatabase())
{
var entity = db.Set <CTMS_SYS_ROLEFUNCTION>().Find(id);
if (entity != null)
{
db.Set <CTMS_SYS_ROLEFUNCTION>().Remove(entity);
}
return(db.SaveChanges() > 0);
}
}
/// <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 bool Edit(MenuInfo model)
{
if (string.IsNullOrEmpty(model.ID))
{
LogService.WriteInfoLog("访问MenuInfoBLL类", "试图修改为空的Function实体!");
throw new KeyNotFoundException();
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <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 bool Edit(UserGene model)
{
if (model == null)
{
LogService.WriteInfoLog(logTitle, "试图修改为空的UserGene实体!");
return(false);
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 新增随访方案
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(QATestSolution model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_QA_TESTSOLUTION>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.SolutionID);
}
}
/// <summary>
/// 修改随访方案
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(QATestSolution model)
{
if (string.IsNullOrEmpty(model.SolutionID))
{
LogService.WriteInfoLog(logTitle, "试图修改为空的QATestSolution实体!");
throw new KeyNotFoundException();
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 修改元数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(MetaData model)
{
if (model == null || model.ID <= 0)
{
LogService.WriteInfoLog(logTitle, "试图修改为空的MetaData实体!");
throw new KeyNotFoundException();
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <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>
/// 新增元数据
/// </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 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>
/// 保存父类parentid
/// </summary>
/// <param name="id"></param>
/// <param name="parentList"></param>
/// <returns></returns>
public bool SaveParentGuideLine(string id, List <ParentGuideLine> parentList)
{
using (var context = new CRDatabase())
{
context.CTMS_PARENTGUIDELINE.Where(p => p.GUIDELINEID == id)
.ForEachAsync(k => context.CTMS_PARENTGUIDELINE.Remove(k));
parentList.ForEach(p => p.GuideLineId = id);
parentList.ForEach(p => context.CTMS_PARENTGUIDELINE.Add(ModelToEntity(p)));
return(context.SaveChanges() > 0);
}
}
/// <summary>
/// 删除会员
/// </summary>
/// <param name="memberId"></param>
/// <returns></returns>
public bool DeleteMember(string memberId)
{
using (var context = new CRDatabase())
{
var entity = context.Set <CTMS_MEMBER>().Find(memberId);
if (entity != null)
{
context.Set <CTMS_MEMBER>().Remove(entity);
context.CTMS_MEMBERPRODUCTS.Where(p => p.MEMBERID == memberId).ToList().ForEach(k => context.CTMS_MEMBERPRODUCTS.Remove(k));
}
return(context.SaveChanges() > 0);
}
}
public bool CloseApply(string applyId)
{
using (var context = new CRDatabase())
{
var entity = context.CTMS_USERAPPLY.FirstOrDefault(p => p.ID == applyId);
if (entity == null)
{
return(false);
}
entity.STATUS = "3";
return(context.SaveChanges() > 0);
}
}
/// <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>
/// 将上面一条设置成已完成
/// </summary>
/// <param name="eventId"></param>
/// <returns>更新结果</returns>
public bool CloseEvent(string eventId)
{
using (var context = new CRDatabase())
{
var entity = context.CTMS_USEREVENT.FirstOrDefault(p => p.EVENTID == eventId);
if (entity == null)
{
return(false);
}
entity.ACTIONSTATUS = ((int)ActionStatus.Complete).ToString();
entity.ENDTIME = System.DateTime.Now;
return(context.SaveChanges() > 0);
}
}
/// <summary>
/// 添加用户待办信息
/// </summary>
public void AddUserEvent(UserEvent model, UserType userType)
{
using (var context = new CRDatabase())
{
//1.根据UserTypetype找到人
var toUserId = context.CTMS_SYS_USERINFO.FirstOrDefault(p => p.USERTYPE == (decimal)userType);
//2.将事件类型ActionInfo插入表中
model.ToUser = toUserId.USERID;
context.CTMS_USEREVENT.Add(ModelToEntity(model));
context.SaveChanges();
}
}
/// <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>
/// 删除单个GuideLine对象
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteGuideLineFlow(string id)
{
if (string.IsNullOrEmpty(id))
{
return(false);
}
using (CRDatabase _context = new CRDatabase())
{
var entity = _context.CTMS_GUIDELINEFLOW.Find(id);
if (entity != null)
{
_context.CTMS_GUIDELINEFLOW.Remove(entity);
}
return(_context.SaveChanges() > 0);
}
}
