private void btnFinish_Click(object sender, EventArgs e)
{
DemarcateTools demarcateTools = demarcateRecordManage.getOneDemarcateToolBySerialNum(txtSerialNum.Text.Trim());
try
{
DemarcateHistory demarcateHistory = new DemarcateHistory
{
DemarcateNum = qRCodePrintForm.demarcateRecords.DemarcateNum,
SerialNum = qRCodePrintForm.demarcateRecords.SerialNum,
Cycle = demarcateTools.Cycle,
LastTime = demarcateTools.LastTime,
DemarcateTime = DateTime.Now.ToString("yyyy-MM-dd"),
NextTime = DateTime.Now.AddDays(demarcateTools.Cycle).ToString("yyyy-MM-dd"),
CheckMan = qRCodePrintForm.demarcateRecords.Examinant
};
int affected = demarcateRecordManage.AddDemarcateHistory(demarcateHistory);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
string sql = $"update DemarcateTools set LastTime='{demarcateHistory.DemarcateTime}',NextTime='{demarcateHistory.NextTime}' where SerialNum='{demarcateDataUploadForm.SerialNum}'";
affected = demarcateRecordManage.UpdateOneDemarcateToolBySql(sql);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
//更新维修次数
ToolsInfo toolsInfo = toolsInfoManage.QueryOneToolsInfo(qRCodePrintForm.demarcateRecords.SerialNum);
int repairTimes = toolsInfo.RepairTimes++;
sql = $"update ToolsInfo set RepairTimes={repairTimes} where SerialNum='{toolsInfo.SerialNum}'";
affected = toolsInfoManage.UpdateToolsInfoBySql(sql);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
MessageBox.Show($"工具{txtSerialNum.Text.Trim()}校准完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
IsdemarcateFinsih = true;
}
//excel operation
public string ExportSingleData2Excel(string filePath, DemarcateHistory demarcateHistory)
{
int affected = 0;
try
{
affected = demarcateRecordService.CreateDemarcateHistoryExcelTable(filePath);
//if (affected < 1) return "创建导出文件失败";
}catch (Exception ex)
{
Console.WriteLine($"CreateMaintainManageInfoExcelTable fail: {ex.Message}");
}
affected = demarcateRecordService.InsertDemarcateHistory2ExcelTable(filePath, demarcateHistory);
if (affected < 1)
{
return("导出数据失败1");
}
return("导出数据成功");
}
private void btnNextStep_Click(object sender, EventArgs e)
{
if (pageNum == 1)
{
if (txtSerialNum.Text.Trim() == "")
{
MessageBox.Show("序列号不能为空，请输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cmbCheckMan.Text.Trim() == "")
{
MessageBox.Show("校准检查员不能为空，请输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (!isToolsExist(txtSerialNum.Text.Trim()))
{
if (!toolsInfoManage.IsToolExistInDb(txtSerialNum.Text.Trim()))
{
MessageBox.Show("仓库中不存在序列号为" + txtSerialNum.Text.Trim() + "的工具，请先录入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (MessageBox.Show("工具序列号不在校准计划中，是否继续？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
}
try
{
checkManManage.AddOneName(cmbCheckMan.Text.Trim());
}
catch (Exception ex)
{
Console.Write("add name fail", ex.Message);
}
}
pageNum++;
DemarcateTools demarcateTools = demarcateRecordManage.getOneDemarcateToolBySerialNum(txtSerialNum.Text.Trim());
if (pageNum == 2)
{
if (Convert.ToDateTime(demarcateTools.NextTime) > DateTime.Now)
{
pageNum--;
if (MessageBox.Show($"该工具的预计校准日期为{demarcateTools.NextTime}，确定要继续校准吗？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
}
btnNextStep.Text = "下一步";
//btnLastStep.Visible = true;
btnNextStep.Enabled = true;
btnLastStep.Enabled = true;
foreach (Control c in panel2.Controls)
{
c.Visible = false;
}
demarcateDataUploadForm.FormBorderStyle = FormBorderStyle.None;
demarcateDataUploadForm.Dock = DockStyle.Fill;
demarcateDataUploadForm.TopLevel = false;
demarcateDataUploadForm.SerialNum = txtSerialNum.Text.Trim();
demarcateDataUploadForm.CheckMan = cmbCheckMan.Text.Trim();
panel2.Controls.Add(demarcateDataUploadForm);
demarcateDataUploadForm.Show();
}
if (pageNum == 3)
{
if (!demarcateDataUploadForm.CalcDemarcateResult())
{
pageNum--;
return;
}
if (!demarcateDataUploadForm.DemarcateResult)
{
pageNum--;
demarcateDataUploadForm.setResultLabel("校准结果：不合格");
if (MessageBox.Show("校准结果不合格，是否重新校准？\n点击确定将会清除校准数据\n点击取消将会把工具标记为待修", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
demarcateDataUploadForm.reDemarcateActon();
demarcateDataUploadForm.setResultLabel("校准结果：");
}
else
{
MaintainManageInfo maintainManageInfo = new MaintainManageInfo
{
ToolSerialName = txtSerialNum.Text.Trim(),
ToolModeName = toolsInfoManage.QueryOneToolsInfo(txtSerialNum.Text.Trim()).Model,
SendFixTime = DateTime.Now.ToString("yyyy-MM-dd"),
Detail = DemarcateStatusDeclare.OffGrade
};
string msg = maintainInfoManage.RegisterBreakTool(maintainManageInfo);
if (!msg.Contains("成功"))
{
MessageBox.Show($"移至待修出错！原因：{msg}", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
return;
}
btnNextStep.Text = "进入下一个工具校准";
//btnNextStep.Location = new Point(btnNextStep.Location.X -90, btnNextStep.Location.Y);
btnNextStep.Enabled = true;
//btnLastStep.Visible = true;
btnLastStep.Enabled = true;
btnFinsih.Visible = true;
btnFinsih.Location = new Point(btnNextStep.Location.X - btnFinsih.Width - 15, btnNextStep.Location.Y);
panel3.Controls.Add(btnFinsih);
btnFinsih.BringToFront();
foreach (Control c in panel2.Controls)
{
c.Visible = false;
}
qRCodePrintForm.demarcateRecords = demarcateDataUploadForm.GetDemarcateRecords();
qRCodePrintForm.FormBorderStyle = FormBorderStyle.None;
qRCodePrintForm.Dock = DockStyle.Fill;
//qRCodePrintForm.Location = new Point(panel2.Location.X + (panel2.Width - qRCodePrintForm.Width)/2, 0);
qRCodePrintForm.Width = panel2.Width;
qRCodePrintForm.TopLevel = false;
panel2.Controls.Add(qRCodePrintForm);
qRCodePrintForm.Show();
//Graphics g = gbStep.CreateGraphics();
}
if (pageNum == 4)
{
if (IsdemarcateFinsih)
{
toolStripButton2_Click(null, null);
return;
}
try
{
DemarcateHistory demarcateHistory = new DemarcateHistory
{
DemarcateNum = qRCodePrintForm.demarcateRecords.DemarcateNum,
SerialNum = qRCodePrintForm.demarcateRecords.SerialNum,
Cycle = demarcateTools.Cycle,
LastTime = demarcateTools.LastTime,
DemarcateTime = DateTime.Now.ToString("yyyy-MM-dd"),
NextTime = DateTime.Now.AddDays(demarcateTools.Cycle).ToString("yyyy-MM-dd"),
CheckMan = qRCodePrintForm.demarcateRecords.Examinant
};
int affected = demarcateRecordManage.AddDemarcateHistory(demarcateHistory);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
string sql = $"update DemarcateTools set LastTime='{demarcateHistory.DemarcateTime}',NextTime='{demarcateHistory.NextTime}' where SerialNum='{demarcateDataUploadForm.SerialNum}'";
affected = demarcateRecordManage.UpdateOneDemarcateToolBySql(sql);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
//更新维修次数
ToolsInfo toolsInfo = toolsInfoManage.QueryOneToolsInfo(qRCodePrintForm.demarcateRecords.SerialNum);
int repairTimes = toolsInfo.RepairTimes++;
sql = $"update ToolsInfo set RepairTimes={repairTimes} where SerialNum='{toolsInfo.SerialNum}'";
affected = toolsInfoManage.UpdateToolsInfoBySql(sql);
if (affected < 1)
{
throw new Exception("系统出现错误，请重新校准!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
toolStripButton2_Click(null, null);
}
}
public int InsertDemarcateHistory(DemarcateHistory demarcateHistory)
{
return(SQLHelper.InsertValuesByStruct("DemarcateHistory", demarcateHistory));
}
public int AddDemarcateHistory(DemarcateHistory demarcateHistory)
{
return(demarcateRecordService.InsertDemarcateHistory(demarcateHistory));
}