zhengcaioa.git - Gitblit

			@@ -439,6 +439,7 @@
			Contents = l.Contents,
			Sort = l.Sort,
			Classify1 = l.Classify1,
			Classify2 = l.Classify2,
			Creater = l.Creater,
			Createtime = l.Createtime,
			RecStatus = l.RecStatus,
			@@ -504,6 +505,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)
			@@ -586,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;
			}

			}
			}