private void this_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Prior)
{
int rowIndex = this.dgvRL.CurrentCell.RowIndex;
if (rowIndex <= 0)
{
return;
}
this.dgvRL.CurrentCell = this.dgvRL.Rows[rowIndex - 1].Cells[0];
}
else if (e.KeyCode == Keys.Next)
{
int rowIndex = this.dgvRL.CurrentCell.RowIndex;
if (rowIndex >= this.dgvRL.RowCount - 1)
{
return;
}
this.dgvRL.CurrentCell = this.dgvRL.Rows[rowIndex + 1].Cells[0];
}
else if (e.KeyCode == this.cancelKey)
{
this.DialogResult = DialogResult.Cancel;
}
else
{
if (e.KeyCode != Keys.Return)
{
return;
}
if (this.lblCheng.Text == "" || this.lblDT.Text == "")
{
frmError frmError = new frmError("请选择正确滴头!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
this.txtZL.Focus();
}
else if (this.txtZL.Text == "" || !UserProc.IsNumeric(this.txtZL.Text) || Convert.ToDecimal(this.txtZL.Text) <= new Decimal(0))
{
frmError frmError = new frmError("请输入正确重量( >=0 )!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
this.txtZL.Focus();
}
else
{
this.DialogResult = DialogResult.OK;
}
}
}
private void this_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Return)
{
this.txtSch.Text = this.txtSch.Text.Trim();
if (this.txtSch.Text == "")
{
frmError frmError = new frmError("无料单号,无法显示!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
DataTable dataTable1 = new DataTable();
DataTable dataTable2 = new DataTable();
//using (SqlConnection sqlConnection = new SqlConnection(Settings.Default.DBconn))
{
//sqlConnection.Open();
//SqlCommand command = sqlConnection.CreateCommand();
//command.CommandTimeout = 300;
string CommandText = "select 1 from T_PFmain where danhao = '" + this.txtSch.Text + "' and sta = '已审核.ToString()'";
//SqlDataReader sqlDataReader1 = command.ExecuteReader();
dataTable1 = db.Ado.GetDataTable(CommandText);
if (dataTable1.Rows.Count != 1)
{
//sqlDataReader1.Close();
//sqlDataReader1.Dispose();
//command.Dispose();
dataTable1.Dispose();
dataTable2.Dispose();
frmError frmError = new frmError("无法找到此料单数据!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return;
}
string sql = "";
if (this.txtSch.Text.StartsWith("LD") || this.txtSch.Text.Length == 10 && this.txtSch.Text.StartsWith("8"))
{
sql = "select 1 from T_PFdata a join T_Base b on a.ranliao = b.item0 and b.leibie = '滴料头' and b.bianhao = '" + Settings.Default.DLjihao + "' where a.danhao = '" + this.txtSch.Text + "' and a.yongliang > 0 order by b.itemName";
}
else
{
sql = "select 1 from T_PFdata a join T_Base b on a.ranliao = b.item0 and b.leibie = '滴料头' and b.bianhao = '" + Settings.Default.DLjihao + "' where a.danhao = '" + this.txtSch.Text + "' and a.JLyongliang > 0 order by b.itemName";
}
//SqlDataReader sqlDataReader2 = command.ExecuteReader();
dataTable2 = db.Ado.GetDataTable(sql);
//sqlDataReader2.Close();
//sqlDataReader2.Dispose();
//command.Dispose();
}
if (dataTable2.Rows.Count == 0)
{
dataTable1.Dispose();
dataTable2.Dispose();
frmError frmError = new frmError("无法找到此料单用量数据!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
this.DialogResult = DialogResult.OK;
}
}
}
else if (e.KeyCode == this.cancelKey)
{
this.DialogResult = DialogResult.Cancel;
}
else
{
if (e.KeyCode != Keys.Prior && e.KeyCode != Keys.Next)
{
return;
}
if (this.lblTS.Text == "查询料单号（扫描输入）")
{
this.lblTS.Text = "查询料单号（键盘输入）";
this.txtSch.Text = "8" + DateTime.Today.ToString("yyMM");
this.txtSch.Select(this.txtSch.Text.Length, 0);
this.txtSch.ScrollToCaret();
}
else
{
this.lblTS.Text = "查询料单号（扫描输入）";
this.txtSch.Text = "";
}
}
}
