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