/// <summary>
/// 判断花色
/// </summary>
/// <param name="_lot"></param>
/// <returns></returns>
private System.Drawing.Image getImageDataFromOracle(string _lot)
{
//通过组件批次号 查询到bom 通过bom查询 iv_test查询功率 和电流
string _ivDataSQL1 = "select COEF_PMAX,PS_SUBCODE from ZWIP_IV_TEST_PRINTLOG where PS_SUBCODE is not null and LOT_NUMBER='" + _lot + "' ";
DataSet ds_iv1 = SQLServerDALServer.Query(_ivDataSQL1);
string sql = "select Picture,PS_SUBCODE,PS_SUBNAME,MAX_VALUE from ZFMM_POWERSET_DETAIL where PS_CODE='05w' and ITEM_NO=2 and PS_SUBCODE='γ'";
byte[] fileData = (byte[])SQLServerDALServer.GetSingle(sql);
System.IO.MemoryStream ms = new System.IO.MemoryStream(fileData);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
return(img);
}
/// <summary>
/// 判断子档位
/// </summary>
/// <param name="_lot"></param>
/// <returns></returns>
private System.Drawing.Image getImageDataFromOracle(string _lot)
{
//通过lotnumber得到bom和组件编号
string LOTSQL1 = "select COLOR,GRADE,ORG_ORDER_NUMBER,ORDER_NUMBER,MATERIAL_CODE from WIP_LOT where LOT_NUMBER='" + _lot + "' ";
ds_LOT = SQLServerDALServer.Query(LOTSQL1);
if (ds_LOT.Tables[0].Rows.Count > 0)
{
DataRow lotRow = ds_LOT.Tables[0].Rows[0];
//通过组件批次号 查询到bom 通过bom查询 iv_test查询功率 和电流 CoefPM
//string _ivDataSQL1 = "select COEF_PMAX,Coef_ISC,Coef_VOC,COEF_IMAX,COEF_VMAX,PS_CODE,PS_ITEM_NO,PS_SUBCODE from ZWIP_IV_TEST where IS_DEFAULT=1 and PS_SUBCODE is not null and LOT_NUMBER='" + _lot + "' order by Test_Time Desc ";
//string _ivDataSQL1 = "select * from ZWIP_IV_TEST where IS_DEFAULT=1 and PS_SUBCODE is not null and LOT_NUMBER='" + _lot + "' order by Test_Time Desc ";
//string _ivDataSQL2 = "SELECT COUNT(*) LINES FROM dbo.ZWIP_IV_TEST WHERELOT_NUMBER='" + _lot + "' AND IS_DEFAULT=1 ";
string _ivDataSQL1 = "select * from ZWIP_IV_TEST where IS_DEFAULT=1 and LOT_NUMBER='" + _lot + "' order by Test_Time Desc ";
ds_iv1 = SQLServerDALServer.Query(_ivDataSQL1);
//string _IVPRINTLOG = "select LOT_NUMBER,TEST_TIME,EQUIPMENT_CODE from ZWIP_IV_TEST_PRINTLOG where LOT_NUMBER='" + txtContent.Text.Trim().ToUpper() + "' and TEST_TIME='" + ds_iv1.Tables[0].Rows[0]["TEST_TIME"].ToString() + "' and EQUIPMENT_CODE='" + ds_iv1.Tables[0].Rows[0]["EQUIPMENT_CODE"].ToString() + "' and ITEM_NO=1";
if (ds_iv1.Tables[0].Rows.Count > 0)
{
string sql = "";
int _pm = getPMFromWorkOrderRule(lotRow["ORDER_NUMBER"].ToString(), lotRow["MATERIAL_CODE"].ToString(), float.Parse(ds_iv1.Tables[0].Rows[0]["COEF_PMAX"].ToString()));
if (_pm == null || _pm == 0)
{
//_pm = PMShowMsg(float.Parse(ds_iv1.Tables[0].Rows[0]["COEF_PMAX"].ToString()));
MessageBox.Show("IV数据异常，请重新测试！");
}
sql = @" select Picture from ZPPM_WORK_ORDER_PRD_POWERSET_DETAIL
where PS_CODE='" + ds_iv1.Tables[0].Rows[0]["PS_CODE"].ToString() + "'"
+ " and ITEM_NO=" + ds_iv1.Tables[0].Rows[0]["PS_ITEM_NO"].ToString()
+ " and PS_SUBCODE='" + ds_iv1.Tables[0].Rows[0]["PS_SUBCODE"].ToString() + "'"
+ " and ORDER_NUMBER='" + lotRow["ORDER_NUMBER"].ToString() + "'"
+ " and MATERIAL_CODE='" + lotRow["MATERIAL_CODE"].ToString() + "'";
byte[] fileData = (byte[])SQLServerDALServer.GetSingle(sql);
if (fileData != null)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream(fileData);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
return(img);
}
sql = "select Picture from ZFMM_POWERSET_DETAIL where PS_CODE='" + ds_iv1.Tables[0].Rows[0]["PS_CODE"].ToString() + "' and ITEM_NO=" + ds_iv1.Tables[0].Rows[0]["PS_ITEM_NO"].ToString() + " and PS_SUBCODE='" + ds_iv1.Tables[0].Rows[0]["PS_SUBCODE"].ToString() + "'";
fileData = (byte[])SQLServerDALServer.GetSingle(sql);
if (fileData != null)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream(fileData);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
return(img);
}
else
{
return(null);
}
}
else
{
MessageBox.Show("IV数据不存在");
}
}
return(null);
}
