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());
}
}
