public int WareInOutADD(WareInOut FH)
{
int intFalg = 0;
try
{
string str_Add = "insert into WareInOut(FDate,FWorknum,FOperator,FWareID,FGoodID,FHGSL,FPSSL,FKLSL,FKHSL,FCarNO,FTYPE,FSerialNum,FGoodsName,FModelno,FItemID,FMaterial,FimagePath,FPSL,FInvoiceType) values( ";
str_Add += " '" + FH.dFDate + "','" + FH.strFWorknum + "',";
str_Add += " '" + FH.strFOperator + "','" + FH.strFWareID + "','" + FH.strFGoodsID + "',";
str_Add += FH.dFHGSL + "," + FH.dFPSSL + "," + FH.dFKLSL + "," + FH.dFKHSL + ",'" + FH.strFCarNO + "'," + FH.intFTYPE + ",'" + FH.strFSerialNum + "','" + FH.strFGoodsName + "','" + FH.strFModelno + "','" + FH.strFItemID + "','" + FH.strFMaterial + "','";
str_Add += FH.strFimagePath + "'," + FH.dFPSL + ",'" + FH.strFInvoiceType + "')";
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int WareInOutUpdate(WareInOut FH)
{
int intFalg = 0;
try
{
string str_Update = "update WareInOut set ";
str_Update += "FDate='" + FH.dFDate + "',";
str_Update += "FWorknum='" + FH.strFWorknum + "',FOperator='" + FH.strFOperator + "',FWareID='" + FH.strFWareID + "',FGoodID='" + FH.strFGoodsID + "',FMaterial = '" + FH.strFMaterial + "',";
str_Update += "FHGSL= " + FH.dFHGSL + ",FPSSL=" + FH.dFKHSL + ",FKLSL=" + FH.dFKLSL + ",FKHSL = " + FH.dFKHSL + ",FCarNO='" + FH.strFCarNO + "',FTYPE=" + FH.intFTYPE + ",FPSL = " + FH.dFPSL + ", FInvoiceType='" + FH.strFInvoiceType + "'";
str_Update += " where FSerialNum='" + FH.strFSerialNum + "'";
intFalg = dbl.ExeInfochange(str_Update);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
