/// <summary>
/// 根据状态获取
/// </summary>
/// <param name="skip"></param>
/// <param name="take"></param>
/// <param name="status"></param>
/// <returns></returns>
public ListResult <CgJiLuDto> GetCgJiLuByStatus(int skip, int take, int status)
{
ListResult <CgJiLuDto> listResult = new ListResult <CgJiLuDto>();
var currentUser = _fapContext.CurrentUser;
var bumen = OrgHelper.GetBuMenId(currentUser);
try
{
var query = _dbContext.CgJiLu.Where(x => x.Status != -1);
//状态2为部门审核；3为科研处审核。
if (status == 2)
{
query = query.Where(x => x.Status == status && x.BumenId == bumen).OrderByDescending(x => x.CreateDate);
}
else if (status == 3)
{
query = query.Where(x => x.Status == status).OrderByDescending(x => x.CreateDate);
}
else if (status == 1)
{
query = query.Where(x => x.Status == 1 && x.BumenId == bumen).OrderByDescending(x => x.CreateDate);
}
// var query = _dbContext.CgJiLu.Where(x=>x.Status == status).OrderByDescending(x => x.CreateDate).Skip(skip).Take(take);
listResult.Results = _mapper.Map <List <CgJiLuDto> >(query.Skip(skip).Take(take).ToList());
listResult.TotalRows = query.Count();
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
listResult.Error = new Error("系统未知错误");
}
return(listResult);
}
public void constructor_WithDBContext_HasDBContext()
{
using (var db = new EnouFlowOrgMgmtContext())
{
OrgHelper o = new OrgHelper(db);
Assert.IsNotNull(o._dbContext);
}
}
public void isObjectExists_invalidId_returnFalse(int id)
{
OrgHelper o = new OrgHelper(db);
var bResult = o.isObjectExists(id);
Assert.False(bResult);
}
public void removeObject_validId_willSetVisibleToFalse()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
var bResult = o.removeObject(org.orgId);
Assert.False(org.isVisible);
}
public void isObjectExists_validId_returnTrue()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
var bResult = o.isObjectExists(org.orgId);
Assert.True(bResult);
}
public void isObjectChangeAllowed_changedGuidObject_ThrowsException()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
org.guid = new Guid().ToString();
Assert.Throws <GuidNotAllowedToChangeException>(() => o.isObjectChangeAllowed(org.orgId, org));
}
public void convert2DTO_withOrgObject_returnDTOObject()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
var dto = o.convert2DTO(org);
Assert.IsInstanceOf <OrgDTO>(dto);
}
public void getObject_validIntId_returnObject()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
var testOrgId = org.orgId;
var testOrg = o.getObject(testOrgId);
Assert.IsInstanceOf <Org>(testOrg);
}
public IHttpActionResult Put(int id, Org value)
{
if (value == null || !ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != value.orgId)
{
return(BadRequest());
}
OrgHelper orgHelper = new OrgHelper(db);
//if (!OrgMgmtDBHelper.isOrgExists(id, db))
if (!orgHelper.isObjectExists(id))
{
return(NotFound());
}
try
{
//if (!OrgMgmtDBHelper.isOrgChangeAllowed(id, value, db))
if (!orgHelper.isObjectChangeAllowed(id, value))
{
return(BadRequest("不允许修改对象!"));
}
;
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
db.Entry(value).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
//if (!OrgMgmtDBHelper.isOrgExists(id, db))
if (!orgHelper.isObjectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void saveCreatedObject_validObj_willExist()
{
OrgHelper o = new OrgHelper(db);
var org = o.createObject();
org.name = "Integration_Test_XXXYYYZZZ";
o.saveCreatedObject(org);
Assert.True(o.isObjectExists(org.orgId));
}
public void saveUpdatedObject_validObj_willExist()
{
OrgHelper o = new OrgHelper(db);
var org = db.orgs.FirstOrDefault();
var orgGuid = org.guid;
org.name = "Integration_Test_XXXYYYZZZ_00";
o.saveUpdatedObject(org);
Assert.AreEqual("Integration_Test_XXXYYYZZZ_00", o.getObject(orgGuid).name);
}
public async Task <IHttpActionResult> GetOrgSchemas(int orgId)
{
var org = await db.orgs.FindAsync(orgId);
if (org == null)
{
return(NotFound());
}
var orgHelper = new OrgHelper(db);
return(Ok(orgHelper.getOrgSchemaDTOs(org)));
}
public IHttpActionResult Delete(int id)
{
//var org = db.orgs.Find(id);
//if (org == null)
//{
// return NotFound();
//}
//org.isVisible = false;
//db.SaveChanges();
//return Ok(OrgMgmtDBHelper.convertOrg2DTO(org));
OrgHelper orgHelper = new OrgHelper(db);
orgHelper.removeObject(id);
var org = db.orgs.Find(id);
return(Ok(orgHelper.convert2DTO(org)));
}
/// <summary>
/// 查询初审人审核
/// </summary>
/// <param name="skip"></param>
/// <param name="take"></param>
/// <returns></returns>
public ListResult <CgJiLuDto> GetJiLuByChushenren(int skip, int take)
{
ListResult <CgJiLuDto> listResult = new ListResult <CgJiLuDto>();
var currentUser = _fapContext.CurrentUser;
var bumen = OrgHelper.GetBuMenId(currentUser);
try
{
var ids = _dbContext.CgShenHe.Where(x => x.Status == 1 && x.Status != -1).Select(p => p.CgId);
var jilu = _dbContext.CgJiLu.Where(x => ids.Contains(x.CgId) && x.BumenId == bumen);
var query = jilu.OrderByDescending(x => x.CreateDate);
listResult.Results = _mapper.Map <List <CgJiLuDto> >(query.Skip(skip).Take(take).ToList());
listResult.TotalRows = query.Count();
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
listResult.Error = new Error("系统未知错误");
}
return(listResult);
}
public IHttpActionResult Post(Org value)
{
if (value == null || !ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var orgHelper = new OrgHelper(db);
try
{
//OrgMgmtDBHelper.saveCreatedOrg(value, db);
orgHelper.saveCreatedObject(value);
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
var dto = orgHelper.convert2DTO(value); //OrgMgmtDBHelper.convertOrg2DTO(value);
return(CreatedAtRoute("DefaultApi", new { id = value.orgId }, dto));
}
/// <summary>
/// 审核
/// </summary>
/// <param name="id"></param>
/// <param name="entity"></param>
/// <param name="status"></param>
/// <returns></returns>
public SingleResult <bool> SaveShenHe(Guid id, CgShenHe entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
try
{
CgShenHe cgShenHe = new CgShenHe();
cgShenHe.Id = Guid.NewGuid();
cgShenHe.CgId = id;
cgShenHe.JieDian = 1;
cgShenHe.Status = status;
cgShenHe.ShenPiRenId = currentUser.Id;
cgShenHe.ShenPiRenName = currentUser.Name;
cgShenHe.ShenPiRenBuMenId = OrgHelper.GetBuMenId(currentUser);
cgShenHe.ShenPiRenBuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
cgShenHe.ShenPiShiJian = cgShenHe.CreateDate = cgShenHe.LastUpdateDate = DateTime.Now;
cgShenHe.ShenHeYiJian = entity.ShenHeYiJian;
_dbContext.CgShenHe.Add(cgShenHe);
//CgShenHeYiJian cgShenHeYiJian = new CgShenHeYiJian();
//cgShenHeYiJian.Id = Guid.NewGuid();
//cgShenHeYiJian.Status = status;
//cgShenHeYiJian.ShenHeId = cgShenHe.Id;
//cgShenHeYiJian.ShenHeYiJian = yijian;
//cgShenHeYiJian.CreateDate = cgShenHeYiJian.LastUpdateDate = DateTime.Now;
//_dbContext.CgShenHeYiJian.Add(cgShenHeYiJian);
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public IHttpActionResult Post(OrgSchema value, [FromUri] int orgId)
{
OrgHelper orgHelper = new OrgHelper(db);
if (value == null || !ModelState.IsValid ||
!orgHelper.isObjectExists(orgId))
{
return(BadRequest(ModelState));
}
try
{
OrgSchemaHelper orgSchemaHelper = new OrgSchemaHelper(db);
value.Org = orgHelper.getObject(orgId);
orgSchemaHelper.saveCreatedObject(value);
//OrgMgmtDBHelper.saveCreatedOrgSchema(db.orgs.Find(orgId), value, db);
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(Ok(value));
}
/// <summary>
/// 保存 成果 其他
/// </summary>
/// <param name="entity"></param>
/// <param name="status"></param>
/// <returns></returns>
public SingleResult <bool> SaveCgQita(Request_CG_Bag entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var qita = entity.cgQiTa;
var canyuzes = entity.canyuzes;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var jilu = entity.jilu;
try
{
if (qita.Id == Guid.Empty)
{
qita.Id = Guid.NewGuid();
qita.UserId = currentUser.Id;
qita.UserName = currentUser.Name;
qita.Status = status;
qita.CreateDate = qita.LastUpdateDate = DateTime.Now;
qita.BuMenId = OrgHelper.GetBuMenId(currentUser);
qita.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgQiTa.Add(qita);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = qita.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = qita.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = qita.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = qita.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
}
else
{
var query_qita = _dbContext.CgQiTa.SingleOrDefault(x => x.Id == qita.Id);
query_qita.MingCheng = qita.MingCheng;
query_qita.ChengGuoNianDu = qita.ChengGuoNianDu;
query_qita.KeYanChengGuoJianJie = qita.KeYanChengGuoJianJie;
query_qita.LastUpdateDate = DateTime.Now;
query_qita.HuoJiangMingCheng = qita.HuoJiangMingCheng;
query_qita.ShiJiDeFen = query_qita.ShiJiDeFen;
query_qita.Status = status;
query_qita.SuoShuNianDu = qita.SuoShuNianDu;
//附件
var query_fj = _dbContext.FuJian.Where(x => x.ChengGuoId == qita.Id);
_dbContext.FuJian.RemoveRange(query_fj);
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = qita.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = qita.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = qita.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = qita.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
}
var result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(qita, jilu, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> SaveCgjl(CgKeYanXiangMu entity, JiLu jilu, List <canyuze> canyuzes, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var str = "";
try
{
if (canyuzes != null)
{
canyuzes.ForEach(x =>
{
str = str + x.name + ',';
});
}
if (_dbContext.CgJiLu.Any(x => x.CgId == entity.Id))
{
//判断是否是退回修改
var query_jilu = _dbContext.CgJiLu.SingleOrDefault(x => x.CgId == entity.Id);
if (query_jilu.Status == -2 && query_jilu.IsKeYanChuShenHe == 1)
{
query_jilu.Status = 3;
}
else if (currentUser.Name != query_jilu.UserName)
{
query_jilu.Status = query_jilu.Status;
}
else if (query_jilu.Status == 0)
{
query_jilu.Status = status;
}
else if (query_jilu.Status == 4)
{
query_jilu.Status = query_jilu.Status;
}
else
{
query_jilu.Status = 1;
}
//query_jilu.UserId = currentUser.Id;
query_jilu.CgLeiXingMingCheng = "科研项目";
query_jilu.LastUpdateDate = DateTime.Now;
query_jilu.StartDate = entity.LiXiangShiJian;
query_jilu.EndDate = entity.GongBuJieXiangShiJian;
query_jilu.HuoJiangLeiXing = entity.XiangMuHuoJiangJiBie;
query_jilu.CgMingCheng = entity.XiangMuMingCheng;
//query_jilu.ShenHeFen = entity.ShenHeDeFen;
query_jilu.XiangMuLaiYuan = entity.XiangMuLaiYuan;
query_jilu.YuanNeiXiangMuBianHao = entity.YuanNeiXiangMuBianHao;
query_jilu.ShuMingPaiXu = entity.BenRenShuMingPaiXu;
query_jilu.XiangMuZuChengYuan = str;
query_jilu.ZhuanJiZhiWu = jilu.ZhuanJiZhiWu;
query_jilu.JiaoGuanZhiWu = jilu.JiaoGuanZhiWu;
}
else
{
CgJiLu cgJiLu = new CgJiLu();
cgJiLu.Id = Guid.NewGuid();
cgJiLu.CgId = entity.Id;
cgJiLu.UserId = currentUser.Id;
cgJiLu.CgLeiXingMingCheng = "科研项目";
cgJiLu.Status = status;
cgJiLu.CreateDate = cgJiLu.LastUpdateDate = DateTime.Now;
cgJiLu.UserName = currentUser.Name;
//正式环境
//OrgHelper.GetBuMenId(currentUser);
//测试环境（包含科室）
//currentUser.OrganizationalUnitRoleDefault.OrganizationalUnitId;
//currentUser.OrganizationalUnitRoleDefault.ORGName;
cgJiLu.BumenId = OrgHelper.GetBuMenId(currentUser);
cgJiLu.Bumen = OrgHelper.GetBuMenMingCheng(currentUser);
cgJiLu.StartDate = entity.LiXiangShiJian;
cgJiLu.EndDate = entity.GongBuJieXiangShiJian;
cgJiLu.HuoJiangLeiXing = entity.XiangMuHuoJiangJiBie;
cgJiLu.CgMingCheng = entity.XiangMuMingCheng;
// cgJiLu.ShenHeFen = entity.ShenHeDeFen;
cgJiLu.XiangMuLaiYuan = entity.XiangMuLaiYuan;
cgJiLu.YuanNeiXiangMuBianHao = entity.YuanNeiXiangMuBianHao;
cgJiLu.ShuMingPaiXu = entity.BenRenShuMingPaiXu;
cgJiLu.XiangMuZuChengYuan = str;
cgJiLu.ZhuanJiZhiWu = jilu.ZhuanJiZhiWu;
cgJiLu.JiaoGuanZhiWu = jilu.JiaoGuanZhiWu;
_dbContext.CgJiLu.Add(cgJiLu);
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
/// <summary>
/// 添加cgkyxm
/// </summary>
/// <param name="entity"></param>
/// <param name="zt">状态</param>
/// <param name="status"></param>
/// <returns></returns>
public SingleResult <bool> AddCgkyxm(Request_CG_Bag entity, int zt, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var kyxm = entity.cgKeYanXiangMu;
var canyuzes = entity.canyuzes;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var jilu = entity.jilu;
bool result = false;
try
{
//科研项目
kyxm.Id = Guid.NewGuid();
kyxm.UserName = currentUser.Name;
kyxm.UserId = currentUser.Id;
kyxm.XiangMuZhuangTai = zt;
kyxm.Status = status;
kyxm.CreateDate = kyxm.LastUpdateDate = DateTime.Now;
kyxm.BuMenId = OrgHelper.GetBuMenId(currentUser);
kyxm.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgKeYanXiangMu.Add(kyxm);
//参与者
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = kyxm.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = kyxm.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = kyxm.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = kyxm.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = kyxm.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(kyxm, jilu, canyuzes, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误", ex);
}
return(singleResult);
}
public SingleResult <bool> SaveCgJiaoCai(Request_CG_Bag entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var jiaocai = entity.cgJiaoCai;
// var canyuzes = entity.canyuzes;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var banquan = entity.banquanlist;
var jilu = entity.jilu;
try
{
if (jiaocai.Id == Guid.Empty)
{
jiaocai.Id = Guid.NewGuid();
jiaocai.UserId = currentUser.Id;
jiaocai.UserName = currentUser.Name;
jiaocai.Status = status;
jiaocai.CreateDate = jiaocai.LastUpdateDate = DateTime.Now;
jiaocai.BuMenId = OrgHelper.GetBuMenId(currentUser);
jiaocai.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgJiaoCai.Add(jiaocai);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = jiaocai.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = jiaocai.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = jiaocai.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = jiaocai.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = jiaocai.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
}
else
{
//教材
var query_jiaocai = _dbContext.CgJiaoCai.SingleOrDefault(x => x.Id == jiaocai.Id);
query_jiaocai.JiaoCaiMingCheng = jiaocai.JiaoCaiMingCheng;
query_jiaocai.Isbn = jiaocai.Isbn;
query_jiaocai.ChuBanShe = jiaocai.ChuBanShe;
query_jiaocai.ChuBanSheJiBie = jiaocai.ChuBanSheJiBie;
query_jiaocai.ChuBanShiJian = jiaocai.ChuBanShiJian;
query_jiaocai.CanBianQingKuang = jiaocai.CanBianQingKuang;
query_jiaocai.IsBiaoZhuXueYuan = jiaocai.IsBiaoZhuXueYuan;
query_jiaocai.QuanShuZiShu = jiaocai.QuanShuZiShu;
query_jiaocai.CanBianZhangJie = jiaocai.CanBianZhangJie;
query_jiaocai.CanBianZiShu = jiaocai.CanBianZiShu;
query_jiaocai.JiaoCaiHuoJiangJiBie = jiaocai.JiaoCaiHuoJiangJiBie;
query_jiaocai.JiaoCaiHuoJiangShiJian = jiaocai.JiaoCaiHuoJiangShiJian;
query_jiaocai.KeYanKaoHeDeFen = jiaocai.KeYanKaoHeDeFen;
query_jiaocai.LastUpdateDate = DateTime.Now;
query_jiaocai.HuoJiangMingCheng = jiaocai.HuoJiangMingCheng;
query_jiaocai.ShiJiDenFen = jiaocai.ShiJiDenFen;
query_jiaocai.Status = status;
query_jiaocai.SuoShuNianDu = jiaocai.SuoShuNianDu;
//附件
var query_fj = _dbContext.FuJian.Where(x => x.ChengGuoId == jiaocai.Id);
_dbContext.FuJian.RemoveRange(query_fj);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = jiaocai.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = jiaocai.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = jiaocai.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = jiaocai.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = jiaocai.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
}
var result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(jiaocai, jilu, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> SaveCgjl(CgJiaoCai entity, JiLu jiLu, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
try
{
if (_dbContext.CgJiLu.Any(x => x.CgId == entity.Id))
{
//判断是否是退回修改
var query_jilu = _dbContext.CgJiLu.SingleOrDefault(x => x.CgId == entity.Id);
if (query_jilu.Status == -2 && query_jilu.IsKeYanChuShenHe == 1)
{
query_jilu.Status = 3;
}
else if (currentUser.Name != query_jilu.UserName)
{
query_jilu.Status = query_jilu.Status;
}
else if (query_jilu.Status == 0)
{
query_jilu.Status = status;
}
else if (query_jilu.Status == 4)
{
query_jilu.Status = query_jilu.Status;
}
else
{
query_jilu.Status = 1;
}
//query_jilu.UserId = currentUser.Id;
query_jilu.CgLeiXingMingCheng = "教材";
query_jilu.LastUpdateDate = DateTime.Now;
query_jilu.StartDate = entity.ChuBanShiJian;
query_jilu.HuoJiangLeiXing = entity.JiaoCaiHuoJiangJiBie;
query_jilu.CgMingCheng = entity.JiaoCaiMingCheng;
//query_jilu.ShenHeFen = entity.ShenHeDeFen;
query_jilu.JiaoGuanZhiWu = jiLu.JiaoGuanZhiWu;
query_jilu.ZhuanJiZhiWu = jiLu.ZhuanJiZhiWu;
}
else
{
CgJiLu cgJiLu = new CgJiLu();
cgJiLu.Id = Guid.NewGuid();
cgJiLu.CgId = entity.Id;
cgJiLu.UserId = currentUser.Id;
cgJiLu.CgLeiXingMingCheng = "教材";
cgJiLu.Status = status;
cgJiLu.CreateDate = cgJiLu.LastUpdateDate = DateTime.Now;
cgJiLu.UserName = currentUser.Name;
cgJiLu.BumenId = OrgHelper.GetBuMenId(currentUser);
cgJiLu.Bumen = OrgHelper.GetBuMenMingCheng(currentUser);
cgJiLu.StartDate = entity.ChuBanShiJian;
//cgJiLu.EndDate = entity.JiHuaWanChengShiJian;
cgJiLu.HuoJiangLeiXing = entity.JiaoCaiHuoJiangJiBie;
cgJiLu.CgMingCheng = entity.JiaoCaiMingCheng;
//cgJiLu.ShenHeFen = entity.ShenHeDeFen;
cgJiLu.JiaoGuanZhiWu = jiLu.JiaoGuanZhiWu;
cgJiLu.ZhuanJiZhiWu = jiLu.ZhuanJiZhiWu;
_dbContext.CgJiLu.Add(cgJiLu);
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> SaveCgZhuzuo(Request_CG_Bag entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var zhuzuo = entity.cgZuZhuo;
var canyuzes = entity.canyuzes;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var banquan = entity.banquanlist;
var jilu = entity.jilu;
try
{
if (zhuzuo.Id == Guid.Empty)
{
zhuzuo.Id = Guid.NewGuid();
zhuzuo.UserId = currentUser.Id;
zhuzuo.UserName = currentUser.Name;
zhuzuo.Status = status;
zhuzuo.CreateDate = zhuzuo.LastUpdateDate = DateTime.Now;
zhuzuo.BuMenId = OrgHelper.GetBuMenId(currentUser);
zhuzuo.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgZuZhuo.Add(zhuzuo);
//作者
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = zhuzuo.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = zhuzuo.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = zhuzuo.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = zhuzuo.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = zhuzuo.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = zhuzuo.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
}
else
{
var query_zuzhuo = _dbContext.CgZuZhuo.SingleOrDefault(x => x.Id == zhuzuo.Id);
query_zuzhuo.ZuZuoMingCheng = zhuzuo.ZuZuoMingCheng;
query_zuzhuo.Isbn = zhuzuo.Isbn;
query_zuzhuo.LeiBie = zhuzuo.LeiBie;
query_zuzhuo.ChuBanSe = zhuzuo.ChuBanSe;
query_zuzhuo.ChuBanSeJiBie = zhuzuo.ChuBanSeJiBie;
query_zuzhuo.ChuBanShiJian = zhuzuo.ChuBanShiJian;
query_zuzhuo.FengMianBenRenShuMingPaiXu = zhuzuo.FengMianBenRenShuMingPaiXu;
query_zuzhuo.YuanNeiBenRenShuMingPaiXu = zhuzuo.YuanNeiBenRenShuMingPaiXu;
query_zuzhuo.IsBiaoZhuXueYuan = zhuzuo.IsBiaoZhuXueYuan;
query_zuzhuo.QuanShuZiShu = zhuzuo.QuanShuZiShu;
query_zuzhuo.GongGaoZhangJie = zhuzuo.GongGaoZhangJie;
query_zuzhuo.GongGaoZiShu = zhuzuo.GongGaoZiShu;
query_zuzhuo.ZuZhuoHuoJiangJiBie = zhuzuo.ZuZhuoHuoJiangJiBie;
query_zuzhuo.ZuZhuoHuoJiangShiJian = zhuzuo.ZuZhuoHuoJiangShiJian;
query_zuzhuo.KeYanKaoHeDeFen = zhuzuo.KeYanKaoHeDeFen;
query_zuzhuo.LastUpdateDate = DateTime.Now;
query_zuzhuo.HuoJiangMingCheng = zhuzuo.HuoJiangMingCheng;
query_zuzhuo.ShiJiDeFen = zhuzuo.ShiJiDeFen;
query_zuzhuo.Status = status;
query_zuzhuo.SuoShuNianDu = zhuzuo.SuoShuNianDu;
//作者
var query_cyz = _dbContext.CgCanYuZhe.Where(x => x.CgId == zhuzuo.Id);
_dbContext.CgCanYuZhe.RemoveRange(query_cyz);
//作者
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = zhuzuo.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
var query_fj = _dbContext.FuJian.Where(x => x.ChengGuoId == zhuzuo.Id);
_dbContext.FuJian.RemoveRange(query_fj);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = zhuzuo.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = zhuzuo.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = zhuzuo.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = zhuzuo.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = zhuzuo.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
}
var result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(zhuzuo, jilu, canyuzes, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
/// <summary>
/// 修改部门
/// </summary>
/// <returns></returns>
public SingleResult <bool> updateBuMen()
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var query_ky = _dbContext.CgKeYanXiangMu.Where(x => x.Status == 1);
var query_lw = _dbContext.CgLunWen.Where(x => x.Status == 1);
var query_jc = _dbContext.CgJiaoCai.Where(x => x.Status == 1);
var query_rj = _dbContext.CgRuanJianYuZhuanLi.Where(x => x.Status == 1);
var query_zz = _dbContext.CgZuZhuo.Where(x => x.Status == 1);
var query_qt = _dbContext.CgQiTa.Where(x => x.Status == 1);
try
{
foreach (var item in query_ky)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
foreach (var item in query_lw)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
foreach (var item in query_jc)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
foreach (var item in query_rj)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
foreach (var item in query_zz)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
foreach (var item in query_qt)
{
var id = _organizationService.GetUser(item.UserId.Value);
var bumenid = OrgHelper.GetBuMenId(id);
var bumenMingCheng = OrgHelper.GetBuMenMingCheng(id);
item.BuMenId = bumenid;
item.BuMenMingCheng = bumenMingCheng;
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误", ex);
}
return(singleResult);
}
public SingleResult <bool> SaveCgLunWen(Request_CG_Bag entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var lunwen = entity.cgLunWen;
var canyuzes = entity.canyuzes;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var banquan = entity.banquanlist;
var zhengshu = entity.zhengshulist;
var baozhi = entity.baozhilist;
var jilu = entity.jilu;
try
{
if (lunwen.Id == Guid.Empty)
{
lunwen.Id = Guid.NewGuid();
lunwen.UserId = currentUser.Id;
lunwen.UserName = currentUser.Name;
lunwen.Status = status;
lunwen.CreateDate = lunwen.LastUpdateDate = DateTime.Now;
lunwen.YuanNeiBenRenShuMingPaiXu = lunwen.BenRenShuMingPaiXu;
lunwen.BuMenId = OrgHelper.GetBuMenId(currentUser);
lunwen.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgLunWen.Add(lunwen);
//作者
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = lunwen.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = lunwen.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = lunwen.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = lunwen.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = lunwen.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = lunwen.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
if (zhengshu != null)
{
for (int i = 0; i < zhengshu.Count; i++)
{
zhengshu[i].Id = Guid.NewGuid();
zhengshu[i].ChengGuoId = lunwen.Id;
zhengshu[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.证书;
zhengshu[i].CreateDateTime = zhengshu[i].LastUpdateTime = DateTime.Now;
zhengshu[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(zhengshu[i]);
}
}
if (baozhi != null)
{
for (int i = 0; i < baozhi.Count; i++)
{
baozhi[i].Id = Guid.NewGuid();
baozhi[i].ChengGuoId = lunwen.Id;
baozhi[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.报纸;
baozhi[i].CreateDateTime = baozhi[i].LastUpdateTime = DateTime.Now;
baozhi[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(baozhi[i]);
}
}
}
else
{
var query_lunwen = _dbContext.CgLunWen.SingleOrDefault(x => x.Id == lunwen.Id);
query_lunwen.LunWenMingCheng = lunwen.LunWenMingCheng;
query_lunwen.LunWenLeiBie = lunwen.LunWenLeiBie;
query_lunwen.FaBiaoQiKan = lunwen.FaBiaoQiKan;
query_lunwen.DangNianQiHao = lunwen.DangNianQiHao;
query_lunwen.LunWenRenDingJiFenLeiXing = lunwen.LunWenRenDingJiFenLeiXing;
query_lunwen.ShouLuQiangKuang = lunwen.ShouLuQiangKuang;
query_lunwen.FaBiaoNianDu = lunwen.FaBiaoNianDu;
query_lunwen.BenRenShuMingPaiXu = lunwen.BenRenShuMingPaiXu;
query_lunwen.YuanNeiBenRenShuMingPaiXu = lunwen.YuanNeiBenRenShuMingPaiXu;
query_lunwen.IsBiaoZhuXueYuan = lunwen.IsBiaoZhuXueYuan;
query_lunwen.LunWenZiShu = lunwen.LunWenZiShu;
query_lunwen.IsYuHangYeLianHeFaBiao = lunwen.IsYuHangYeLianHeFaBiao;
query_lunwen.IsYuDiFangLianHeFaBiao = lunwen.IsYuDiFangLianHeFaBiao;
query_lunwen.IsYuGuoJiLianHeFaBiao = lunwen.IsYuGuoJiLianHeFaBiao;
query_lunwen.IsKuaXueKeLunWen = lunwen.IsKuaXueKeLunWen;
query_lunwen.LunWenHuoJiangJiBie = lunwen.LunWenHuoJiangJiBie;
query_lunwen.LunWenHuoJiangShiJian = lunwen.LunWenHuoJiangShiJian;
query_lunwen.KeYanKaoHeDeFen = lunwen.KeYanKaoHeDeFen;
query_lunwen.LastUpdateDate = DateTime.Now;
query_lunwen.HuoJiangMingCheng = lunwen.HuoJiangMingCheng;
query_lunwen.ShiJiDeFen = lunwen.ShiJiDeFen;
query_lunwen.ZaiTiLeiXing = lunwen.ZaiTiLeiXing;
query_lunwen.ZaiTiMingCheng = lunwen.ZaiTiMingCheng;
query_lunwen.GuoJiBiaoZhunHao = lunwen.GuoJiBiaoZhunHao;
query_lunwen.ChuBanSe = lunwen.ChuBanSe;
query_lunwen.Status = status;
query_lunwen.SuoShuNianDu = lunwen.SuoShuNianDu;
//作者
var query_cyz = _dbContext.CgCanYuZhe.Where(x => x.CgId == lunwen.Id);
_dbContext.CgCanYuZhe.RemoveRange(query_cyz);
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = lunwen.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
var query_fj = _dbContext.FuJian.Where(x => x.ChengGuoId == lunwen.Id);
_dbContext.FuJian.RemoveRange(query_fj);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = lunwen.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = lunwen.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = lunwen.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = lunwen.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (banquan != null)
{
for (int i = 0; i < banquan.Count; i++)
{
banquan[i].Id = Guid.NewGuid();
banquan[i].ChengGuoId = lunwen.Id;
banquan[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.版权页面;
banquan[i].CreateDateTime = banquan[i].LastUpdateTime = DateTime.Now;
banquan[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(banquan[i]);
}
}
if (zhengshu != null)
{
for (int i = 0; i < zhengshu.Count; i++)
{
zhengshu[i].Id = Guid.NewGuid();
zhengshu[i].ChengGuoId = lunwen.Id;
zhengshu[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.证书;
zhengshu[i].CreateDateTime = zhengshu[i].LastUpdateTime = DateTime.Now;
zhengshu[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(zhengshu[i]);
}
}
if (baozhi != null)
{
for (int i = 0; i < baozhi.Count; i++)
{
baozhi[i].Id = Guid.NewGuid();
baozhi[i].ChengGuoId = lunwen.Id;
baozhi[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.报纸;
baozhi[i].CreateDateTime = baozhi[i].LastUpdateTime = DateTime.Now;
baozhi[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(baozhi[i]);
}
}
}
var result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(lunwen, jilu, canyuzes, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> SaveCgjl(CgLunWen entity, JiLu jiLu, List <canyuze> canyuzes, int status)
{
var rendingleixing = "";
var rendingfanwei = "";
#region 认定类型
if (entity.LunWenRenDingJiFenLeiXing == 0)
{
rendingleixing = "刊登在《中国社会科学》和《中国科学》刊物上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 1)
{
rendingleixing = "刊登在《人民日报》等国家级报纸上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 2)
{
rendingleixing = "《新华文摘》收录的论文全文、“ＳＣＩ”和“ＥＩ”收录的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 3)
{
rendingleixing = "刊登在CSSCI来源期刊上的论文、《中国人民大学报刊复印资料》全文收录的论文、刊登在《解放日报》等省部级报纸上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 4)
{
rendingleixing = "“ISTP”和“ISR”收录的学术论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 5)
{
rendingleixing = "刊登在全国中文核心期刊上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 6)
{
rendingleixing = "刊登在公安部主管及公安部部属院校正式出版期刊上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 7)
{
rendingleixing = "刊登在其他正式出版的期刊及公安部内部资料上的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 8)
{
rendingleixing = "正式出版的论文集收录的论文，《新华文摘》、《高等学校文科学报文摘》和《中国社会科学文摘》收录的文摘、省部级单位内部编印的论文集收录的论文";
}
else if (entity.LunWenRenDingJiFenLeiXing == 9)
{
rendingleixing = "刊登在市局内部资料上的论文、局级单位内部编印的论文集收录的论文 ";
}
else if (entity.LunWenRenDingJiFenLeiXing == 10)
{
rendingleixing = "公安院校内部编印的论文集收录的论文 ";
}
else if (entity.LunWenRenDingJiFenLeiXing == 11)
{
rendingleixing = "其他正式出版的文摘期刊收录的文摘，正式出版的论文集收录的文摘";
}
else if (entity.LunWenRenDingJiFenLeiXing == 12)
{
rendingleixing = "正式出版的各类文摘收录的论文题录";
}
else if (entity.LunWenRenDingJiFenLeiXing == 13)
{
rendingleixing = "报科研处并经专家评审合格的结合本职工作的论文或报告";
}
#endregion
#region 认定范围
if (entity.ShouLuQiangKuang == "0")
{
rendingfanwei = "SCI（科学引文索引）";
}
else if (entity.ShouLuQiangKuang == "1")
{
rendingfanwei = "SSCI（社会科学引文索引）";
}
else if (entity.ShouLuQiangKuang == "2")
{
rendingfanwei = "EI（工程索引）";
}
else if (entity.ShouLuQiangKuang == "3")
{
rendingfanwei = "CPCI（国际会议录索引）";
}
else if (entity.ShouLuQiangKuang == "4")
{
rendingfanwei = "A & HCI（艺术与人文科学索引）";
}
else if (entity.ShouLuQiangKuang == "5")
{
rendingfanwei = "CSCD（中国科技期刊引证报告）";
}
else if (entity.ShouLuQiangKuang == "6")
{
rendingfanwei = "CSSCI（中文社会科学引文索引）";
}
else if (entity.ShouLuQiangKuang == "7")
{
rendingfanwei = "北大中文核心期刊";
}
else if (entity.ShouLuQiangKuang == "8")
{
rendingfanwei = "其他期刊";
}
#endregion
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var str = "";
try
{
if (canyuzes != null)
{
canyuzes.ForEach(x =>
{
str = str + x.name + ',';
});
}
if (_dbContext.CgJiLu.Any(x => x.CgId == entity.Id))
{
//判断是否是退回修改
var query_jilu = _dbContext.CgJiLu.SingleOrDefault(x => x.CgId == entity.Id);
if (query_jilu.Status == -2 && query_jilu.IsKeYanChuShenHe == 1)
{
query_jilu.Status = 3;
}
else if (currentUser.Name != query_jilu.UserName)
{
query_jilu.Status = query_jilu.Status;
}
else if (query_jilu.Status == 0)
{
query_jilu.Status = status;
}
else if (query_jilu.Status == 4)
{
query_jilu.Status = query_jilu.Status;
}
else
{
query_jilu.Status = 1;
}
// query_jilu.UserId = currentUser.Id;
query_jilu.CgLeiXingMingCheng = "论文";
query_jilu.LastUpdateDate = DateTime.Now;
query_jilu.StartDate = entity.FaBiaoNianDu;
query_jilu.HuoJiangLeiXing = entity.LunWenHuoJiangJiBie;
query_jilu.CgMingCheng = entity.LunWenMingCheng;
// query_jilu.ShenHeFen = entity.ShenHeDeFen;
query_jilu.ShuMingPaiXu = entity.BenRenShuMingPaiXu;
query_jilu.XiangMuZuChengYuan = str;
query_jilu.RenDingLeiXing = rendingleixing;
query_jilu.RenDingFanWei = rendingfanwei;
query_jilu.ZhuanJiZhiWu = jiLu.ZhuanJiZhiWu;
query_jilu.JiaoGuanZhiWu = jiLu.JiaoGuanZhiWu;
}
else
{
CgJiLu cgJiLu = new CgJiLu();
cgJiLu.Id = Guid.NewGuid();
cgJiLu.CgId = entity.Id;
cgJiLu.UserId = currentUser.Id;
cgJiLu.CgLeiXingMingCheng = "论文";
cgJiLu.Status = status;
cgJiLu.CreateDate = cgJiLu.LastUpdateDate = DateTime.Now;
cgJiLu.UserName = currentUser.Name;
cgJiLu.BumenId = OrgHelper.GetBuMenId(currentUser);
cgJiLu.Bumen = OrgHelper.GetBuMenMingCheng(currentUser);
cgJiLu.StartDate = entity.FaBiaoNianDu;
// cgJiLu.EndDate = entity.JiHuaWanChengShiJian;
cgJiLu.HuoJiangLeiXing = entity.LunWenHuoJiangJiBie;
cgJiLu.CgMingCheng = entity.LunWenMingCheng;
//cgJiLu.ShenHeFen = entity.ShenHeDeFen;
cgJiLu.ShuMingPaiXu = entity.BenRenShuMingPaiXu;
cgJiLu.XiangMuZuChengYuan = str;
cgJiLu.RenDingLeiXing = rendingleixing;
cgJiLu.RenDingFanWei = rendingfanwei;
cgJiLu.ZhuanJiZhiWu = jiLu.ZhuanJiZhiWu;
cgJiLu.JiaoGuanZhiWu = jiLu.JiaoGuanZhiWu;
//cgJiLu.RenDingLeiXing = entity.LunWenRenDingJiFenLeiXing;
_dbContext.CgJiLu.Add(cgJiLu);
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> SaveCgRuanJian(Request_CG_Bag entity, int status)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var currentUser = _fapContext.CurrentUser;
var ruanjian = entity.CgRuanJianYuZhuanLi;
var canyuzes = entity.canyuzes;
var zhuanlis = entity.zhuanlis;
var fm = entity.fengmianList;
var file = entity.fileList;
var article = entity.articleList;
var wenjian = entity.wenjianList;
var zhengshu = entity.zhengshulist;
var jilu = entity.jilu;
try
{
if (ruanjian.Id == Guid.Empty)
{
ruanjian.Id = Guid.NewGuid();
ruanjian.UserId = currentUser.Id;
ruanjian.UserName = currentUser.Name;
ruanjian.Status = status;
ruanjian.CreateDate = ruanjian.LastUpdateDate = DateTime.Now;
ruanjian.YuanNeiBenRenShuMingPaiXu = ruanjian.BenRenShuMingPaiXu;
ruanjian.BuMenId = OrgHelper.GetBuMenId(currentUser);
ruanjian.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(currentUser);
_dbContext.CgRuanJianYuZhuanLi.Add(ruanjian);
//作者
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = ruanjian.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
if (zhuanlis != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = ruanjian.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 1;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = ruanjian.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = ruanjian.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = ruanjian.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = ruanjian.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (zhengshu != null)
{
for (int i = 0; i < zhengshu.Count; i++)
{
zhengshu[i].Id = Guid.NewGuid();
zhengshu[i].ChengGuoId = ruanjian.Id;
zhengshu[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.证书;
zhengshu[i].CreateDateTime = zhengshu[i].LastUpdateTime = DateTime.Now;
zhengshu[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(zhengshu[i]);
}
}
}
else
{
var query_ruanjian = _dbContext.CgRuanJianYuZhuanLi.SingleOrDefault(x => x.Id == ruanjian.Id);
query_ruanjian.MingCheng = ruanjian.MingCheng;
query_ruanjian.LeiXing = ruanjian.LeiXing;
query_ruanjian.BenRenShuMingPaiXu = ruanjian.BenRenShuMingPaiXu;
query_ruanjian.YuanNeiBenRenShuMingPaiXu = ruanjian.YuanNeiBenRenShuMingPaiXu;
query_ruanjian.IsHangYeLianHeZhuanLi = ruanjian.IsHangYeLianHeZhuanLi;
query_ruanjian.KeYanKaoHeDeFen = ruanjian.KeYanKaoHeDeFen;
query_ruanjian.LastUpdateDate = DateTime.Now;
query_ruanjian.HuoJiangMingCheng = ruanjian.HuoJiangMingCheng;
query_ruanjian.ShiJiDeFen = ruanjian.ShiJiDeFen;
query_ruanjian.ZhuanLiHao = ruanjian.ZhuanLiHao;
query_ruanjian.ZhuanLiShenQingRi = ruanjian.ZhuanLiShenQingRi;
query_ruanjian.ShouQuanGongGaoRi = ruanjian.ShouQuanGongGaoRi;
query_ruanjian.DengJiHao = ruanjian.DengJiHao;
query_ruanjian.KaiFaWanChengRiQi = ruanjian.KaiFaWanChengRiQi;
query_ruanjian.QuanLiQuDeFangShi = ruanjian.QuanLiQuDeFangShi;
query_ruanjian.QuanLiFanWei = ruanjian.QuanLiFanWei;
query_ruanjian.Status = status;
query_ruanjian.SuoShuNianDu = ruanjian.SuoShuNianDu;
var query_cyz = _dbContext.CgCanYuZhe.Where(x => x.CgId == ruanjian.Id);
_dbContext.CgCanYuZhe.RemoveRange(query_cyz);
if (canyuzes != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = ruanjian.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 0;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
if (zhuanlis != null)
{
for (int i = 0; i < canyuzes.Count; i++)
{
var cgCanYuZhe = new CgCanYuZhe();
cgCanYuZhe.Id = Guid.NewGuid();
cgCanYuZhe.CgId = ruanjian.Id;
cgCanYuZhe.Name = canyuzes[i].name;
if (canyuzes[i].isbenyuan == "是")
{
cgCanYuZhe.IsBenYuan = 0;
}
else
{
cgCanYuZhe.IsBenYuan = 1;
}
cgCanYuZhe.PaiXu = i;
cgCanYuZhe.IsTongXunZuoZe = 1;
cgCanYuZhe.Status = 1;
cgCanYuZhe.CreateDate = cgCanYuZhe.LastUpdateDate = DateTime.Now;
_dbContext.CgCanYuZhe.Add(cgCanYuZhe);
}
}
//附件
var query_fj = _dbContext.FuJian.Where(x => x.ChengGuoId == ruanjian.Id);
_dbContext.FuJian.RemoveRange(query_fj);
//附件
if (fm != null)
{
for (int i = 0; i < fm.Count; i++)
{
fm[i].Id = Guid.NewGuid();
fm[i].ChengGuoId = ruanjian.Id;
fm[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
fm[i].CreateDateTime = fm[i].LastUpdateTime = DateTime.Now;
fm[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(fm[i]);
}
}
if (file != null)
{
for (int i = 0; i < file.Count; i++)
{
file[i].Id = Guid.NewGuid();
file[i].ChengGuoId = ruanjian.Id;
file[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
file[i].CreateDateTime = file[i].LastUpdateTime = DateTime.Now;
file[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(file[i]);
}
}
if (article != null)
{
for (int i = 0; i < article.Count; i++)
{
article[i].Id = Guid.NewGuid();
article[i].ChengGuoId = ruanjian.Id;
article[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
article[i].CreateDateTime = article[i].LastUpdateTime = DateTime.Now;
article[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(article[i]);
}
}
if (wenjian != null)
{
for (int i = 0; i < wenjian.Count; i++)
{
wenjian[i].Id = Guid.NewGuid();
wenjian[i].ChengGuoId = ruanjian.Id;
wenjian[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
wenjian[i].CreateDateTime = wenjian[i].LastUpdateTime = DateTime.Now;
wenjian[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
if (zhengshu != null)
{
for (int i = 0; i < zhengshu.Count; i++)
{
zhengshu[i].Id = Guid.NewGuid();
zhengshu[i].ChengGuoId = ruanjian.Id;
zhengshu[i].WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.证书;
zhengshu[i].CreateDateTime = zhengshu[i].LastUpdateTime = DateTime.Now;
zhengshu[i].PaiXu = i.ToString();
_dbContext.FuJian.Add(wenjian[i]);
}
}
}
var result = _dbContext.SaveChanges() > 0;
if (result)
{
SaveCgjl(ruanjian, jilu, canyuzes, status);
}
singleResult.Result = result;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public void createObject_NotSetDBContext_ThrowsException()
{
OrgHelper o = new OrgHelper();
Assert.Throws <DataLogicException>(() => o.createObject());
}
public SingleResult <bool> SaveXiangMu(XiangMuDto entity)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
XiangMu instance = new XiangMu();
var cUser = _fapContext.CurrentUser;
try
{
if (_dbContext.XiangMu.Any(p => p.Id == entity.Id))
{
instance = _dbContext.XiangMu.Find(entity.Id);
}
else
{
entity.Id = Guid.NewGuid();
entity.CreateDate = entity.LastUpdateDate = DateTime.Now;
entity.Status = (int)XiangMuZhuangTaiName.提交;
entity.ShenQingRenId = cUser.Id;
entity.ShenQingRenBuMenMingCheng = cUser.Name;
entity.ShenQingRenBuMenId = OrgHelper.GetBuMenId(cUser);
entity.ShenQingRenBuMenMingCheng = OrgHelper.GetBuMenMingCheng(cUser);
entity.IsYanQi = false;
_dbContext.XiangMu.Add(instance);
}
_mapper.Map(entity, instance, typeof(XiangMuDto), typeof(XiangMu));
//添加外键信息
//方案
if (entity.XiangMuFangAn != null)
{
if (_dbContext.XiangMuFangAn.Any(p => p.XiangMuId == entity.Id))
{
var fangAnInstance = _dbContext.XiangMuFangAn.Find(entity.Id);
entity.XiangMuFangAn.LastUpdateDate = DateTime.Now;
_mapper.Map(entity.XiangMuFangAn, fangAnInstance, typeof(XiangMuFangAn), typeof(XiangMuFangAn));
}
else
{
entity.XiangMuFangAn.XiangMuId = entity.Id;
entity.XiangMuFangAn.CreateDate = entity.XiangMuFangAn.LastUpdateDate = DateTime.Now;
_dbContext.XiangMuFangAn.Add(entity.XiangMuFangAn);
}
}
//成员
if (entity.XiangMuZuYuans != null)
{
//将除去做过删除操作的元素
var zyIds = entity.XiangMuZuYuans.Select(p => p.Id);
var delRange = _dbContext.XiangMuZuYuan.Where(p => p.XiangMuId == entity.Id && !zyIds.Contains(p.Id));
_dbContext.XiangMuZuYuan.RemoveRange(delRange);
entity.KeTiZuChengYuanRenSu = entity.XiangMuZuYuans.Count();
foreach (var zy in entity.XiangMuZuYuans)
{
if (_dbContext.XiangMuZuYuan.Any(p => p.Id == zy.Id))
{
var zyInstance = _dbContext.XiangMuZuYuan.Find(zy.Id);
zy.LastUpdateDate = DateTime.Now;
_mapper.Map(zy, zyInstance, typeof(XiangMuZuYuan), typeof(XiangMuZuYuan));
}
else
{
zy.XiangMuId = entity.Id;
zy.CreateDate = zy.LastUpdateDate = DateTime.Now;
_dbContext.XiangMuZuYuan.Add(zy);
}
}
}
//经费
if (entity.JingFeis != null)
{
//将除去做过删除操作的元素
var jfIds = entity.JingFeis.Select(p => p.Id);
var delRange = _dbContext.JingFei.Where(p => p.XiangMuId == entity.Id && !jfIds.Contains(p.Id));
_dbContext.JingFei.RemoveRange(delRange);
foreach (var jf in entity.JingFeis)
{
if (_dbContext.JingFei.Any(p => p.Id == jf.Id))
{
var jfInstance = _dbContext.JingFei.Find(jf.Id);
jf.LastUpdateDate = DateTime.Now;
_mapper.Map(jf, jfInstance, typeof(JingFei), typeof(JingFei));
}
else
{
jf.XiangMuId = entity.Id;
jf.CreateDate = jf.LastUpdateDate = DateTime.Now;
_dbContext.JingFei.Add(jf);
}
}
}
_dbContext.SaveChanges();
singleResult.Result = true;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
public SingleResult <bool> AddXiangMuChengGuo(ChengGuoRequest_Bag chengGuoRequest_Bag)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var chengguo = chengGuoRequest_Bag.xiangMuChengGuo;
var fengmianList = chengGuoRequest_Bag.fengmianList;
var fileList = chengGuoRequest_Bag.fileList;
var articleList = chengGuoRequest_Bag.articleList;
var wenjianList = chengGuoRequest_Bag.wenjianList;
var cUser = _fapContext.CurrentUser;
if (fengmianList != null && fileList != null && articleList != null)
{
wenjianList = null;
}
try
{
if (chengguo.Id == Guid.Empty)
{
chengguo.Id = Guid.NewGuid();
chengguo.BuMenId = OrgHelper.GetBuMenId(cUser);
chengguo.BuMenMingCheng = OrgHelper.GetBuMenMingCheng(cUser);
chengguo.ZuoZeId = cUser.Id;
chengguo.PaiXu = 1;
chengguo.Stadus = 0;
chengguo.CreateDate = chengguo.LastUpdateDate = DateTime.Now;
_dbContext.XiangMuChengGuo.Add(chengguo);
if (chengguo.ChengGuoLeiXing == 0 || chengguo.ChengGuoLeiXing == 1 || chengguo.ChengGuoLeiXing == 2)
{ //期刊封面
if (fengmianList != null)
{
fengmianList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.ChengGuoId == chengguo.Id))
{
var single = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
single.WenJianLeiXing = x.WenJianLeiXing;
single.WenJianMingCheng = x.WenJianMingCheng;
single.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
single.LuJing = x.LuJing;
single.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
//期刊目录
if (fileList != null)
{
fileList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.ChengGuoId == chengguo.Id))
{
var single = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
single.WenJianLeiXing = x.WenJianLeiXing;
single.WenJianMingCheng = x.WenJianMingCheng;
single.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
single.LuJing = x.LuJing;
single.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
//上传文章页面
if (articleList != null)
{
articleList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.ChengGuoId == chengguo.Id))
{
var single = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
single.WenJianLeiXing = x.WenJianLeiXing;
single.WenJianMingCheng = x.WenJianMingCheng;
single.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
single.LuJing = x.LuJing;
single.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
}
else
{
//上传附件
if (wenjianList != null)
{
wenjianList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.ChengGuoId == chengguo.Id))
{
var single = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
single.WenJianLeiXing = x.WenJianLeiXing;
single.WenJianMingCheng = x.WenJianMingCheng;
single.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
single.LuJing = x.LuJing;
single.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
}
}
else
{
if (_dbContext.XiangMuChengGuo.Any(x => x.Id == chengguo.Id))
{
var single = _dbContext.XiangMuChengGuo.SingleOrDefault(x => x.Id == chengguo.Id);
single.ZuoZeId = chengguo.ZuoZeId;
single.ZuoZeMingCheng = chengguo.ZuoZeMingCheng;
single.BuMenId = chengguo.BuMenId;
single.BuMenMingCheng = chengguo.BuMenMingCheng;
single.ChengGuoMingCheng = chengguo.ChengGuoMingCheng;
single.ChengGuoLeiXing = chengguo.ChengGuoLeiXing;
single.NianQi = chengguo.NianQi;
single.PaiXu = chengguo.PaiXu;
single.Stadus = chengguo.Stadus;
single.LastUpdateDate = chengguo.LastUpdateDate;
if (chengguo.ChengGuoLeiXing == 0 || chengguo.ChengGuoLeiXing == 1 || chengguo.ChengGuoLeiXing == 2)
{
//期刊封面
if (fengmianList != null)
{
fengmianList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.Id == x.Id))
{
var singlefengmian = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
singlefengmian.WenJianLeiXing = x.WenJianLeiXing;
singlefengmian.WenJianMingCheng = x.WenJianMingCheng;
singlefengmian.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
singlefengmian.LuJing = x.LuJing;
singlefengmian.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊封面;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
//期刊目录
if (fileList != null)
{
fileList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.Id == x.Id))
{
var singlemulu = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
singlemulu.WenJianLeiXing = x.WenJianLeiXing;
singlemulu.WenJianMingCheng = x.WenJianMingCheng;
singlemulu.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
singlemulu.LuJing = x.LuJing;
singlemulu.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.期刊目录;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
//上传文章页面
if (articleList != null)
{
articleList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.Id == x.Id))
{
var singlewenzhang = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
singlewenzhang.WenJianLeiXing = x.WenJianLeiXing;
singlewenzhang.WenJianMingCheng = x.WenJianMingCheng;
singlewenzhang.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
singlewenzhang.LuJing = x.LuJing;
singlewenzhang.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文章页面;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
}
else
{
//上传附件
if (wenjianList != null)
{
wenjianList.ForEach(x =>
{
if (_dbContext.FuJian.Any(p => p.Id == x.Id))
{
var singlefujian = _dbContext.FuJian.SingleOrDefault(d => d.Id == x.Id);
singlefujian.WenJianLeiXing = x.WenJianLeiXing;
singlefujian.WenJianMingCheng = x.WenJianMingCheng;
singlefujian.FuWuQiWenJianMingCheng = x.FuWuQiWenJianMingCheng;
singlefujian.LuJing = x.LuJing;
singlefujian.LastUpdateTime = x.LastUpdateTime;
}
else
{
x.ChengGuoId = chengguo.Id;
x.WenJianLeiXing = (int)MeiJuUtils.chengGuoFuJianLeiXing.文件附件;
x.CreateDateTime = x.LastUpdateTime = DateTime.Now;
_dbContext.FuJian.Add(x);
}
});
}
}
}
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误");
}
return(singleResult);
}
