Model/DelRequireDAL.cs

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

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

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

public class DelRequireDAL
{
	public IQueryable<DelRequire> ListAll(int subpeopleid, int step1userid, int step2userid, int dangqianbuzhouid, bool? ispass, DateTime? searchdatetime1, DateTime? searchdatetime2)
	{
		IQueryable<DelRequire> result;
		using (huadushuiEntities huadushuiEntities = new huadushuiEntities())
		{
			IQueryable<DelRequire> queryable = from m in huadushuiEntities.tb_delrequire
			where (subpeopleid > 0) ? (m.subpeopleid == (int?)subpeopleid) : true
			where (step1userid > 0) ? (m.step1userid == (int?)step1userid) : true
			where (step2userid > 0) ? (m.step2userid == (int?)step2userid) : true
			where (dangqianbuzhouid > 0) ? (m.dangqianbuzhouid == (int?)dangqianbuzhouid) : true
			where ispass.HasValue ? (m.ispass == ispass) : true
			where searchdatetime1.HasValue ? (m.subtime >= searchdatetime1) : true
			where searchdatetime2.HasValue ? (m.subtime <= searchdatetime2) : true
			select m into delrequire
			select new DelRequire
			{
				id = delrequire.id,
				xiangguanid = delrequire.xiangguanid,
				type = delrequire.type,
				reason = delrequire.reason,
				subpeople = delrequire.subpeople,
				subpeopleid = delrequire.subpeopleid,
				subtime = delrequire.subtime,
				step1userid = delrequire.step1userid,
				step1user = delrequire.step1user,
				step1time = delrequire.step1time,
				step2userid = delrequire.step2userid,
				step2user = delrequire.step2user,
				step2time = delrequire.step2time,
				ispass = delrequire.ispass,
				dangqianbuzhouid = delrequire.dangqianbuzhouid,
				step3userid = delrequire.step3userid,
				step3user = delrequire.step3user,
				step3time = delrequire.step3time,
				step4userid = delrequire.step4userid,
				step4user = delrequire.step4user,
				step4time = delrequire.step4time,
				URL = delrequire.URL
			};
			result = queryable;
		}
		return result;
	}

	public int DeldelRequire(int[] ids)
	{
		int result = 0;
		using (huadushuiEntities huadushuiEntities = new huadushuiEntities())
		{
			IQueryable<tb_delrequire> queryable = from m in huadushuiEntities.tb_delrequire
			where ids.Contains(m.id)
			select m;