软件总结

查询商品：

 

 

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

 

public List<Goods> Seachergoods(string code,int tid)
{
using (dao.Connection)
{
string sql = string.Format("SELECT a.*," +
"b.Zname,c.Gname,d.Storagenums,d.Supermarketnums,d.Notstoragenums FROM goods a LEFT JOIN goodskucun d ON a.ID=d.Gid,goodsleixing b,gongying c WHERE " +
"a.Typeid=b.ID and a.Supid=c.ID AND a.Code LIKE '%{0}%' and {1}",code,tid==0 ?"1=1":$"a.Typeid={tid}");
return dao.Connection.Query<Goods>(sql).ToList();
}
}