private void buttonSaveNew_Click(object sender, EventArgs e)
{
//frmFixAdd frmsub = new frmFixAdd();
//frmsub.buttonPairSearch.Enabled = true;
try
{
string CusID = textBoxClientID.Text.Trim();
string FatherId = textBoxFixMaiNId.Text.Trim();
string fittingName = textBoxProductName.Text.Trim();
string typeId = comboBoxTypeID.Text.Trim();
string TypeName = textBoxTypeNAME.Text.Trim();
string unit = textBoxUnit.Text.Trim();
string materialID = comboBoxMaterialID.Text.Trim();
string materialName = textBoxMaterialName.Text.Trim();
string Flength = textBoxLength.Text.Trim();
string Fwide = textBoxWide.Text.Trim();
string Fheight = textBoxHeight.Text.Trim();
string quantity = textBoxQuantity.Text.Trim();
string memo = textBoxMemo.Text.Trim();
string price = textBoxPrice.Text.Trim();
Boolean yinshua = checkBox1.Checked;
Boolean zhanjiao = checkBox2.Checked;
Boolean dading = checkBox3.Checked;
//string sql = "insert into T_fixbox (cusID,productname,producttype,materialname,plength,pwide,pheight,unit,quantity,price,memo) values
string MidQuery = "select ID from T_MATERIAL where materialid ='" + materialID + "'";
databaseexe databaseexe = new databaseexe();
string id = databaseexe.getTopselect(MidQuery, "ID");
string sql = "insert into T_fixpro (CusId,productNAME,typeid,producttype,materialId,MaterialName,plength,pwide,pheight,unit,quantity,fatherid,memo,price) values ('" + CusID + "','" + fittingName + "','" + typeId + "','" + TypeName + "','" + id + "','" + materialName + "','" + Flength + "','" + Fwide + "','" + Fheight + "','" + unit + "','" + quantity + "','" + FatherId + "','" + memo + "','" + price + "')";
/*string sql = "update T_Customer set CusShort='" + CusShort + "',CusName='" + CusName + "',CusTelephone='" + CusTel + "',CusFax='" + CusFax + "',CusAdress='" + CusAdress + "',CusPerson='" + CusPerson + "',CusBank='" + CusBank + "',CusAccount='" + CusAccount + "',CusMemo='" + CusMemo + "'where CusId='" + CusId + "'";*/
dbexe.sqlcmd(sql);
string sql1 = "select top 1 id from T_fixpro order by id DESC ";
databaseexe databaseexe2 = new databaseexe();
string newid = databaseexe2.getTopid(sql1);
if (yinshua.Equals(true))
{
string sql2 = "update T_fixpro set yingshua ='true' where id='" + newid + "'";
dbexe.sqlcmd(sql2);
}
if (zhanjiao.Equals(true))
{
string sql3 = "update T_fixpro set zhanjiao ='true' where id='" + newid + "'";
dbexe.sqlcmd(sql3);
}
if (dading.Equals(true))
{
string sql4 = "update T_fixpro set dading ='true' where id='" + newid + "'";
dbexe.sqlcmd(sql4);
}
MessageBox.Show("数据保存成功!");
string sql5 = "select top 1 id from T_fixpro order by id DESC ";
databaseexe databaseexe3 = new databaseexe();
textBoxFixId.Text = databaseexe2.getTopid(sql5);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
