/// <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); }