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