public bool Clear(string objtype)
{
bool done = false;
using (
SQLiteConnection mySQLiteConnection =
new SQLiteConnection(_SQLiteConnectionStringBuilder.ConnectionString))
{
mySQLiteConnection.Open();
SQLiteTransaction mySQLiteTransaction = mySQLiteConnection.BeginTransaction();
try
{
switch (objtype)
{
case "YINGJDF":
DataObjectYINGJDFDAL objYingJDFDAL = new DataObjectYINGJDFDAL();
objYingJDFDAL.DeleteAll(mySQLiteTransaction);
break;
case "YIJDFZZ_2":
DataObjectYIJDFZZ_2DAL objYIJDFZZ_2DAL = new DataObjectYIJDFZZ_2DAL();
objYIJDFZZ_2DAL.DeleteAll(mySQLiteTransaction);
break;
case "YIJDFTX_2":
DataObjectYIJDFTX_2DAL objYIJDFTX_2DAL = new DataObjectYIJDFTX_2DAL();
objYIJDFTX_2DAL.DeleteAll(mySQLiteTransaction);
break;
case "YIJDFZZ":
DataObjectYIJDFZZDAL objYIJDFZZDAL = new DataObjectYIJDFZZDAL();
objYIJDFZZDAL.DeleteAll(mySQLiteTransaction);
break;
case "YIJDFTX":
DataObjectYIJDFTXDAL objYIJDFTXDAL = new DataObjectYIJDFTXDAL();
objYIJDFTXDAL.DeleteAll(mySQLiteTransaction);
break;
}
mySQLiteTransaction.Commit();
done = !done;
}
catch (Exception ex)
{
mySQLiteTransaction.Rollback();
//throw ex;
}
finally
{
mySQLiteConnection.Close();
}
return(done);
}
}
public void Add(ArrayList pDataObjectArr)
{
using (SQLiteConnection mySQLiteConnection = new SQLiteConnection(_SQLiteConnectionStringBuilder.ConnectionString))
{
mySQLiteConnection.Open();
SQLiteTransaction mySQLiteTransaction = mySQLiteConnection.BeginTransaction();
try
{
foreach (Object pDataObject in pDataObjectArr)
{
if (pDataObject is Obj_YINGJDF)
{
DataObjectYINGJDFDAL objYINGJDFDAL = new DataObjectYINGJDFDAL();
objYINGJDFDAL.Add(pDataObject as Obj_YINGJDF, mySQLiteTransaction);
}
else if (pDataObject is Obj_YIJDF_ZZ)
{
}
else if (pDataObject is Obj_YIJDF_TX)
{
}
else if (pDataObject is Obj_YIJDF_ZZ_2)
{
DataObjectYIJDFZZ_2DAL objYIJDFZZ_2DAL = new DataObjectYIJDFZZ_2DAL();
objYIJDFZZ_2DAL.Add(pDataObject as Obj_YIJDF_ZZ_2, mySQLiteTransaction);
}
else if (pDataObject is Obj_YIJDF_TX_2)
{
DataObjectYIJDFTX_2DAL objYIJDFTX_2DAL = new DataObjectYIJDFTX_2DAL();
objYIJDFTX_2DAL.Add(pDataObject as Obj_YIJDF_TX_2, mySQLiteTransaction);
}
else
{
}
}
mySQLiteTransaction.Commit();
}
catch (Exception ex)
{
mySQLiteTransaction.Rollback();
//throw ex;
}
finally
{
mySQLiteConnection.Close();
}
}
}
public void BulkCopyAdd(DataTable dt, string tableType)
{
using (
SQLiteConnection mySQLiteConnection =
new SQLiteConnection(_SQLiteConnectionStringBuilder.ConnectionString))
{
mySQLiteConnection.Open();
SQLiteTransaction mySQLiteTransaction = mySQLiteConnection.BeginTransaction();
try
{
if (tableType == "Obj_YINGJDF")
{
DataObjectYINGJDFDAL objYINGJDFDAL = new DataObjectYINGJDFDAL();
}
else if (tableType == "Obj_YIJDF_ZZ")
{
DataObjectYIJDFZZDAL objYIJDFZZDAL = new DataObjectYIJDFZZDAL();
objYIJDFZZDAL.BulkCopyInsert(dt, mySQLiteTransaction);
}
else if (tableType == "Obj_YIJDF_TX")
{
}
else
{
}
mySQLiteTransaction.Commit();
}
catch (Exception ex)
{
mySQLiteTransaction.Rollback();
//throw ex;
}
finally
{
mySQLiteConnection.Close();
}
}
}
