//自定义绑定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(); } }