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