YTKDBlibrary 1.0.1.23

• .NETStandard 2.0

  • MySql.Data (>= 8.0.20)

////查询：包含 查询类型————————返回自定义模型
           //List<modelTableQuery> _query = new List<modelTableQuery>();
           //_query.Add(new modelTableQuery() { columName = _m.tableColum[0].columName, queryType = YTKDBlibrary.Enum.enmQueryType.equal, columValue = 7, columType = enmClumType.INT });
           ////创建分页对象
           //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 });
           //modelSqlObj ms = _sql.SelectCount(_query);


           ////查询总数—————————————指定条件
           //int count = _exe.SelectCount(ms);
           ////查询结果集合：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" };
           ////指定条件
           //List<modelTableQuery> query = new List<modelTableQuery>() {
           //new modelTableQuery(){ columName="usrid",columType=enmClumType.INT,columValue=1},
           //new modelTableQuery(){ columName="pwd",columType=enmClumType.VARCHAR,columValue="密码"}
           //};
           //modelSqlObj sqlUpdate = _sql.Update(_ups, query);
           //_exe.Update(sqlUpdate);
           //Console.ReadKey();


           //删除————————————逻辑删除
           //modelDel mdlDel = new modelDel();
           //mdlDel.isLogic = true;
           //mdlDel.delColum = "country";
           //mdlDel.logicValue = 1;

           //删除————————————物理删除+条件
           //modelDelQurey mdlDeln = new modelDelQurey()
           //{
           //    isLogic = false
           //};
           //List<modelTableQuery> mdlDelq = new List<modelTableQuery>() {
           //new modelTableQuery(){
           //columValue=1,
           //columName="usrid",
           //columType=enmClumType.INT
           //}
           //};
           //modelSqlObj obj = _sql.Delete(mdlDeln,mdlDelq);
           //bool r = _exe.Delete(obj);
           //Console.ReadKey();