今日总结

商品查询：

 

 查询的核心代码：

public void seacher_Click(object sender, EventArgs e)
{
int yongid = S.Seid(dianming.Text.Trim(), zhuren.Text.Trim(), location.Text.Trim());
var datas = S.Seachergoods(s_code.Text.Trim(),(int)s_type.SelectedValue,yongid);
goods.AutoGenerateColumns = false;
goods.DataSource = datas;
}

 

public int Seid(string dianming, string zhuren, string location)
{
using (dao.Connection)
{
string sql = $"select ID from yonghu where Name = '{zhuren}' and Supname='{dianming}' and Suplocation='{location}'";
return dao.Connection.Query<int>(sql).FirstOrDefault();
}
}