private void btnAdd_Click(object sender, EventArgs e)
{
RepoSpareTool[] repoSpareTools = new RepoSpareTool[] { };
List <RepoSpareTool> ktls = repoSpareTools.ToList();
if (textBox1.Text != "" && numericUpDown1.Value != 0)
{
ktls.Add(this.getOneInput(textBox1, numericUpDown1));
}
if (textBox2.Text != "" && numericUpDown2.Value != 0)
{
ktls.Add(this.getOneInput(textBox2, numericUpDown2));
}
if (textBox3.Text != "" && numericUpDown3.Value != 0)
{
ktls.Add(this.getOneInput(textBox3, numericUpDown3));
}
if (textBox4.Text != "" && numericUpDown4.Value != 0)
{
ktls.Add(this.getOneInput(textBox4, numericUpDown4));
}
if (textBox5.Text != "" && numericUpDown5.Value != 0)
{
ktls.Add(this.getOneInput(textBox5, numericUpDown5));
}
repoSpareTools = ktls.ToArray();
insertValue2Db(repoSpareTools);
}
public RepoSpareTool getOneRepoSpareToolFromDb(string spareToolModel)
{
string sql = "select * from RepoSpareTool where SpareToolModel='" + spareToolModel + "'";
SQLiteDataReader reader = SQLHelper.ReadTableBySql(sql);
RepoSpareTool repoSpareTool = new RepoSpareTool();
if (!reader.HasRows)
{
reader.Close();
return(null);
}
while (reader.Read())
{
try
{
repoSpareTool.SpareToolModel = reader["SpareToolModel"].ToString();
repoSpareTool.Num = reader["Num"].ToString() != "" ? int.Parse(reader["Num"].ToString()) : 0;
repoSpareTool.AddTime = Convert.ToDateTime(reader["Time"].ToString()).ToString("yyyy-MM-dd");
}
catch (Exception ex)
{
Console.WriteLine($"getOneRepoSpareToolFromDb failed, error message is: {ex.Message}");
}
}
if (reader != null)
{
reader.Close();
}
return(repoSpareTool);
}
private RepoSpareTool getOneInput(TextBox txtBox, NumericUpDown upDown)
{
RepoSpareTool repoSpareTool = new RepoSpareTool();
repoSpareTool.SpareToolModel = txtBox.Text;
repoSpareTool.Num = (int)upDown.Value;
repoSpareTool.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
return(repoSpareTool);
}
public string ExportSingleData2Excel(string filePath, RepoSpareTool repoSpareTool)
{
int affected = 0;
try
{
affected = repoSpareToolService.CreatRepoSpareToolExcelTable(filePath);
//if (affected < 1) return "创建导出文件失败";
}catch (Exception ex)
{
Console.WriteLine($"CreatRepoSpareToolExcelTable fail: {ex.Message}");
}
affected = repoSpareToolService.InsertRepoSpareTool2ExcelTable(filePath, repoSpareTool);
if (affected < 1)
{
return("导出数据失败");
}
return("导出数据成功");
}
private RepoSpareTool[] GetRepoSpareToolFromGrid()
{
RepoSpareTool[] repoSpareTool = new RepoSpareTool[] { };
List <RepoSpareTool> ktls = repoSpareTool.ToList();
//遍历 DataGridView 所有行
int row = dataGridView1.Rows.Count; //得到总行数
int cell = dataGridView1.Rows[0].Cells.Count; //得到总列数
for (int i = 0; i < row; i++) //得到总行数并在之内循环
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].EditedFormattedValue))
{
ktls.Add(new RepoSpareTool
{
SpareToolModel = dataGridView1.Rows[i].Cells[1].Value.ToString(),
Num = int.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString()),
AddTime = dataGridView1.Rows[i].Cells[3].Value.ToString(),
});
}
}
return(ktls.ToArray());
}
private void insertValue2Db(RepoSpareTool[] repoSpareTools)
{
if (repoSpareTools.Length == 0)
{
MessageBox.Show("录入失败，输入的记录个数为0", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
foreach (RepoSpareTool repoSpareTool in repoSpareTools)
{
try
{
if (repoSpareToolManage.IsRepoSpareToolExist(repoSpareTool.SpareToolModel))
{
RepoSpareTool repoSpare = repoSpareToolManage.QueryOneRepoSpare(repoSpareTool.SpareToolModel);
repoSpare.Num += repoSpareTool.Num;
int affected = repoSpareToolManage.UpdateRepoSpareNum(repoSpare.SpareToolModel, repoSpare.Num);
if (affected < 1)
{
MessageBox.Show("序列号(" + repoSpareTool.SpareToolModel + ") 插入失败, 已存在序列号相同的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
MessageBox.Show("数据录入成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int affectedRow = repoSpareToolManage.AddRepoSpareTool(repoSpareTool);
if (affectedRow < 1)
{
MessageBox.Show("录入失败，操作数据库失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
MessageBox.Show("数据录入成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
catch
{
MessageBox.Show("数据录入失败，操作数据库失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
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 AddRepoSpareTool(RepoSpareTool repoSpareTool)
{
return(repoSpareToolService.AddRepoSpareTool(repoSpareTool));
}
public int AddRepoSpareTool(RepoSpareTool repoSpareTool)
{
return(SQLHelper.InsertValuesByStruct("RepoSpareTool", repoSpareTool));
}
