Exemplo n.º 1
0
 public override void InsertEntity(EntityData entitydata)
 {
     try
     {
         this.CheckData(entitydata);
         string    className = entitydata.MainTableName;
         SqlStruct sqlStruct = SqlManager.GetSqlStruct(className, "Insert");
         if (sqlStruct.SqlString.Length != 0)
         {
             base.db.SubmitDataTable(entitydata.Tables[className], sqlStruct, SqlOperatorType.Insert);
         }
         foreach (DataRelation relation in entitydata.Relations)
         {
             if (className == relation.ParentTable.TableName)
             {
                 string    tableName = relation.ChildTable.TableName;
                 SqlStruct struct3   = SqlManager.GetSqlStruct(tableName, "Insert");
                 if (struct3.SqlString.Length != 0)
                 {
                     base.db.SubmitDataTable(entitydata.Tables[tableName], struct3, SqlOperatorType.Insert);
                 }
             }
         }
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Exemplo n.º 2
0
        public virtual EntityData SelectbyPrimaryKey(object keyvalues)
        {
            EntityData data2;

            try
            {
                EntityData entitydata = new EntityData(this.m_EntityName);
                SqlStruct  sqlStruct  = SqlManager.GetSqlStruct(this.m_EntityName, "Select");
                if (sqlStruct.SqlString.Length != 0)
                {
                    if (1 != sqlStruct.ParamsList.Length)
                    {
                        throw new ApplicationException("参数列表不匹配");
                    }
                    this.db.FillEntity(sqlStruct.SqlString, sqlStruct.ParamsList[0], keyvalues, entitydata, this.m_EntityName);
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                this.db.Close();
                throw exception;
            }
            return(data2);
        }
Exemplo n.º 3
0
 public virtual void SubmitEntity(EntityData entitydata)
 {
     try
     {
         this.CheckData(entitydata);
         this.db.SubmitAllData(entitydata.Tables[this.m_EntityName], SqlManager.GetSqlStruct(this.m_EntityName, "Insert"), SqlManager.GetSqlStruct(this.m_EntityName, "Update"), SqlManager.GetSqlStruct(this.m_EntityName, "Delete"));
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Exemplo n.º 4
0
 public virtual void DeleteEntity(EntityData entitydata)
 {
     try
     {
         this.CheckData(entitydata);
         SqlStruct sqlStruct = SqlManager.GetSqlStruct(this.m_EntityName, "Delete");
         if (sqlStruct.SqlString.Length != 0)
         {
             this.db.SubmitDataTable(entitydata.Tables[this.m_EntityName], sqlStruct, SqlOperatorType.Delete);
         }
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Exemplo n.º 5
0
        public override EntityData SelectbyPrimaryKey(object[] keyvalues)
        {
            EntityData data2;

            try
            {
                EntityData entitydata = new EntityData(base.m_EntityName);
                string     className  = entitydata.MainTableName;
                foreach (DataRelation relation in entitydata.Relations)
                {
                    if (className == relation.ChildTable.TableName)
                    {
                        string    tableName = relation.ParentTable.TableName;
                        SqlStruct sqlStruct = SqlManager.GetSqlStruct(tableName, "Select");
                        if (sqlStruct.SqlString.Length != 0)
                        {
                            base.db.FillEntity(sqlStruct.SqlString, sqlStruct.ParamsList, keyvalues, entitydata, tableName);
                        }
                    }
                }
                SqlStruct struct3 = SqlManager.GetSqlStruct(className, "Select");
                if (struct3.SqlString.Length != 0)
                {
                    base.db.FillEntity(struct3.SqlString, struct3.ParamsList, keyvalues, entitydata, base.m_EntityName);
                }
                foreach (DataRelation relation2 in entitydata.Relations)
                {
                    if (className == relation2.ParentTable.TableName)
                    {
                        string    text3   = relation2.ChildTable.TableName;
                        SqlStruct struct4 = SqlManager.GetSqlStruct(text3, "Select");
                        if (struct4.SqlString.Length != 0)
                        {
                            base.db.FillEntity(struct4.SqlString, struct4.ParamsList, keyvalues, entitydata, text3);
                        }
                    }
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(data2);
        }
Exemplo n.º 6
0
        public override EntityData SelectAll()
        {
            EntityData data2;

            try
            {
                EntityData entitydata = new EntityData(base.m_EntityName);
                foreach (DataRelation relation in entitydata.Relations)
                {
                    if (entitydata.Tables[base.m_EntityName].TableName == relation.ChildTable.TableName)
                    {
                        string    tableName = relation.ParentTable.TableName;
                        SqlStruct struct2   = SqlManager.GetSqlStruct(base.m_EntityName, tableName, "SelectAll");
                        if (struct2.SqlString.Length != 0)
                        {
                            base.db.FillEntity(struct2.GetSqlStringWithOrder(), (string[])null, (object[])null, entitydata, tableName);
                        }
                    }
                }
                SqlStruct sqlStruct = SqlManager.GetSqlStruct(base.m_EntityName, "SelectAll");
                if (sqlStruct.SqlString.Length != 0)
                {
                    base.db.FillEntity(sqlStruct.GetSqlStringWithOrder(), (string[])null, (object[])null, entitydata, base.m_EntityName);
                }
                foreach (DataRelation relation2 in entitydata.Relations)
                {
                    if (entitydata.Tables[base.m_EntityName].TableName == relation2.ParentTable.TableName)
                    {
                        string    text2   = relation2.ChildTable.TableName;
                        SqlStruct struct4 = SqlManager.GetSqlStruct(base.m_EntityName, text2, "SelectAll");
                        if (struct4.SqlString.Length != 0)
                        {
                            base.db.FillEntity(struct4.GetSqlStringWithOrder(), (string[])null, (object[])null, entitydata, text2);
                        }
                    }
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(data2);
        }
Exemplo n.º 7
0
 public override void SubmitEntity(EntityData entitydata)
 {
     try
     {
         this.CheckData(entitydata);
         string className = entitydata.MainTableName;
         base.db.SubmitAllData(entitydata.Tables[className], SqlManager.GetSqlStruct(className, "Insert"), SqlManager.GetSqlStruct(className, "Update"), SqlManager.GetSqlStruct(className, "Delete"));
         foreach (DataRelation relation in entitydata.Relations)
         {
             if (className == relation.ParentTable.TableName)
             {
                 string tableName = relation.ChildTable.TableName;
                 base.db.SubmitAllData(entitydata.Tables[tableName], SqlManager.GetSqlStruct(tableName, "Insert"), SqlManager.GetSqlStruct(tableName, "Update"), SqlManager.GetSqlStruct(tableName, "Delete"));
             }
         }
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Exemplo n.º 8
0
        public virtual EntityData SelectAll()
        {
            EntityData data2;

            try
            {
                //初始化this.m_EntityName表的表结构
                EntityData entitydata = new EntityData(this.m_EntityName);
                SqlStruct  sqlStruct  = SqlManager.GetSqlStruct(this.m_EntityName, "SelectAll");
                if (sqlStruct.SqlString.Length != 0)
                {
                    this.db.FillEntity(sqlStruct.GetSqlStringWithOrder(), (string[])null, (object[])null, entitydata, this.m_EntityName);
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                this.db.Close();
                throw exception;
            }
            return(data2);
        }
Exemplo n.º 9
0
 public virtual SqlStruct GetSqlStruct(string className, string sqlStringName)
 {
     return(SqlManager.GetSqlStruct(className, className, sqlStringName));
 }