public static void BatchDelete <T>(string ids)
{
OracleHelper.BatchDelete <T>(ids);
}
public void Run()
{
#region 添加
if (false)
{
OracleHelper.BeginTransaction();
try
{
//子表的子表
BrandChildChild bcc1 = new BrandChildChild();
bcc1.Id = BrandDal.GetNextID();
bcc1.Name = "bcc1" + DateTime.Now.ToString();
BrandDal.Insert(bcc1);
//子表
BrandChild bc1 = new BrandChild();
bc1.Id = BrandDal.GetNextID();
bc1.Name = "bc1" + DateTime.Now.ToString();
bc1.bcc = bcc1;
OracleHelper.Insert(bc1);
//主表
Brand bd1 = new Brand();
bd1.Id = BrandDal.GetNextID();
bd1.Name = "bd1" + DateTime.Now.ToString();
bd1.bc = bc1;
OracleHelper.Insert(bd1);
OracleHelper.EndTransaction();
}
catch (Exception ex)
{
OracleHelper.RollbackTransaction();
}
}
#endregion
#region 修改
if (false)
{
OracleHelper.BeginTransaction();
try
{
//替换子表
BrandChild bc1 = new BrandChild();
bc1.Id = BrandDal.GetNextID();
bc1.Name = "bc1" + DateTime.Now.ToString();
OracleHelper.Insert(bc1);
//更新主表
Brand bd1 = OracleHelper.FindById <Brand>(27);
bd1.Name = "bd1" + DateTime.Now.ToString();
bd1.bc = bc1;
OracleHelper.Update(bd1);
OracleHelper.EndTransaction();
}
catch (Exception ex)
{
OracleHelper.RollbackTransaction();
}
}
#endregion
#region 除
if (false)
{
OracleHelper.BeginTransaction();
try
{
OracleHelper.Delete <Brand>(21);
OracleHelper.BatchDelete <Brand>("22,23");
OracleHelper.EndTransaction();
}
catch (Exception ex)
{
OracleHelper.RollbackTransaction();
}
}
#endregion
#region 大文本
if (false)
{
Brand bd1 = OracleHelper.FindById <Brand>(27);
bd1.Blb = Encoding.Default.GetBytes("大家好！");
bd1.Clb = "大家好！";
OracleHelper.Update(bd1);
Brand bd12 = OracleHelper.FindById <Brand>(27);
}
#endregion
#region 查询列表
List <Brand> brandList = BrandDal.FindListBySql <Brand>("select * from BRAND");
#endregion
#region 分页查询列表
PageViewModel pageViewModel = BrandDal.FindPageBySql <Brand>("select * from BRAND", "order by Id desc", 10, 1);
#endregion
}
