private void button1_Click(object sender, EventArgs e)//确认 { if (!Check()) { return; } if (Operation) { row = table.NewRow(); row["GroupID"] = M.GetMaxLabelGroupID(); row["GroupName"] = textBox1.Text.Trim(); row["GroupOrder"] = numericUpDown1.Value; row["LocationID"] = LocationID; table.Rows.Add(row); } else { row["GroupName"] = textBox1.Text.Trim(); row["GroupOrder"] = numericUpDown1.Value; row["LocationID"] = LocationID; } LB.Update(); LB.Reload(); ToAdd(); }
private void button1_Click(object sender, EventArgs e)//确认保存 { if (!Check()) { return; } if (Operation) { row = table.NewRow(); try { MaxID = (int)table.Select("", "GroupID DESC")[0]["GroupID"] + 1; } catch { MaxID = 1; } row["GroupID"] = MaxID; row["GroupName"] = textBox1.Text.Trim(); row["GroupOrder"] = numericUpDown1.Value; table.Rows.Add(row); } else { row["GroupName"] = textBox1.Text.Trim(); row["GroupOrder"] = numericUpDown1.Value; } LB.Update(); LB.Reload(); ToAdd(); }
private void button1_Click(object sender, EventArgs e)//确认 { if (!Check()) { return; } if (Operation) { row = table.NewRow(); //用如下这种办法新增主键值时,表主键不要设自动增长,否则新增后立马删除会报错。因为如果是自动增长,存入的表的主键值实际是历史最大值,而DataTable存入的是本次最大值,这样就会发生找不到对应数据的情况。 try { MaxID = (int)table.Select("", "LocationID DESC")[0]["LocationID"] + 1; }//只有地点才能用这种方式取最大ID,因为它不会分组 catch { MaxID = 1; } row["LocationID"] = MaxID; row["LocationName"] = textBox1.Text.Trim(); row["LocationOrder"] = numericUpDown1.Value; table.Rows.Add(row); } else { row["LocationName"] = textBox1.Text.Trim(); row["LocationOrder"] = numericUpDown1.Value; } LB.Update(); LB.Reload(); ToAdd(); }
private void button2_Click(object sender, EventArgs e)//确认保存 { if (!Check()) { return; } if (Operation) { row = table.NewRow(); try { MaxID = (int)table.Select("", "ID DESC")[0]["ID"] + 1; } catch { MaxID = 1; } row["ID"] = MaxID; row["Title"] = textBox1.Text.Trim(); row["YearN"] = dateTimePicker1.Value.Year; row["MonthN"] = dateTimePicker1.Value.Month; row["DayN"] = dateTimePicker1.Value.Day; row["ValidYear"] = checkBox1.Checked; table.Rows.Add(row); } else { row["Title"] = textBox1.Text.Trim(); row["YearN"] = dateTimePicker1.Value.Year; row["MonthN"] = dateTimePicker1.Value.Month; row["DayN"] = dateTimePicker1.Value.Day; row["ValidYear"] = checkBox1.Checked; } LB.Update(); LB.Reload(); ToAdd(); }
private void button1_Click(object sender, EventArgs e)//日记本管理 { new Groups().ShowDialog(); LB.Reload(); try { LB.SelectedIndex = 0; } catch { LB.SelectedIndex = -1; } ShowData(); }
void ReloadGroups()//重载笔记本列表 { LB.Reload(); CBB.Reload(); }