public RealVariableGrid(tblVariable tocopy)
: base(tocopy)
{
try
{
tblREAL tblreal = new tblREAL();
tblreal.VarNameID = this.VarNameID;
tblreal.SelectVarID();
this.UNI = tblreal.UNI;
this.FOR = tblreal.FOR;
this.IRL = tblreal.IRL;
this.IRH = tblreal.IRH;
this.LL = tblreal.LL;
this.HH = tblreal.HH;
this.L = tblreal.L;
this.H = tblreal.H;
Loaded = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void AddREAL(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;
tblREAL tblreal = new tblREAL();
tblController tblcontroller = tblSolution.m_tblSolution().GetControllerFromName(controllername);
if (tblcontroller == null)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("Import REAL Error: controller " + controllername + " does not exist in database");
return;
}
tblPou tblpou = tblcontroller.GetPouFromName(pouname);
if (tblpou == null)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("Import REAL 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)
{
tblreal.headerString = str;
headerline = false;
ControllerNameCol = tblreal.ColumnExistInHeader("ControllerName");
if (ControllerNameCol == -1)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("REAL add error: ControllerName column does not exist in " + filename);
break;
}
pouNameCol = tblreal.ColumnExistInHeader("pouName");
if (pouNameCol == -1)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("REAL add error: pouName column does not exist in " + filename);
break;
}
VarNameCol = tblreal.ColumnExistInHeader("VarName");
if (VarNameCol == -1)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("REAL add error: VarName column does not exist in " + filename);
break;
}
}
else
{
tblreal = new tblREAL();
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()];
tblreal.AddFromString(_strs, _strs[pouNameCol], ref _log);
tblreal.VarNameID = tblvariable.VarNameID;
if ((ret = tblreal.Insert()) != 0)
{
if (ret == 19)
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows(_log + " Already exist in database");
}
}
}
else
{
DCS.Forms.MainForm.Instance().WriteToOutputWindows("REAL add Error: Varaible " + _strs[VarNameCol] + " does not exist in database");
}
}
}
}
reader.Close();
}
}
