private string GetNoteModelData(ModelData newModel) { using (E3_Components_SymbolsEntities db = new E3_Components_SymbolsEntities()) { string note = "Изменено: "; try { ModelData before = db.ModelData.First(a => a.Entry == newModel.Entry); if (before.Type != newModel.Type) { note += "Type: " + before.Type + " | " + newModel.Type + "; "; } if (before.Class != newModel.Class) { note += "Class: " + before.Class + " | " + newModel.Class + "; "; } if (before.Description != newModel.Description) { note += "Description: " + before.Description + " | " + newModel.Description + "; "; } return(note); } catch { return("Новая модель"); } } }
private string GetNoteSymbolData(SymbolData newModel) { using (E3_Components_SymbolsEntities db = new E3_Components_SymbolsEntities()) { string note = "Изменено: "; try { SymbolData before = db.SymbolData.First(a => a.ENTRY == newModel.ENTRY); if (before.VERSION != newModel.VERSION) { note += "VERSION: " + before.VERSION + " | " + newModel.VERSION + "; "; } if (before.Norm != newModel.Norm) { note += "Norm: " + before.Norm + " | " + newModel.Norm + "; "; } if (before.LSHDES != newModel.LSHDES) { note += "LSHDES: " + before.LSHDES + " | " + newModel.LSHDES + "; "; } if (before.LSHTYP != newModel.LSHTYP) { note += "LSHTYP: " + before.LSHTYP + " | " + newModel.LSHTYP + "; "; } if (before.ENTRYTYP != newModel.ENTRYTYP) { note += "ENTRYTYP: " + before.ENTRYTYP + " | " + newModel.ENTRYTYP + "; "; } if (before.LPNTR != newModel.LPNTR) { note += "LPNTR: " + before.LPNTR + " | " + newModel.LPNTR + "; "; } if (before.VersionText != newModel.VersionText) { note += "VersionText: " + before.VersionText + " | " + newModel.VersionText + "; "; } if (before.Class != newModel.Class) { note += "Class: " + before.Class + " | " + newModel.Class + "; "; } if (before.Description != newModel.Description) { note += "Description: " + before.Description + " | " + newModel.Description + "; "; } if (before.SYMINDEX != newModel.SYMINDEX) { note += "SYMINDEX: " + before.SYMINDEX + " | " + newModel.SYMINDEX + "; "; } if (before.FLAGS2 != newModel.FLAGS2) { note += "FLAGS2: " + before.FLAGS2 + " | " + newModel.FLAGS2 + "; "; } if (before.FLAGS != newModel.FLAGS) { note += "FLAGS: " + before.FLAGS + " | " + newModel.FLAGS + "; "; } return(note); } catch { return("Новый символ"); } } }
private string GetNoteComponentData(ComponentData newModel) { using (E3_Components_SymbolsEntities db = new E3_Components_SymbolsEntities()) { string note = "Изменено: "; try { ComponentData before = db.ComponentData.First(a => a.ENTRY == newModel.ENTRY); if (before.VERSION != newModel.VERSION) { note += "VERSION: " + before.VERSION + " | " + newModel.VERSION + "; "; } if (before.VERSION != newModel.VERSION) { note += "VERSION: " + before.VERSION + " | " + newModel.VERSION + "; "; } if (before.DeviceLetterCode != newModel.DeviceLetterCode) { note += "DeviceLetterCode: " + before.DeviceLetterCode + " | " + newModel.DeviceLetterCode + "; "; } if (before.Class != newModel.Class) { note += "Class: " + before.Class + " | " + newModel.Class + "; "; } if (before.ENTRYTYP != newModel.ENTRYTYP) { note += "ENTRYTYP: " + before.ENTRYTYP + " | " + newModel.ENTRYTYP + "; "; } if (before.Description != newModel.Description) { note += "Description: " + before.Description + " | " + newModel.Description + "; "; } if (before.LPNTR != newModel.LPNTR) { note += "LPNTR: " + before.LPNTR + " | " + newModel.LPNTR + "; "; } if (before.VSTATUS != newModel.VSTATUS) { note += "VSTATUS: " + before.VSTATUS + " | " + newModel.VSTATUS + "; "; } if (before.VersionText != newModel.VersionText) { note += "VersionText: " + before.VersionText + " | " + newModel.VersionText + "; "; } if (before.MPNTR != newModel.MPNTR) { note += "MPNTR: " + before.MPNTR + " | " + newModel.MPNTR + "; "; } if (before.Flags != newModel.Flags) { note += "Flags: " + before.Flags + " | " + newModel.Flags + "; "; } if (before.ArticleNumber != newModel.ArticleNumber) { note += "ArticleNumber: " + before.ArticleNumber + " | " + newModel.ArticleNumber + "; "; } if (before.Supplier != newModel.Supplier) { note += "Supplier: " + before.Supplier + " | " + newModel.Supplier + "; "; } if (before.SPNTR != newModel.SPNTR) { note += "SPNTR: " + before.SPNTR + " | " + newModel.SPNTR + "; "; } if (before.Class_main != newModel.Class_main) { note += "Class_main: " + before.Class_main + " | " + newModel.Class_main + "; "; } if (before.katek_1C != newModel.katek_1C) { note += "katek_1C: " + before.katek_1C + " | " + newModel.katek_1C + "; "; } if (before.katek_type_rkd != newModel.katek_type_rkd) { note += "katek_type_rkd: " + before.katek_type_rkd + " | " + newModel.katek_type_rkd + "; "; } if (before.katek_name_rkd != newModel.katek_name_rkd) { note += "katek_name_rkd: " + before.katek_name_rkd + " | " + newModel.katek_name_rkd + "; "; } return(note); } catch { return("Новый компонент"); } } }