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();
}
