private void buttonChoose_Click(object sender, EventArgs e) { try { ManuGenarator manu = new ManuGenarator(); dataValue.ManuSaleid = SaleOrderdataGridView1.CurrentRow.Cells[0].Value.ToString(); string ManuOrderid = dataValue.ManuSaleid; string ManuId = manu.manuGenerator(ManuOrderid); string sql = " Select id from t_ordersale where orderid ='" + ManuOrderid + "'order by id asc"; databaseexe databaseexe = new databaseexe(); string[] arr; arr = databaseexe.getMultiData(sql, "id"); for (int i = 0; i < arr.Length; i++) { string AllMaterialQuery = " Select unitquantity*orderquantity as a from T_manus where ZhuanAnID = '" + arr[i].ToString() + "'"; string AllMaterialQuantity = databaseexe.getTopselect(AllMaterialQuery, "a"); string sql1 = "insert into T_manuOrder (manuid,allmaterialquantity,saleid,zhuananid) values('" + ManuId + "','" + AllMaterialQuantity + "','" + ManuOrderid + "','" + arr[i].ToString() + "')"; dbexe.sqlcmd(sql1); } frmManuOrderAdd3 f1 = (frmManuOrderAdd3)this.Owner; f1.dgload(ManuOrderid, ManuId); } catch (Exception ex) { MessageBox.Show(ex.Message); } /*string orderQuantity = SaleOrderdataGridView1.CurrentRow.Cells[10].Value.ToString(); * string Uniqueid = SaleOrderdataGridView1.CurrentRow.Cells[1].Value.ToString(); * string unitQuantityQuery = "select unitquantity from T_manus where zhuananid ='" + Uniqueid + "'"; * databaseexe databaseexe = new databaseexe(); * string UnitQuantity = databaseexe.getTopselect(unitQuantityQuery, "unitquantity"); * * AutoCount autoCount = new AutoCount(); * string MaterialAll = autoCount.MaterialCount(orderQuantity,UnitQuantity); * * //frmManuOrderAdd3 frmsub = new frmManuOrderAdd3(SaleOrderdataGridView1.CurrentRow); * //frmsub.Show(); * * * /* string Orderid = dataValue.saleid; * frmOrderSaleNew2 frmsub = new frmOrderSaleNew2(Orderid); * frmOrderSaleNew2.FrmOrderSaleNew2.dgload(Orderid); * this.Close();*/ //string Orderid = dataValue.saleid; /* dataValue.ManuSaleid = SaleOrderdataGridView1.CurrentRow.Cells[0].Value.ToString(); * string ManuOrderid = dataValue.ManuSaleid; * Select id from t_ordersale * * string sql = "insert into T_manuOrder (manuid,saleid,allMaterialQuantity) values ('" + ManuId + "','"+ManuOrderid+ "','"+MaterialAll+"')"; * dbexe.sqlcmd(sql); * MessageBox.Show("数据添加成功!");*/ //frmManuOrderAdd3 frmManuOrderAdd3 = new frmManuOrderAdd3(ManuOrderid); // frmManuOrderAdd3.FrmManuOrderAdd3.dgload(ManuOrderid); this.Close(); MessageBox.Show("数据添加成功!"); }
private void buttonSaveNew_Click_1(object sender, EventArgs e) { frmManuOrderAdd3 frmsub = new frmManuOrderAdd3(); frmsub.Show(); }