/// <summary>
/// 老化结束数量
/// </summary>
private void refreshEndBIStatus()
{
try
{
string er = string.Empty;
CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB);
DataSet ds = null;
string sqlCmd = string.Empty;
if (cmbModel.Text == CLanguage.Lan("所有老化机种"))
{
sqlCmd = "select * from RUN_PARA where doRun=" + (int)EDoRun.老化结束 + " order by UUTNO";
}
else
{
sqlCmd = "select * from RUN_PARA where doRun=" + (int)EDoRun.老化结束 + " and ModelName='" + cmbModel.Text + "' order by UUTNO";
}
if (!db.QuerySQL(sqlCmd, out ds, out er))
{
MessageBox.Show(er);
return;
}
labOutNum.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 加载中英文字典
/// </summary>
private void LoadLanguge()
{
try
{
CLanguage.LoadLanType();
string lanDB = Application.StartupPath + "\\LAN.accdb";
if (!File.Exists(lanDB))
{
return;
}
CDBCOM db = new CDBCOM(EDBType.Access, ".", lanDB);
string er = string.Empty;
DataSet ds = null;
string sqlCmd = "select * from LanList order by idNo";
if (!db.QuerySQL(sqlCmd, out ds, out er))
{
return;
}
Dictionary <string, string> lan = new Dictionary <string, string>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string LAN_CH = ds.Tables[0].Rows[i]["LAN_CH"].ToString();
string LAN_EN = ds.Tables[0].Rows[i]["LAN_EN"].ToString();
if (!lan.ContainsKey(LAN_CH))
{
lan.Add(LAN_CH, LAN_EN);
}
}
CLanguage.Load(lan, out er);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 产能统计
/// </summary>
private void refreshYieldRecord()
{
try
{
string er = string.Empty;
YieldView.Rows.Clear();
CDBCOM db = new CDBCOM(EDBType.Access, "", CGlobalPara.SysDB);
string sqlCmd = "select * from YieldRecord order by idNo";
DataSet ds = null;
if (!db.QuerySQL(sqlCmd, out ds, out er))
{
MessageBox.Show(er);
return;
}
int dayTTNum = 0;
int dayPassNum = 0;
double dayFailRate = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string idNo = (i + 1).ToString();
string yieldTimes = ds.Tables[0].Rows[i]["YieldTimes"].ToString();
int ttNum = System.Convert.ToInt32(ds.Tables[0].Rows[i]["ttNum"].ToString());
int passNum = System.Convert.ToInt32(ds.Tables[0].Rows[i]["passNum"].ToString());
double failRate = 0;
if (ttNum != 0)
{
failRate = (double)(ttNum - passNum) / (double)ttNum;
}
YieldView.Rows.Add(idNo, yieldTimes, ttNum, passNum, failRate.ToString("P2"));
dayTTNum += ttNum;
dayPassNum += passNum;
}
if (dayTTNum != 0)
{
dayFailRate = (double)(dayTTNum - dayPassNum) / (double)dayTTNum;
}
YieldView.Rows.Add("*", "00:00--24:00", dayTTNum, dayPassNum, dayFailRate.ToString("P2"));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private bool LoadPLCAccessDB(string accessFile)
{
try
{
if (!File.Exists(accessFile))
{
//MessageBox.Show("【" + accessFile + "】不存在", "Tip", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
PLCView.Rows.Clear();
string er = string.Empty;
CDBCOM db = new CDBCOM(EDBType.Access, "", accessFile);
DataSet ds = null;
string sqlCmd = string.Format("select * from AlamList order by idNo");
if (!db.QuerySQL(sqlCmd, out ds, out er))
{
MessageBox.Show(er, "Tip", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
PLCView.Rows.Add(ds.Tables[0].Rows[i]["RegFun"].ToString(),
ds.Tables[0].Rows[i]["RegDesc"].ToString(),
"");
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Tip", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
}
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());
}
}
