WebClass/SectorsTypeBDL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;

namespace WebClass
{
	public class SectorsTypeBDL
	{
		public int AddSectorsType(SectorsType sectorstype)
		{
			int result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				db.AddToSectorsType(sectorstype);
				result = db.SaveChanges();
			}
			return result;
		}

		public List<SectorsType> GetSectorsTypeList()
		{
			List<SectorsType> result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				result = (from n in db.SectorsType
				where n.ParentID == (int?)0
				select n).ToList<SectorsType>();
			}
			return result;
		}

		public List<SectorsType> GetTypeByParentID(int parentID)
		{
			List<SectorsType> result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				result = (from n in db.SectorsType
				where n.ParentID == (int?)parentID
				select n).ToList<SectorsType>();
			}
			return result;
		}

		public int DeleteParentID(int typeid)
		{
			int result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				SectorsType obj = db.SectorsType.FirstOrDefault((SectorsType n) => n.TypeID == typeid);
				List<SectorsType> list = (from n in db.SectorsType
				where n.ParentID == (int?)typeid
				select n).ToList<SectorsType>();
				if (list.Count > 0)
				{
					foreach (SectorsType item in list)
					{
						db.SectorsType.DeleteObject(item);
					}
				}
				db.SectorsType.DeleteObject(obj);