public BoolVariableGrid(tblVariable tocopy) : base(tocopy) { try { tblBOOL tblbool = new tblBOOL(); tblbool.VarNameID = this.VarNameID; tblbool.SelectVarID(); this.Text0 = tblbool.Text0; this.Text1 = tblbool.Text1; Loaded = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//public void importBOOL(string filename,string controllername) public void AddBOOL(string filename, string controllername, string pouname) { if (MainForm.Instance().CurrentUser.LogicExplorer != (int)EXPLORER_ACCESS.Full) { System.Windows.Forms.MessageBox.Show("current user cannot add any Contrller"); } if (!File.Exists(filename)) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("File " + filename + " does not exist"); return; } int ControllerNameCol = -1; int pouNameCol = -1; int VarNameCol = -1; int ret = 0; string str; string _log = ""; bool headerline = true; tblBOOL tblbool = new tblBOOL(); tblController tblcontroller = tblSolution.m_tblSolution().GetControllerFromName(controllername); if (tblcontroller == null) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("Import BOOL Error: controller " + controllername + " does not exist in database"); return; } tblPou tblpou = tblcontroller.GetPouFromName(pouname); if (tblpou == null) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("Import BOOL Error: pou " + pouname + " does not exist in " + controllername); return; } //var transaction = Common.Conn.BeginTransaction(); using (StreamReader reader = new StreamReader(filename)) { while ((str = reader.ReadLine()) != null) { str.Replace(",,", ", ,"); if (str.StartsWith("!")) { continue; } if (headerline) { tblbool.headerString = str; headerline = false; ControllerNameCol = tblbool.ColumnExistInHeader("ControllerName"); if (ControllerNameCol == -1) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("BOOL add error: ControllerName column does not exist in " + filename); break; } pouNameCol = tblbool.ColumnExistInHeader("pouName"); if (pouNameCol == -1) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("BOOL add error: pouName column does not exist in " + filename); break; } VarNameCol = tblbool.ColumnExistInHeader("VarName"); if (VarNameCol == -1) { DCS.Forms.MainForm.Instance().WriteToOutputWindows("BOOL add error: VarName column does not exist in " + filename); break; } } else { tblbool = new tblBOOL(); string[] _strs = str.Split(new Char[] { ',' }); if ((_strs[ControllerNameCol].ToLower() == controllername) && (_strs[pouNameCol].ToLower() == pouname)) { if (tblpou.VariablesByName.ContainsKey(_strs[VarNameCol].ToLower())) { tblVariable tblvariable = tblpou.VariablesByName[_strs[VarNameCol].ToLower()]; tblbool.AddFromString(_strs, _strs[pouNameCol], ref _log); tblbool.VarNameID = tblvariable.VarNameID; if ((ret = tblbool.Insert()) != 0) { if (ret == 19) { DCS.Forms.MainForm.Instance().WriteToOutputWindows(_log + " Already exist in database"); } } } else { DCS.Forms.MainForm.Instance().WriteToOutputWindows("BOOL add Error: Varaible " + _strs[VarNameCol] + " does not exist in database"); } } } } reader.Close(); } //transaction.Commit(); }