private void FillRawDataTable(DataTable tbl, int row, int column)
{
int columnP1 = 1;
var db = DbScheme.Connections["Main"];
string dataCn = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "RawData");
for (int i = 0; i < row; i++)
{
double[] rowData = (MyCogToolBlock.Outputs[string.Format("strRow{0}", i + 1)].Value as string).Split(',').Select(x => double.Parse(x)).ToArray();
string viewRowLabel = db.ExecuteScalar <string>("select textCn from ViewScheme where ccdId = ? and brandId = ? and viewId = ? and recordId = ?", CcdId, BrandId, 0, i);
DataRow labelRow = tbl.NewRow();
string sql = "select * from CcdCompValue where ccdId = ? and brandId = ? and item between ? and ? order by item";
int itemStart = i * column;
int itemEnd = i * column + column - 1;
var qurey = db.Query <CcdCompValue>(sql, CcdId, BrandId, itemStart, itemEnd).ToArray();
for (int j = 0; j < column; j++)
{
labelRow[j + columnP1] = qurey[j].Label;
}
labelRow[columnP1 - 1] = viewRowLabel;
tbl.Rows.Add(labelRow);
DataRow dataRow = tbl.NewRow();
for (int j = 0; j < column; j++)
{
dataRow[j + columnP1] = rowData[j];
}
dataRow[columnP1 - 1] = dataCn;
tbl.Rows.Add(dataRow);
}
var dgv = StationViews.GetDgv("RawData", CcdId);
if (dgv.InvokeRequired)
{
dgv.Invoke(new Action(() =>
{
dgv.DataSource = tbl;
dgv.DgvLayout();
}));
}
else
{
dgv.DataSource = tbl;
dgv.DgvLayout();
}
}
private void FillRefValue(DataTable tbl, int row, int column)
{
int columnP1 = 1;
var db = DbScheme.Connections["Main"];
string r0Text = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "r0");
string r1Text = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "r1");
string r2Text = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "r2");
for (int i = 0; i < row; i++)
{
string viewRowLabel = db.ExecuteScalar <string>("select textCn from ViewScheme where ccdId = ? and brandId = ? and viewId = ? and recordId = ?", CcdId, BrandId, 0, i);
DataRow labelRow = tbl.NewRow();
DataRow r0Row = tbl.NewRow();
DataRow r1Row = tbl.NewRow();
DataRow r2Row = tbl.NewRow();
string sql = "select * from CcdCompValue where ccdId = ? and brandId = ? and item between ? and ? order by item";
int itemStart = i * column;
int itemEnd = i * column + column - 1;
var qurey = db.Query <CcdCompValue>(sql, CcdId, BrandId, itemStart, itemEnd).ToArray();
for (int j = 0; j < column; j++)
{
labelRow[j + columnP1] = qurey[j].Label;
r0Row[j + columnP1] = qurey[j].R0;
r1Row[j + columnP1] = qurey[j].R1;
r2Row[j + columnP1] = qurey[j].R2;
}
labelRow[columnP1 - 1] = viewRowLabel;
r0Row[columnP1 - 1] = r0Text;
r1Row[columnP1 - 1] = r1Text;
r2Row[columnP1 - 1] = r2Text;
tbl.Rows.Add(labelRow);
tbl.Rows.Add(r2Row);
tbl.Rows.Add(r1Row);
tbl.Rows.Add(r0Row);
}
var dgv = StationViews.GetDgv("RefValue", CcdId);
if (dgv.InvokeRequired)
{
dgv.Invoke(new Action(() =>
{
dgv.DataSource = tbl;
dgv.DgvLayout();
}));
}
else
{
dgv.DataSource = tbl;
dgv.DgvLayout();
}
}
private bool FillDataTable(DataTable tbl, int row, int column)
{
bool result = false;
int columnP1 = 1;
var db = DbScheme.Connections["Main"];
bool bSuccess = (MyCogToolBlock.RunStatus.Result == CogToolResultConstants.Accept);
foreach (CogToolBlock toolBlock in MyCogToolBlock.Tools.OfType <CogToolBlock>())
{
if (toolBlock.RunStatus.Result != CogToolResultConstants.Accept)
{
bSuccess = false;
}
}
double ErrorValue = -1000000.0;
string r1Text = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "r1");
string r2Text = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "r2");
string dataCn = db.ExecuteScalar <string>("select textCn from UiGlossary where name = ?", "Data");
for (int i = 0; i < row; i++)
{
double[] rowData = (MyCogToolBlock.Outputs[string.Format("strRow{0}", i + 1)].Value as string).Split(',').Select(x => double.Parse(x)).ToArray();
string viewRowLabel = db.ExecuteScalar <string>("select textCn from ViewScheme where ccdId = ? and brandId = ? and viewId = ? and recordId = ?", CcdId, BrandId, 0, i);
if (!bSuccess)
{
for (int ic = 0; ic < rowData.Length; ic++)
{
rowData[ic] = ErrorValue;
}
}
DataRow labelRow = tbl.NewRow();
DataRow r1Row = tbl.NewRow();
DataRow r2Row = tbl.NewRow();
string sql = "select * from CcdCompValue where ccdId = ? and brandId = ? and item between ? and ? order by item";
int itemStart = i * column;
int itemEnd = i * column + column - 1;
var qurey = db.Query <CcdCompValue>(sql, CcdId, BrandId, itemStart, itemEnd).ToArray();
for (int j = 0; j < column; j++)
{
labelRow[j + columnP1] = qurey[j].Label;
r1Row[j + columnP1] = qurey[j].R1;
r2Row[j + columnP1] = qurey[j].R2;
}
labelRow[columnP1 - 1] = viewRowLabel;
r1Row[columnP1 - 1] = r1Text;
r2Row[columnP1 - 1] = r2Text;
tbl.Rows.Add(labelRow);
tbl.Rows.Add(r2Row);
tbl.Rows.Add(r1Row);
DataRow dataRow = tbl.NewRow();
for (int j = 0; j < column; j++)
{
dataRow[j + columnP1] = rowData[j];
}
dataRow[columnP1 - 1] = dataCn;
tbl.Rows.Add(dataRow);
}
var dgv = StationViews.GetDgv("Data", CcdId);
if (dgv.InvokeRequired)
{
dgv.Invoke(new Action(() =>
{
dgv.DataSource = tbl;
dgv.DgvLayout();
result = dgv.CheckResultData(row, column);
}));
}
else
{
dgv.DataSource = tbl;
dgv.DgvLayout();
result = dgv.CheckResultData(row, column);
}
VirtualIo vIo = VirtualIo.GetDevice(CcdId);
if (result)
{
vIo.SetOk();
UiMainForm.LogMessage(string.Format("Ccd{0}输出OK信号", CcdId));
}
else
{
vIo.SetNg();
UiMainForm.LogMessage(string.Format("Ccd{0}输出NG信号", CcdId));
}
ZoneInfo zinfo = UiZoneInfo.Infos[CcdId];
zinfo.Show(result);
UiMainForm.LogMessage(string.Format("Ccd{0}运行结束", CcdId));
return(result);
}
