static void Main(string[] args)
{
// 反射+工厂+配置文件
IGetDataHelper client = MyFactory.CreateFactory();
#region 查询：一般方法
// 根据Id获取对象实体
{
User userModel = client.GetModelById <User>(1);
Console.WriteLine("获取User对象：");
Console.WriteLine(ShowData(userModel));
Company compModel = client.GetModelById <Company>(2);
Console.WriteLine("\n\n获取Company对象：");
Console.WriteLine(ShowData(compModel));
}
// 获取所有对象
{
List <User> userList = client.GetModelList <User>();
if (userList.Count > 0)
{
Console.WriteLine("\n\n获取User集合：");
foreach (var item in userList)
{
Console.WriteLine(ShowData(item));
}
}
List <Company> compList = client.GetModelList <Company>();
if (compList.Count > 0)
{
Console.WriteLine("\n\n获取Company集合：");
foreach (var item in compList)
{
Console.WriteLine(ShowData(item));
}
}
}
#endregion
#region 查询：表达式目录树
{
ExpressionSqlHelper expressionSql = new ExpressionSqlHelper();
List <User> userList = expressionSql.ExpressQuery <User>(n => n.Id > 2 && n.Name.Contains("1"));
if (userList.Count > 0)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("\n\n--表达式目录树--获取User集合：\n");
foreach (var item in userList)
{
Console.WriteLine(ShowData(item));
}
}
}
#endregion
Console.ForegroundColor = ConsoleColor.Gray;
// 添加数据
{
User userModel = new User()
{
Name = "神韵凌天",
Account = "admin",
Password = "******",
Email = "*****@*****.**",
Mobile = "13812345678",
CompanyId = 1,
CreateTime = DateTime.Now,
LastLoginTime = DateTime.Now,
LastModifyTime = DateTime.Now,
CreatorId = 1,
Status = 1,
UserType = 2
};
if (userModel.Validate())
{
int row = client.AddModel(userModel);
if (row > 0)
{
Console.WriteLine("\n\n添加User对象：");
Console.WriteLine(ShowData(userModel));
}
else
{
Console.WriteLine("\n\n添加User对象失败！！！");
}
}
else
{
Console.WriteLine("\n\n添加User对象失败！！！属性格式错误");
}
}
// 更新User对象数据
{
try
{
User userModel = client.GetModelList <User>()[1];
if (userModel.Id != 0)
{
userModel.Name = "TestUpdate";
userModel.Mobile = "15726683424";
if (userModel.Validate())
{
int row = client.UpdateModel <User>(userModel);
if (row > 0)
{
Console.WriteLine("\n\n更新User对象：");
Console.WriteLine(ShowData(userModel));
}
else
{
Console.WriteLine("\n\n更新User对象失败！！！");
}
}
else
{
Console.WriteLine("\n\n更新User对象失败！！！属性格式错误");
}
}
}
catch (Exception ex)
{
Console.WriteLine("\n\n更新数据出错：", ex.Message);
}
}
//// 删除数据
//{
// User userModel = client.GetModelList<User>()[1];
// if (userModel.Id != 0)
// {
// int row = client.DeleteModel<User>(userModel.Id);
// if (row > 0)
// {
// Console.WriteLine("\n\n删除User对象：");
// Console.WriteLine(ShowData(userModel));
// }
// else
// {
// Console.WriteLine("\n\n删除User对象失败！！！");
// }
// }
//}
Console.ReadKey();
}