private void btn_Update_Click(object sender, EventArgs e) { DateTime dt1 = Convert.ToDateTime(dateTimePicker1.Text); DateTime dt = dt1.AddDays(1); string strSql = "SELECT DISTINCT b.O_SecGoodsCode,b.O_SecGoodsName FROM Mes_OrgResHead AS a LEFT JOIN dbo.Mes_OrgResDetail AS b ON a.O_OrgResNo = b.O_OrgResNo WHERE a.O_StockCode = '" + Globels.strStockCode + "' AND a.O_UploadDate > '" + dt1 + "' and a.O_UploadDate < '" + dt + "'"; DataSet ds = new DataSet(); Mes_ConvertBLL ConvertBLL = new Mes_ConvertBLL(); ds = ConvertBLL.GetList(strSql); //cmbGoodsName.Items.Clear(); listView1.Items.Clear(); int nLen = ds.Tables[0].Rows.Count; this.listView1.BeginUpdate(); for (int i = 0; i < nLen; i++) { //cmbGoodsName.Items.Add(ds.Tables[0].Rows[i]["O_SecGoodsName"].ToString()); //DateTime dt = DateTime.Now.Date.AddDays(-1); strSql = "SELECT SUM(O_Qty) as O_Qty,SUM(O_SecQty) as O_SecQty,O_GoodsName,a.O_OrgResNo,b.O_Batch FROM Mes_OrgResHead AS a LEFT JOIN dbo.Mes_OrgResDetail AS b ON a.O_OrgResNo = b.O_OrgResNo WHERE a.O_StockCode = '" + Globels.strStockCode + "' AND a.O_UploadDate > '" + dt1 + "' and a.O_UploadDate < '" + dt + "' and O_SecGoodsName = '" + ds.Tables[0].Rows[i]["O_SecGoodsName"].ToString() + "' group by O_GoodsName,a.O_OrgResNo,b.O_Batch"; DataSet ds2 = new DataSet(); ds2 = ConvertBLL.GetList(strSql); int nLen2 = ds2.Tables[0].Rows.Count; if (nLen2 > 0) { List <string> OrderNoList = new List <string>(); //txtGoodsName.Text = ds2.Tables[0].Rows[0]["O_GoodsName"].ToString(); decimal dQty = 0; decimal dQtySec = 0; for (int j = 0; j < nLen2; j++) { if (!OrderNoList.Contains(ds2.Tables[0].Rows[j]["O_OrgResNo"].ToString())) { OrderNoList.Add(ds2.Tables[0].Rows[j]["O_OrgResNo"].ToString()); dQtySec = dQtySec + Convert.ToDecimal(ds2.Tables[0].Rows[j]["O_SecQty"].ToString()); } dQty = dQty + Convert.ToDecimal(ds2.Tables[0].Rows[j]["O_Qty"].ToString()); } txtQty.Text = dQty.ToString(); txtQtySec.Text = dQtySec.ToString(); decimal dConvert = dQtySec / dQty; dConvert = Math.Round(dConvert, 6); txtConvert.Text = dConvert.ToString(); ListViewItem lvi = new ListViewItem(ds2.Tables[0].Rows[0]["O_GoodsName"].ToString()); lvi.SubItems.Add(dQty.ToString()); lvi.SubItems.Add(ds.Tables[0].Rows[i]["O_SecGoodsName"].ToString()); lvi.SubItems.Add(dQtySec.ToString()); lvi.SubItems.Add(dConvert.ToString()); this.listView1.Items.Add(lvi); } } this.listView1.EndUpdate(); }
private void btn_Update_Click(object sender, EventArgs e) { DateTime dt1 = Convert.ToDateTime(dateTimePicker1.Text); DateTime dt = dt1.AddDays(1); string strSql = "SELECT * FROM Mes_Barcode WHERE B_WorkShopCode = '" + Globels.strWorkShop + "' AND B_Ptime > '" + dt1 + "' and B_Ptime < '" + dt + "' order by B_Ptime"; DataSet ds = new DataSet(); Mes_ConvertBLL ConvertBLL = new Mes_ConvertBLL(); ds = ConvertBLL.GetList(strSql); //cmbGoodsName.Items.Clear(); listView1.Items.Clear(); int nLen = ds.Tables[0].Rows.Count; this.listView1.BeginUpdate(); //decimal sumQty = 0; for (int i = 0; i < nLen; i++) { ListViewItem lvi = new ListViewItem(ds.Tables[0].Rows[i]["B_Code"].ToString()); lvi.SubItems.Add(ds.Tables[0].Rows[i]["B_Name"].ToString()); lvi.SubItems.Add(ds.Tables[0].Rows[i]["B_Qty"].ToString()); if (ds.Tables[0].Rows[i]["B_Status"].ToString() == "1") { lvi.SubItems.Add("已生成"); } else { lvi.SubItems.Add("已入库"); } lvi.SubItems.Add(ds.Tables[0].Rows[i]["B_Remark"].ToString()); this.listView1.Items.Add(lvi); //sumQty += Convert.ToDecimal(ds.Tables[0].Rows[i]["B_Qty"].ToString()); } //DataRow dr = ds.Tables[0].NewRow(); //dr["B_Name"] = "合计:"; //dr["B_Qty"] = sumQty.ToString(); //ListViewItem lvi1 = new ListViewItem(); //lvi1.SubItems.Add(dr["B_Name"].ToString()); //lvi1.SubItems.Add(dr["B_Qty"].ToString()); //this.listView1.Items.Add(lvi1); txtNum.Text = nLen.ToString(); this.listView1.EndUpdate(); }