public Boolean AddActivity(Activity activity) { CurrentDal.Add(activity); if (!(DbSession.SaveChanges() > 0)) { return(false); } UserEnroll userEnroll = new UserEnroll() { ActivityID = activity.ActivityID, UserInfoID = activity.ActivityManagerID, UserEnrollStart = activity.ActivityEnrollStart, ModfiedOn = DateTime.Now, CreateTime = DateTime.Now, Status = delInvalid, }; DbSession.UserEnrollDal.Add(userEnroll); var org = DbSession.OrganizeInfoDal.GetEntities(u => u.OrganizeInfoID == activity.ActivityApplyOrganizeID).FirstOrDefault(); org.ActivityCount++; DbSession.OrganizeInfoDal.Update(org); if (DbSession.SaveChanges() > 0) { return(true); } else { return(false); } }
//得到用户所具有的全部权限:正常权限+特殊权限 public async Task <List <actionJwt> > getActionByUserId(int id) { //这里是通过角色来得到的权限 var user = await CurrentDal.GetEntities(u => u.id == id).Include(u => u.actions).Include(u => u.roles).ThenInclude(u => u.actions).FirstOrDefaultAsync(); //获取所有去除逻辑删除的角色 var allRoles = (from r in user.roles where r.is_delete == delFlagNormal select r).ToList(); //通过有效角色获取所有去除逻辑删除的权限 var allAction = (from r in allRoles from a in r.actions where a.is_delete == delFlagNormal select a).ToList(); //这里是获取有效的特殊权限 var specialAction = (from r in user.actions where r.is_delete == delFlagNormal select r).ToList(); //合并两个权限 allAction.AddRange(specialAction.AsEnumerable()); //去重 var myAllAction = allAction.Distinct().ToList().Select(u => new actionJwt { id = u.id, action_name = u.action_name, router = u.router, icon = u.icon }).ToList(); return(myAllAction); }
/// <summary> /// 获取角色的菜单集合 /// </summary> /// <param name="UserCode"></param> /// <returns></returns> public List <MenuView> GetData(int RoleCode) { var list = CurrentDal.LoadEntities(a => true).OrderByDescending(a => a.Type).ThenBy(a => a.OrderNumber); //获取数据库所有的菜单(按type降序排列) var rolesList = CurrentDBSession.RoleMenuRelationDal.LoadEntities(a => a.RoleId == RoleCode); //获取该角色的菜单权限 //数据库模型转换成视图模型 List <MenuView> listRes = new List <MenuView>(); foreach (var item in list) { MenuView menu = new MenuView() { id = item.id, pid = item.pid, icon = item.icon, text = item.text, expanded = false, items = new List <MenuView>() }; //设置选中属性 var temp = rolesList.Where(a => a.MenuId == item.id).FirstOrDefault(); if (temp != null) { menu.checkState = temp.CheckState; } listRes.Add(menu); } //把模型嵌套起来 foreach (MenuView item in listRes) { if (item.pid == 0) //当查找到最上层 停止循环 { break; } listRes.Find(a => a.id == item.pid).items.Add(item); } listRes = listRes.Where(a => a.pid == 0).ToList(); //只取最上层的元素 return(listRes); }
//通过 public bool AListUpdatePolical(List <int> ids) { try { foreach (int id in ids) { var user = CurrentDal.GetEntities(u => u.UserInfoID == id).First(); if (user.UpdatePoliticalID != user.PoliticalID) { var duration = DbSession.UserDurationDal.GetEntities(u => u.UserDurationID == user.UserInfoID).FirstOrDefault(); user.PoliticalID = (int)user.UpdatePoliticalID; if (user.PoliticalID == polParty && duration.UserDurationPartyTime == null) { duration.UserDurationPartyTime = DateTime.Now; } else if (user.PoliticalID == polPreparatory && duration.UserDurationPropartyTime == null) { duration.UserDurationPropartyTime = DateTime.Now; } DbSession.UserDurationDal.Update(duration); } } DbSession.SaveChanges(); return(NormalListByULS(ids)); } catch (Exception e) { return(false); } }
/// <summary> /// 获取某人的角色 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public IQueryable <Role> GetOnesRole(string userCode) { var roleIds = CurrentDBSession.UserRoleRelationDal.LoadEntities(a => a.UserCode == userCode).Select(a => a.RoleId);//角色编号 var list = CurrentDal.LoadEntities(a => roleIds.Contains(a.Id)); return(list); }
/// <summary> /// 审核表单 /// </summary> /// <param name="TransferBillId"></param> /// <returns></returns> public string Examine(Guid GiveBillId, string UserName) { string result = ""; GiveBill bill = CurrentDal.LoadEntities(a => a.Id == GiveBillId).FirstOrDefault(); List <Record> list = bill.Record.ToList(); foreach (Record item in list) { InWarehouse inWarehouse = CurrentDBSession.InWarehouseDal.LoadEntities(i => i.ItemCode == item.ItemCode && i.ItemLocationId == item.ItemLocationId && i.ItemBatch == item.ItemBatch).FirstOrDefault(); if (inWarehouse == null || inWarehouse.Count < item.Count)//如果没有库存 新建一条记录 { result = "物料编号:" + item.ItemCode + "物料名称:" + item.ItemName + "库存不足,弃审失败"; return(result); } else if (inWarehouse.Count == item.Count) // 库存正好相等 删除这条记录 { CurrentDBSession.InWarehouseDal.DeleteEntity(inWarehouse); item.State = 2; } else if (inWarehouse.Count > item.Count)//库存大于记录 相减 { inWarehouse.Count = inWarehouse.Count - item.Count; CurrentDBSession.InWarehouseDal.EditEntity(inWarehouse); item.State = 2; } } bill.BillState = 2; //改成已审核状态 bill.ExaminePerson = UserName; //审核人 bill.ExamineDate = DateTime.Now; CurrentDal.EditEntity(bill); result = CurrentDBSession.SaveChanges() ? "审核成功!" : "审核失败!"; return(result); }
private ReturnMessageModel CheckPassword(string userName, string password) { var returnMessageModel = new ReturnMessageModel(); var userList = CurrentDal.GetEntitiesByKey(m => m.UserName == userName).ToList(); if (userList.Count == 0) { returnMessageModel.Code = ReturnMessageCode.Fail; returnMessageModel.Message = "用户名不存在"; } else if (userList.Count > 1) { returnMessageModel.Code = ReturnMessageCode.SystemError; returnMessageModel.Message = "用户名太多"; } else { if (userList[0].Password == password) { returnMessageModel.Code = ReturnMessageCode.Success; returnMessageModel.Message = "登陆成功"; //Session["loginUser"] = } else { returnMessageModel.Code = ReturnMessageCode.Fail; returnMessageModel.Message = "密码错误"; } } return(returnMessageModel); }
public IQueryable <Chronic_disease_Comm_Testing_Faeces> LoadSearchEntities(Model.SearchParam.CommonParam parms) { var temp = CurrentDal.LoadEntityAsNoTracking(t => true); if (!string.IsNullOrEmpty(parms.idCard)) { //身份证号不为空的情况下:只要输入身份证号,其他条件一律过滤掉,只以身份证号为准 temp = temp.Where(t => t.id_card_number == parms.idCard).OrderBy(t => t.create_time); } else { temp = temp.Where(t => t.community_code.StartsWith(parms.region_code) && t.type.Contains("Therioma")); if (!string.IsNullOrEmpty(parms.name)) { temp = temp.Where(t => t.names.Contains(parms.name)); } if (!string.IsNullOrEmpty(parms.sex)) { temp = temp.Where(t => t.sex == parms.sex); } if (!string.IsNullOrEmpty(parms.txtBirthDateBegin) && !string.IsNullOrEmpty(parms.txtBirthDateEnd)) { DateTime birthDateBegin = Convert.ToDateTime(parms.txtBirthDateBegin); DateTime birthDateEnd = Convert.ToDateTime(parms.txtBirthDateEnd); temp = temp.Where(t => (birthDateBegin <= t.birth_date) && (birthDateEnd >= t.birth_date)); } if (!string.IsNullOrEmpty(parms.address)) { temp = temp.Where(t => t.address.Contains(parms.address)); } temp = temp.OrderByDescending(t => t.create_time); } parms.TotalCount = temp.Count(); return(temp.Skip((parms.PageIndex - 1) * parms.PageSize).Take(parms.PageSize)); }
public List <MailInfo> GetAllDraftMail(int userInfoId, string query) { /* UserInfo userInfo = CurrentDBSession.UserInfoDal.LoadEntites(u => u.ID == userInfoId).FirstOrDefault(); * return userInfo.MailInfo.Where(m=>m.IsDraft==true).OrderByDescending(m=>m.CreateTime).ToList(); */ return(CurrentDal.LoadEntites(m => m.SenderId == userInfoId && m.IsDraft == true && m.Title.Contains(query)).ToList()); }
/// <summary> /// 审核表单 /// </summary> /// <param name="TransferBillId"></param> /// <returns></returns> public string Examine(Guid BackInputId, string UserName) { string result = ""; BackInput bill = CurrentDal.LoadEntities(a => a.Id == BackInputId).FirstOrDefault(); List <Record> list = bill.Record.ToList(); foreach (Record item in list) { item.State = 2; item.ExamineDate = DateTime.Now; InWarehouse inWarehouse = CurrentDBSession.InWarehouseDal.LoadEntities(i => i.ItemCode == item.ItemCode && i.ItemLocationId == item.ItemLocationId && i.ItemBatch == item.ItemBatch).FirstOrDefault(); if (inWarehouse == null || inWarehouse.Count < item.Count) //当前库存不够 ,不允许做弃审操作 { result = "物料编号:" + item.ItemCode + "物料名称:" + item.ItemName + "库存不足,审核失败"; return(result); } else if (inWarehouse.Count == item.Count) { CurrentDBSession.InWarehouseDal.DeleteEntity(inWarehouse); } else //有库存 { inWarehouse.Count -= item.Count; CurrentDBSession.InWarehouseDal.EditEntity(inWarehouse); } } bill.BillState = 2; //改成已审核状态 bill.ExaminePerson = UserName; //审核人 bill.ExamineDate = DateTime.Now; CurrentDal.EditEntity(bill); result = CurrentDBSession.SaveChanges() ? "审核成功!" : "审核失败!"; return(result); }
/// <summary> /// 获取某人有权限的菜单 只两层 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public List <MenuViewForMainPage> GetOnesMenu(string userCode) { var RoleIds = CurrentDBSession.UserRoleRelationDal.LoadEntities(a => a.UserCode == userCode).Select(a => a.RoleId); //权限ID集合 var MenuIds = CurrentDBSession.RoleMenuRelationDal.LoadEntities(a => RoleIds.Contains(a.RoleId)).Select(a => a.MenuId); //菜单ID集合 var list = CurrentDal.LoadEntities(a => MenuIds.Contains(a.id) && a.Type == 1).OrderBy(a => a.OrderNumber); //外层菜单 var list1 = CurrentDal.LoadEntities(a => MenuIds.Contains(a.id) && a.Type == 2).OrderBy(a => a.OrderNumber); //内层菜单 //转换外层菜单 List <MenuViewForMainPage> listRes = new List <MenuViewForMainPage>(); foreach (var item in list) { MenuViewForMainPage menu = new MenuViewForMainPage() { Id = item.id, pid = item.pid, text = item.text, Url = item.Url, nodes = new List <MenuViewForMainPage>() }; listRes.Add(menu); } //转换内层菜单 List <MenuViewForMainPage> listRes1 = new List <MenuViewForMainPage>(); foreach (var item in list1) { MenuViewForMainPage menu = new MenuViewForMainPage() { Id = item.id, pid = item.pid, text = item.text, Url = item.Url, nodes = null }; listRes1.Add(menu); } //把模型嵌套起来 foreach (MenuViewForMainPage item in listRes1) { listRes.Find(a => a.Id == item.pid).nodes.Add(item); } return(listRes.ToList()); }
/// <summary> /// 实现多条件查询 /// </summary> /// <param name="userQueryParam">查询参数</param> /// <returns></returns> public IQueryable <UserInfo> LoadPageData(UserQueryParam userQueryParam) { short noDel = (short)Model.Enum.DelFlagEnum.NoDel; //查询出所有没有删除的数据 var temp = CurrentDal.GetEntity(u => u.DelFlag == noDel); //判断查询名字是否为空 if (!string.IsNullOrEmpty(userQueryParam.SearchName)) { temp = temp.Where(u => u.Name.Contains(userQueryParam.SearchName)); } //在此处拼接多个条件 返回temp 可以写多个if 获取参数 //查询到数据总条数 var pageSize = userQueryParam.PageSize; var pageIndex = userQueryParam.PageIndex - 1; //分页 记得先排序 var userInfos = temp.OrderBy(u => u.ID) .Skip(pageSize * pageIndex) .Take(pageSize); userQueryParam.Total = temp.Count(); return(userInfos); }
/// <summary> /// 生成单号 /// </summary> /// <returns></returns> public string GetBillCode(string head) { string res = ""; try { string temp = DateTime.Now.ToString("yyyyMM"); //六位年月 temp = head + temp; int totalCount; //没用 string flowid; var lastbill = CurrentDal.LoadPageEntities(a => a.BillCode.Substring(0, 8) == temp, a => a.BillCode, 1, 1, false, out totalCount).FirstOrDefault(); if (lastbill == null) { flowid = "00001"; } else { flowid = string.Format("{0:00000}", (Convert.ToInt32(lastbill.BillCode.Substring(8, 5)) + 1)); } res = temp + flowid; } catch { res = "no"; } return(res); }
/// <summary> /// 获取最新公告信息 /// 最多4条 /// </summary> /// <returns></returns> public IEnumerable <NewSysNewsModel> GetNewSysNews() { // 最新公告 4条 return(CurrentDal.GetEntities(p => true).OrderByDescending(p => p.Id).Take(4).ToList().Select(p => new NewSysNewsModel { Id = p.Id, Title = p.Title, Content = p.Content.GetFirst(22), CreateTime = p.CreateTime })); }
//分页 多条件搜索 public IQueryable <Chronic_disease_SmokeAndDrink> LoadSearchEntities(Model.SearchParam.CommonParam commonParam) { var temp = CurrentDal.LoadEntityAsNoTracking(t => true); if (!string.IsNullOrEmpty(commonParam.idCard)) { //身份证号不为空的情况下:只要输入身份证号,其他条件一律过滤掉,只以身份证号为准 temp = temp.Where(t => t.id_card_number == commonParam.idCard).OrderByDescending(t => t.create_time); } else { temp = temp.Where(t => t.community_code.StartsWith(commonParam.region_code)); if (!string.IsNullOrEmpty(commonParam.name)) { temp = temp.Where(t => t.name.Contains(commonParam.name)); } if (!string.IsNullOrEmpty(commonParam.sex)) { temp = temp.Where(t => t.sex == commonParam.sex); } if (!string.IsNullOrEmpty(commonParam.txtBirthDateBegin) && !string.IsNullOrEmpty(commonParam.txtBirthDateEnd)) { DateTime birthDateBegin = Convert.ToDateTime(commonParam.txtBirthDateBegin); DateTime birthDateEnd = Convert.ToDateTime(commonParam.txtBirthDateEnd); temp = temp.Where(t => birthDateBegin <= t.birth_date && birthDateEnd >= t.birth_date); } if (!string.IsNullOrEmpty(commonParam.address)) { temp = temp.Where(t => t.permanent_address.Contains(commonParam.address)); } temp = temp.OrderByDescending(t => t.create_time); } commonParam.TotalCount = temp.Count(); return(temp.Skip((commonParam.PageIndex - 1) * commonParam.PageSize).Take(commonParam.PageSize)); }
public IQueryable <T> GetPageEntities <S>(int pageSize, int pageIndex, out int total, Expression <Func <T, bool> > whereLambda, Expression <Func <T, S> > orderByLambda, bool isAsc) { return(CurrentDal.GetPageEntities(pageSize, pageIndex, out total, whereLambda, orderByLambda, isAsc)); }
/// <summary> /// 审核表单 /// </summary> /// <param name="TransferBillId"></param> /// <returns></returns> public string Examine(Guid OtherInputId, string UserName) { OtherInput bill = CurrentDal.LoadEntities(a => a.Id == OtherInputId).FirstOrDefault(); List <Record> list = bill.Record.ToList(); List <InWarehouse> listAdd = new List <InWarehouse>();//新增列表 foreach (Record item in list) { item.State = 2; item.ExamineDate = DateTime.Now; InWarehouse inWarehouse = CurrentDBSession.InWarehouseDal.LoadEntities(i => i.ItemCode == item.ItemCode && i.ItemLocationId == item.ItemLocationId && i.ItemBatch == item.ItemBatch).FirstOrDefault(); //查暂存 InWarehouse temp = listAdd.Where(p => p.ItemCode == item.ItemCode && p.ItemLocationId == item.ItemLocationId && p.ItemBatch == item.ItemBatch).FirstOrDefault(); if (inWarehouse == null && temp == null)//如果都没有库存 新建一条记录 { inWarehouse = new InWarehouse() { Id = Guid.NewGuid(), ItemBatch = item.ItemBatch, ItemCode = item.ItemCode, ItemLine = item.ItemLine, ItemLocation = item.ItemLocation, ItemLocationId = item.ItemLocationId, Warehouse = item.Warehouse, WarehouseId = item.WarehouseId, ItemName = item.ItemName, ItemSpecifications = item.ItemSpecifications, ItemUnit = item.ItemUnit, Count = item.Count, Company = bill.Company, CompanyId = bill.CompanyId, Department = bill.Department, DepartmentId = bill.DepartmentId }; item.CurrentCount = item.Count; listAdd.Add(inWarehouse); //添加到暂存区 } else if (inWarehouse == null && temp != null) //只有暂存区有库存 { temp.Count += item.Count; item.CurrentCount = temp.Count; } else //数据库有库存 { inWarehouse.Count += item.Count; CurrentDBSession.InWarehouseDal.EditEntity(inWarehouse); item.CurrentCount = inWarehouse.Count; } } //最后添加新增列表中数据 foreach (var item in listAdd) { CurrentDBSession.InWarehouseDal.AddEntity(item); } bill.BillState = 2; //改成已审核状态 bill.ExaminePerson = UserName; //审核人 bill.ExamineDate = DateTime.Now; CurrentDal.EditEntity(bill); return(CurrentDBSession.SaveChanges() ? "操作成功" : "操作失败"); }
public T Add(T entity) { //return DbSession.OrderInfoDal.Add(); CurrentDal.Add(entity); DbSession.SaveChanges(); return(entity); }
/// <summary> /// 获取统计行 /// </summary> /// <returns></returns> public List <TBL_ZDCQ_ZFHBBT> GetTotalEntitis(decimal?year) { List <TBL_ZDCQ_ZFHBBT> list = new List <TBL_ZDCQ_ZFHBBT>(); if (year == null) { return(list); } TBL_ZDCQ_ZFHBBT entity = new TBL_ZDCQ_ZFHBBT(); var entitis = CurrentDal.LoadEntities(t => t.YEAR == year); entity.XMMC = "合计"; entity.HS = entitis.Sum(t => t.HS); entity.NYRK = entitis.Sum(t => t.NYRK); entity.DSZN = entitis.Sum(t => t.DSZN); entity.FNYRK = entitis.Sum(t => t.FNYRK); entity.XJ = entitis.Sum(t => t.XJ); entity.ZXCZ1 = entitis.Sum(t => t.ZXCZ1); entity.ZXCZ2 = entitis.Sum(t => t.ZXCZ2); entity.ZXCZ3 = entitis.Sum(t => t.ZXCZ3); entity.CJTCZ = entitis.Sum(t => t.CJTCZ); entity.LJTCZ = entitis.Sum(t => t.LJTCZ); entity.CQZXCZ = entitis.Sum(t => t.CQZXCZ); entity.SGGJCZ = entitis.Sum(t => t.SGGJCZ); entity.XZGYYCZ = entitis.Sum(t => t.XZGYYCZ); entity.KGCGWHCZ = entitis.Sum(t => t.KGCGWHCZ); entity.ZDGCJ = entitis.Sum(t => t.ZDGCJ); entity.SLJ = entitis.Sum(t => t.SLJ); entity.HHZBQ = entitis.Sum(t => t.HHZBQ); entity.HJT = entitis.Sum(t => t.HJT); entity.GTJCZ = entitis.Sum(t => t.GTJCZ); entity.HJJE = entitis.Sum(t => t.HJJE); list.Add(entity); return(list); }
/// <summary> /// 创建投票选项 /// </summary> /// <param name="voteOption">投票选项</param> /// <param name="user">当前用户</param> /// <param name="vote">当前投票</param> /// <param name="message">处理结果信息</param> /// <returns></returns> public QssResult QssCreateVoteOption(JArray options, User user, Vote vote, out string message) { List <VoteOption> entities = new List <VoteOption>(); foreach (JObject item in options) { entities.Add(new VoteOption() { Content = (string)item["Content"], Vote = vote }); } try { CurrentDal.AddRange(entities); DbSession.SaveChanges(); message = "保存投票选项成功!"; return(QssResult.Success); } catch (Exception exception) { message = "保存投票选项失败!"; QssLogHelper.Log("保存投票选项失败", $"在保存投票: {vote.Title} 时失败! 原因:{exception.Message}", QssLogType.Error, exception, $"{user.Account}({user.Name})"); throw; } }
//another way to set field in base class , no test---------- //public UserInfoBll() //{ // base.CurrentDal = DbSessionFactory.GetDbSession().UserInfoDal; //} //---------------------------------------------------------- public IQueryable <UserInfo> GetSearchIndex <S>(UserQueryParam qm, Expression <Func <UserInfo, S> > orderByLambada, out int totalCount) { IQueryable <UserInfo> users = CurrentDal.GetEntities(u => true); if (qm.ID != 0) { users = users.Where(u => u.ID == qm.ID); } if (!string.IsNullOrEmpty(qm.UName)) { users = users.Where(u => u.UName.Contains(qm.UName)); } if (!string.IsNullOrEmpty(qm.ShowName)) { users = users.Where(u => u.ShowName.Contains(qm.ShowName)); } if (!string.IsNullOrEmpty(qm.Remark)) { users = users.Where(u => u.Remark.Contains(qm.Remark)); } if (qm.TimeAfter != DateTime.MinValue) { users = users.Where(u => DateTime.Compare(u.SubTime, qm.TimeAfter) > 0); } if (qm.TimeBefore != DateTime.MinValue) { users = users.Where(u => DateTime.Compare(qm.TimeBefore, u.SubTime) > 0); } totalCount = users.Count(); users = users.OrderBy(orderByLambada).Skip(qm.pageIndex * qm.pageCount).Take(qm.pageCount); return(users); }
/// <summary> /// 删除过期用户 在定时任务中调用 /// </summary> public void DeleteExpireUser() { // 过期用户 var expUsers = CurrentDal.GetEntities(p => p.Grade + p.LoSch < DateTime.Now.Year); if (expUsers.Count() == 0) { return; } // 相关填写记录 var userIds = expUsers.Select(x => x.Id); var wtLogs = DbSession.WtLogDal.GetEntities(p => userIds.Contains(p.User.Id)); try { DbSession.WtLogDal.DeleteRange(wtLogs); DbSession.SaveChanges(); } catch (Exception exception) { QssLogHelper.Log("批量删除填写记录失败", "在批量删除过期用户时,批量删除填写记录失败! 原因:" + exception.Message, QssLogType.Error, exception); } try { CurrentDal.DeleteRange(expUsers); DbSession.SaveChanges(); } catch (Exception exception) { QssLogHelper.Log("批量删除过期用户失败", "在批量删除过期用户时,批量删除用户失败! 原因:" + exception.Message, QssLogType.Error, exception); } }
/// <summary> /// 保存导入的数据(仅限LH.武汉站) /// </summary> /// <param name="bill"></param> /// <returns></returns> public string SaveImport(GiveBill bill) { try { //查询数据库中有没有重复项 if (CurrentDal.LoadEntities(a => a.LBBillCode == bill.LBBillCode).Count() > 0) { return(bill.LBBillCode + "导入失败!客户单号重复!\r\n"); } ; //主表 bill.Id = Guid.NewGuid(); //生成一个id bill.BillCode = GetBillCode("JH"); //生成单号 if (bill.BillCode == "no") { bill.BillCode = GetBillCode("JH"); //再次生成单号 } bill.BillState = 1; //保存状态 bill.CreateDate = DateTime.Now; bill.MakePerson = HttpContext.Current.Session["UserName"].ToString(); bill.LoadGoodsType = "武汉-配送客户出库装货"; bill.BackLoadGoodsType = "武汉-客户现场卸货"; bill.OutputType = "配送交货出库"; bill.OutputTypeId = 20; bill.BusinessType = "武汉-二次配送"; bill.Department = "LH.武汉站"; bill.DepartmentId = "LH7011"; bill.Company = "联合运输"; bill.CompanyId = "LH0000"; bill.Remark = "批量导入"; //子表 foreach (var item in bill.Record)//生成子表id { item.Id = Guid.NewGuid(); item.Department = bill.Department; item.DepartmentId = bill.DepartmentId; item.State = bill.BillState; item.CreateDate = bill.CreateDate; item.InOrOut = 0; item.MainTableType = "GiveBill"; item.InOutTypeId = bill.OutputTypeId; item.InOutTypeName = bill.OutputType; var goodItem = CurrentDBSession.GoodItemDal.LoadEntities(a => a.ItemCode == item.ItemCode).FirstOrDefault(); item.ItemLine = goodItem.ItemLine; item.ItemName = goodItem.ItemName; item.ItemSpecifications = goodItem.ItemSpecifications; item.ItemUnit = goodItem.ItemUnit; item.UnitWeight = goodItem.UnitWeight; item.Remark = bill.Remark; } CurrentDal.AddEntity(bill); return(CurrentDBSession.SaveChanges() ? "" : bill.LBBillCode + "导入失败!\r\n"); } catch (Exception) { return(bill.LBBillCode + "导入失败!\r\n"); } }
public int DeleteList(List <int> ids) { foreach (var id in ids) { CurrentDal.Detete(id); } return(DbSession.SaveChanges());//这里把SaveChanges方法提到了循环体外,自然就与数据库交互一次 }
public int DeleteListLogical(List <int> ids) { foreach (var id in ids) { CurrentDal.DeleteLogical(id); } return(DbSession.SaveChanges()); }
public bool Delete(List <string> ids) { foreach (var id in ids) { CurrentDal.Delete(id); } return(DbSession.SaveChanges() > 0); }
public bool Update(List <T> entities) { foreach (var entity in entities) { CurrentDal.Update(entity); } return(DbSession.SaveChanges() > 0); }
public int deleteList(List <int> ids) { foreach (var id in ids) { CurrentDal.Delete(id); } return(DbSession.Savechanges()); }
public int DeleteList(List <int> ids) { foreach (var id in ids) { CurrentDal.delete(id); } return(dbsession.SaveChanges()); }
public List <MailInfo> GetAllDraftMail(int userId) { // UserInfo userInfo = CurrentDBSession.UserInfoDal.LoadEntites(u => u.ID == userId).FirstOrDefault(); return(CurrentDal.LoadEntites(m => m.SenderId == userId && m.IsDraft == true).ToList()); // return userInfo.MailInfo.Where(m=>m.IsDraft==true).OrderByDescending(m=>m.CreateTime).ToList(); }