/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BT_Search_Click(object sender, EventArgs e)
{
data = new Dictionary <string, object>();
if (!String.IsNullOrEmpty(TB_Sn.Text))
{
AsmRTrackingObject aro = AsmRTracking_BLL.GetAsmRTrackingObjectBySn(" SN='" + TB_Sn.Text.Trim() + "'");
if (aro != null)
{
label6.Text = TB_Sn.Text.Trim();
label6.Refresh();
label8.Text = aro.TypeName;
label8.Refresh();
label10.Text = aro.DT.ToString("yyyy-MM-dd HH:mm:ss");
label10.Refresh();
label12.Text = " ";
label12.Refresh();
//data = new Dictionary<string, object>();
data.Add("sn", TB_Sn.Text.Trim());
data.Add("productionType", aro.TypeName);
data.Add("onlineDate", aro.DT.ToString());
data.Add("offlineDate", "");
DataTable dt = Bolt_BLL.GetBoltByCondition(" SN='" + TB_Sn.Text.Trim() + "'");
if (dt.Rows.Count != 0)
{
DGV_Bolt.DataSource = dt;//DGV_Bolt接收数据
DGV_Bolt.Visible = true;
label3.Visible = true;
DGV_Bolt.ClearSelection();
}
else
{
label3.Visible = false;
DGV_Bolt.Visible = false;
}
data.Add("bolt", dt);
DataTable materialdt = AsmKeypart_BLL.GetKeypartByCondition(" SN='" + TB_Sn.Text.Trim() + "'");
if (materialdt.Rows.Count != 0)
{
DGV_Material.DataSource = materialdt;//DGV_Material接收数据
DGV_Material.Visible = true;
label2.Visible = true;
DGV_Material.ClearSelection();
}
else
{
label2.Visible = false;
DGV_Material.Visible = false;
}
data.Add("material", materialdt);
DataTable leakagedt = AsmLeakage_BLL.GetLeakageBySn(" SN='" + TB_Sn.Text.Trim() + "'");
if (leakagedt.Rows.Count != 0)
{
DGV_Leakage.DataSource = leakagedt;//DGV_Leakage接收数据
DGV_Leakage.Visible = true;
label5.Visible = true;
DGV_Leakage.ClearSelection();
}
else
{
label5.Visible = false;
DGV_Leakage.Visible = false;
}
data.Add("leakage", leakagedt);
return;
}
else
{
AsmPTrackingObject apo = AsmPTracking_BLL.GetPTrackingObjectByCondition(" SN='" + TB_Sn.Text.Trim() + "'");
if (apo != null)
{
label6.Text = TB_Sn.Text.Trim();
label6.Refresh();
label8.Text = apo.TypeName;
label8.Refresh();
label10.Text = apo.DT.ToString("yyyy-MM-dd HH:mm:ss");
label10.Refresh();
label12.Text = apo.OFFLINE_DT.ToString("yyyy-MM-dd HH:mm:ss");
label12.Refresh();
//data = new Dictionary<string, object>();
data.Add("sn", TB_Sn.Text.Trim());
data.Add("productionType", apo.TypeName);
data.Add("onlineDate", apo.DT.ToString());
data.Add("offlineDate", apo.OFFLINE_DT.ToString());
DataTable dt = Bolt_BLL.GetBoltByCondition(" SN='" + TB_Sn.Text.Trim() + "'");
if (dt.Rows.Count != 0)
{
DGV_Bolt.DataSource = dt;//DGV_Bolt接收数据
DGV_Bolt.Visible = true;
label3.Visible = true;
DGV_Bolt.ClearSelection();
}
else
{
label3.Visible = false;
DGV_Bolt.Visible = false;
}
data.Add("bolt", dt);
DataTable materialdt = AsmKeypart_BLL.GetKeypartByCondition(" SN='" + TB_Sn.Text.Trim() + "'");
if (materialdt.Rows.Count != 0)
{
DGV_Material.DataSource = materialdt;//DGV_Material接收数据
DGV_Material.Visible = true;
label2.Visible = true;
DGV_Material.ClearSelection();
}
else
{
label2.Visible = false;
DGV_Material.Visible = false;
}
data.Add("material", materialdt);
DataTable leakagedt = AsmLeakage_BLL.GetLeakageBySn(" SN='" + TB_Sn.Text.Trim() + "'");
if (leakagedt.Rows.Count != 0)
{
DGV_Leakage.DataSource = leakagedt;//DGV_Leakage接收数据
DGV_Leakage.Visible = true;
label5.Visible = true;
DGV_Leakage.ClearSelection();
}
else
{
label5.Visible = false;
DGV_Leakage.Visible = false;
}
data.Add("leakage", leakagedt);
return;
}
else
{
MessageBox.Show("不存在此总成号，请重新输入");
TB_Sn.Text = "";
}
}
}
else
{
MessageBox.Show("请输入总成号！");
}
}
