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