//清空 private void btnClear_Click(object sender, EventArgs e) { if (choiseProduct( ) == false) { return; } FormBatOpera from = new FormBatOpera("批量清空", table); if (from.ShowDialog( ) == DialogResult.OK) { table = from.getTable; DateTime dtOne, dtTwo; int days; foreach (DataRow row in table.Rows) { DataRow ro = tableView.Select("主件品号='" + row ["P1"] + "'") [0]; dtOne = Convert.ToDateTime(row ["P3"]); dtTwo = Convert.ToDateTime(row ["P4"]); days = (dtTwo - dtOne).Days; if (tableView.Columns.Contains(dtOne.ToString(" yyyy-MM-dd "))) { ro [dtOne.ToString(" yyyy-MM-dd ")] = 0; } for (int i = 0; i < days; i++) { if (tableView.Columns.Contains(dtOne.ToString(" yyyy-MM-dd "))) { dtOne = dtOne.AddDays(1); ro [dtOne.ToString(" yyyy-MM-dd ")] = 0; } } } gridControl1.Refresh( ); } }
//增加天数 private void btnAddDays_Click(object sender, EventArgs e) { if (choiseProduct( ) == false) { return; } FormBatOpera from = new FormBatOpera("增加排产天数", table); if (from.ShowDialog( ) == DialogResult.OK) { Query( ); } }
//排产 private void btnPai_Click(object sender, EventArgs e) { if (choiseProduct( ) == false) { return; } FormBatOpera from = new FormBatOpera("批量分摊", table); if (from.ShowDialog( ) == DialogResult.OK) { table = from.getTable; DateTime dtOne, dtTwo; int days, proNum, totalNum = 0, sumNum = 0; foreach (DataRow row in table.Rows) { DataRow ro = tableView.Select("主件品号='" + row ["P1"] + "'") [0]; foreach (DataColumn column in tableView.Columns) { if (column.ColumnName == "排产量") { sumNum = Convert.ToInt32(ro [column.ColumnName]); } if (column.ColumnName != "主件品号" && column.ColumnName != "主件品名" && column.ColumnName != "订单量" && column.ColumnName != "预计生产量" && column.ColumnName != "排产量" && column.ColumnName != "库存量" && column.ColumnName != "库存可用量" && column.ColumnName != "未排量" && column.ColumnName != "生产车间" && column.ColumnName != "仓库" && column.ColumnName != "单位" && column.ColumnName != "开单未入量" && column.ColumnName != "客户名称") { if (ro [column.ColumnName] != null && !string.IsNullOrEmpty(ro [column.ColumnName].ToString( ))) { totalNum += Convert.ToInt32(ro [column.ColumnName]); } } } dtOne = Convert.ToDateTime(row ["P3"]); dtTwo = Convert.ToDateTime(row ["P4"]); proNum = Convert.ToInt32(row ["P6"]); days = (dtTwo - dtOne).Days; if (tableView.Columns.Contains(dtOne.ToString(" yyyy-MM-dd "))) { if (proNum + totalNum > sumNum) { proNum = sumNum - totalNum; } ro [dtOne.ToString(" yyyy-MM-dd ")] = proNum; totalNum += proNum; } for (int i = 0; i < days; i++) { if (tableView.Columns.Contains(dtOne.ToString(" yyyy-MM-dd "))) { if (proNum + totalNum > sumNum) { proNum = sumNum - totalNum; } dtOne = dtOne.AddDays(1); ro [dtOne.ToString(" yyyy-MM-dd ")] = proNum; totalNum += proNum; } } } gridControl1.Refresh( ); } }