insiderProject.DAL/deposit.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 
{
	 	//deposit
		public partial class deposit
	{
   		     
		public int Exists(int Id)
		{
		insiderProject.Entity.insiderProjectEntities Eny = new insiderProject.Entity.insiderProjectEntities();
			return	Eny.deposit.Where(p => p.Id == Id).Count();
		}
		public int depositCount(insiderProject.Entity.deposit admo)
		{
			insiderProject.Entity.insiderProjectEntities Eny = new insiderProject.Entity.insiderProjectEntities();

			var list=Eny.deposit.AsQueryable() ;
            var query = Eny.deposit;
            if (admo.Id.ToString()!="0") {
				list = query.Where(p => p.Id == admo.Id);
            }
																if (!string.IsNullOrWhiteSpace(admo.dmoney)) {
				list = query.Where(p => p.dmoney == admo.dmoney);
			}
																			if (!string.IsNullOrWhiteSpace(admo.dremark)) {
				list = query.Where(p => p.dremark == admo.dremark);
			}
													if (!string.IsNullOrWhiteSpace(admo.dmode)) {
				list = query.Where(p => p.dmode == admo.dmode);
			}
													if (!string.IsNullOrWhiteSpace(admo.dparentid)) {
				list = query.Where(p => p.dparentid == admo.dparentid);
			}
														
			
			return list.Count();

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