Ejemplo n.º 1
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)
                {
                    this.db.FillEntity(sqlStruct.SqlString, sqlStruct.ParamsList, keyvalues, entitydata, this.m_EntityName);
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                this.db.Close();
                throw exception;
            }
            return(data2);
        }
Ejemplo n.º 2
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;
     }
 }
Ejemplo n.º 3
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);
        }
Ejemplo n.º 4
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[0], keyvalues, entitydata, tableName);
                        }
                    }
                }
                SqlStruct struct3 = SqlManager.GetSqlStruct(className, "Select");
                if (struct3.SqlString.Length != 0)
                {
                    if (1 != struct3.ParamsList.Length)
                    {
                        throw new ApplicationException("参数列表不匹配");
                    }
                    base.db.FillEntity(struct3.SqlString, struct3.ParamsList[0], keyvalues, entitydata, base.m_EntityName);
                }
                data2 = entitydata;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(data2);
        }
Ejemplo n.º 5
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;
     }
 }
Ejemplo n.º 6
0
 public virtual SqlStruct GetSqlStruct(string className, string sqlStringName)
 {
     return(SqlManager.GetSqlStruct(className, className, sqlStringName));
 }