private void buttonChoose_Click(object sender, EventArgs e) { try { databaseexe databaseexe = new databaseexe(); string ZhuanAnid = PurchaseOrderdataGridView2.CurrentRow.Cells[0].Value.ToString(); string PurchaseQuantity = PurchaseOrderdataGridView2.CurrentRow.Cells[5].Value.ToString(); string BomidQuery = "select bomid from T_pur where zhuananid='" + ZhuanAnid + "'"; string bomid = databaseexe.getTopselect(BomidQuery, "bomid"); string priceQuery = "Select materialprice from T_BOMPRICE where bomid='" + bomid + "'and Supid='" + Supid + "'"; string price = databaseexe.getTopselect(priceQuery, "materialprice"); string sql1 = "insert into T_purchaseOrder (purchaseid,purchasequantity,zhuananid,price,supid) values('" + PurchaseId + "','" + PurchaseQuantity + "','" + ZhuanAnid + "','" + price + "','" + Supid + "')"; dbexe.sqlcmd(sql1); /*string sql = "select zhuananid as 专案编号,CusShort as 客户,productName as 品名,materialName as 纸板名称,bomsize as 规格, allMaterialQuantity-matstock as 欠料数量 from T_pur where purchaseid is null and manuid is not null "; * dbexe.sqlcmd(sql);*/ string sql2 = "select zhuananid as 专案编号,CusShort as 客户,productName as 品名,materialName as 纸板名称,bomsize as 规格, allMaterialQuantity-matstock as 欠料数量 from T_pur where purchaseid is null and manuid is not null "; // dbexe.getdataset(sql2, "T_pur").Tables[0]; DataTable Datatable; Datatable = dbexe.getdataset(sql2, "T_pur").Tables[0]; for (int i = 0; i < Datatable.Rows.Count; i++) { if (int.Parse(Datatable.Rows[i]["欠料数量"].ToString()) < 0) { Datatable.Rows[i]["欠料数量"] = "0"; } } PurchaseOrderdataGridView2.DataSource = Datatable; /*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 PurchaseQuantity="update T_PurchaseOrder set purchasequantity='"+PurchaseOrderdataGridView2.CurrentRow.Cells[5].Value.ToString()+"'where zhuananid= '"+ZhuanAnid+"'"; * * }*/ frmPurchaseAdd4 f1 = (frmPurchaseAdd4)this.Owner; f1.dgload(PurchaseId); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonSaveNew_Click(object sender, EventArgs e) { frmPurchaseAdd4 frmsub = new frmPurchaseAdd4(); frmsub.Show(); }