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
#region
 
using System.Data;
using CSFramework.DB;
using CSFrameworkV5.CodeGeneratorCore;
using CSFrameworkV5.Core;
using CSFrameworkV5.DataAccess;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Models;
using CSFrameworkV5.WebRef;
 
#endregion
 
namespace CSFrameworkV5.Business
{
    /// <summary>
    ///     BLL业务逻辑层:blltest 2022-5-1
    /// </summary>
    public class blltest : bllBaseDataDict
    {
        public static DatabaseMSSQL mSSQL;
 
        private dalPURDHA _DAL; //自定义策略接口(桥接层)
 
        //IBridge_Language _Bridge;
        public blltest()
        {
            _KeyFieldName = PURDHA.__KeyName; //主键字段
            _SummaryTableName = PURDHA.__TableName; //表名
            _WriteDataLog = false; //是否保存数据操作日志
            _DataDictBridge =
                DALFactory.CreateDalByORM(Loginer.CurrentUser,
                    typeof(PURDHA)); //数据字典通用DAL层实例
            _DAL = new dalPURDHA(Loginer.CurrentUser); //DAL层实例         
        }
 
        /// <summary>
        ///     创建自定义策略接口(桥接层)实例
        /// </summary>
        /// <returns></returns>
        private IBridge_Language CreateBridge()
        {
            if (BridgeFactory.IsADODirect) //直连模式
                return new dalPURDHA(Loginer.CurrentUser);
 
            //如需要开发Web服务代理层，参考WebRef模块WebService_Customer.cs文件
            if (BridgeFactory.IsWCFBridge) return new WCF_Language();
 
            throw new CustomException(BridgeFactory.UNKNOW_BRIDGE_TYPE);
        }
 
        public bool QueryDelete(DataTable dr, string tableName, string KEY)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            //DataSet dZ = new DataSet();
            //dZ.Tables.Add(dF.Copy());
            var T = mSSQL.DeleteDataSet(dr, tableName, KEY);
            return T;
        }
 
        public bool QuerySave(DataTable dr, string tableName)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            var T = mSSQL.AddTable(dr, tableName);
            return T;
        }
 
        public DataTable QueryT()
        {
            var dt = _DAL.Query();
            return dt;
        }
 
        public bool QueryUpdata(DataTable dF, string tableName, string KEY)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            //DataSet dZ = new DataSet();
            //dZ.Tables.Add(dF.Copy());
            var T = mSSQL.UpdateDataSet(dF, tableName, KEY);
 
            return T;
        }
        //public DataTable Query(String ObjectID, String CHS, String CHT, String ENG, String DataType)
        //{
        //    DataTable dt = _Bridge.Query(ObjectID, CHS, CHT, ENG, DataType);
        //    _SummaryTable = dt;
        //    return dt;
        //}
 
        //internal DataTable GetTypeData()
        //{
        //    return _Bridge.GetLanguageTypeData();
        //}
 
        //public DataTable GetLanguageData()
        //{
        //    return _Bridge.GetLanguageData();
        //}
 
        //public bool PostLanguage(string lanType, string objectID, string defaultValue, string itemType)
        //{
        //    return _Bridge.PostLanguage(lanType, objectID, defaultValue, itemType);
        //}
    }
}