insiderProject.DAL/card.cs

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

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

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

namespace insiderProject.DAL 
{
	 	//card
		public partial class card
	{
   		     
		public int Exists(int Id)
		{
		insiderProject.Entity.insiderProjectEntities Eny = new insiderProject.Entity.insiderProjectEntities();
			return	Eny.card.Where(p => p.Id == Id).Count();
		}
		public int cardCount(insiderProject.Entity.card admo)
		{
			insiderProject.Entity.insiderProjectEntities Eny = new insiderProject.Entity.insiderProjectEntities();

			var list=Eny.card.AsQueryable() ;
            var query = Eny.card;
            if (admo.Id.ToString()!="0") {
				list = query.Where(p => p.Id == admo.Id);
            }
																if (!string.IsNullOrWhiteSpace(admo.cname)) {
				list = query.Where(p => p.cname == admo.cname);
			}
													if (!string.IsNullOrWhiteSpace(admo.cdiscount)) {
				list = query.Where(p => p.cdiscount == admo.cdiscount);
			}
													if (!string.IsNullOrWhiteSpace(admo.cmoney)) {
				list = query.Where(p => p.cmoney == admo.cmoney);
			}
														
			
			return list.Count();

		}
				
		
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(insiderProject.Entity.card admo)
		{
		insiderProject.Entity.insiderProjectEntities Eny = new insiderProject.Entity.insiderProjectEntities();
		Eny.card.Add(admo);
			return Eny.SaveChanges();
		}
		
		
		/// <summary>
		/// 更新一条数据
		/// </summary>