//耗材绑定
private void Bander_HaocaiList()
{
searchLookUpEdit_YaopinName.Properties.DataSource = null;
DataTable dtRowHC = Maticsoft.DBUtility.DbHelperOleDb.Query("select ID as 序号,RH_Name as 名称,RH_Guige as 耗材规格,RH_Price as 耗材价格,RH_Unit as 包装,RH_PYName as 耗材简拼 from Room_Haocai order by RH_AddTime desc,id desc").Tables[0];
searchLookUpEdit_YaopinName.Properties.View.Columns.Clear();//清空列
if (dtRowHC.Rows.Count > 0)
{
searchLookUpEdit_YaopinName.Properties.DataSource = dtRowHC;
}
else
{
searchLookUpEdit_YaopinName.Properties.DataSource = null;
}
dtRowHC = null;
}
private void Bander_HaocaiList()
{
searchLookUpEdit_YaopinName.Properties.DataSource = null;
DataTable dtRowHC = Maticsoft.DBUtility.DbHelperOleDb.Query("select ID as 序号,RH_Name as 名称,RH_Guige as 耗材规格,RH_Price as 耗材价格,RH_Unit as 包装,RH_PYName as 耗材简拼 from Room_Haocai order by RH_AddTime desc,id desc").Tables[0];
searchLookUpEdit_YaopinName.Properties.View.Columns.Clear();//清空列
if (dtRowHC.Rows.Count > 0)
{
searchLookUpEdit_YaopinName.Properties.DataSource = dtRowHC;
}
else
{
searchLookUpEdit_YaopinName.Properties.DataSource = null;
}
dtRowHC = null;
}