protected void btnBOM_Click(object sender, EventArgs e)
{
try
{
if (Grid2.SelectedRowIndexArray.Length <= 0)
{
Alert.Show("请选择产品");
return;
}
SQLHelper.DbHelperSQL.SetConnectionString("");
foreach (int i in Grid2.SelectedRowIndexArray)
{
string sql = "select count(*) from dbo.proBomHeader where ver=(select max(ver) from proBomHeader where prono='" + Grid2.Rows[i].Values[2].ToString() + "')";
SQLHelper.DbHelperSQL.SetConnectionString("");
if (SQLHelper.DbHelperSQL.GetSingle(sql, 30).ToString() == "0")
{
Alert.Show("该产品未找到对应的工程BOM");
continue;
}
if (Grid2.Rows[i].Values.GetValue(8).ToString() == "0")
{
sql = "select count(*) from dbo.proBomHeader where ver=(select max(ver) from proBomHeader where prono='" + Grid2.Rows[i].Values[2].ToString() + "')";
if (SQLHelper.DbHelperSQL.GetSingle(sql, 30).ToString() == "0")
{
continue;
}
CommFunction.MakeBomByOrder(Grid2.DataKeys[i][0].ToString(), Grid2.Rows[i].Values[2].ToString(), Grid2.Rows[i].Values[1].ToString(), Grid2.Rows[i].Values[4].ToString(), User.Identity.Name, "OrderDetail");
//makeBom(Grid2.Rows[i].Values[2].ToString(), Grid2.Rows[i].Values[1].ToString(), Grid2.Rows[i].Values[4].ToString(), Grid2.DataKeys[i][0].ToString(), "OrderDetail");
}
}
Alert.Show("生成成功");
}
catch (Exception ee)
{
Alert.Show("生成失败：" + ee.ToString());
}
}
protected void btnHeaderBom_Click(object sender, EventArgs e)
{
try
{
if (Grid1.SelectedRowIndexArray.Length <= 0)
{
Alert.Show("请选择订单");
return;
}
if (Grid1.Rows[Grid1.SelectedRowIndex].Values[11].ToString() == "0")
{
Alert.Show("订单未审核通过不能生成BOM");
return;
}
string sql = "";
SQLHelper.DbHelperSQL.SetConnectionString("");
foreach (int i in Grid1.SelectedRowIndexArray)
{
sql = "select * from orderdetail where IsBom=0 and fsn=" + Grid1.DataKeys[i][0].ToString();
DataTable dt = SQLHelper.DbHelperSQL.ReturnDataTable(sql, 30);
for (int j = 0; j < dt.Rows.Count; j++)
{
sql = "select count(*) from dbo.proBomHeader where ver=(select max(ver) from proBomHeader where prono='" + dt.Rows[j]["itemno"].ToString() + "')";
if (SQLHelper.DbHelperSQL.GetSingle(sql, 30).ToString() == "0")
{
continue;
}
CommFunction.MakeBomByOrder(dt.Rows[j]["sn"].ToString(), dt.Rows[j]["itemno"].ToString(), Grid1.Rows[i].Values[1].ToString(), dt.Rows[j]["quantity"].ToString(), User.Identity.Name, "orderheader");
//makeBom(dt.Rows[j]["itemno"].ToString(), Grid1.Rows[i].Values[1].ToString(), dt.Rows[j]["quantity"].ToString(), dt.Rows[j]["sn"].ToString(), "OrderDetail");
}
//sql = "update orderheader set IsBom=1 where sn=" + Grid1.DataKeys[i][0].ToString();
//SQLHelper.DbHelperSQL.ExecuteSql(sql, 30);
}
Alert.Show("生成成功");
}
catch (Exception ee)
{
Alert.Show("生成失败：" + ee.ToString());
}
}