/// <summary>
/// 加载数据库的表
/// </summary>
private List <BaseTable> LoadBaseTable()
{
string BaseType = DataConnection.DBInfo.BaseName;
DataTable dt = new DataTable();
if (BaseType == EDType.MySQL.ToString())
{
MySQLBSHelper MySQL = new MySQLBSHelper(PComm.ConnectionName);
dt = MySQL.BsDataTable($"select table_name as TableName from information_schema.tables where table_schema = '{DataConnection.DBInfo.DataName}' order by TABLE_NAME asc ");
}
else if (BaseType == EDType.SQLServer.ToString())
{
SQLServerBSHelper SqlServer = new SQLServerBSHelper(PComm.ConnectionName);
dt = SqlServer.BsDataTable("SELECT name as TableName FROM SysObjects Where XType = 'U' or XType='V' ORDER BY Name");
}
return(dt.ToModel <BaseTable>());
}
public void TestMethod1()
{
GDModel.SQLModel Model = new GDModel.SQLModel();
List <GDModel.SQLModel> ListModel = new List <GDModel.SQLModel>();
ListModel.OrderByDescending(o => o.Value);
SQLServerBSHelper helper = new SQLServerBSHelper();
GDTable dt = new GDTable()
{
Id = -1,
Money = 0,
DateTime = DateTime.Now,
Float = 0,
Name = $"测试{DateTime.Now.ToString("yyyyMMddhhmmssffff")}",
Nums = 0,
Sex = false,
State = GDTable.States
.启用,
Rember = "一大段文字。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。",
};
List <GDTable> GDList = new List <GDTable>();
for (int i = 0; i < 10; i++)
{
dt.Nums = i;
GDList.Add(dt);
}
//插入返回自增Id：测试通过
//int it = helper.GDAddGetId(dt);
//插入一条数据：测试通过
//bool r = helper.GDAdd(dt);
//批量插入数据：测试通过（insert into table values(),(),(),(),(),(),(),(),()）
//bool r = helper.GDAddBatch(GDList);
//更新数据：
GDTable updatedt = new GDTable()
{
Id = 64,
Money = 1,
DateTime = DateTime.Now,
Float = 1,
Name = $"Update1测试{DateTime.Now.ToString("yyyyMMddhhmmssffff")}",
Nums = 1,
Sex = true,
State = GDTable.States.启用,
Rember = "Update1一大段文字",
};
//根据条件更新表数据：测试通过
//bool r = helper.GDUpdate(updatedt,w=>w.Id==1);
//根据主键更新表数据：测试通过
//bool r = helper.GDUpdateByKey(updatedt);
//删除数据：测试通过
//bool r = helper.GDelete(updatedt, w => w.Sex==false);
//根据主键删除表数据：测试通过
//bool r = helper.GDeleteByKey(updatedt);
/////************-------查询单个表Start----------***********/////
//查询一条数据：测试通过
//var info = helper.GDInfo(updatedt,w=>w.Id==1);
//查询多条数据无排序默认主键倒叙：测试通过
var l = GDList.AsQueryable();
l = l.Where(w => w.Id == 1);
l = l.Where(w => w.Nums == 1);
//var list1 = helper.GDList(updatedt, o => o.Id == 1);
//var list11 = helper.GDList(l);
//查询多条数据排序倒叙：测试通过
//var list2 = helper.GDList(updatedt, o => o.Id == 1, o => o.Id);
//var list22 = helper.GDList(l, o => o.Id);
//查询多条数据排序：测试通过
//var list3 = helper.GDList(updatedt, null, o => new { o.Id, o.Nums }, SQLEnum.SortType.Asc);
//var list33 = helper.GDList(l, o => o.Id, SQLEnum.SortType.Asc);
//分页：测试通过
//var Pading1 = helper.GDPaging(updatedt, o => o.Id == 1, 1, 5);
//var Pading11 = helper.GDPaging(l, 1, 5);
//分页：测试通过
//var Pading2 = helper.GDPaging(updatedt, null, o => o.Id, 1, 5);
//var Pading22 = helper.GDPaging(l, o => o.Id, 1, 5);
//分页：测试通过
//var Pading3 = helper.GDPaging(updatedt, null, o => o.Id, SQLEnum.SortType.Asc, 2, 5);
//var Pading33 = helper.GDPaging(l, o => o.Id, SQLEnum.SortType.Asc, 1, 5);
/////************-------查询单个表End----------***********/////
/////************-------查询多个表Start----------***********/////
//多表查询
//var searchmore = helper.GDMergerSearch(helper.GDCodition(new GDTable(), o => o.Id == 1, q => q.Id), helper.GDCodition(new GDTable(), o => o.Id == 2, q => q.Id));
//var r1 = helper.As<GDTable>(searchmore[0]);
//var r2 = helper.As<GDTable>(searchmore[1]);
//多表执行
var morex = helper.GDMergerExecute(helper.GDCodition(new GDTable()
{
Money = 1,
DateTime = DateTime.Now,
Float = 1,
Name = $"Update1测试{DateTime.Now.ToString("yyyyMMddhhmmssffff")}",
Nums = 8,
Sex = true,
State = GDTable.States.启用,
Rember = "Update1一大段文字",
}, SQLEnum.OperationType.Add, null), helper.GDCodition(new GDTable()
{
Money = 1,
DateTime = DateTime.Now,
Float = 1,
Name = $"Update1测试{DateTime.Now.ToString("yyyyMMddhhmmssffff")}",
Nums = 9,
Sex = true,
State = GDTable.States.启用,
Rember = "Update1一大段文字",
}, SQLEnum.OperationType.Add, null));
/////************-------查询多个表End----------***********/////
}