/// <summary>
/// 存在多条数据的Parameter
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Model"></param>
/// <param name="Type"></param>
/// <param name="编号"></param>
/// <returns></returns>
public List <GDModel.SQLModel> GDGetPropertys <T>(T Model, SQLEnum.DataBaseType Type, int Nums)
{
List <GDModel.SQLModel> ListParameter = new List <GDModel.SQLModel>();
PropertyInfo[] propertys = Model.GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
GDColoum objAttrs = pi.GetCustomAttribute <GDColoum>();
if (objAttrs != null)
{
GDModel.SQLModel sqlmodel = new GDModel.SQLModel();
object obj = pi.GetValue(Model, null);
if (obj != null)
{
object o = null;
switch (Type)
{
case SQLEnum.DataBaseType.SqlServer:
o = new SqlParameter("@" + pi.Name + Nums, obj);
break;
case SQLEnum.DataBaseType.MySql:
o = new MySqlParameter("@" + pi.Name + Nums, obj);
break;
case SQLEnum.DataBaseType.Sqlite:
o = new SQLiteParameter("@" + pi.Name + Nums, obj);
break;
default:
break;
}
ListParameter.Add(new GDModel.SQLModel()
{
Field = pi.Name,
Value = obj,
ValueStr = obj.ToValStr(),
Parameter = o,
ParameterName = "@" + pi.Name + Nums,
IsKey = objAttrs.IsKey,
IsIncrease = (objAttrs.IsKey && objAttrs.IsIncrease)
});
}
}
}
return(ListParameter);
}
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----------***********/////
}
