public void Normal_Insert() { int ID; var userInfo = new UserVO() { UserName = "******", GetDate = DateTime.Now }; var insertUser = new InsertUserVO() { PassWord = "******", UserName = "******" }; // 将标识设置到标识字段 Table.Data.User.Insert(userInfo, true); Assert.IsTrue(userInfo.ID > 0); // 设置out ID userInfo.ID++; Table.Data.User.Insert(userInfo, out ID); Assert.IsTrue(userInfo.ID > 0 && userInfo.ID == ID); // 缓存表 Table.Data.UserRole.Insert(new UserRoleVO { Caption = "标题", Descr = "不清楚" }); // 不同逻辑删除方式新入(主键为GUID) Table.Data.Orders.Insert(new OrdersVO { ID = Guid.NewGuid(), OrderNo = "12345678-1", CreateAt = DateTime.Now, CreateName = "用户1" }); Table.Data.OrdersAt.Insert(new OrdersVO { ID = Guid.NewGuid(), OrderNo = "12345678-2", CreateAt = DateTime.Now, CreateName = "用户1" }); Table.Data.OrdersBool.Insert(new OrdersVO { ID = Guid.NewGuid(), OrderNo = "12345678-3", CreateAt = DateTime.Now, CreateName = "用户1" }); Table.Data.OrdersNum.Insert(new OrdersVO { ID = Guid.NewGuid(), OrderNo = "12345678-4", CreateAt = DateTime.Now, CreateName = "用户1" }); Table.Data.OrdersBoolCache.Insert(new OrdersVO { ID = Guid.NewGuid(), OrderNo = "12345678-5", CreateAt = DateTime.Now, CreateName = "用户1" }); // 存储过程 Table.Data.InsertUser.Execute(insertUser); Assert.IsTrue(insertUser.ID > 0); // 配置SQL Table.Data.InsertNewUser.Execute(); // 手动SQL var table = Table.Data; table.ManualSql.Execute("INSERT INTO Members_User (UserName,PassWord) VALUES(@UserName,@PassWord)", table.DbProvider.CreateDbParam("UserName", "steden1"), table.DbProvider.CreateDbParam("PassWord", "steden1")); }
public void ExecuteTestMethod() { var info = new InsertUserVO { UserName = "******", PassWord = "******" }; Proc.Data.InsertUser.Execute(info); Assert.IsTrue(info.ID > 1); }