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