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();
}
