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
#region
 
using System;
using System.Data;
using System.Windows.Forms;
using CSFrameworkV5.Business;
using CSFrameworkV5.Core;
using CSFrameworkV5.DataAccess;
using CSFrameworkV5.Models;
 
#endregion
 
namespace CSFrameworkV5.ClientFoundationTester
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void btnDal_Click(object sender, EventArgs e)
        {
            var user = TesterTools.Loginer;
 
            var dt = new dalCompanyInfo(user).GetSummaryData();
 
            //模拟修改一条记录
            if (dt.Rows.Count > 0)
            {
                dt.Rows[0][sys_CompanyInfo.Fax] = "0799-99992222";
                dt.Rows[0][sys_CompanyInfo.Tel] = "0799-99992222-3";
                dt.Rows[0][sys_CompanyInfo.Address] =
                    "广东省珠海市街道号-" + DateTime.Now.ToStringEx();
            }
 
            //使用数据字段基类通用方法(bllBaseDataDict.Update)提交单表数据
            var ok = bllBaseDataDict.Update(dt, typeof(sys_CompanyInfo));
 
            MessageBox.Show(ok ? "成功" : "失败");
        }
 
        private void button2_Click(object sender, EventArgs e)
        {
            //
            //DALFactory类详细功能测试
            //
            //1.创建DAL.CreateDal方法
            var dal = DALFactory.CreateDal(Loginer.CurrentUser,
                Loginer.CurrentUser.DBID, sys_CompanyInfo.__TableName);
 
            var dt = dal.GetSummaryData();
            MessageBox.Show(dt.Rows.Count.ToStringEx());
 
            //2.创建DAL.CreateDalByORM方法 - 使用ORM模型的类型
            var dal1 =
                DALFactory.CreateDalByORM(Loginer.CurrentUser,
                    typeof(tb_MyUser));
            var user = dal1.GetDataByKey("admin");
            //模拟修改一条记录
            if (user.Rows.Count > 0)
                user.Rows[0][tb_MyUser.Remark] =
                    "最后修改时间：" + DateTime.Now.ToStringEx();
 
            var ds = new DataSet();
            ds.Tables.Add(user.Copy());
            var ok = dal1.Update(ds);
            MessageBox.Show(ok ? "成功" : "失败");
 
            //3.创建DAL.CreateDalByORM方法 - 使用ORM模型类的全名
            var dal2 = DALFactory.CreateDalByORM(Loginer.CurrentUser,
                typeof(tb_MyUser).FullName);
            var user2 = dal2.GetDataByKey("admin");
            MessageBox.Show(user2.Rows.Count.ToStringEx());
 
            //4.创建DAL.CreateDalByORM方法 - 使用ORM模型类的全名
            var dal3 = DALFactory.CreateDalByTableName(Loginer.CurrentUser,
                tb_MyUser.__TableName);
            var user3 = dal3.GetDataByKey("admin");
            MessageBox.Show(user3.Rows.Count.ToStringEx());
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
            TesterTools.InitTestEnviroment();
        }
    }
}