public void SQL数据库_测试实体删除_添加_查询_保存() { CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); SqlTestDataEntity de = new SqlTestDataEntity(sqlAdapter); de.Fill(); for (int i = 0; i < de.Count; i++) { de[i].Delete(); } int result = de.Save(); de.Add(); de.AFild = "1"; //de.BFild = "11.22"; de.CFild = "2012-10-11"; de.DFild = "WW"; de.Add(); de.AFild = "2"; de.BFild = "33.44"; //de.CFild = ""; de.DFild = "QQ"; de.Add(); de.AFild = "3"; de.BFild = "44.55"; de.CFild = "2012-10-13"; de.DFild = ""; result = de.Save(); Assert.AreEqual(3, result, "实体保存失败"); }
public void QueryPaging_执行返回数据集的存储过程_postgre() { int padingId = CJia.DefaultPostgre.QueryPaging("select * from gm_user"); CJia.DataAdapter dataAdapter = new CJia.DataAdapter("Postgre"); DataTable result = dataAdapter.QueryPagingData(padingId, 1000); }
public void Sql数据库查询() { string SqlQuery = @"select * from Table_A"; CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); DataTable Result = sqlAdapter.Query(SqlQuery); Assert.IsNotNull(Result, "查询失败"); }
public void Sql数据库插入数据_数字日期() { string SqlInsert = @"insert into Table_C (A,B,C,D) values (@1,@2,@3,@4)"; CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); object[] SqlParams = new object[] { 11, 22.225, "2012-12-22 12:32:56", "bb" }; int Result = sqlAdapter.Execute(SqlInsert, SqlParams); Assert.AreEqual(1, Result, "插入失败"); }
public void Sql数据库插入数据_仅字符串() { string SqlInsert = @"insert into Table_A (colA,colB,colC,colD,colE) values (@1,@2,@3,@4,@5)"; CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); object[] SqlParams = new object[] { "11", "22", "aa", "bb", "**" }; int Result = sqlAdapter.Execute(SqlInsert, SqlParams); Assert.AreEqual(1, Result, "插入失败"); }
public void Sql数据库插入数据_数字日期_批量插入() { string SqlInsert = @"insert into Table_C (A) values (@1)"; CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); List <object> listParams = new List <object>(); listParams.Add(22); listParams.Add(33); listParams.Add(44); int Result = sqlAdapter.BatchExecute(SqlInsert, listParams); Assert.AreEqual(3, Result, "批量插入失败"); }
/// <summary> /// 绑定数据 /// </summary> /// <param name="PadingId">分页id</param> public void BindingData(int PadingId) { if (this.dataAdapter == null) { this.dataAdapter = new CJia.DataAdapter("pading"); } if (this.padingId != 0) { this.dataAdapter.DeletePaging(this.padingId); } this.padingId = PadingId; this.nowAllData = null; this.QueryPageData(1); this.GoPage(1); }
public void SQL数据库_TestDynamicTableEntity_测试根据表名动态创建实体() { CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); using (CJia.DynamicEntity de = new CJia.DynamicEntity(CJia.ORM.DatabaseType.SqlServer, sqlAdapter, "TABLE_W", "", null)) { dynamic result = de.DataEntity; int i = result.Count; string entityName = result.EntityName; string AValue = result.A; Assert.AreNotEqual(0, AValue.Length); result.B = "12345"; result.EntityAdapter = sqlAdapter; int count = result.Save(); Assert.AreEqual(false, de.DataEntity.isReadOnly); Assert.AreEqual(1, count); } }
public void Sql数据库插入数据_数字日期_空值() { string SqlInsert = @"insert into Table_C (A,B,C,D) values (@1,@2,@3,@4)"; CJia.DataAdapter sqlAdapter = new CJia.DataAdapter(CJia.DbConfigName.SqlDB.ToString()); object[] SqlParams = new object[] { DBNull.Value, DBNull.Value, DBNull.Value, "gg" }; int Result = 0; string exMsg = ""; try { Result = sqlAdapter.Execute(SqlInsert, SqlParams); } catch (Exception ex) { exMsg = ex.Message; } Assert.AreEqual(1, Result, exMsg); }