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); }
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; } }
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); }
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); }
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; } }
public virtual SqlStruct GetSqlStruct(string className, string sqlStringName) { return(SqlManager.GetSqlStruct(className, className, sqlStringName)); }