29 KiB
using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using ICSSoft.Base.Config.DBHelper; using ICSSoft.Base.Config.AppConfig; using ICSSoft.Frame.Data.Entity; using System.Collections; using System.IO; using ICSSoft.Frame.Data.BLL; using ICSSoft.Frame.DataConnect.Action; using ICSSoft.Frame.DataConnect; using ICSSoft.Frame.DataCollect;
namespace ICSSoft.Frame.APP { public delegate void LotCodeChangeEventHandler(string ItemCode, string RouteCode, string OpCode);
public partial class UserControlCollectBeginTop : UserControl { public event LotCodeChangeEventHandler LotCodeChange; private const string PAUSE = "暂停"; private const string CANCELPAUSE = "取消暂停"; private const string START = "开工"; private const string END = "完工"; private string Status; private string routeCode; private string EQPType; private string partCode = ""; private string partSpec = "";
#region 采集
public UserControlCollectBeginTop() { InitializeComponent();
txtUserCode.Focus(); }
#region 员工条码 private void txtUserCode_KeyPress(object sender, KeyPressEventArgs e) { try {
if (e.KeyChar == (char)Keys.Enter) { string UserCode = txtUserCode.Text.Trim(); string sql = "select distinct ID, UserCode,UserName from dbo.Sys_User with(nolock) where UserCode='{0}'"; sql = string.Format(sql, UserCode); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
if (data.Rows.Count > 0) { foreach (DataRow dr in data.Rows) { txtUserCode.Text = dr["UserCode"].ToString(); txtUserName.Text = dr["UserName"].ToString(); } txtLotNo.Focus(); SetMsg(Color.Blue, ""); } else { txtUserName.Text = ""; txtUserCode.SelectAll(); txtUserCode.Focus(); SetMsg(Color.Red, "员工条码不存在！"); } } } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } #endregion
#region 产品跟踪单号 private void txtLotNo_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == (char)Keys.Enter) { #region 20200820新增防呆 string chksql = @"select ISNULL(EATTRIBUTE6,'') AS EATTRIBUTE6 from ICSITEMLot where LotNO='{0}' AND WorkPoint='{1}'"; chksql = string.Format(chksql, txtLotNo.Text.Trim(), AppConfig.WorkPointCode); DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, chksql).Tables[0]; if (dt.Rows.Count == 0) { ICSBaseSimpleCode.AppshowMessageBox("产品跟踪单号不存在!!"); return; } else { if (dt.Rows[0]["EATTRIBUTE6"].ToString() == "") { ICSBaseSimpleCode.AppshowMessageBox("产品跟踪单号未绑定零件号，请先绑定再发料!!"); return; } } #endregion btnStart.Text = START; btnPauseBegin.Text = PAUSE; string LotNo = txtLotNo.Text.Trim(); string sql = @"SELECT DISTINCT a.ID, a.LOTNO, a.LOTQTY, b.MOCODE, b.ITEMCODE, a.VenderLotNO, c.INVNAME AS ItemName, d.LOTStatus, CASE d.CollectStatus WHEN 'COLLECT_BEGIN' THEN 'WG' ELSE 'KG' END AS Status FROM ICSITEMLot a WITH (nolock) LEFT JOIN ICSMO b WITH (nolock) ON a.TransNO = b.MOCODE AND a.TransLine=b.MOSEQ LEFT JOIN ICSINVENTORY c WITH (nolock) ON b.ITEMCODE = c.INVCODE LEFT JOIN ICSLOTSIMULATION d WITH(nolock) ON a.LOTNO = d.LOTNO WHERE a.LOTNO = '{0}'"; sql = string.Format(sql, LotNo); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
if (data.Rows.Count > 0) { foreach (DataRow dr in data.Rows) { txtLotNo.Text = dr["LOTNO"].ToString(); //txtLotNo.Tag = dr["LOTSEQ"].ToString(); //txtLotQty.Text = dr["LOTQTY"].ToString(); txtItemCode.Text = dr["ITEMCODE"].ToString(); txtItemName.Text = dr["ItemName"].ToString(); txtMoCode.Text = dr["MOCODE"].ToString(); txtVenderLotNO.Text = dr["VenderLotNO"].ToString(); Status = dr["Status"].ToString(); if (dr["Status"].ToString().Equals("WG")) btnStart.Text = END; if (dr["LOTStatus"].ToString().Equals(PAUSE)) btnPauseBegin.Text = CANCELPAUSE;
if (LotCodeChange != null) { LotCodeChange(txtItemCode.Text.Trim(), routeCode, txtOpCode.Text.Trim()); } }
txtOpCode.Focus(); SetMsg(Color.Blue, ""); } else { //txtLotNo.Tag = ""; //txtLotQty.Text = ""; txtItemCode.Text = ""; txtItemName.Text = ""; txtMoCode.Text = ""; txtLotNo.SelectAll(); txtLotNo.Focus(); txtInvLotFurnace.Text = ""; SetMsg(Color.Red, "产品跟踪单号不存在！"); } } } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } #endregion
#region 工序条码 private void txtOpCode_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == (char)Keys.Enter) { btnStart.Text = START; btnPauseBegin.Text = PAUSE; string OpCode = txtOpCode.Text.Trim(); string LOTNO = txtLotNo.Text.Trim(); string sql = @"SELECT DISTINCT a.ID, a.OPCODE, a.OPDESC, b.RouteCode, b.EQPCode, b.EQPName,d.LOTStatus, CASE d.CollectStatus WHEN 'COLLECT_BEGIN' THEN 'WG' ELSE 'KG' END AS Status, Type,ISNULL(b.EATTRIBUTE1,0) AS EATTRIBUTE1 FROM ICSOP a WITH (nolock) LEFT JOIN ICSMO2User b WITH(nolock) ON a.OPCODE = b.OPCODE LEFT JOIN ICSLOTSIMULATION d WITH(nolock) ON b.LOTNO = d.LOTNO and b.OPCODE=d.OPCODE LEFT JOIN ICSEquipment e WITH(nolock) ON b.EQPCode=e.EQPCode WHERE b.OPCODE = '{0}' AND b.LOTNO = '{1}'"; sql = string.Format(sql, OpCode, LOTNO); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
if (data.Rows.Count > 0) { SetMsg(Color.Blue, ""); foreach (DataRow dr in data.Rows) { //if (dr["EATTRIBUTE1"].ToString()=="1") /{ / txtOpName.Text = ""; / txtEQPCode.Text = ""; / txtEQPName.Text = ""; / Status = ""; / routeCode = ""; / EQPType = ""; / txtOpCode.SelectAll(); / txtOpCode.Focus(); / SetMsg(Color.Red, "委外工序不能在此界面报工！"); / return; /}
txtOpCode.Text = dr["OPCODE"].ToString(); txtOpName.Text = dr["OPDESC"].ToString(); txtEQPCode.Text = dr["EQPCode"].ToString(); txtEQPName.Text = dr["EQPName"].ToString(); Status = dr["Status"].ToString(); routeCode = dr["RouteCode"].ToString(); EQPType = dr["Type"].ToString(); if (dr["Status"].ToString().Equals("WG")) btnStart.Text = END; if (dr["LOTStatus"].ToString().Equals(PAUSE)) btnPauseBegin.Text = CANCELPAUSE; }
if (LotCodeChange != null) { LotCodeChange(txtItemCode.Text.Trim(), routeCode, txtOpCode.Text.Trim()); }
this.txtRealEQP.SelectAll(); this.txtRealEQP.Focus();
} else { txtOpName.Text = ""; txtEQPCode.Text = ""; txtEQPName.Text = ""; Status = ""; routeCode = ""; EQPType = ""; txtOpCode.SelectAll(); txtOpCode.Focus(); SetMsg(Color.Red, "该批次工序对应的派工信息不存在！"); } } } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } #endregion
#region 设备条码 private void txtEQPCode_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == (char)Keys.Enter) { #region 20200820新增防呆 string chksql = @"select ISNULL(MTStatus,'') AS MTStatus from ICSEquipment where EQPCode='{0}' And WorkPoint='{1}'"; chksql = string.Format(chksql, txtRealEQP.Text.Trim(), AppConfig.WorkPointCode); DataTable chkdt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, chksql).Tables[0]; if (chkdt.Rows.Count != 0) { if (chkdt.Rows[0]["MTStatus"].ToString() == "是") { chksql = @"select * from ICSItemOPPrice where ITEMCODE='{0}' AND OPCODE='{1}' AND WorkPoint='{2}'"; chksql = string.Format(chksql, txtItemCode.Text.Trim(), txtOpCode.Text.Trim(), AppConfig.WorkPointCode); chkdt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, chksql).Tables[0]; if (chkdt.Rows.Count == 0) { SetMsg(Color.Red, "开工设备类型为泛威时，必须维护工序价格！"); return; } } } #endregion string EQPCode = txtRealEQP.Text.Trim(); string sql = @"SELECT DISTINCT a.EQPID, a.EQPCode, a.EQPName,Type FROM ICSEquipment a WITH (nolock) WHERE a.EQPCode = '{0}'"; sql = string.Format(sql, EQPCode); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
if (data.Rows.Count > 0) { foreach (DataRow dr in data.Rows) { txtRealEQP.Text = dr["EQPCode"].ToString(); txtRealEQPName.Text = dr["EQPName"].ToString(); EQPType = dr["Type"].ToString(); } SetMsg(Color.Blue, "");
/if (Status.Equals("KG")) / save(); } else { txtRealEQPName.Text = ""; txtRealEQP.SelectAll(); txtRealEQP.Focus(); EQPType = ""; SetMsg(Color.Red, "设备条码不存在！"); } } } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } #endregion
#region 检查输入数据 public string check() { string msg = ""; if (txtUserName.Text.Trim() == "") { msg += "请重新扫描员工条码！\n"; } if (txtMoCode.Text.Trim() == "") { msg += "请重新扫描产品跟踪单号！\n"; } if (txtOpName.Text.Trim() == "") { msg += "请重新扫描工序条码！\n"; } if (txtRealEQPName.Text.Trim() == "") { msg += "请重新扫描设备条码！\n"; } return msg; } #endregion
//消息提示 private void SetMsg(Color color, string Msg) { txtMessages.Text = Msg; txtMessages.ForeColor = color; } #endregion
#region 暂停开始 private void btnPauseBegin_Click(object sender, EventArgs e) { if (btnPauseBegin.Text.Trim().Equals(PAUSE)) { Pause(); } else { CancelPause(); } }
private void Pause()
{
try
{
if (txtLotNo.Text.Trim() = "" || txtOpCode.Text.Trim() = "" || txtUserCode.Text.Trim() = "" || txtRealEQP.Text.Trim() = "")
{
SetMsg(Color.Red, "请先扫描批次信息！");
return;
}
#region simulation ICSLOTSIMULATION simulationNew = new ICSLOTSIMULATION(); simulationNew.MUSER = txtUserCode.Text.Trim(); simulationNew.LOTNO = txtLotNo.Text.Trim(); simulationNew.OPCODE = txtOpCode.Text.Trim(); simulationNew.EQPCODE = txtRealEQP.Text.Trim(); #endregion
ICSCollectBLL.Pause(AppConfig.AppConnectString, simulationNew); SetMsg(Color.Blue, "暂停成功！");
btnPauseBegin.Text = CANCELPAUSE;
}
catch (Exception ex)
{
SetMsg(Color.Red, ex.Message);
}
}
#endregion
private void clear()
{
try
{
txtUserCode.Text = "";
txtUserName.Text = "";
txtItemCode.Text = "";
txtVenderLotNO.Text = "";
txtLotNo.Text = "";
txtMoCode.Text = "";
txtItemName.Text = "";
txtOpCode.Text = "";
txtOpName.Text = "";
txtKeyPart.Text = "";
txtEQPCode.Text = "";
txtEQPName.Text = "";
txtInvLotFurnace.Text = "";
txtRealEQP.Text = "";
txtRealEQPName.Text = "";
txtMemo.Text = "";
}
catch (Exception ex)
{
SetMsg(Color.Red, ex.Message);
}
}
#region 取消暂停
private void CancelPause()
{
try
{
if (txtLotNo.Text.Trim() = "" || txtOpCode.Text.Trim() = "" || txtUserCode.Text.Trim() = "" || txtRealEQP.Text.Trim() = "")
{
SetMsg(Color.Red, "请先扫描批次信息！");
return;
}
#region simulation ICSLOTSIMULATION simulationNew = new ICSLOTSIMULATION(); simulationNew.MUSER = txtUserCode.Text.Trim(); simulationNew.LOTNO = txtLotNo.Text.Trim(); simulationNew.OPCODE = txtOpCode.Text.Trim(); simulationNew.EQPCODE = txtRealEQP.Text.Trim(); #endregion
ICSCollectBLL.CancelPause(AppConfig.AppConnectString, simulationNew); SetMsg(Color.Blue, "取消暂停成功！"); btnPauseBegin.Text = PAUSE; clear(); } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } #endregion
#region 开工、完工 private void btnTransfer_Click(object sender, EventArgs e) { SetMsg(Color.Blue, ""); string msg = check(); if (msg != "") { SetMsg(Color.Red, msg); return; } try { string OpCode = txtOpCode.Text.Trim(); string LOTNO = txtLotNo.Text.Trim(); string sql = @"SELECT DISTINCT a.ID, a.OPCODE, a.OPDESC, b.RouteCode, b.EQPCode, b.EQPName,d.LOTStatus, CASE d.CollectStatus WHEN 'COLLECT_BEGIN' THEN 'WG' ELSE 'KG' END AS Status, Type,ISNULL(b.EATTRIBUTE1,0) AS EATTRIBUTE1 FROM ICSOP a WITH (nolock) LEFT JOIN ICSMO2User b WITH(nolock) ON a.OPCODE = b.OPCODE LEFT JOIN ICSLOTSIMULATION d WITH(nolock) ON b.LOTNO = d.LOTNO and b.OPCODE=d.OPCODE LEFT JOIN ICSEquipment e WITH(nolock) ON b.EQPCode=e.EQPCode WHERE b.OPCODE = '{0}' AND b.LOTNO = '{1}'"; sql = string.Format(sql, OpCode, LOTNO); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0]; if (data.Rows.Count > 0) { foreach (DataRow dr in data.Rows) { if (dr["EATTRIBUTE1"].ToString() == "1") { txtOpName.Text = ""; txtEQPCode.Text = ""; txtEQPName.Text = ""; Status = ""; routeCode = ""; EQPType = ""; txtOpCode.SelectAll(); txtOpCode.Focus(); SetMsg(Color.Red, "所扫描的工序为委外工序，无法开工，请确认！"); return; } } } #region simulation ICSLOTSIMULATION simulationNew = new ICSLOTSIMULATION(); simulationNew.MUSER = txtUserCode.Text.Trim(); simulationNew.LOTNO = txtLotNo.Text.Trim(); simulationNew.OPCODE = txtOpCode.Text.Trim(); simulationNew.EQPCODE = txtRealEQP.Text.Trim(); simulationNew.RESCODE = txtInvLotFurnace.Text.Trim();//试样号 simulationNew.CHECKLOTNO = txtMemo.Text.Trim(); //备注
//simulationNew.MOCODE = simulation.MOCODE; //simulationNew.LOTSEQ = simulation.LOTSEQ;
//simulationNew.LOTQTY = Convert.ToInt32(simulation.LOTQTY); //simulationNew.GOODQTY = simulation.GOODQTY; //simulationNew.NGQTY = simulation.NGQTY; //simulationNew.LOTStatus = simulation.LOTStatus;
//simulationNew.MODELCODE = simulation.MODELCODE; //simulationNew.ITEMCODE = simulation.ITEMCODE; //simulationNew.FROMROUTE = simulation.FROMROUTE; //simulationNew.FROMOP = simulation.FROMOP;
//simulationNew.ROUTECODE = simulation.ROUTECODE; //simulationNew.RESCODE = simulation.RESCODE; //simulationNew.CHECKLOTNO = simulation.CHECKLOTNO; //simulationNew.CARTONCODE = simulation.CARTONCODE; //simulationNew.PALLETCODE = simulation.PALLETCODE; //simulationNew.PRODUCTSTATUS = simulation.PRODUCTSTATUS;
//simulationNew.LACTION = simulation.LACTION; //simulationNew.ACTIONLIST = simulation.ACTIONLIST; //simulationNew.NGTIMES = simulation.NGTIMES; //simulationNew.ISCOM = simulation.ISCOM;
//simulationNew.ISHOLD = simulation.ISHOLD; //simulationNew.SHELFNO = simulation.SHELFNO; //simulationNew.MOSEQ = simulation.MOSEQ; //simulationNew.CollectStatus = simulation.CollectStatus;
//simulationNew.BeginTime = simulation.BeginTime;
//simulationNew.SEQ = simulation.SEQ + 1; //simulationNew.EndTime = Convert.ToDateTime(AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss").ToString("HHmmss")); //simulationNew.MUSERName = AppConfig.UserName; //simulationNew.MTIME = DateTime.Now; //simulationNew.WorkPoint = AppConfig.WorkPointCode; //simulationNew.EATTRIBUTE1 = simulation.EATTRIBUTE1; #endregion
if (btnStart.Text.Trim().Equals(START)) { simulationNew.EATTRIBUTE1 = "COLLECT_BEGIN"; } else { simulationNew.EATTRIBUTE1 = "COLLECT_END"; } ICSCollectBLL.Save(AppConfig.AppConnectString, simulationNew); SetMsg(Color.Blue, btnStart.Text.Trim() + "成功！");
if (btnStart.Text.Trim().Equals(START)) { btnStart.Text = END; } else { btnStart.Text = START; } } catch (Exception ex) { SetMsg(Color.Red, ex.Message); }
} #endregion
private void txtLotNo_Click(object sender, EventArgs e) { txtLotNo.Focus(); txtLotNo.SelectAll(); }
private void txtOpCode_Click(object sender, EventArgs e) { txtOpCode.Focus(); txtOpCode.SelectAll(); }
private void btnTransfer_Click_1(object sender, EventArgs e) { SetMsg(Color.Blue, ""); string msg = check(); if (msg != "") { SetMsg(Color.Red, msg); return; } try { #region simulation ICSLOTSIMULATION simulationNew = new ICSLOTSIMULATION(); simulationNew.MUSER = txtUserCode.Text.Trim(); simulationNew.LOTNO = txtLotNo.Text.Trim(); simulationNew.OPCODE = txtOpCode.Text.Trim(); simulationNew.EQPCODE = txtRealEQP.Text.Trim(); simulationNew.RESCODE = txtInvLotFurnace.Text.Trim();//试样号 simulationNew.CHECKLOTNO = txtMemo.Text.Trim(); //备注
//simulationNew.MOCODE = simulation.MOCODE; //simulationNew.LOTSEQ = simulation.LOTSEQ;
//simulationNew.LOTQTY = Convert.ToInt32(simulation.LOTQTY); //simulationNew.GOODQTY = simulation.GOODQTY; //simulationNew.NGQTY = simulation.NGQTY; //simulationNew.LOTStatus = simulation.LOTStatus;
//simulationNew.MODELCODE = simulation.MODELCODE; //simulationNew.ITEMCODE = simulation.ITEMCODE; //simulationNew.FROMROUTE = simulation.FROMROUTE; //simulationNew.FROMOP = simulation.FROMOP;
//simulationNew.ROUTECODE = simulation.ROUTECODE; //simulationNew.RESCODE = simulation.RESCODE; //simulationNew.CHECKLOTNO = simulation.CHECKLOTNO; //simulationNew.CARTONCODE = simulation.CARTONCODE; //simulationNew.PALLETCODE = simulation.PALLETCODE; //simulationNew.PRODUCTSTATUS = simulation.PRODUCTSTATUS;
//simulationNew.LACTION = simulation.LACTION; //simulationNew.ACTIONLIST = simulation.ACTIONLIST; //simulationNew.NGTIMES = simulation.NGTIMES; //simulationNew.ISCOM = simulation.ISCOM;
//simulationNew.ISHOLD = simulation.ISHOLD; //simulationNew.SHELFNO = simulation.SHELFNO; //simulationNew.MOSEQ = simulation.MOSEQ; //simulationNew.CollectStatus = simulation.CollectStatus;
//simulationNew.BeginTime = simulation.BeginTime;
//simulationNew.SEQ = simulation.SEQ + 1; //simulationNew.EndTime = Convert.ToDateTime(AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss").ToString("HHmmss")); //simulationNew.MUSERName = AppConfig.UserName; //simulationNew.MTIME = DateTime.Now; //simulationNew.WorkPoint = AppConfig.WorkPointCode; //simulationNew.EATTRIBUTE1 = simulation.EATTRIBUTE1; #endregion
ICSCollectBLL.Transfer(AppConfig.AppConnectString, simulationNew); SetMsg(Color.Blue, btnTransfer.Text.Trim() + "成功！");
} catch (Exception ex) { SetMsg(Color.Red, ex.Message); } }
//上料采集 private void txtKeyPart_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar != (char)Keys.Enter) { return; } //检查数据输入 SetMsg(Color.Blue, ""); string msg = check(); if (msg != "") { SetMsg(Color.Red, msg); return; } try { #region simulation ICSLOTONWIPITEM simulationNew = new ICSLOTONWIPITEM(); simulationNew.MUSER = txtUserCode.Text.Trim(); simulationNew.LOTNO = txtLotNo.Text.Trim(); simulationNew.OPCODE = txtOpCode.Text.Trim(); simulationNew.INVLOTNO = txtKeyPart.Text.Trim(); #endregion
ICSCollectBLL.SaveItem(AppConfig.AppConnectString, simulationNew); SetMsg(Color.Blue, txtKeyPart.Text.Trim() + " 上料成功！"); } catch (Exception ex) { SetMsg(Color.Red, ex.Message); } } } }