private void btnClrUse_Click(object sender, EventArgs e) { if (MessageBox.Show(CLanguage.Lan("确认要归零库位母治具使用次数?"), "Tip", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } string er = string.Empty; CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB); string sqlCmd = "update RUN_PARA set UsedNum=0"; if (!db.excuteSQL(sqlCmd, out er)) { MessageBox.Show(CLanguage.Lan("归零库位母治具使用次数错误") + ":" + er); } else { MessageBox.Show(CLanguage.Lan("归零库位母治具使用次数OK")); } }
private void refreshModelList() { try { string er = string.Empty; CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB); DataSet ds = null; string sqlCmd = "select distinct ModelName from RUN_PARA where doRun=" + (int)EDoRun.正在老化 + " or doRun=" + (int)EDoRun.老化结束; if (!db.QuerySQL(sqlCmd, out ds, out er)) { MessageBox.Show(er); return; } labModelNum.Text = ds.Tables[0].Rows.Count.ToString(); cmbModel.Items.Clear(); cmbModel.Items.Add(CLanguage.Lan("所有老化机种")); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { cmbModel.Items.Add(ds.Tables[0].Rows[i]["ModelName"].ToString()); } cmbModel.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnQueryFailSn_Click(object sender, EventArgs e) { try { btnQueryFailSn.Enabled = false; snFailView.Rows.Clear(); string er = string.Empty; string startDate = dpStartDate.Value.ToString("yyyy/MM/dd") + " 00:00:00"; string endDate = dpEndDate.Value.ToString("yyyy/MM/dd") + " 23:59:59"; CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB); DataSet ds = null; string sqlCmd = string.Empty; if (txtFailSn.Text == string.Empty) { sqlCmd = string.Format("select * from FailRecord where StartTime >= '{0}' and StartTime <='{1}'" + " order by StartTime desc,IdCard,SlotNo", startDate, endDate); } else { sqlCmd = string.Format("select * from FailRecord where StartTime >= '{0}' and StartTime <='{1}' and SerialNo='{2}'", startDate, endDate, txtFailSn.Text); } if (!db.QuerySQL(sqlCmd, out ds, out er)) { labFailStatus.Text = er; labFailStatus.ForeColor = Color.Red; return; } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string serialNo = ds.Tables[0].Rows[i]["SerialNo"].ToString(); string fixName = ds.Tables[0].Rows[i]["IdCard"].ToString() + "-" + System.Convert.ToInt16(ds.Tables[0].Rows[i]["SlotNo"].ToString()).ToString("D2"); string localName = ds.Tables[0].Rows[i]["LocalName"].ToString(); string startTime = ds.Tables[0].Rows[i]["StartTime"].ToString(); string endTime = ds.Tables[0].Rows[i]["EndTime"].ToString(); string failInfo = ds.Tables[0].Rows[i]["FailInfo"].ToString(); string failTime = ds.Tables[0].Rows[i]["FailTime"].ToString(); string filePath = ds.Tables[0].Rows[i]["ReportPath"].ToString(); snFailView.Rows.Add(serialNo, fixName, localName, startTime, endTime, failInfo, failTime, filePath); } labFailStatus.Text = CLanguage.Lan("查询不良数量") + ":" + "【" + ds.Tables[0].Rows.Count.ToString() + "】"; labFailStatus.ForeColor = Color.Blue; } catch (Exception ex) { labFailStatus.Text = ex.ToString(); labFailStatus.ForeColor = Color.Red; } finally { btnQueryFailSn.Enabled = true; } }
/// <summary> /// 即将老化结束 /// </summary> private void refreshChmrStatus() { try { string er = string.Empty; CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB); DataSet ds = null; int leftTimes = System.Convert.ToInt32(txtEndTimes.Text) * 60; string sqlCmd = string.Empty; if (cmbModel.Text == CLanguage.Lan("所有老化机种")) { sqlCmd = "select RUN_BASE.LocalName," + "RUN_PARA.ModelName," + "RUN_PARA.IDCard," + "RUN_PARA.StartTime," + "RUN_PARA.EndTime," + "UUT_PARA.RunTime," + "RUN_PARA.doRun," + "RUN_PARA.BurnTime," + "RUN_PARA.UUTNO" + " from RUN_PARA,RUN_BASE,UUT_PARA" + " where RUN_PARA.UUTNO = RUN_BASE.UUTNO" + " and RUN_PARA.UUTNO = UUT_PARA.UUTNO" + " and RUN_PARA.IDCard<>''" + " and (RUN_PARA.doRun=" + (int)EDoRun.老化结束 + " or (RUN_PARA.doRun=" + (int)EDoRun.正在老化 + " and (RUN_PARA.BurnTime - UUT_PARA.RunTime)<" + leftTimes.ToString() + "))" + " order by RUN_PARA.ModelName,RUN_PARA.StartTime"; } else { sqlCmd = "select RUN_BASE.LocalName," + "RUN_PARA.ModelName," + "RUN_PARA.IDCard," + "RUN_PARA.StartTime," + "RUN_PARA.EndTime," + "UUT_PARA.RunTime," + "RUN_PARA.doRun," + "RUN_PARA.BurnTime," + "RUN_PARA.UUTNO" + " from RUN_PARA,RUN_BASE,UUT_PARA" + " where RUN_PARA.UUTNO=RUN_BASE.UUTNO" + " and RUN_PARA.UUTNO = UUT_PARA.UUTNO" + " and RUN_PARA.IDCard<>''" + " and (RUN_PARA.doRun=" + (int)EDoRun.老化结束 + " or (RUN_PARA.doRun=" + (int)EDoRun.正在老化 + " and (RUN_PARA.BurnTime-UUT_PARA.RunTime)<" + leftTimes.ToString() + "))" + " and ModelName='" + cmbModel.Text + "'" + " order by RUN_PARA.ModelName,RUN_PARA.StartTime"; } if (!db.QuerySQL(sqlCmd, out ds, out er)) { MessageBox.Show(er); return; } int preNum = ds.Tables[0].Rows.Count; uutView.Rows.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int idNo = i + 1; string modelName = ds.Tables[0].Rows[i]["ModelName"].ToString(); string localName = ds.Tables[0].Rows[i]["LocalName"].ToString(); string idCard = ds.Tables[0].Rows[i]["IDCard"].ToString(); string startTime = ds.Tables[0].Rows[i]["StartTime"].ToString(); int runTime = System.Convert.ToInt32(ds.Tables[0].Rows[i]["RunTime"].ToString()); TimeSpan ts = new TimeSpan(0, 0, runTime); string runTimes = ts.Days.ToString("D2") + ":" + ts.Hours.ToString("D2") + ":" + ts.Minutes.ToString("D2") + ":" + ts.Seconds.ToString("D2"); int doRun = System.Convert.ToInt32(ds.Tables[0].Rows[i]["doRun"].ToString()); string status = string.Empty; if (doRun == (int)EDoRun.正在老化) { status = "老化中"; } else { status = "老化结束"; } uutView.Rows.Add(idNo, modelName, localName, idCard, startTime, runTimes, status); } labPreNum.Text = preNum.ToString(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }