private void button1_Click(object sender, EventArgs e)
{
string saleid = dataValue.saleid;
try
{
if (textBoxNumber.Text == "")
{
MessageBox.Show("未填写数量！");
return;
}
else
{
/* string cusid = Cid;
* OrderGenerator orderGenerator = new OrderGenerator();
* JObject jsonObject = new JObject();
* jsonObject = JObject.Parse(orderGenerator.orderGenerator(cusid));
* //Boxid=
*
* /*textBoxOrderid.Text = jsonObject.GetValue("orderid").ToString();
* string orderid = jsonObject.GetValue("orderid").ToString();
* string number = jsonObject.GetValue("number").ToString();
* string sql = "insert into T_allsale (number,orderid,cusid)values('" + number + "','" + orderid + "','" + cusid + "')";
* databaseexe databaseexe = new databaseexe();*/
string boxid = ProductdataGridView2.CurrentRow.Cells[0].Value.ToString();
string idQuery = "select id from T_fixpro where fatherid='" + boxid + "'or id ='" + boxid + "'order by id asc";
databaseexe databaseexe = new databaseexe();
string[] arr = databaseexe.getMultiData(idQuery, "id");
for (int i = 0; i < arr.Length; i++)
{
string id;
id = arr[i];
string sql = "insert into T_ordersale (number,orderid ,proid,cusid,quantity,indate,orderdate,deliverytime,orderperson) values ('" + dataValue.salenumber + "','" + dataValue.saleid + "','" + id + "','" + Cid + "','" + textBoxNumber.Text.Trim() + "','" + dataValue.indate + "','" + dataValue.orderdate + "','" + dataValue.deliverytime + "','" + dataValue.orderPerson + "')";
dbexe.sqlcmd(sql);
}
string biliQuery = "select quantity from T_fixpro where id ='" + boxid + "' or fatherid = '" + boxid + "' order by id asc";
string[] bili = databaseexe.getMultiData(biliQuery, "quantity");
string shuliang = textBoxNumber.Text.ToString().Trim();
for (int j = 1; j < bili.Length; j++)
{
string tempid = arr[j];
string tempbili = bili[j];
int tempnumber = int.Parse(tempbili) * int.Parse(shuliang);
string sql = "update t_ordersale set quantity='" + tempnumber + "' where proid = '" + tempid + "'";
databaseexe.sqlcmd(sql);
}
MessageBox.Show("数据添加成功!");
/*teacherdataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
* string sql1 = "select teacherId as 教师编号,teacherName as 教师姓名,tage as 年龄,Tdepartement as 所属学院 from teacher";
* teacherdataGridView1.DataSource =
* dbexe.getdataset(sql1, "teacher").Tables[0];*/
string Orderid = dataValue.saleid;
frmOrderSaleNew2 frmsub = new frmOrderSaleNew2(Orderid);
frmOrderSaleNew2.FrmOrderSaleNew2.dgload(Orderid);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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("数据添加成功!");
}
