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