private void deleteColumnToolStripMenuItem_Click(object sender, EventArgs e)
{
if (SelectHeaderColumnIndex > -1)
{
if (stationComboBox.Text != "" && modelComboBox.Text != "" && customerComboBox.Text != "")
{
tableColList.RemoveAt(SelectHeaderColumnIndex);
DataGridView1.Columns.RemoveAt(SelectHeaderColumnIndex);
Sqlite.DeleteColumnInfo(stationComboBox.Text, modelComboBox.Text, customerComboBox.Text, SelectHeaderColumnIndex);
Sqlite.UpdateProduct(stationComboBox.Text, modelComboBox.Text, customerComboBox.Text, DataGridView1.RowCount, DataGridView1.ColumnCount);
}
SelectHeaderColumnIndex = -1;
}
}
private void deleteBtn_Click(object sender, EventArgs e)
{
if (DataGridView1.CurrentCell == null)
{
MessageBox.Show("请选择表格", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (stationComboBox.Text == "")
{
MessageBox.Show("请输入站別", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (modelComboBox.Text == "")
{
MessageBox.Show("请输入产品型号", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (customerComboBox.Text == "")
{
MessageBox.Show("请输入客戶別", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("确定删除表格啊?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
Sqlite.DeleteProduct(stationComboBox.Text, modelComboBox.Text, customerComboBox.Text);
for (int i = 0; i < tableColList.Count; i++)
{
Sqlite.DeleteColumnInfo(stationComboBox.Text, modelComboBox.Text, customerComboBox.Text, i);
}
DataGridView1.Rows.Clear();
DataGridView1.Columns.Clear();
stationComboBox.Text = "";
modelComboBox.Text = "";
customerComboBox.Text = "";
}
}