public string CheckMachineParamsByID(string MachineID, string reel_id)
{
try
{
string sqlGetID = "select TERMINAL_NAME from SYS_TERMINAL where TERMINAL_ID='" + MachineID + "'";
var dbSearch = new OracleRepository(NewMesTest);
DataTable dtMachineName = dbSearch.FindTable(sqlGetID);
if (dtMachineName.Rows.Count == 0)
{
LogHelper.Info("NG:根据机台ID查找不到机台名称" + MachineID);
return("NG:根据机台ID查找不到机台名称");
}
string MachineType = dtMachineName.Rows[0][0].ToString();
//判断机台类型，分为Masking,Sensor和VCN1,VCN2
if (MachineType.Contains("Masking"))
{
MachineType = "Masking";
}
else if (MachineType.Contains("Glue staking"))
{
MachineType = "Sensor";
}
else if (MachineType.Contains("VCN1"))
{
MachineType = "VCN1Coating";
}
else if (MachineType.Contains("VCN2"))
{
MachineType = "VCN2Coating";
}
string sqlGetParams = "select A as MachineParam from sajet.machine_name where MACHINE_NAME='" + MachineType + "'";
DataTable dtMachineParam = dbSearch.FindTable(sqlGetID);
if (dtMachineParam.Rows.Count == 0)
{
LogHelper.Info("NG:根据机台名称查找不到机台胶水料号" + MachineID);
return("NG:根据机台名称查找不到机台胶水料号");
}
LogHelper.Info("查询胶水料号成功;" + dtMachineParam.Rows[0][0].ToString() + ";" + MachineID);
reel_id = reel_id.Substring(0, 14);//截取前十四位位胶水料号
if (reel_id != dtMachineParam.Rows[0][0].ToString())
{
LogHelper.Info("NG:当前机台应该使用的胶水料号不正确" + MachineID);
return("NG:当前机台使用的胶水料号不正确");
}
return(dtMachineParam.Rows[0][0].ToString());
}
catch (Exception ex)
{
LogHelper.Info("NG:查询机台胶水料号异常" + ex.ToString() + "请联系系统工程师解决");
return("NG:查询机台胶水料号异常" + ex.ToString() + "请联系系统工程师解决");
}
}
public bool insertqrcode(string ReelID, string lotNo, string PartNo, string DateCode, int Qty, string VendorCode, string remark, string username, out string message)
{
message = null;
bool flag = true;
try
{
string cmd = string.Empty;
cmd = @"SELECT REEL_ID,PART_NO,DATE_CODE,QTY,LOTNO,VENDOR_CODE,PO FROM LCR_BASE_REEL WHERE REEL_ID=:REELID";
DataTable dt = repository.FindTable(cmd, new { REELID = ReelID });
if (dt.Rows.Count > 0)//已有数据，存入历史表
{
cmd = "delete from lcr.lcr_base_reel where reel_id=:reelid";
repository.ExecuteBySql(cmd, new
{
reelid = ReelID
});
}
cmd = "insert into lcr.LCR_BASE_REEL(reel_id,part_no,DATE_CODE,QTY,LOTNO,VENDOR_CODE,remark1,createuserid,createdate) values " +
"(:reelid,:partno,:datecode,:qty,:lotno,:vendorcode,:lotno1,:userid,:createdate)";
repository.ExecuteBySql(cmd, new
{
reelid = ReelID,
partno = PartNo,
datecode = DateCode,
qty = Qty,
lotno = lotNo,
lotno1 = remark,////由于标签规格不标准，批次存在两个栏位
vendorcode = VendorCode,
userid = username,
createdate = DateTime.Now
});
message = "REEL ID 注册成功";
}
catch (Exception ex)
{
message = ex.Message;
flag = false;
}
return(flag);
}
/// <summary>
/// 测量成功时，插入测量值
/// </summary>
/// <returns></returns>
private bool InsertTestResult(string reelid, string partno, string testvalue, string unit, string userid)
{
bool flag = true;
try
{
string cmd = string.Empty;
cmd = @"select reel_id from lcr.LCR_REEL lt where lt.reel_id=:reelid";
DataTable dt = repository.FindTable(cmd, new { reelid = reelid });
if (dt.Rows.Count > 0)//已有数据，存入历史表
{
cmd = " insert into LCR_REEL_DETAIL( reel_id,part_no,result,value,unit,cr" +
"eatedate,createuserid) select t.reel_id,t.part_no," +
"t.result,t.value,t.unit,t.createdate,t.createuserid from LCR_REEL t where t.reel_id= :reelid ";
repository.ExecuteBySql(cmd, new { reelid = reelid });
cmd = "delete from lcr.LCR_REEL lt where lt.reel_id=:reelid";
repository.ExecuteBySql(cmd, new { reelid = reelid });
}
cmd = "insert into lcr.LCR_REEL(reel_id,part_no,result,value,unit,createuserid,createdate) values " +
"(:reelid,:partno,:result,:value,:unit,:userid,:createdate)";
repository.ExecuteBySql(cmd, new { reelid = reelid, partno = partno, result = "PASS",
value = testvalue, unit = unit, userid = userid, createdate = DateTime.Now });
AddRow(txtCPN.Text.Trim(), txtReelNo.Text.Trim(), testvalue, "PASS");
}
catch (Exception ex)
{
setMessage(MessageType.Error, ex.Message);
flag = false;
}
return(flag);
}
private bool getReelIDInfo(string reelid)
{
bool flag = true;
try
{
string cmd = string.Empty;
string cmd1 = string.Empty;
cmd = @"select p.part_no,m.reel_no,m.reel_qty,m.datecode,m.lot ,v.vendor_code||':'||v.vendor_name as vendor
from sajet.g_material m,sajet.sys_part p,sajet.sys_vendor v
where p.part_id=m.part_id
and m.vendor_id=v.erp_id(+)
and m.reel_no=:rellNo ";
cmd1 = @"select reel_id, part_no, date_code, qty, lotno, vendor_code, po, sortcode, createdate, createuserid, modifydate, modifyuserid,
remark1, remark2, remark3, remark4, remark5, remark6 from lcr_base_reel m
where m.reel_id=:rellNo ";
DataTable dt = repository.FindTable(cmd, new { rellNO = reelid });
//DataTable dt = ClientUtils.ExecuteSQL(cmd).Tables[0];
if (dt.Rows.Count <= 0)
{
DataTable dt1 = repository.FindTable(cmd1, new { rellNO = reelid });
if (dt1.Rows.Count <= 0)
{
MessageBox.Show("该最小料包号(" + reelid + ")不存在或没有料号或供应商或输入错误!");
flag = false;
}
else
{
this.txtCPN.Text = dt1.Rows[0]["part_no"].ToString();
this.txtQTY.Text = dt1.Rows[0]["qty"].ToString();
this.txtLC.Text = dt1.Rows[0]["lotno"].ToString();
this.txtDC.Text = dt1.Rows[0]["date_code"].ToString();
this.txtVendor.Text = dt1.Rows[0]["vendor_code"].ToString();
}
}
else if (Double.Parse(dt.Rows[0]["reel_qty"].ToString()) <= 0)
{
MessageBox.Show("该最小料包号(" + reelid + ")已经全部用完");
flag = false;
}
else
{
this.txtCPN.Text = dt.Rows[0]["part_no"].ToString();
this.txtQTY.Text = dt.Rows[0]["reel_qty"].ToString();
this.txtLC.Text = dt.Rows[0]["Lot"].ToString();
this.txtDC.Text = dt.Rows[0]["datecode"].ToString();
this.txtVendor.Text = dt.Rows[0]["vendor"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
flag = false;
}
return(flag);
}
