-
-
Save ShilGen/a40c4e5bc90a85d8efd26b79b9ffa2e9 to your computer and use it in GitHub Desktop.
Скрипт массового добавления аттрибута точкам учёта
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Серийный номер ПУ | Код ERP | |
var worksheet = WorkbookNonExcel.Worksheets.FirstOrDefault(); | |
var mpas = MeterPoint.GetInstances().ToArray(); | |
int i =1; | |
while(worksheet.Cells[i,0].Value!=null) | |
{ | |
var sn = worksheet.Cells[i,0].Value.ToString(); | |
var erp = worksheet.Cells[i,1].Value.ToString(); | |
var mps = mpas.Where(qwe=>qwe?.AttributeElectricityMeter?.AttributeSerialNumber==sn).ToArray(); | |
if (mps.Count()==0) | |
{ | |
worksheet.Cells[i,2].Value = "Точка учёта не найдена"; | |
} | |
if (mps.Count()>1) | |
{ | |
worksheet.Cells[i,2].Value = "Найдено несколько точек учёта"; | |
} | |
if (mps.Count()==1) | |
{ | |
var mp = mps.FirstOrDefault(); | |
mp.WriteValueByAttributeCaption("ERP",erp); | |
worksheet.Cells[i,2].Value = "Аттрибут установлен"; | |
} | |
i++; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment