using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using WorkM;
|
|
namespace MES
|
{
|
public partial class FrmShow : Form
|
{
|
public FrmShow()
|
{
|
InitializeComponent();
|
}
|
|
private void pictureBox5_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void pictureBox1_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void textBox1_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
DAL.ClsSc_ProcessExchangeBill oPeb = new DAL.ClsSc_ProcessExchangeBill();
|
if (oPeb.GetIDByNo(DBUtility.ClsPub.isStrNull(txtHProcExchBillNo.Text), ref DBUtility.ClsPub.sExeReturnInfo) == false)
|
{
|
MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
long lngBillKey = oPeb.omodel.HInterID;
|
if (checkBox1.Checked == true)
|
{
|
GetLastOut(lngBillKey);
|
}
|
else
|
{
|
GetLotProc(lngBillKey);
|
}
|
|
}
|
}
|
|
private void checkBox1_CheckedChanged(object sender, EventArgs e)
|
{
|
txtHProcExchBillNo.Text = "";
|
txtHProcExchBillNo.Select();
|
}
|
|
|
private void GetLotProc(long lngBillKey)
|
{
|
DataSet DsCheck;
|
DataSet DsCheckIPQC;
|
DataSet DsCheck2;
|
DataSet Ds;
|
DataSet DsFIFO;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//ÅжÏÉϵÀ³öÕ¾ÊÇ·ñÆ·ÖÊÈ·ÈÏ
|
DsCheckIPQC = oCn.RunProcReturn("exec h_p_MES_CheckIPQCCheckByLot " + lngBillKey, "h_p_MES_CheckIPQCCheckByLot");
|
if (DsCheckIPQC.Tables[0].Rows.Count > 0)
|
{
|
if (DsCheckIPQC.Tables[0].Rows[0]["HBillType"].ToString() == "3791")
|
{
|
MessageBox.Show("³öÕ¾µ¥£º" + DsCheckIPQC.Tables[0].Rows[0]["HBillNo"].ToString() + ",δÌá½»IPQCÆ·ÖÊÈ·ÈÏ£¬²»ÔÊÐí¼ÌÐøɨÃ裡", "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
else
|
{
|
MessageBox.Show("ίÍâ½ÓÊÕµ¥£º" + DsCheckIPQC.Tables[0].Rows[0]["HBillNo"].ToString() + ",δÌá½»IPQCÆ·ÖÊÈ·ÈÏ£¬²»ÔÊÐí¼ÌÐøɨÃ裡", "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
//ÅжÏÊÇ·ñ´æÔÚ½ÓÊÕÊýÁ¿²»µÈÓÚ·¢³öÊýÁ¿²¢ÇÒûÓÐÌá½»MRBÆÀÉ󵥵ijöÕ¾µ¥
|
DsCheck2 = oCn.RunProcReturn("exec h_p_MES_CheckHaveNoPassByLot " + lngBillKey, "h_p_MES_CheckHaveNoPassByLot");
|
if (DsCheck2.Tables[0].Rows.Count > 0)
|
{
|
if (DsCheck2.Tables[0].Rows[0]["HBillType"].ToString() == "3791")
|
{
|
MessageBox.Show("³öÕ¾µ¥£º" + DsCheck2.Tables[0].Rows[0]["HBillNo"].ToString() + ",δÌá½»MRBÆÀÉóµ¥£¬²»ÔÊÐí¼ÌÐøɨÃ裡", "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
else
|
{
|
MessageBox.Show("ίÍâ½ÓÊÕµ¥£º" + DsCheck2.Tables[0].Rows[0]["HBillNo"].ToString() + ",δÌá½»MRBÆÀÉóµ¥£¬²»ÔÊÐí¼ÌÐøɨÃ裡", "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
//ÅжÏÊÇ·ñ´æÔÚδÉóºËMRBÆÀÉóµ¥
|
DsCheck = oCn.RunProcReturn("select * from QC_NoPassProdCheckBillMain where HProcExchInterID = " + lngBillKey + " and HChecker='' ", "QC_NoPassProdCheckBillMain");
|
if (DsCheck.Tables[0].Rows.Count > 0)
|
{
|
MessageBox.Show("ÉϵÀ¹¤ÐòMRBÆÀÉóµ¥Î´ÉóºË£¬²»ÔÊÐí¼ÌÐøɨÃ裡", "Ìáʾ");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
//µÃµ½LOT¿¨ÐÅÏ¢
|
Ds = oCn.RunProcReturn("exec h_p_Sc_GetProcByLotNo " + lngBillKey, "h_p_Sc_GetProcByLotNo");
|
if (Ds == null)
|
{
|
MessageBox.Show("´íÎóÔÒò£º" + DBUtility.ClsPub.sErrInfo);
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("LOTÎÞЧ!");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
//³öÕ¾µ¥
|
if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "out" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "×ÔÖÆ")
|
{
|
DsFIFO = oCn.RunProcReturn("exec h_p_MES_LotFIFO '" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["µ¥¾ÝºÅ"]) + "'," + DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HSubID"]) + ",'out'", "h_p_MES_LotFIFO");
|
if (DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) != "OK")
|
{
|
if (MessageBox.Show(DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) + ",ÊÇ·ñ¼ÌÐø£¿", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{ }
|
else
|
{
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
MES_StationOutBill oMES_StationOutBill = new MES_StationOutBill();
|
oMES_StationOutBill.lngBillKey = lngBillKey;
|
oMES_StationOutBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationOutBill.ShowDialog();
|
}
|
//ίÍâ½ÓÊÕ
|
else if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "out" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "ίÍâ")
|
{
|
//if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HChecker"]) == "")
|
//{
|
// MessageBox.Show("ίÍâ·¢³öµ¥:" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HJZBillNo"]) + "δÉóºË£¬²»ÔÊÐí½ÓÊÕ!");
|
// txtHProcExchBillNo.Text = "";
|
// return;
|
//}
|
if (DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HCloseType"]) != 0)
|
{
|
MessageBox.Show("ίÍâ·¢³öµ¥:" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HJZBillNo"]) + "Òѹرգ¬²»ÔÊÐí½ÓÊÕ!");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
DsFIFO = oCn.RunProcReturn("exec h_p_MES_LotFIFO '" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["µ¥¾ÝºÅ"]) + "'," + DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HSubID"]) + ",'out'", "h_p_MES_LotFIFO");
|
if (DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) != "OK")
|
{
|
if (MessageBox.Show(DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) + ",ÊÇ·ñ¼ÌÐø£¿", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{ }
|
else
|
{
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
MES_StationEntrustOutBill oMES_StationEntrustOutBill = new MES_StationEntrustOutBill();
|
oMES_StationEntrustOutBill.lngBillKey = lngBillKey;
|
oMES_StationEntrustOutBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationEntrustOutBill.ShowDialog();
|
}
|
//ίÍâ·¢³ö
|
else if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "in" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "ίÍâ")
|
{
|
//ÏȽøÏȳö
|
DsFIFO = oCn.RunProcReturn("exec h_p_MES_LotFIFO '" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["µ¥¾ÝºÅ"]) + "'," + DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HSubID"]) + ",'in'", "h_p_MES_LotFIFO");
|
if (DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) != "OK")
|
{
|
if (MessageBox.Show(DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) + ",ÊÇ·ñ¼ÌÐø£¿", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{ }
|
else
|
{
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
MES_StationEntrustInBill oMES_StationEntrustInBill = new MES_StationEntrustInBill();
|
oMES_StationEntrustInBill.lngBillKey = lngBillKey;
|
oMES_StationEntrustInBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationEntrustInBill.ShowDialog();
|
}
|
//½øÕ¾µ¥
|
else
|
{
|
DsFIFO = oCn.RunProcReturn("exec h_p_MES_LotFIFO '" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["µ¥¾ÝºÅ"]) + "'," + DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HSubID"]) + ",'in'", "h_p_MES_LotFIFO");
|
if (DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) != "OK")
|
{
|
if (MessageBox.Show(DBUtility.ClsPub.isStrNull(DsFIFO.Tables[0].Rows[0][0]) + ",ÊÇ·ñ¼ÌÐø£¿", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{ }
|
else
|
{
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
}
|
MES_StationInBill oMES_StationInBill = new MES_StationInBill();
|
oMES_StationInBill.lngBillKey = lngBillKey;
|
oMES_StationInBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationInBill.ShowDialog();
|
}
|
txtHProcExchBillNo.Text = "";
|
}
|
|
public MES_StationOutBill oFrm;
|
public MES_StationEntrustOutBill oFrm2;
|
private void GetLastOut(long HLotInterID)
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
Ds = oCn.RunProcReturn("exec h_p_Sc_GetLastOutByLotNo " + HLotInterID, "h_p_Sc_GetLastOutByLotNo");
|
if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0)
|
{
|
MessageBox.Show("²»´æÔÚ³öÕ¾µ¥£¡");
|
txtHProcExchBillNo.Text = "";
|
return;
|
}
|
if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]) == "×ÔÖÆ")
|
{
|
DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
|
if (oBill.ShowBill(DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]), ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
oFrm = new MES_StationOutBill();
|
oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
oFrm.BillOld = oBill;
|
oFrm.ShowDialog();
|
}
|
else
|
{
|
MessageBox.Show("µ¥¾ÝδÕÒµ½", "Ìáʾ");
|
}
|
oBill = null;
|
}
|
else
|
{
|
DAL.ClsSc_StationEntrustOutBill oBill = new DAL.ClsSc_StationEntrustOutBill();
|
if (oBill.ShowBill(DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]), ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
oFrm2 = new MES_StationEntrustOutBill();
|
oFrm2.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
oFrm2.BillOld = oBill;
|
oFrm2.ShowDialog();
|
}
|
else
|
{
|
MessageBox.Show("µ¥¾ÝδÕÒµ½", "Ìáʾ");
|
}
|
oBill = null;
|
}
|
txtHProcExchBillNo.Text = "";
|
}
|
|
private void pictureBox6_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void pictureBox2_Click(object sender, EventArgs e)
|
{
|
MES_StationOutBill oMES_StationOutBill = new MES_StationOutBill();
|
oMES_StationOutBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationOutBill.ModCaption = "Éú²úÍ깤»ã±¨µ¥";
|
oMES_StationOutBill.ShowDialog();
|
}
|
|
private void pictureBox3_Click(object sender, EventArgs e)
|
{
|
MES_StationInBill oMES_StationInBill = new MES_StationInBill();
|
oMES_StationInBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMES_StationInBill.ModCaption = "Éú²ú½øվȷÈϵ¥";
|
oMES_StationInBill.ShowDialog();
|
}
|
|
private void pictureBox4_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void pictureBox7_Click(object sender, EventArgs e)
|
{
|
Application.Exit();
|
}
|
}
|
}
|
