schangxiang@126.com
2024-09-07 65dffc693a21462f6bfa9fd30604753a03bf6bca
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
using iWare_SCADA_BusinessLogical.DLA.Dao;
using iWare_SCADA_Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace iWare_SCADA_BusinessLogical
{
    public class DataCaptureColumnDictManager
    {
        ///// <summary>
        ///// 获取 调度系统启动相关
        ///// </summary>
        ///// <param name="edm"></param>
        ///// <returns></returns>
        //public static IList<DataCaptureColumnDict> GetCCSystem(DbModel edm)
        //{
        //    return edm.DataCaptureColumnDictList.Where(x => x.EquipmentID == "1").ToList();//.FirstOrDefault();
        //}
        /// <summary>
        /// 获取 调度系统启动相关
        /// </summary>
        /// <param name="edm"></param>
        /// <returns></returns>
        public static List<EquipmentBaseInfo> GetEquipmentBaseInfo()
        {
            using (DbModel db = new DbModel())
            {
                //
                //var a = db.EquipmentBaseInfos.Find(1);//主键为1的
                var b = db.EquipmentBaseInfo.Where(o=>o.EquipmentId=="1").ToList();
 
 
                var query = db.EquipmentBaseInfo.Where(s => s.EquipmentId == "1").ToList();//返回IQueryable 说明是延迟查询
 
                //查询所有
                var query2 = db.EquipmentBaseInfo.ToList();//这个不是延迟查询
                //var query3 = db.DataCaptureConfigs.ToList();//这个不是延迟查询       
 
                return b;
 
 
                //var ccSystem = DataCaptureColumnDictManager.GetEquipmentBaseInfo(edm);
                //if (ccSystem == null)
                //{
                //    MessageBox.Show("请联系管理员维护系统调度相关的数据!");
                //    return;
                //};
            }
            //return edm.EquipmentBaseInfos.Find;
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        public static void pageselect(int pageIndex,int pageSize)
        {
            using (DbModel db = new DbModel())
            {
                var query3 = db.EquipmentBaseInfo.Skip((pageIndex - 1) * pageSize).Take(pageSize);
            }
            //CommonDao<EquipmentBaseInfo, EquipmentBaseInfo> CommonDao=new CommonDao<EquipmentBaseInfo, EquipmentBaseInfo>();
 
        }
 
    }
}