1

yhj

2024-07-24 5e5d945e91568b973faa27d8ab0bcef99fc4a6c5

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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
#region
 
using System;
using System.Data;
using CSFrameworkV5.Core;
using CSFrameworkV5.Core.CodeGenerator;
using CSFrameworkV5.Models;
 
///*************************************************************************/
///*
///* 文件名    ：dalMenu.cs                                
///* 程序说明  : 菜单数据字典的DAL层
///* 原创作者  ：www.csframework.com 
///* 
///* Copyright 2006-2021 wwww.csframework.com, 保留所有权利.
///*
///**************************************************************************/
 
#endregion
 
namespace CSFrameworkV5.DataAccess
{
    /// <summary>
    ///     菜单数据字典的DAL层
    /// </summary>
    [DefaultORM_UpdateMode(typeof(tb_MyMenu), true)]
    public class dalMenu : dalBaseDataDict
    {
        public dalMenu(Loginer loginer)
            : base(loginer)
        {
            _KeyName = tb_MyMenu.__KeyName;
            _TableName = tb_MyMenu.__TableName;
            _ModelType = typeof(tb_MyMenu);
            _Database = DatabaseProvider.SystemDatabase;
        }
 
        /// <summary>
        ///     根据表名获取该表的SQL命令生成器
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        protected override IGenerateSqlCommand CreateSqlGenerator(
            DataTable table)
        {
            Type ORM = null;
 
            if (table.TableName == tb_MyMenu.__TableName)
                ORM = typeof(tb_MyMenu);
 
            if (table.TableName == tb_MyFormTagName.__TableName)
                ORM = typeof(tb_MyFormTagName);
 
            if (ORM == null) throw new Exception(table.TableName + "表没有ORM模型！");
 
            //支持两种SQL命令生成器
            return new GenerateSqlCmdByTableFields(ORM, table,
                GeneratorFactory);
        }
 
        /// <summary>
        ///     根据菜单名删除
        /// </summary>
        /// <param name="keyValue">菜单名, menuName</param>
        /// <returns></returns>
        public override bool Delete(string keyValue)
        {
            var sp = _Database.CreateSqlProc("usp_DeleteMenu");
            sp.AddParam("MenuName", DbType.String, keyValue);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            var i = _Database.ExecuteCommand(sp.Command);
            return true;
        }
 
        public override DataTable GetDataDictByTableName(string tableName)
        {
            if (string.IsNullOrEmpty(tableName)) throw new Exception("表名不能为空！");
 
            var sql =
                $"SELECT * FROM {tableName} WHERE DataSetID={_Database.ParamSymboName}DataSetID ORDER BY ModuleID";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("DataSetID", _Loginer.DBID);
            return _Database.GetTable(cmd.Command, TableName);
        }
 
        public DataTable GetMenuPicker()
        {
            var sql =
                $"SELECT ModuleID,MenuName,MenuCaption FROM tb_MyMenu WHERE DataSetID={_Database.ParamSymboName}DataSetID AND MenuCaption<>{_Database.ParamSymboName}MenuCaption ORDER BY ModuleID";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("DataSetID", _Loginer.DBID);
            cmd.AddParam("MenuCaption", "-");
            return _Database.GetTable(cmd.Command, TableName);
        }
 
        public override DataTable GetSummaryData()
        {
            AssertTableName();
            var sql =
                $"SELECT * FROM {TableName} WHERE DataSetID={_Database.ParamSymboName}DataSetID ORDER BY ModuleID";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("DataSetID", _Loginer.DBID);
            return _Database.GetTable(cmd.Command, TableName);
        }
    }
}