private void textBox3_DoubleClick(object sender, EventArgs e)
{
ProductSelect PS = new ProductSelect();
PS.ShowDialog();
textBox3.Text = irow.ToString();
}
private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
if (e.ColumnIndex == 1 && dataGridView1.CurrentRow.IsNewRow)
{
MachineSelect fm = new MachineSelect();
fm.ShowDialog();
if (_irow == 0)
{
return;
}
dataGridView1.AllowUserToAddRows = false;
bs.AddNew();
dataGridView1[e.ColumnIndex, e.RowIndex].Value = _irow;
_irow = 0;
dataGridView1.AllowUserToAddRows = true;
}
else if (e.ColumnIndex == 1)
{
MachineSelect fm = new MachineSelect();
fm.ShowDialog();
if (_irow == 0)
{
return;
}
dataGridView1[e.ColumnIndex, e.RowIndex].Value = _irow;
_irow = 0;
dataGridView1.AllowUserToAddRows = true;
}
else if (e.ColumnIndex == 2)
{
ProductSelect ps = new ProductSelect();
ps.ShowDialog();
if (_irow == 0)
{
return;
}
dataGridView1[e.ColumnIndex, e.RowIndex].Value = _irow;
_irow = 0;
}
}
private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["品號"].Index && dataGridView1.CurrentRow.IsNewRow)
{
ProductSelect fm = new ProductSelect();
DataRow dr;
fm.ShowDialog();
try {
dataGridView1.AllowUserToAddRows = false;
scheduleBs.AddNew();
dataGridView1[e.ColumnIndex, e.RowIndex].Value = irow;
dr = myds.Tables["產品資料表"].Rows.Find(dataGridView1["品號", e.RowIndex].Value.ToString());
dataGridView1["品名", e.RowIndex].Value = dr["品名"];
dataGridView1["規格", e.RowIndex].Value = dr["規格"];
dataGridView1["單價", e.RowIndex].Value = dr["單價"];
dataGridView1["目前庫存數量", e.RowIndex].Value = dr["庫存量"].ToString();
dataGridView1.AllowUserToAddRows = true;
dataGridView1.CurrentCell = dataGridView1[dataGridView1.Columns["數量"].Index, e.RowIndex];
_irow = new int();
}
catch
{
dataGridView1.Rows.RemoveAt(e.RowIndex);
dataGridView1.AllowUserToAddRows = true;
}
}
else if (e.ColumnIndex == dataGridView1.Columns["品號"].Index)
{
ProductSelect fm = new ProductSelect();
fm.ShowDialog();
//dataGridView1.AllowUserToAddRows = false;
if (!dataGridView1[e.ColumnIndex, e.RowIndex].Value.ToString().Equals(_irow.ToString()))
{
DataRow dr = myds.Tables["訂單明細資料表"].NewRow();
int old;
int old2;
try
{
old = int.Parse(myds.Tables["訂單明細資料表"].Rows[e.RowIndex]["品號"].ToString());
}
catch
{
old = 0;
}
try
{
old2 = int.Parse(myds.Tables["訂單明細資料表"].Rows[e.RowIndex]["數量"].ToString());
}
catch
{
old2 = 0;
}
dr["品號"] = _irow;
myds.Tables["訂單明細資料表"].Rows.Add(dr);
try
{
dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
dr = myds.Tables["產品資料表"].Rows.Find(dataGridView1["品號", e.RowIndex].Value.ToString());
dataGridView1["品名", e.RowIndex].Value = dr["品名"];
dataGridView1["規格", e.RowIndex].Value = dr["規格"];
dataGridView1["單價", e.RowIndex].Value = dr["單價"];
dataGridView1["目前庫存數量", e.RowIndex].Value = dr["庫存量"].ToString();
_irow = new int();
}
catch
{
dr = myds.Tables["訂單明細資料表"].NewRow();
dr["品號"] = old;
myds.Tables["訂單明細資料表"].Rows.Add(dr);
dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
dr = myds.Tables["產品資料表"].Rows.Find(dataGridView1["品號", e.RowIndex].Value.ToString());
if (old2 != 0)
{
dataGridView1["數量", e.RowIndex].Value = old2;
}
try
{
dataGridView1["品名", e.RowIndex].Value = dr["品名"];
dataGridView1["規格", e.RowIndex].Value = dr["規格"];
dataGridView1["單價", e.RowIndex].Value = dr["單價"];
dataGridView1["目前庫存數量", e.RowIndex].Value = dr["庫存量"].ToString();
}
catch
{
}
_irow = new int();
}
}
}
}
