public static string GetAuthorOfComputer()
{
string author = "";
List<string> macAddresses = GetMacAddressOfCurrentComputer();
foreach (string macAddress in macAddresses)
{
SqlSelect sqlSelect = new SqlSelect(TbPeopleHardwareAddress.Name);
sqlSelect.Like(TbPeopleHardwareAddress.MacAddress, macAddress);
sqlSelect.RetrieveData();
if (sqlSelect.CountOfRows == 1)
{
author = sqlSelect.GetValueOfField(TbPeopleHardwareAddress.SurnameAndName).ToString();
break;
}
}
return author != "" ? author : macAddresses[0];
}
private void ConstructSelectQuery(ref SqlSelect sqlSelectQuery)
{
if (tbGlobalSearch.Text != "")
{
string str = tbGlobalSearch.Text;
sqlSelectQuery.TypeOfLogicIsAnd = false;
sqlSelectQuery.Like(TbMaterials.MaterialId, str);
sqlSelectQuery.Like(TbMaterials.AuthorOfRecord, str);
sqlSelectQuery.Like(TbMaterials.Comment, str);
sqlSelectQuery.Like(TbMaterials.ConcentrationInWafer, str);
sqlSelectQuery.Like(TbMaterials.Corresponds, str);
sqlSelectQuery.Like(TbMaterials.CreationDate, str);
sqlSelectQuery.Like(TbMaterials.Ingot, str);
sqlSelectQuery.Like(TbMaterials.LaunchedStatus, str);
sqlSelectQuery.Like(TbMaterials.MaterialOfWafer, str);
sqlSelectQuery.Like(TbMaterials.RecordIdOfAttachmentFile, str);
sqlSelectQuery.Like(TbMaterials.RecordIdOfEpitStructureFile, str);
sqlSelectQuery.Like(TbMaterials.Technology, str);
sqlSelectQuery.Like(TbMaterials.TechProc, str);
sqlSelectQuery.Like(TbMaterials.StructureManufacturer, str);
sqlSelectQuery.Like(TbMaterials.ThicknessOfWafer, str);
sqlSelectQuery.Like(TbMaterials.TypeOfWafer, str);
sqlSelectQuery.Like(TbMaterials.VerificationStatus, str);
sqlSelectQuery.Like(TbMaterials.WaferDiameter, str);
sqlSelectQuery.Like(TbMaterials.WaferManufacturer, str);
sqlSelectQuery.Like(TbMaterials.WaferResistance, str);
return;
}
if (tbNumberOfParty.Text != "")
sqlSelectQuery.Equal(TbMaterials.NumberOfParcel, tbNumberOfParty.Text);
if (!rbDontWantWNFilter.Checked)
{
if (tbNumberOfWafers.Enabled)
{
int x = Int32.Parse(tbNumberOfWafers.Text);
sqlSelectQuery.Equal(TbMaterials.NumberOfWafer, x);
}
if (tbNumberOfWafersStart.Enabled)
{
int x1 = Int32.Parse(tbNumberOfWafersStart.Text);
sqlSelectQuery.MoreOrEqual(TbMaterials.NumberOfWafer, x1);
}
if (tbNumberOfWafersFinish.Enabled)
{
int x2 = Int32.Parse(tbNumberOfWafersFinish.Text);
sqlSelectQuery.LessOrEqual(TbMaterials.NumberOfWafer, x2);
}
}
if (!rbDontWantDateFilter.Checked)
{
if (dtpCreationTime.Enabled)
sqlSelectQuery.Equal(TbMaterials.CreationDate, dtpCreationTime.Value.Date);
if (dtpCreationStart.Enabled)
sqlSelectQuery.MoreOrEqual(TbMaterials.CreationDate, dtpCreationStart.Value.Date);
if (dtpCreationFinish.Enabled)
sqlSelectQuery.LessOrEqual(TbMaterials.CreationDate, dtpCreationFinish.Value.Date);
}
if (cbAuthorOfRecord.Text != "")
sqlSelectQuery.Equal(TbMaterials.AuthorOfRecord, cbAuthorOfRecord.Text);
if (cbDefinitionOfWafer.Text != "")
sqlSelectQuery.Equal(TbMaterials.WaferManufacturer, cbDefinitionOfWafer.Text);
if (cbTypeOfWafer.Text != "")
sqlSelectQuery.Equal(TbMaterials.TypeOfWafer, cbTypeOfWafer.Text);
if (cbMaterialOfWafer.Text != "")
sqlSelectQuery.Equal(TbMaterials.MaterialOfWafer, cbMaterialOfWafer.Text);
if (!rbDontWantConcFilter.Checked)
{
if (tbConcOfWafer.Enabled)
sqlSelectQuery.Equal(TbMaterials.ConcentrationInWafer, Double.Parse(tbConcOfWafer.Text));
if (tbConcOfWaferStart.Enabled)
sqlSelectQuery.MoreOrEqual(TbMaterials.ConcentrationInWafer, Double.Parse(tbConcOfWaferStart.Text));
if (tbConcOfWaferFinish.Enabled)
sqlSelectQuery.LessOrEqual(TbMaterials.ConcentrationInWafer, Double.Parse(tbConcOfWaferFinish.Text));
}
if (!rbDontWantWTFilter.Checked)
{
if (tbThicknessOfWafer.Enabled)
{
double thickness = Double.Parse(tbThicknessOfWafer.Text);
if (cbWaferThicknessDim.Text == "нм")
thickness /= 1000;
sqlSelectQuery.Equal(TbMaterials.ThicknessOfWafer, thickness);
}
if (tbThicknessOfWaferStart.Enabled)
{
double thickness = Double.Parse(tbThicknessOfWaferStart.Text);
if (cbWaferThicknessDimStart.Text == "нм")
thickness /= 1000;
sqlSelectQuery.MoreOrEqual(TbMaterials.ThicknessOfWafer, thickness);
}
if (tbThicknessOfWaferFinish.Enabled)
{
double thickness = Double.Parse(tbThicknessOfWaferFinish.Text);
if (cbWaferThicknessDimFinish.Text == "нм")
thickness /= 1000;
sqlSelectQuery.LessOrEqual(TbMaterials.ThicknessOfWafer, thickness);
}
}
if (!rbStatusAll.Checked)
{
if (rbStatusLaunched.Checked)
sqlSelectQuery.Equal(TbMaterials.LaunchedStatus, "YES");
if (rbStatusNoLaunched.Checked)
sqlSelectQuery.Equal(TbMaterials.LaunchedStatus, "NO");
}
if (cbTechnology.Text != "")
{
sqlSelectQuery.Equal(TbMaterials.Technology, cbTechnology.Text);
}
if (cbTechProc.Text != "")
{
sqlSelectQuery.Equal(TbMaterials.TechProc, cbTechProc.Text);
}
if (cbManufacturer.Text != "")
{
sqlSelectQuery.Equal(TbMaterials.StructureManufacturer, cbManufacturer.Text);
}
if (tbIngot.Text != "")
{
sqlSelectQuery.Equal(TbMaterials.Ingot, tbIngot.Text);
}
if (tbCorresponds.Text != "")
{
sqlSelectQuery.Equal(TbMaterials.Corresponds, tbCorresponds.Text);
}
}