private void dataGridView1_CellLeave(object sender, DataGridViewCellEventArgs e)
{
dataGridView1.EndEdit();
// comboBox1.Focus();
try
{
decimal hjzl = 0;
for (int i = 0; i < dataGridView1.SelectedCells.Count; i++)
{
hjzl += decimal.Parse(dataGridView1.SelectedCells[i].Value.ToString());
}
label14.Text = hjzl.ToString();
}
catch { }
try
{
if (comboBox1.Text.Trim() != "")
{
if (dataGridView1.CurrentCell.ColumnIndex == 1)
{
if (!Globals.CheckNumber(dataGridView1.CurrentRow.Cells["zl"].Value.ToString().Trim()))
{
MessageBox.Show("请输入数字");
dataGridView1.CurrentRow.Cells["zl"].Value = null;
return;
}
else if (dataGridView1.CurrentRow.Cells["barcode"].Value == null)
{
dataGridView1.CurrentRow.Cells["barcode"].Value = comboBox1.SelectedValue.ToString().PadLeft(5, '0') + DateTime.Now.Year.ToString().Substring(2, 2) + Globals.get_tmlsh(conn).PadLeft(5, '0');
dataGridView1.CurrentRow.Cells["cd"].Value = decimal.Parse(Math.Floor(decimal.Parse(dataGridView1.CurrentRow.Cells["zl"].Value.ToString()) / decimal.Parse(bl.Text)).ToString()); //计算重量
dataGridView1.CurrentRow.Cells["wlmc"].Value = comboBox1.Text;
}
DataRow[] drArr = dt1.Select("fname = '" + comboBox2.Text + "'");
if (dataGridView1.CurrentRow.Cells["fck"].Value == null)
{
dataGridView1.CurrentRow.Cells["fck"].Value = comboBox2.Text;
dataGridView1.CurrentRow.Cells["fcw"].Value = comboBox3.Text;
dataGridView1.CurrentRow.Cells["cknm"].Value = drArr[0]["FItemID"].ToString();;
dataGridView1.CurrentRow.Cells["cwnm"].Value = comboBox3.SelectedValue;
dataGridView1.CurrentRow.Cells["frkrq"].Value = dateTimePicker1.Text;
dataGridView1.CurrentRow.Cells["fscrq"].Value = dateTimePicker2.Text;
dataGridView1.CurrentRow.Cells["gysmc"].Value = gys.Text;
dataGridView1.CurrentRow.Cells["gysid"].Value = FSupplyID.Text;
dataGridView1.CurrentRow.Cells["rkdh"].Value = textBox1.Text;
dataGridView1.CurrentRow.Cells["Fhjph"].Value = label16.Text;
dataGridView1.CurrentRow.Cells["Fxh"].Value = xh.Text.Trim();
dataGridView1.CurrentRow.Cells["wlnm"].Value = comboBox1.SelectedValue;
dataGridView1.CurrentRow.Cells["fpc"].Value = pici.Text;
}
}
}
else
{
dataGridView1.CurrentCell = dataGridView1[1, dataGridView1.CurrentCell.RowIndex];
MessageBox.Show("先选择物料");
}
}
catch {
}
}
private void dataGridView1_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter & dataGridView1.CurrentCell.ColumnIndex == 1)//是否选择的是第6个单元格
{
if (!Globals.CheckNumber(dataGridView1.CurrentRow.Cells["zl"].Value.ToString().Trim()))
{
MessageBox.Show("请输入数字");
dataGridView1.CurrentRow.Cells["zl"].Value = null;
return;
}
else if (dataGridView1.CurrentRow.Cells["barcode"].Value == null)
{
dataGridView1.CurrentRow.Cells["barcode"].Value = comboBox1.SelectedValue.ToString().PadLeft(5, '0') + DateTime.Now.Year.ToString().Substring(2, 2) + Globals.get_tmlsh(conn).PadLeft(5, '0');
// dataGridView1.CurrentRow.Cells["cd"].Value = int.Parse(Math.Floor(decimal.Parse(dataGridView1.CurrentRow.Cells["zl"].Value.ToString()) / decimal.Parse(bl.Text) * 1000000).ToString());//计算重量
dataGridView1.CurrentRow.Cells["cd"].Value = decimal.Parse(Math.Floor(decimal.Parse(dataGridView1.CurrentRow.Cells["zl"].Value.ToString()) / decimal.Parse(bl.Text)).ToString());//计算重量
dataGridView1.CurrentRow.Cells["wlmc"].Value = comboBox1.Text;
}
DataRow[] drArr = dt1.Select("fname = '" + comboBox2.Text + "'");
if (dataGridView1.CurrentRow.Cells["fck"].Value == null)
{
dataGridView1.CurrentRow.Cells["fck"].Value = comboBox2.Text;
dataGridView1.CurrentRow.Cells["fcw"].Value = comboBox3.Text;
dataGridView1.CurrentRow.Cells["cknm"].Value = drArr[0]["FItemID"].ToString();;
dataGridView1.CurrentRow.Cells["cwnm"].Value = comboBox3.SelectedValue;
dataGridView1.CurrentRow.Cells["frkrq"].Value = dateTimePicker1.Text;
dataGridView1.CurrentRow.Cells["fscrq"].Value = dateTimePicker2.Text;
dataGridView1.CurrentRow.Cells["gysmc"].Value = gys.Text;
dataGridView1.CurrentRow.Cells["gysid"].Value = FSupplyID.Text;
dataGridView1.CurrentRow.Cells["rkdh"].Value = textBox1.Text;
dataGridView1.CurrentRow.Cells["Fhjph"].Value = label16.Text;
dataGridView1.CurrentRow.Cells["Fxh"].Value = xh.Text.Trim();
dataGridView1.CurrentRow.Cells["wlnm"].Value = comboBox1.SelectedValue;
dataGridView1.CurrentRow.Cells["fpc"].Value = pici.Text;
}
}
if (e.KeyCode == Keys.Enter & dataGridView1.CurrentCell.ColumnIndex == 2)//是否选择的是第6个单元格
{
if (!Globals.CheckNumber(dataGridView1.CurrentRow.Cells["cd"].Value.ToString().Trim()))
{
MessageBox.Show("请输入数字");
dataGridView1.CurrentRow.Cells["cd"].Value = null;
return;
}
}
// dataGridView1.CurrentCell = dataGridView1[1, dataGridView1.CurrentCell.RowIndex];
}
catch {
MessageBox.Show("请选择料号");
}
}