YTKDBlibrary 1.0.0.6

• .NETStandard 2.0

  • MySql.Data (>= 8.0.20)

//查询——————————自定义模型
           //创建查询条件
           tb_test _seq = new tb_test() { pwd = "aaaaaa", name = "yinlik" };

           //创建分页对象
           modelPage _page = new modelPage() { isPage = true, pageNum = 1, rowCount = 2 };

           //创建排序条件
           List<modelOrder> _order = new List<modelOrder>();
           _order.Add(new modelOrder() { orderColum = "usrid", orderType = YTKDBlibrary.Enum.enmOrderType.DESC });

           modelSqlObj mdlCount = _sql.SelectCount(_seq);
           int count = _exe.SelectCount(mdlCount);
           List<tb_test> res = _exe.Select<tb_test>(_sql.Select(_seq, _page, _order));
           ResultObj<SearchResultObj<tb_test>> result = new ResultObj<SearchResultObj<tb_test>>() { data = new SearchResultObj<tb_test>() { pageList = res, itemTotal = count } };
           Console.ReadKey();


           //查询：包含 查询类型————————返回自定义模型
           List<modelTableQuery> _query = new List<modelTableQuery>();
           _query.Add(new modelTableQuery() { columName = _m.tableColum[1].columName, queryType = YTKDBlibrary.Enum.enmQueryType.like, columValue = "a" });
           //创建分页对象
           modelPage _page = new modelPage() { isPage = true, pageNum = 1, rowCount = 2 };
           //创建排序条件
           List<modelOrder> _order = new List<modelOrder>();
           _order.Add(new modelOrder() { orderColum = _m.tableColum[0].columName, orderType = YTKDBlibrary.Enum.enmOrderType.DESC });
           //查询总数
           int count = _exe.SelectCount(_sql.SelectCount(_query));
           //查询结果集合：tb_test 是表结构 模型 需要自己定义
           List<tb_test> res = _exe.Select<tb_test>(_sql.Select(_query, _page, _order));
           Console.ReadKey();


           //查询：sql语句返回——————————返回自定义模型
           List<tb_test> rrr = _exe.Select<tb_test>("select * from tb_test;", null);
           Console.ReadKey();

           // 插入————————————自定义模型
           tb_test _ins = new tb_test() { pwd = "测试啊啊啊啊啊3啊测试啊啊啊啊dd啊啊啊" };
           modelSqlObj sqlIns = _sql.Insert(new List<object>() { _ins }, true);
           int id = _exe.Insert(sqlIns);
           Console.ReadKey();


           //更新————————————自定义模型
           tb_test _ups = new tb_test() { pwd = "aaaaaa", name = "yinlik" };
           modelSqlObj sqlUpdate = _sql.Update(_ups, "usrid", 2);
           _exe.Update(sqlUpdate);
           Console.ReadKey();


           //删除————————————自定义模型
           modelDel mdlDel = new modelDel();
           mdlDel.isLogic = true;
           mdlDel.delColum = "country";
           mdlDel.logicValue = 1;
           mdlDel.query = new tb_test() { usrid = 2 };
           modelSqlObj obj = _sql.Delete(mdlDel);
           bool r = _exe.Delete(obj);
           Console.ReadKey();