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);
|
}
|
}
|
}
|
