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