/// <summary> /// setup the Equipment template /// </summary> /// <returns></returns> public List <templateOutput> GetXmlTemplateOutput() { var templateOutputs = new List <templateOutput>(); TagGenLink = EquipName + "." + Suffix; if (BaseAddressParam.Equals(BaseAddr.Status)) { AddressOffset = TagAddress - BaseAddrPairs[BaseAddr.Status.ToString()]; templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_VarDiscreteOutputs(this)); } //require both tag and alarm tag if (BaseAddressParam == BaseAddr.Alarm) { AddressOffset = TagAddress - BaseAddrPairs[BaseAddr.Alarm.ToString()]; templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_VarDiscreteOutputs(this)); templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_DigAlmOutputs(this)); } //create tag and trend tag (if required) if (BaseAddressParam.Equals(BaseAddr.Analog)) { AddressOffset = TagAddress - BaseAddrPairs[BaseAddr.Analog.ToString()]; templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_VarAnalogOutputs(this)); if (SetTrends) { templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_TrnOutputs(this)); } } //create totalisers if (BaseAddressParam.Equals(BaseAddr.Totalisers)) { AddressOffset = TagAddress - BaseAddrPairs[BaseAddr.Totalisers.ToString()]; templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_VarAnalogOutputs(this)); } //create calculated variable (if specified) if (IsCalCulated) { templateOutputs.Add(TomPriceEquipmentTemplate.GetEquipmentType_CalculatedCommandVariable(this)); } return(templateOutputs); }
/// <summary> /// /// </summary> public bool ConvertTagsInExcelToTemplate(DataSet ds) { foreach (DataTable dtTable in ds.Tables) { //DEBUG if (dtTable.TableName.Contains("Chlo")) { log.Debug("stop"); } var equipmentTypeTemplate = new template { desc = dtTable.TableName }; //name of worksheet - equipment type name equipmentTypeTemplate.param = TomPriceEquipmentTemplate.GetEquipmentType_Param(dtTable.TableName, ""); equipmentTypeTemplate.input = TomPriceEquipmentTemplate.GetEquipmentType_Input(); var templateOutputs = new List <templateOutput>(); //get baseaddress? var baseAddressList = new Dictionary <string, int>(); foreach (DataRow row in dtTable.AsEnumerable().Take(4)) { baseAddressList.Add(row["Tag Name"].ToString(), int.Parse(row["Address"].ToString())); } //put the information into class var outputparams = new List <EquipmentTypeOutputParam>(); string equipment = ""; foreach (DataRow row in dtTable.AsEnumerable().Skip(4)) { //inner exception if (row.IsNull("Tag Name")) { continue; } string tagName = row["Tag Name"].ToString().Replace('.', '_'); equipment = row.IsNull("Equipment") ? equipment : row["Equipment"].ToString(); var nameSplit = tagName.Split(new char[] { '_', '.' }); try { int.TryParse(Regex.Match(row["Address"].ToString(), @"\d+").Value, out int plcNumericAddress); var outputparam = new EquipmentTypeOutputParam { EquipName = dtTable.TableName.Replace(" ", string.Empty), Comment = row["Comment"].ToString(), DataType = row["Data Type"].ToString(), Suffix = tagName.Substring(tagName.IndexOf(equipment) + equipment.Length).TrimStart(new char[] { '_', '.', ',', '|' }), //suffix is anything after equipment name string Prefix = nameSplit[0], BaseAddrPairs = baseAddressList, BaseAddressParam = !row.IsNull("Tag Type") ? (BaseAddr)Enum.Parse(typeof(BaseAddr), row["Tag Type"].ToString()):BaseAddr.None, TagAddress = plcNumericAddress, AlmCategory = row.IsNull("Category") ? "" : row["Category"].ToString(), RawZero = row.IsNull("Raw Zero Scale") ? "0" : row["Raw Zero Scale"].ToString(), RawFull = row.IsNull("Raw Full Scale") ? "0" : row["Raw Full Scale"].ToString(), EngZero = row.IsNull("Eng Zero Scale") ? "0" : row["Eng Zero Scale"].ToString(), EngFull = row.IsNull("Eng Full Scale") ? "0" : row["Eng Full Scale"].ToString(), SetTrends = row.IsNull("Set Trend") ? false : bool.Parse(row["Set Trend"].ToString()), Units = row.IsNull("Eng Units") ? string.Empty : row["Eng Units"].ToString(), Format = row.IsNull("Format") ? string.Empty : row["Format"].ToString() }; if (!row.IsNull(@"I/O Device")) { if (row["I/O Device"].ToString().Equals("CICODESVR")) { outputparam.DeviceIO = row["I/O Device"].ToString(); outputparam.FuncName = row["Address"].ToString(); outputparam.IsCalCulated = true; } else { outputparam.DeviceIO = row["I/O Device"].ToString(); } } outputparams.Add(outputparam); } catch (Exception ex) { log.ErrorFormat("ConvertTagToTemplate:{0},{1}", tagName, ex); } } //find duplicates in list? var result = outputparams.GroupBy(x => x.Suffix.TrimStart(new char[] { '_', '.', ',' })).Select(y => new { suffix = y.Key, count = y.Count() }); foreach (var rec in result.Where(a => a.count > 1)) { log.WarnFormat("Please correct tag list: possible duplication of tags, suffux: {0} for {1}", rec.suffix, dtTable.TableName); } //get xml formatted string from outputparams outputparams.ForEach(s => templateOutputs.AddRange(s.GetXmlTemplateOutput())); if (templateOutputs.Count > 0) { equipmentTypeTemplate.output = templateOutputs.ToArray(); } //add to list EquipmentTypeTemplates.Add(equipmentTypeTemplate); } //serialise to XML EquipmentTypeTemplates.ForEach(s => SerializeEquipmentTypeTemplate(s, s.desc)); return(EquipmentTypeTemplates.Count > 0); }