public static string PrepareGetListStoredProcedure(Table table) { Template template = new Template(TemplatesPath + "dalSPGetList.tpl"); template.selectSection("DAL_SP"); template.setField("DB_NAME", table.Catalog); template.setField("SP_NAME", string.Format("[{0}].[dal_{1}_getlist]", table.Schema, table.Name)); template.setField("TABLE_NAME", string.Format("[{0}].[{1}]", table.Schema, table.Name)); template.setField("SELECT_FIELD_NAMES", table.FieldNames); template.appendSection(); template.deselectSection(); return template.getContent(); }
public static string PrepareDeleteStoredProcedure(Table table) { Template template = new Template(TemplatesPath + "dalSPDelete.tpl"); template.selectSection("DAL_SP"); template.setField("DB_NAME", table.Catalog); template.setField("SP_NAME", string.Format("[{0}].[dal_{1}_deletebyid]", table.Schema, table.Name)); template.setField("TABLE_NAME", string.Format("[{0}].[{1}]", table.Schema, table.Name)); template.setField("TABLE_PKFIELD_NAME", table.PKField.ColumnName); template.setField("TABLE_PKFIELD_PARAMNAME", "@" + table.PKField.ColumnName); template.setField("TABLE_PKFIELD_TYPE", table.PKField.DataTypeFull); template.appendSection(); template.deselectSection(); return template.getContent(); }
public static string PrepareInsertStoredProcedure(Table table) { Template template = new Template(TemplatesPath + "dalSPInsert.tpl"); template.selectSection("DAL_SP"); template.setField("DB_NAME", table.Catalog); template.setField("SP_NAME", string.Format("[{0}].[dal_{1}_insert]", table.Schema, table.Name)); template.setField("TABLE_NAME", string.Format("[{0}].[{1}]", table.Schema, table.Name)); template.setField("INSERT_FIELD_NAMES", table.FieldNames); //template.setField("INSERT_FIELD_VALUES", "@" + table.FieldNames.Trim().Replace(", \n", ", \n@")); template.setField("INSERT_FIELD_NAMES_WITHOUT_PKFIELD", table.FieldNames_WithoutPK); //template.setField("INSERT_FIELD_VALUES_WITHOUT_PKFIELD", "@" + table.FieldNames_WithoutPK.Trim().Replace(", \n", ", \n@")); string spParams = string.Empty; string insertStatements = string.Empty; string insertStatements_withoutpk = string.Empty; foreach (KeyValuePair<string, Column> col in table.Columns) { spParams += string.Format("@{0} {1}, \n", col.Value.ColumnName, col.Value.DataTypeFull); insertStatements += string.Format("@{0}, \n", col.Value.ColumnName); if (col.Value.Key != ConstraintKey.Primary) insertStatements_withoutpk += string.Format("@{0}, \n", col.Value.ColumnName); } spParams = spParams.TrimEnd(new char[] { ',', ' ', '\n' }); insertStatements = insertStatements.TrimEnd(new char[] { ',', ' ', '\n' }); insertStatements_withoutpk = insertStatements_withoutpk.TrimEnd(new char[] { ',', ' ', '\n' }); template.setField("TABLE_PKFIELD_PARAMNAME", "@"+table.PKField.ColumnName); template.setField("TABLE_PKFIELD_DBTYPE", "int"); //table.PKField.DataTypeFull template.setField("SP_PARAMS", spParams); template.setField("INSERT_FIELD_VALUES", insertStatements); template.setField("INSERT_FIELD_VALUES_WITHOUT_PKFIELD", insertStatements_withoutpk); template.appendSection(); template.deselectSection(); return template.getContent(); }
public static string PrepareUserTableClass(Table table) { Template template = new Template(TemplatesPath + "dalUserTable.tpl"); template.selectSection("DAL_TABLE"); template.setField("PROJECT_NAMESPACE", string.Format("{0}.DataAccessLayer", table.Catalog)); template.setField("TABLE_NAME", table.Name); template.setField("TABLE_PKFIELD_NAME", table.PKField.ColumnName); template.appendSection(); template.deselectSection(); return template.getContent(); }
public static string PrepareUpdateStoredProcedure(Table table) { Template template = new Template(TemplatesPath + "dalSPUpdate.tpl"); template.selectSection("DAL_SP"); template.setField("DB_NAME", table.Catalog); template.setField("SP_NAME", string.Format("[{0}].[dal_{1}_updatebyid]", table.Schema, table.Name)); template.setField("TABLE_NAME", string.Format("[{0}].[{1}]", table.Schema, table.Name)); template.setField("TABLE_PKFIELD_NAME", table.PKField.ColumnName); template.setField("TABLE_PKFIELD_PARAMNAME", "@" + table.PKField.ColumnName); string spParams = string.Empty; string setStatements = string.Empty; foreach(KeyValuePair<string, Column> col in table.Columns) { spParams += string.Format("@{0} {1}, \n", col.Value.ColumnName, col.Value.DataTypeFull); setStatements += string.Format("[{0}].[{1}].[{2}] = @{2}, \n", table.Schema, table.Name, col.Value.ColumnName); } spParams = spParams.TrimEnd(new char[] { ',', ' ', '\n' }); setStatements = setStatements.TrimEnd(new char[] { ',', ' ', '\n' }); template.setField("SP_PARAMS", spParams); template.setField("SP_SET_STATEMENT", setStatements); template.appendSection(); template.deselectSection(); return template.getContent(); }
public static string PrepareTableClass(Table table) { Template template = new Template(TemplatesPath+"dalTable.tpl"); template.selectSection("DAL_TABLE"); template.setField("PROJECT_NAMESPACE", string.Format("{0}.DataAccessLayer", table.Catalog)); template.setField("TABLE_NAME", table.Name); template.setField("TABLE_PKFIELD_NAME", table.PKField.ColumnName); template.setField("TABLE_PKFIELD_TYPE", table.PKField.DataType4Code); template.selectSection("TABLE_STRING_FIELDS"); foreach (KeyValuePair<string, Column> columnItem in table.Columns) { template.setField("TABLE_FIELD_TYPE", columnItem.Value.DataType4Code); template.setField("TABLE_FIELD_NAME", columnItem.Value.ColumnName); template.appendSection(); } template.deselectSection(); template.selectSection("TABLE_FIELDS"); foreach (KeyValuePair<string, Column> columnItem in table.Columns) { template.setField("TABLE_FIELD_TYPE", columnItem.Value.DataType4Code); template.setField("TABLE_FIELD_NAME", columnItem.Value.ColumnName); template.appendSection(); } template.deselectSection(); template.selectSection("SAVE_TABLE_FIELDS"); foreach (KeyValuePair<string, Column> columnItem in table.Columns) { template.setField("TABLE_DBFIELD_NAME", "@" + columnItem.Value.ColumnName); template.setField("TABLE_FIELD_NAME", columnItem.Value.ColumnName); template.appendSection(); } template.deselectSection(); template.selectSection("GETLIST_TABLE_FIELDS"); foreach (KeyValuePair<string, Column> columnItem in table.Columns) { template.setField("TABLE_FIELD_TYPE", columnItem.Value.DataType4Code); template.setField("TABLE_FIELD_NAME", columnItem.Value.ColumnName); template.appendSection(); } template.deselectSection(); template.selectSection("INIT_TABLE_FIELDS"); foreach (KeyValuePair<string, Column> columnItem in table.Columns) { template.setField("TABLE_FIELD_TYPE", columnItem.Value.DataType4Code); template.setField("TABLE_FIELD_NAME", columnItem.Value.ColumnName); template.appendSection(); } template.deselectSection(); template.appendSection(); template.deselectSection(); return template.getContent(); }