コード例 #1
0
        public void Load(string Condition = "")
        {
            ClsDataAccess Da = new ClsDataAccess();

            try
            {
                Da.Connect();
                this.Load(Da, Condition);
            }
            catch (Exception ex)
            { throw ex; }
            finally
            { Da.Close(); }
        }
コード例 #2
0
        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);
        }
コード例 #3
0
        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();
            }
        }
コード例 #4
0
        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();
            }
        }
コード例 #5
0
        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();
            }
        }
コード例 #6
0
        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();
            }
        }
コード例 #7
0
        //[-]

        public virtual void Load(ClsKeys Keys = null)
        {
            ClsDataAccess Da           = new ClsDataAccess();
            StringBuilder Sb_Condition = new StringBuilder();
            string        Condition    = "";

            try
            {
                if (Keys != null)
                {
                    if (Keys.Count() != this.mHeader_Key.Count)
                    {
                        throw new Exception("Keys not equal to required keys.");
                    }

                    string Inner_Condition_And = "";
                    bool   IsStart             = false;
                    foreach (string Inner_Key in this.mHeader_Key)
                    {
                        Sb_Condition.Append(Inner_Condition_And + " " + Inner_Key + " = " + Keys[Inner_Key]);
                        if (!IsStart)
                        {
                            Inner_Condition_And = " And ";
                        }
                        IsStart = true;
                    }
                }

                Condition = Sb_Condition.ToString();

                Da.Connect();

                DataTable Dt;
                DataRow   Dr;

                if (Keys == null)
                {
                    Dt = Methods_Query.GetQuery(Da, this.mHeader_ViewName, "*", "1 = 0");
                    Dr = Dt.NewRow();
                }
                else
                {
                    Dt = Methods_Query.GetQuery(Da, this.mHeader_ViewName, "*", Condition);
                    Dr = Dt.Rows[0];
                }

                this.mHeader_Dr = Dr;

                //[-]

                if (this.mBase_TableDetail != null)
                {
                    foreach (ClsBaseTableDetail Inner_Obj in this.mBase_TableDetail)
                    {
                        Inner_Obj.Load(Da, Condition);
                    }
                }

                //[-]

                if (this.mBase_RowDetail != null)
                {
                    foreach (ClsBaseRowDetail Inner_Obj in this.mBase_RowDetail)
                    {
                        Inner_Obj.Load(Da, Condition);
                    }
                }

                //[-]

                this.AddRequired();
            }
            catch { }
        }