//自定义绑定ListView数据
private void listViewDate()
{
this.listView1.View = View.Details;
this.listView1.FullRowSelect = true;
string sql = "select s_PID,sum(s_Amount) as s_KCAmount,s_Pname from HY_Storage group by s_PID,s_Pname having sum(s_Amount)<40";
SqlDataReader sdr = hyul.f_HY_Storagelist(sql);
while (sdr.Read())
{
ListViewItem lv = new ListViewItem(sdr[0].ToString());
lv.SubItems.Add(sdr[2].ToString());
lv.SubItems.Add(sdr[1].ToString());
this.listView1.Items.Add(lv);
}
}
//汇总库存数量金额
private void f_account(string sql)
{
SqlDataReader sdr = hystorfobll.f_HY_Storagelist(sql);
while (sdr.Read())
{
//this.label3.Text = string.Format("{0:N}",float.Parse(sdr["PR"].ToString()));
this.label4.Text = sdr["AM"].ToString();
}
}