Repository navigation
Expand file tree
/
Copy pathUnitTest.cs
More file actions
66 lines (58 loc) · 2.3 KB
/
Copy pathUnitTest.cs
File metadata and controls
66 lines (58 loc) · 2.3 KB
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
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Utility.Data;
using Utility.WebForm;
namespace TestLibrary
{
[TestClass]
public class UnitTest
{
const string ConnStr = "Server=.; Database=Test; User ID=sa; Password=123;";
const string TableName = "Profile";
SqlConnection conn = new SqlConnection(ConnStr);
[TestMethod]
public List<SqlParameter> CreateParameter(string name, string sex, string bornDate)
{
return new List<SqlParameter>()
{
new SqlParameter("@Name", name) { SourceColumn = "Name LIKE" } ,
new SqlParameter("@Sex", sex) { SourceColumn = "Sex LIKE" },
new SqlParameter("@BornDate", bornDate) { SourceColumn = "BornDate >=" }
};
}
[TestMethod]
public void BuildSql()
{
var args = this.CreateParameter("Jack", "男", "1989-10-10");
args.Add("@IDcardNumber", "123456789", "IDCardNumber =");
args.Add("@Address", "东莞市", "Address =");
string insert_sql = args.BuildInsertSql(TableName);
string delete_sql = args.BuildDeleteSql(TableName);
}
[TestMethod]
public void NonQuery()
{
SqlConnection conn = new SqlConnection(ConnStr);
var args = this.CreateParameter("Jack", "男", "1989-10-10");
args.Add("@IDcardNumber", "123456789", "IDCardNumber =");
args.Add("@Address", "东莞市", "Address =");
string insert_sql = args.BuildInsertSql(TableName);
conn.ExecuteNonQuery(insert_sql, args);
string delete_sql = args.BuildDeleteSql(TableName);
conn.ExecuteNonQuery(delete_sql, args);
}
[TestMethod]
public void ConvertToParameter()
{
IDataParameter param = ControlTool.ConvertToParameter<SqlParameter>("Name$lr", "J");
param.ParameterName = @"@Name";
SqlConnection conn = new SqlConnection(ConnStr);
var args = new IDataParameter[] { param };
string insert_sql = args.BuildInsertSql(TableName);
conn.ExecuteNonQuery(insert_sql, args);
}
}
}