public void Load(string Condition = "")
{
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
this.Load(Da, Condition);
}
catch (Exception ex)
{ throw ex; }
finally
{ Da.Close(); }
}
public virtual bool Save()
{
bool IsSave = false;
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
Da.BeginTransaction();
Da.SaveDataRow(this.mHeader_Dr, this.mHeader_TableName);
//[-]
if (this.mBase_TableDetail != null)
{
foreach (ClsBaseTableDetail Inner_Obj in this.mBase_TableDetail)
{
Inner_Obj.Save(Da);
}
}
//[-]
if (this.mBase_RowDetail != null)
{
foreach (ClsBaseRowDetail Inner_Obj in this.mBase_RowDetail)
{
Inner_Obj.Save(Da);
}
}
//[-]
Da.CommitTransaction();
IsSave = true;
}
catch (Exception ex)
{
Da.RollbackTransaction();
throw ex;
}
finally
{ Da.Close(); }
return(IsSave);
}
public static DataTable GetQuery(string ViewObject, string Fields, string Condition, string Sort)
{
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
return(GetQuery(Da, ViewObject, Fields, Condition, Sort));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
public static DataSet ExecuteQuery(string Query)
{
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
return(Da.ExecuteQuery(Query));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
public static DataSet ExecuteQuery(string ProcedureName, ClsDataAccess.Struct_Parameters[] ProcedureParameters)
{
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
return(Da.ExecuteQuery(ProcedureName, ProcedureParameters));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
public static DataTable GetQuery(string ViewObject, string Fields, ClsQueryCondition Condition, string Sort = "", Int64 Top = 0, Int32 Page = 0)
{
ClsDataAccess Da = new ClsDataAccess();
try
{
Da.Connect();
return(GetQuery(Da, ViewObject, Fields, Condition, Sort, Top, Page));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
