private void updateAllData(string time, string nextStatus, string state)
{
MaintainManageInfo maintainManageInfo = getAllInput();
if (maintainManageInfo == null)
{
return;
}
if (nextStatus == _finishStatus)
{
maintainManageInfo.FinishFixTime = time;
}
if (nextStatus == _suspendStatus)
{
maintainManageInfo.SuspendTime = time;
}
maintainManageInfo.Status = nextStatus;
maintainManageInfo.State = state;
string msg = maintainInfoManage.UpdateBreakToolInfo(maintainManageInfo);
if (msg == "挂起" || msg == "未使用任何零件")
{
DialogResult = DialogResult.OK;
Close();
return;
}
MessageBox.Show(msg, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex > -1)
{
DataGridViewButtonCell btnCell = dataGridView1.CurrentCell as DataGridViewButtonCell;
if (btnCell != null)
{
try
{
string serialNum = dataGridView1.Rows[e.RowIndex].Cells["SerialNumCol"].Value.ToString();
int affectedRow = maintainInfoManage.DeleteOneRegisterTools(serialNum);
if (affectedRow < 1)
{
throw new Exception("删除记录失败");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
MaintainManageInfo maintainManageInfo = GetOneToolsInfoFromGrid();
for (int i = maintainManageInfoList.Count - 1; i >= 0; i--)
{
if (maintainManageInfoList[i].ToolSerialName == maintainManageInfo.ToolSerialName)
{
maintainManageInfoList.Remove(maintainManageInfoList[i]);
}
}
dataGridView1.DataSource = null;
dataGridView1.DataSource = maintainManageInfoList;
}
}
}
public MaintainManageInfo getOneBreakToolFromDb(string toolSerialName)
{
string sql = "select * from MaintainManageInfo where ToolSerialName='" + toolSerialName + "'";
SQLiteDataReader reader = SQLHelper.ReadTableBySql(sql);
MaintainManageInfo maintainManage = new MaintainManageInfo();
if (!reader.HasRows)
{
reader.Close();
return(null);
}
while (reader.Read())
{
try
{
maintainManage.ToolSerialName = reader["ToolSerialName"].ToString();
maintainManage.ToolModeName = reader["ToolModeName"].ToString();
maintainManage.SendFixTime = Convert.ToDateTime(reader["SendFixTime"].ToString()).ToString("yyyy-MM-dd");
maintainManage.Status = reader["Status"].ToString();
maintainManage.Detail = reader["Detail"].ToString();
maintainManage.UsedRepoSpareToolInfo = commonService.ConvertStr2Dic(reader["UsedRepoSpareToolInfo"].ToString());
maintainManage.UsedOtherSpareToolInfo = commonService.ConvertStr2Dic(reader["UsedOtherSpareToolInfo"].ToString());
}
catch (Exception ex)
{
Console.WriteLine($"getOneBreakToolFromDb failed, error message is: {ex.Message}");
}
}
if (reader != null)
{
reader.Close();
}
return(maintainManage);
}
public int UpdateMaintainManageInfo(MaintainManageInfo maintainManageInfo)
{
string usedRepoSpareToolInfo = commonService.ConvertDic2Str(maintainManageInfo.UsedRepoSpareToolInfo);
string usedOtherSpareToolInfo = commonService.ConvertDic2Str(maintainManageInfo.UsedOtherSpareToolInfo);
string sql;
if (maintainManageInfo.State == "0")
{
if (maintainManageInfo.Status == MaintainDeclare.Suspend)
{
sql = $"update MaintainManageInfo set UsedRepoSpareToolInfo='{usedRepoSpareToolInfo}', UsedOtherSpareToolInfo='{usedOtherSpareToolInfo}', Status='{maintainManageInfo.Status}', SuspendTime='{maintainManageInfo.SuspendTime}' where ToolSerialName='{maintainManageInfo.ToolSerialName}' and State='0'";
}
else
{
sql = $"update MaintainManageInfo set UsedRepoSpareToolInfo='{usedRepoSpareToolInfo}', UsedOtherSpareToolInfo='{usedOtherSpareToolInfo}', Status='{maintainManageInfo.Status}', FinishFixTime='{maintainManageInfo.FinishFixTime}' where ToolSerialName='{maintainManageInfo.ToolSerialName }' and State='0'";
}
}
else
{
if (maintainManageInfo.Status == MaintainDeclare.Suspend)
{
sql = $"update MaintainManageInfo set UsedRepoSpareToolInfo='{usedRepoSpareToolInfo}', UsedOtherSpareToolInfo='{usedOtherSpareToolInfo}', Status='{maintainManageInfo.Status}', SuspendTime='{maintainManageInfo.SuspendTime}', State='{maintainManageInfo.State}' where ToolSerialName='{maintainManageInfo.ToolSerialName}' and State='0'";
}
else
{
sql = $"update MaintainManageInfo set UsedRepoSpareToolInfo='{usedRepoSpareToolInfo}', UsedOtherSpareToolInfo='{usedOtherSpareToolInfo}', Status='{maintainManageInfo.Status}', FinishFixTime='{maintainManageInfo.FinishFixTime}', State='{maintainManageInfo.State}' where ToolSerialName='{maintainManageInfo.ToolSerialName}' and State='0'";
}
}
return(SQLHelper.UpdateTableBySql(sql));
}
public bool IsNotFinishBreakToolExist(MaintainManageInfo maintainManageInfo)
{
string sql = "select * from MaintainManageInfo where ToolSerialName='" + maintainManageInfo.ToolSerialName + "' and Status!='" + MaintainDeclare.RepairFinished + "'";
SQLiteDataReader reader = SQLHelper.ReadTableBySql(sql);
if (reader != null && reader.HasRows)
{
reader.Close();
return(true);
}
return(false);
}
private MaintainManageInfo getAllInput()
{
if (!checkInput())
{
return(null);
}
MaintainManageInfo maintainManageInfo = new MaintainManageInfo();
maintainManageInfo.ToolSerialName = cmbSerialNum.Text;
maintainManageInfo.UsedRepoSpareToolInfo = commonManage.ConvertStr2Dic(txtRepoSpare.Text);
maintainManageInfo.UsedOtherSpareToolInfo = commonManage.ConvertStr2Dic(txtOtherSpare.Text);
return(maintainManageInfo);
}
private MaintainManageInfo getAllInput()
{
MaintainManageInfo maintainManageInfo = new MaintainManageInfo();
maintainManageInfo.ToolModeName = txtModel.Text;
maintainManageInfo.ToolSerialName = cmbSerialNum.Text;
maintainManageInfo.SendFixTime = dtpSendTime.Text;
maintainManageInfo.Detail = rtxDetail.Text;
maintainManageInfo.Status = "待维修";
maintainManageInfo.UsedOtherSpareToolInfo = null;
maintainManageInfo.UsedRepoSpareToolInfo = null;
maintainManageInfo.State = "0";
return(maintainManageInfo);
}
private void setAllInputWhenSuspendBefore()
{
if (string.Compare(status, _suspendStatus) == 0)
{
MaintainManageInfo maintainManageInfo = maintainInfoManage.GetOneBreakToolFromDb(RepairManageForm.ToolSerialName);
if (maintainManageInfo == null)
{
Console.WriteLine("maintainManageInfo is nil");
return;
}
txtRepoSpare.Text = commonManage.ConvertDic2Str(maintainManageInfo.UsedRepoSpareToolInfo);
txtOtherSpare.Text = commonManage.ConvertDic2Str(maintainManageInfo.UsedOtherSpareToolInfo);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!toolsInfoManage.IsToolExistInDb(cmbSerialNum.Text.Trim()))
{
MessageBox.Show($"序列号为{cmbSerialNum.Text.Trim()}的工具不在仓库中", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
MaintainManageInfo maintainManageInfo = getAllInput();
string msg = maintainInfoManage.RegisterBreakTool(maintainManageInfo);
if (msg.Contains("成功"))
{
maintainManageInfoList.Add(maintainManageInfo);
dataGridView1.DataSource = null;
dataGridView1.DataSource = maintainManageInfoList;
return;
}
MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
public string RegisterBreakTool(MaintainManageInfo maintainManageInfo)
{
if (maintainManageInfo.ToolSerialName == "" || maintainManageInfo.SendFixTime == "" || maintainManageInfo.Detail == "")
{
return("录入失败，请补全所有信息！");
}
try
{
if (maintainManageInfoService.IsNotFinishBreakToolExist(maintainManageInfo))
{
return("登记失败，该工具已经在维修中！");
}
int affected = maintainManageInfoService.AddMaintainManageInfo(maintainManageInfo);
if (affected < 1)
{
return("录入失败！");
}
return("数据录入成功！");
}
catch
{
return("error");
}
}
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 string UpdateBreakToolInfo(MaintainManageInfo maintainManageInfo)
{
if (!new MaintainManageInfoService().IsNotFinishBreakToolExist(maintainManageInfo))
{
return("名称为" + maintainManageInfo.ToolSerialName + "的工具不存在！");
}
if (maintainManageInfo.UsedRepoSpareToolInfo == null)
{
maintainManageInfoService.UpdateMaintainStatus(maintainManageInfo);
return("未使用任何零件");
}
foreach (var item in maintainManageInfo.UsedRepoSpareToolInfo)
{
RepoSpareTool repoSpareTool = repoSpareToolService.getOneRepoSpareToolFromDb(item.Key);
if (repoSpareTool == null)
{
return("数据库中不包含型号为：" + item.Key + "的备件信息");
}
if (repoSpareTool.Num < item.Value)
{
return("数据库中型号为：" + item.Key + "的备件个数不足" + item.Value.ToString() + "个");
}
}
try
{
maintainManageInfoService.UpdateMaintainManageInfo(maintainManageInfo);
if (maintainManageInfo.Status != MaintainDeclare.Suspend)
{
foreach (var item in maintainManageInfo.UsedRepoSpareToolInfo)
{
RepoSpareTool repoSpareTool = repoSpareToolService.getOneRepoSpareToolFromDb(item.Key);
int num = repoSpareTool.Num - item.Value;
Console.WriteLine("num is {0}", num);
int affectedRow = repoSpareToolService.updateRepoSpareToolNum(num, item.Key);
if (affectedRow < 1)
{
return("更新数据库失败！");
}
SpareToolUseHistory spareToolUseHistory = new SpareToolUseHistory();
spareToolUseHistory.SpareToolModel = item.Key;
spareToolUseHistory.Num = item.Value;
spareToolUseHistory.UseTime = DateTime.Now.ToString("yyyy-MM-dd");
affectedRow = repoSpareToolManage.InsertSpareUseHistory(spareToolUseHistory);
if (affectedRow < 1)
{
return("更新数据库失败！");
}
}
int affected = maintainManageInfoService.InsertOneRepairHistory(new RepairHistory
{
ToolSerialName = maintainManageInfo.ToolSerialName,
ToolModeName = maintainManageInfo.ToolModeName,
SendFixTime = maintainManageInfo.SendFixTime,
FinishFixTime = maintainManageInfo.FinishFixTime,
Detail = maintainManageInfo.Detail,
UsedOtherSpareToolInfo = maintainManageInfo.UsedOtherSpareToolInfo,
UsedRepoSpareToolInfo = maintainManageInfo.UsedRepoSpareToolInfo
});
if (affected < 1)
{
return("更新数据库失败！");
}
}
return("挂起");
}
catch
{
return("error");
}
}
public int UpdateBreakToolStatus(MaintainManageInfo maintainManageInfo)
{
return(maintainManageInfoService.UpdateMaintainStatus(maintainManageInfo));
}
public int UpdateMaintainStatus(MaintainManageInfo maintainManageInfo)
{
string sql = "update MaintainManageInfo set Status='" + maintainManageInfo.Status + "' where ToolSerialName='" + maintainManageInfo.ToolSerialName + "' and State='0'";
return(SQLHelper.UpdateTableBySql(sql));
}
public int AddMaintainManageInfo(MaintainManageInfo maintainManageInfo)
{
return(SQLHelper.InsertValuesByStruct("MaintainManageInfo", maintainManageInfo));
}
