zhengcaioa.git - Gitblit

			@@ -33,11 +33,11 @@
			(searchEntity.Comments == "" ? true : s.Comments.Contains(searchEntity.Comments)) &&
			(searchEntity.RecStatus == "" ? s.RecStatus == "A" : s.RecStatus == searchEntity.RecStatus)
			).ToList();
			if (searchEntity.totalrows == 0)
			{
			//if (searchEntity.totalrows == 0)
			//{
			//获取总数
			searchEntity.totalrows = listCode.Count;
			}
			//}
			var list = listCode.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
			var listSysCode = new List<SysCodeEntity>();
			if (list.Count > 0)
			@@ -402,15 +402,25 @@
			(string.IsNullOrWhiteSpace(searchEntity.Comments) ? true : a.Comments.Contains(searchEntity.Comments)) &&
			(string.IsNullOrWhiteSpace(searchEntity.CodeSn) ? true : a.CodeSn.Contains(searchEntity.CodeSn)) &&
			(string.IsNullOrWhiteSpace(searchEntity.Contents) ? true : a.Contents.Contains(searchEntity.Contents)) &&
			(string.IsNullOrWhiteSpace(searchEntity.WentiId) ? true : a.Contents == searchEntity.WentiId)
			(string.IsNullOrWhiteSpace(searchEntity.WentiId) ? true : a.Contents == searchEntity.WentiId) &&
			(string.IsNullOrWhiteSpace(searchEntity.Classify1) ? true : a.Classify1.Contains(searchEntity.Classify1))
			select a
			).OrderBy(x=>x.Sort).ToList();

			if (searchEntity.totalrows == 0)
			if (!string.IsNullOrEmpty(searchEntity.Sort))
			{
			listCode = listCode.OrderBy(x => x.CodeSn).ToList();
			}
			else if (!string.IsNullOrEmpty(searchEntity.Sort1))
			{
			listCode = listCode.OrderBy(x => x.Classify1).ThenBy(x=>x.CodeSn).ToList();
			}

			//if (searchEntity.totalrows == 0)
			//{
			//获取总数
			searchEntity.totalrows = listCode.Count;
			}
			//}
			var list = listCode.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
			var listSysCode = new List<SysCodeDtlEntity>();

			@@ -428,7 +438,8 @@
			Comments = l.Comments,
			Contents = l.Contents,
			Sort = l.Sort,

			Classify1 = l.Classify1,
			Classify2 = l.Classify2,
			Creater = l.Creater,
			Createtime = l.Createtime,
			RecStatus = l.RecStatus,
			@@ -468,6 +479,7 @@
			alldtl.Createtime = model.Createtime;
			alldtl.Modifier = model.Modifier;
			alldtl.Modifytime = model.Modifytime;
			alldtl.Classify1 = model.Classify1;
			alldtl.CreatetimeStr = model.Createtime.ToString();
			alldtl.RecStatusName = model.RecStatus.ToString().Equals("A") ? "启用" : "停用";
			}
			@@ -495,6 +507,68 @@
			return alldtl;
			}

			public List<SysCodeDtlEntity> GetSysCodeDtlInfoss(string Classify1, string CodeTable, string CodeField, string WentiId = "")
			{


			List<SysCodeDtlEntity> sysCodeDtlEntities = new List<SysCodeDtlEntity>();
			var models = _context.SysCodeDtls.Where(x => x.Classify1 == Classify1).OrderBy(x=>x.CodeSn).ToList(); ;


			if (models != null&& models.Count>0)
			{
			foreach (var model in models)
			{
			var alldtl = new SysCodeDtlEntity();
			alldtl.Id = model.Id;
			alldtl.CodeId = model.CodeId;
			alldtl.CodeSn = model.CodeSn;
			alldtl.Comments = model.Comments;
			alldtl.Contents = model.Contents;
			alldtl.Sort = model.Sort;
			alldtl.RecStatus = model.RecStatus;
			alldtl.Creater = model.Creater;
			alldtl.Createtime = model.Createtime;
			alldtl.Modifier = model.Modifier;
			alldtl.Modifytime = model.Modifytime;
			alldtl.Classify1 = model.Classify1;
			alldtl.Classify2 = model.Classify2;
			alldtl.CreatetimeStr = model.Createtime.ToString();
			alldtl.RecStatusName = model.RecStatus.ToString().Equals("A") ? "启用" : "停用";
			sysCodeDtlEntities.Add(alldtl);
			}


			}
			else
			{
			var alldtl = new SysCodeDtlEntity();
			var syscode = _context.SysCodes.Where(x => x.RecStatus == "A" && x.CodeTable == CodeTable && x.CodeField == CodeField).FirstOrDefault();
			if (syscode != null)
			{
			alldtl.Contents = WentiId;
			alldtl.CodeId = syscode.Id;
			}


			alldtl.Classify1 = Classify1;
			sysCodeDtlEntities.Add(alldtl);
			}












			return sysCodeDtlEntities;
			}

			public ResultEntity SaveSysCodeDtl(SysCodeDtlEntity Entity)
			{
			var resultEntity = new ResultEntity();
			@@ -504,6 +578,17 @@
			resultEntity.Result = true;
			try
			{
			if (!string.IsNullOrEmpty(Entity.CodeSn))
			{
			var list = _context.SysCodeDtls.Where(e => e.CodeSn == Entity.CodeSn && e.RecStatus == "A" && e.Id != Entity.Id && e.CodeId == Entity.CodeId).ToList();
			if (list.Count > 0)
			{
			resultEntity.Result = false;
			resultEntity.Message = "该编码已经存在";
			return resultEntity;
			}
			}


			if (!string.IsNullOrEmpty(Entity.Id))
			{
			@@ -517,6 +602,7 @@
			mModel.Contents = Entity.Contents + "";
			mModel.Sort = Entity.Sort;
			mModel.RecStatus = "A";
			mModel.Classify1 = Entity.Classify1;

			mModel.Modifier = Entity.Modifier;
			mModel.Modifytime = Entity.Modifytime;
			@@ -545,7 +631,8 @@
			Creater = Entity.Modifier,
			Createtime = Entity.Modifytime,
			Modifier = Entity.Modifier,
			Modifytime = Entity.Modifytime
			Modifytime = Entity.Modifytime,
			Classify1 = Entity.Classify1,
			});


			@@ -562,5 +649,148 @@

			return resultEntity;
			}


			public ResultEntity SaveSysCodeDtls(SysCodeDtlEntity Entity)
			{
			var resultEntity = new ResultEntity();


			//事务
			resultEntity.Result = true;
			try
			{


			var sysCodeDtls = _context.SysCodeDtls.Where(x => x.RecStatus == "A" && x.CodeId == Entity.CodeId && x.Classify1 == Entity.Classify1).ToList();
			if (sysCodeDtls != null && sysCodeDtls.Count > 0)
			{
			foreach (var sysCodeDtl in sysCodeDtls)
			{
			_context.SysCodeDtls.Remove(sysCodeDtl);
			}
			}

			var CodeSns = Entity.CodeSns;
			if (CodeSns != null && CodeSns.Length > 0)
			{
			for (int i = 0; i < CodeSns.Length; i++)
			{
			if (!string.IsNullOrEmpty(Entity.CodeSns[i]) \|\| !string.IsNullOrEmpty(Entity.Commentss[i]) )
			{
			_context.SysCodeDtls.Add(new SysCodeDtl()
			{
			Id = Guid.NewGuid().ToString(),
			CodeSn = Entity.CodeSns[i],
			RoleId = "",
			CodeId = Entity.CodeId,
			Comments = Entity.Commentss[i],
			Contents = Entity.Contentss[i],
			Sort = Entity.Sorts[i],
			RecStatus = "A",
			Creater = Entity.Modifier,
			Createtime = Entity.Modifytime,
			Modifier = Entity.Modifier,
			Modifytime = Entity.Modifytime,
			Classify1 = Entity.Classify1,
			Classify2 = Entity.Classify2s[i],
			});
			}
			}
			}




			_context.SaveChanges();

			}
			catch (Exception ex)
			{
			resultEntity.Message = "信息保存失败，请联系管理人员。" + ex.Message; ;
			resultEntity.Result = false;

			}

			return resultEntity;
			}


			public ResultEntity addSysCodeDtls(SysCodeDtlEntity Entity)
			{
			var resultEntity = new ResultEntity();


			//事务
			resultEntity.Result = true;
			resultEntity.ReturnID = "";
			try
			{


			//var sysCodeDtls = _context.SysCodeDtls.Where(x => x.RecStatus == "A" && x.CodeId == Entity.CodeId && x.Classify1 == Entity.Classify1).ToList();
			//if (sysCodeDtls != null && sysCodeDtls.Count > 0)
			//{
			// foreach (var sysCodeDtl in sysCodeDtls)
			// {
			// _context.SysCodeDtls.Remove(sysCodeDtl);
			// }
			//}

			var CodeSns = Entity.CodeSns;
			if (CodeSns != null && CodeSns.Length > 0)
			{
			for (int i = 0; i < CodeSns.Length; i++)
			{
			if (!string.IsNullOrEmpty(Entity.CodeSns[i]) \|\| !string.IsNullOrEmpty(Entity.Commentss[i]))
			{
			var id = Guid.NewGuid().ToString();
			_context.SysCodeDtls.Add(new SysCodeDtl()
			{
			Id = id,
			CodeSn = Entity.CodeSns[i],
			RoleId = "",
			CodeId = Entity.CodeId,
			Comments = Entity.Commentss[i],
			Contents = Entity.Contentss[i],
			Sort = Entity.Sorts[i],
			RecStatus = "A",
			Creater = Entity.Modifier,
			Createtime = Entity.Modifytime,
			Modifier = Entity.Modifier,
			Modifytime = Entity.Modifytime,
			Classify1 = Entity.Classify1,
			Classify2 = Entity.Classify2s[i],
			});

			if(i == CodeSns.Length - 1)
			{
			resultEntity.ReturnID += Entity.CodeSns[i];
			}
			else
			{
			resultEntity.ReturnID += Entity.CodeSns[i] + ",";
			}

			}
			}
			}




			_context.SaveChanges();

			}
			catch (Exception ex)
			{
			resultEntity.Message = "信息保存失败，请联系管理人员。" + ex.Message; ;
			resultEntity.Result = false;

			}

			return resultEntity;
			}

			}
			}