Example #1
0
        public void Delete()
        {
            SysProduct pro = new SysProduct();
            pro.ProductId = 58;

            _dba.Delete(pro);

            var dt = _dba.QueryDataTable("select * from sys_product where ProductName=@ProductName",
                new { ProductName = "zwb" });
            Console.WriteLine(DataTableUtil.ToString(dt));
        }
Example #2
0
        public void Delete()
        {
            SysProduct pro = new SysProduct();

            pro.ProductId = 58;

            _dba.Delete(pro);

            var dt = _dba.QueryDataTable("select * from sys_product where ProductName=@ProductName",
                                         new { ProductName = "zwb" });

            Console.WriteLine(DataTableUtil.ToString(dt));
        }
Example #3
0
        public void Update()
        {
            SysProduct pro = new SysProduct();
            pro.ProductId = 59;
            pro.ProductName = "zwb";
            pro.RecordStatus = "Inactive";

            _dba.Update(pro);

            var dt = _dba.QueryDataTable("select * from sys_product where ProductName=@ProductName",
                new { ProductName = "zwb" });
            Console.WriteLine(DataTableUtil.ToString(dt));
        }
Example #4
0
        public void Insert()
        {
            SysProduct pro = new SysProduct();

            pro.ProductName  = "zwb";
            pro.RecordStatus = "Active";

            _dba.Insert(pro);

            var dt = _dba.QueryDataTable("select * from sys_product where ProductName=@ProductName",
                                         new { ProductName = "zwb" });

            Console.WriteLine(DataTableUtil.ToString(dt));
        }