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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
#region
 
using System;
using System.Data;
using System.Text;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Core.CodeGenerator;
using CSFrameworkV5.Interfaces.Bridge;
using CSFrameworkV5.Models;
 
#endregion
 
namespace CSFrameworkV5.DataAccess
{
    /// <summary>
    ///     DAL数据层:dal_DocNoRule
    /// </summary>
    [DefaultORM_UpdateMode(typeof(sys_DocNoRule), true)]
    public class dal_DocNoRule : dalBaseDataDict, IBridge_DocNoRule
    {
        /// <summary>
        ///     构造器
        /// </summary>
        /// <param name="loginer">当前登录用户</param>
        public dal_DocNoRule(Loginer loginer)
            : base(loginer)
        {
            _KeyName = sys_DocNoRule.__KeyName; //主键字段
            _TableName = sys_DocNoRule.__TableName; //表名
            _ModelType = typeof(sys_DocNoRule); //指定ORM模型
            _UpdateSummaryKeyMode = UpdateKeyMode.None;
        }
 
        public bool CheckNoExistsEx(string DBID, string docCode)
        {
            var sql =
                $"SELECT COUNT(*) FROM sys_DocNoRule WHERE DocCode={_Database.ParamSymboName}DocCode";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("DocCode", docCode);
            object o = DatabaseProvider.GetDatabase(DBID)
                .ExecuteCommand(cmd.Command);
            return ConvertEx.ToInt(o) > 0;
        }
 
        public bool Delete(string DBID, string keyValue)
        {
            var sql =
                $"DELETE FROM sys_DocNoRule WHERE RowID={_Database.ParamSymboName}RowID";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("RowID", keyValue);
            object o = DatabaseProvider.GetDatabase(DBID)
                .ExecuteCommand(cmd.Command);
            return ConvertEx.ToInt(o) > 0;
        }
 
        public DataTable GetData(string DBID)
        {
            var db = DatabaseProvider.GetDatabase(DBID);
            var sql = "SELECT * FROM sys_DocNoRule ORDER BY DocCode; ";
            var cmd = db.CreateCommand(sql);
            return db.GetTable(cmd.Command, sys_DocNoRule.__TableName);
        }
 
        public DataTable GetDataByKey(string DBID, string keyValue)
        {
            var sql =
                $"SELECT * FROM sys_DocNoRule WHERE RowID={_Database.ParamSymboName}RowID";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("RowID", keyValue);
            return DatabaseProvider.GetDatabase(DBID)
                .GetTable(cmd.Command, sys_DocNoRule.__TableName);
        }
 
        public DataTable Search(string DBID, string DocCode)
        {
            var cmd = _Database.CreateCommand("");
 
            var sb = new StringBuilder();
            sb.Append("SELECT * FROM sys_DocNoRule WHERE 1=1 ");
 
            if (!string.IsNullOrEmpty(DocCode))
            {
                sb.Append($" AND DocCode ={_Database.ParamSymboName}DocCode");
                cmd.AddParam("DocCode", DocCode);
            }
 
            sb.Append(" ORDER BY StationCode,DocCode;");
 
            cmd.Command.CommandText =
                CodeSafeHelper.GetSafeSQL(sb.ToStringEx());
 
            return DatabaseProvider.GetDatabase(DBID)
                .GetTable(cmd.Command, sys_DocNoRule.__TableName);
        }
 
        public bool UpdateToDB(string DBID, DataTable data)
        {
            var dal = new dal_DocNoRule(_Loginer);
            dal.Database = DatabaseProvider.GetDatabase(DBID);
            var ds = new DataSet();
            ds.Tables.Add(data.Copy());
            return dal.Update(ds);
        }
 
        /// <summary>
        ///     根据表名获取该表对应的SQL命令生成器
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        protected override IGenerateSqlCommand CreateSqlGenerator(
            DataTable table)
        {
            Type ORM = null;
            if (table.TableName == sys_DocNoRule.__TableName)
                ORM = typeof(sys_DocNoRule);
 
            if (ORM == null) throw new Exception(table.TableName + "表没有ORM模型！");
 
            //静态类模型SQL命令生成器
            return new GenerateSqlCmdByTableFields(ORM, table,
                GeneratorFactory);
 
            //对象实体类模型SQL命令生成器
            //return new GenerateSqlCmdByObjectClass(ORM, table, this.GeneratorFactory);
        }
    } //public class
} //namespace