You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
728 lines
29 KiB
728 lines
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新增防呆 20210430去掉
|
|
// 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;
|
|
}
|
|
DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在处理...请稍等...");
|
|
try
|
|
{
|
|
_wait.Show();
|
|
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();
|
|
_wait.Close();
|
|
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;
|
|
}
|
|
_wait.Close();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
_wait.Close();
|
|
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);
|
|
}
|
|
}
|
|
|
|
private void UserControlCollectBeginTop_Load(object sender, EventArgs e)
|
|
{
|
|
txtUserCode.Focus();
|
|
}
|
|
}
|
|
}
|