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();
}
