private void UniPreparation(string UnName)
{
DG_UniPreparation.DataSource = null;
if (UnName != "")
{
string NewUnname = string.Empty;
//dr = ds.Tables[0].Select(" 通用名 like '% + UnName + "%'");
DataTable DTable = ds.Tables[0];
DTable = ds.Tables[0].Copy();
DTable.Rows.Clear();
NewUnname = UnName.Replace("%", " ");
NewUnname = NewUnname.Replace("*", " ");
NewUnname = NewUnname.Replace("|", " ");
NewUnname = NewUnname.Replace(":", " ");
NewUnname = NewUnname.Replace("：", " ");
//dt2.ImportRow(dt.Rows[0]);//这是加入的是第一行
//string sql = string.Format(" 通用名 like '%{0}%'", NewUnname);
string sql = string.Format(" 通用名 like '%{0}%' OR SpellCode like '%{0}%'", NewUnname);
try
{
DataRow[] rowsArry = ds.Tables[0].Select(sql);
foreach (DataRow row in rowsArry)
{
DTable.ImportRow(row);
}
//dt.Rows.Add(dr);
if (DTable.Rows.Count > 0)
{
DG_UniPreparation.DataSource = DTable;
}
}
catch
{
DTable = db.GetPIVAsDB(select.UniPreparation(UnName)).Tables[0];
if (DTable.Rows.Count > 0)
{
DG_UniPreparation.DataSource = DTable;
}
}
}
else
{
DG_UniPreparation.DataSource = ds.Tables[0];
}
if (DG_UniPreparation.Rows.Count > 0)
{
DG_UniPreparation.Columns[0].Visible = false;
DG_UniPreparation.Columns[1].Width = 180;
DG_UniPreparation.Columns[2].Width = 200;
//DG_UniPreparation.Columns[5].Width = 200*4;
DG_UniPreparation.ClearSelection();
}
}
private void Txt_UniPreparation_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Down)
{
DG_UniPreparation.Select();
}
else if (e.KeyCode == Keys.Escape)
{
DG_UniPreparation.Visible = false;
}
else if (e.KeyCode == Keys.Enter && DG_UniPreparation.Visible == true)
{
DG_UniPreparation.Visible = false;
}
else if (e.KeyCode == Keys.Enter && DG_UniPreparation.Visible == false)
{
DG_UniPreparation.Visible = true;
}
}
