insiderProject.DAL/AdminUser.cs

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

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

using System; 
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic; 
using System.Data;
using insiderProject.Common;
using insiderProject.Entity;
using System.Linq;
using System.Data.Entity;
using Newtonsoft.Json;

namespace insiderProject.DAL 
{
	 	//AdminUser
		public partial class AdminUser
	{

		public int Exists(int Id)
		{
			insiderProject.Entity.insiderProjectEntities tme = new insiderProject.Entity.insiderProjectEntities();
			return	tme.AdminUser.Where(p => p.Id == Id).Count();
		 
		}
		
		public int AdminUserCount(insiderProject.Entity.AdminUser admo)
		{
			insiderProject.Entity.insiderProjectEntities tme = new insiderProject.Entity.insiderProjectEntities();
			var list=tme.AdminUser.AsQueryable() ;
            var query = tme.AdminUser;
            if (admo.Id.ToString()!="0") {
				list = query.Where(p => p.Id == admo.Id);
            }
			if (!string.IsNullOrWhiteSpace(admo.username)) {
				list = query.Where(p => p.username == admo.username);
			}
			if (!string.IsNullOrWhiteSpace(admo.password))
			{
				list = query.Where(p => p.password == admo.password);
			}
			if (!string.IsNullOrWhiteSpace(admo.qq))
			{
				list = query.Where(p => p.qq == admo.qq);
			}
			if (!string.IsNullOrWhiteSpace(admo.email))
			{
				list = query.Where(p => p.email == admo.email);
			}
			if (!string.IsNullOrWhiteSpace(admo.phone))
			{
				list = query.Where(p => p.phone == admo.phone);
			}
			if (!string.IsNullOrWhiteSpace(admo.sex))
			{
				list = query.Where(p => p.sex == admo.sex);
			}
			return list.Count();

		}

		/// <summary>