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
using CSFramework.DB;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
 
namespace CSFramework.DBTester
{
    static class Program
    {
        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.ThreadException += Application_ThreadException;
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
 
 
 
            ////isid是自增字段
            //sys_Log log = new sys_Log
            //{
            //    DocNo = "doc0123412341234",
            //    GUID32 = "2345234523452435",
            //    LogDate = DateTime.Now,
            //    LogUser = "admin",
            //    OPType = 1,
            //};
 
            var conn = "Server=.;Database=CSFrameworkV5_Normal;User ID=sa;Password=test; Max Pool Size=512; Pooling=true;Connect Timeout=30";
            IDatabase db = DatabaseFactory.CreateSqlDatabase(conn);
            var list = db.meta_GetStoreProcList();
            return;
 
            ////实例化DbCommand生成器
            //DbCommandGenerator g = new DbCommandGenerator(db);
 
            ////测试案例1 - 获取标识有特性(Attribute)的字段
            //var list = g.GetAttributeFields(typeof(sys_Log), typeof(KeyField));
            //var list2 = g.GetAttributeFields(typeof(sys_Log), typeof(IgnoreField));
 
            ////测试案例2
            //var m5 = g.GetTableName(typeof(sys_Log));
            //var m1 = g.GetDeleteCommand(typeof(sys_Log));
            //var m2 = g.GetDeleteCommand<sys_Log>(log);
            //var m3 = g.GetInsertCommand(typeof(sys_Log));
            //var m4 = g.GetInsertCommand<sys_Log>(log);            
            //var m6 = g.GetUpdateCommand(typeof(sys_Log));
            //var m7 = g.GetUpdateCommand<sys_Log>(log);
 
            //new DbFramework(db).AddObject<sys_Log>(log, new string[] { "isid", "DocNo" });//旧的使用方法
            //new DbFramework(db).AddObject<sys_Log>(log, "isid", "DocNo"); //新方法：params 参数形式
            //List<sys_Log> list2 = new DbFramework(db).Select<sys_Log>();//新增功能：返回所有对象
            //sys_Log one = new DbFramework(db).Select<sys_Log>("isid", 1);//新增功能：根据关键字返回一个对象
 
 
 
            //byte[] ts = new byte[] { 0, 0, 0, 0, 0, 20, 12, 229 };
 
 
            //var s = TimeStampTool.TimestampToString(ts);
 
            //var st = TimeStampTool.strToHexByte(s);
 
            //var d1 = TimeStampTool.FromBytes(ts);
 
            //long lo = Math.Abs(BitConverter.ToInt64(ts, 0));
            //var ss = TimeSpan.FromTicks(lo);
 
            //string sql = "select * from aaa汉字表";
            //if (sql.Substring(sql.Length - 1, 1) != ";") sql = sql + ";";
 
            Application.Run(new frmTestDB());
            //Application.Run(new frmSQLConcurrentTester());
        }
 
 
 
        private static void Application_ThreadException(object sender, System.Threading.ThreadExceptionEventArgs e)
        {
            MessageBox.Show(e.Exception.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }
}