private void txtModuleID_KeyPress(object sender, KeyPressEventArgs e)
{
string strProductType;
string strSizeWeight;
string[] arySizeWeight;
if (e.KeyChar == 13)
{
if (txtModuleID.Text == "")
{
MessageBox.Show(this, "请扫描组件序列号！");
return;
}
//与数据库比对
DataTable dt = objCRUD.QueryPmaxByModuleID(txtModuleID.Text);
if (dt == null)
{
MessageBox.Show(this, "没有查询到该组件序列号！");
txtModuleID.Text = "";
return;
}
string strPmax = dt.Rows[0]["Pmax"].ToString();
string strimp = dt.Rows[0]["IPM"].ToString();
dt = null;
//车间
dt = objCRUD.Queryarea(txtModuleID.Text);
string strcej = dt.Rows[0]["PRIDISPLAYNAME"].ToString();
dt = null;
DYCJ.SelectedItem = strcej;
dt = objCRUD.QueryareaBZ(txtModuleID.Text);
string strcejBZ = dt.Rows[0]["workshop"].ToString();
dt = null;
//dt = objCRUD.QueryAssembleByModuleID(txtModuleID.Text);
dt = objCRUD.QueryFamilyCodeByModuleID(txtModuleID.Text);
//查询装配件号改为查询组件的装配件号 add by xue lei on 2017-12-2
if (dt != null && dt.Rows.Count > 0)
{
//txtProductType.Text = dt.Rows[0]["product_code"].ToString();
txtProductType.Text = dt.Rows[0]["ProductType"].ToString();
}
else
{
//MessageBox.Show("未查询到组件的装配件号");
MessageBox.Show("未查询到组件的产品族");
return;
}
/**************************************************************
* string strcj = "";
* if (DYCJ.SelectedItem.ToString() == "一车间")
* strcj = "M01";
* else if (DYCJ.SelectedItem.ToString() == "二车间")
* strcj = "M02";
* else if (DYCJ.SelectedItem.ToString() == "三车间")
* strcj = "M03";
****88888888888888888888888888888888888888888/
* /**************************************************************/
#region 查询组件序列号的产品族&组件尺寸和重量
//查询组件序列号的产品族&组件尺寸和重量 add by lei.xue on 2017-3-19==========================================
//dt = null;
//dt = objCRUD.QueryProductTypeByModuleLot(txtModuleID.Text);
//if (dt != null && dt.Rows.Count > 0)
//{
// txtProductType.Text = dt.Rows[0]["producttype"].ToString();
// strSizeWeight = dt.Rows[0]["sizeweight"].ToString();
// arySizeWeight = strSizeWeight.Split(',');
// if (arySizeWeight.Length >= 5)
// {
// txtSize.Text = arySizeWeight[3];
// txtWeight.Text = arySizeWeight[4];
// }
//}
//else
//{
// MessageBox.Show("未查询到产品族、尺寸和重量信息");
// return;
//}
//查询组件序列号的产品族&组件尺寸和重量 add by lei.xue on 2017-3-19==========================================
#endregion
string strAssembly = "";
string strAeesmblyMatchPmax = "";
if (strimp == "")
{
dt = objCRUD.QueryLabelInfo1(strcejBZ, strPmax, txtProductType.Text);
}
else
{
dt = objCRUD.QueryLabelInfo(strcejBZ, strimp, strPmax, txtProductType.Text);
}
if (dt != null && dt.Rows.Count > 0)
{
txtPmax.Text = dt.Rows[0]["Pmax"].ToString();
txtVmp.Text = dt.Rows[0]["Vmp"].ToString();
txtVoc.Text = dt.Rows[0]["Voc"].ToString();
txtVolmax.Text = dt.Rows[0]["Volmax"].ToString();
txtModuleapp.Text = dt.Rows[0]["ModuleApp"].ToString();
txtFusemax.Text = dt.Rows[0]["Fusemax"].ToString();
txtIsc.Text = dt.Rows[0]["Isc"].ToString();
txtImp.Text = dt.Rows[0]["Imp"].ToString();
DYCJ.SelectedText = strcej;
//装配件号的第3、4、5位用配置表里的pmax替换
//txtProductType.Text = strAeesmblyMatchPmax;
if (txtProductType.Text.Substring(2, 3).ToString() == "***")
{
//配置信息中的装配件号第3、4、5位用*号替换
txtProductType.Text = txtProductType.Text.Replace("***", txtPmax.Text);
}
}
else
{
MessageBox.Show("未查询到配置信息");
return;
}
btnPrint_Click(null, null);
}
}
