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);
}
