public int SelPorcelainUpdate(tb_SelPorcelain sp)
{
int intFalg = 0;
try
{
string str_Update = "UPdate [dbo].[SelPorceLain] set " +
"[PlApplyDate] = '" + sp.dPlApplyDate + "' " +
",[PlApplytime] = '" + sp.strPlApplytime + "' " +
",[PLOperatorID] = '" + sp.strPlOperatorID + "' " +
",[PlOperator] = '" + sp.strPlOperator + "' " +
",[PlWorkNumID] = '" + sp.strPlWorkNumID + "' " +
",[PlGoodsID] = '" + sp.strPlGoodsID + "'" +
",[PlGoodsName] = '" + sp.strPlGoodsName + "' " +
",[PlModelNo] = '" + sp.strPlModelNo + "' " +
",[PlKilnNo] = '" + sp.strPlKilnNo + "' " +
",[PlColor] = '" + sp.strPlColor + "' " +
",[PlWorkshopId] = '" + sp.strPlWorkshopId + "' " +
",[PlNeedGlazed] = " + sp.iPlNeedGlazed + " " +
",[PlModelFaults] = '" + sp.strPlModelFaults + "' " +
",[PlModelFaultsID] = '" + sp.strPlModelFaultsID + "' " +
",[PlGlazeFaults] = '" + sp.strPlGlazeFaults + "' " +
",[PlFireFaults] = '" + sp.strPlFireFaults + "' " +
",[PlLevels] = '" + sp.strPlLevels + "' " +
",[FTypeSteps1] = '" + sp.strFTypeSteps1 + "' " +
",[FTypeSteps2] = '" + sp.strFTypeSteps2 + "' " +
",[FTypeSteps3] = '" + sp.strFTypeSteps3 + "' " +
",[FColorSteps] = '" + sp.strFColorSteps + "' " +
",[PlQty] = " + sp.iPlQty + " " +
",[PlThisQty] = " + sp.iPlThisQty + " " +
",fMaterial = '" + sp.FMaterial + "' " +
" where PlSerialNum = '" + sp.strPlSerialNum + "' ";
intFalg = dbl.ExeInfochange(str_Update);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int SelPorcelainADD(tb_SelPorcelain sp)
{
int intFalg = 0;
try
{
string str_Add = @"INSERT INTO [dbo].[SelPorceLain] (
[PlApplyDate]
,[PlApplytime]
,[PLOperatorID]
,[PlOperator]
,[PlSerialNum]
,[PlWorkNumID]
,[PlGoodsID]
,[PlGoodsName]
,[PlKilnNo]
,[PlColor]
,[PlWorkshopId]
,[PlNeedGlazed]
,[PlModelFaults]
,[PlModelFaultsID ]
,[PlGlazeFaults]
,[PlFireFaults]
,[PlLevels]
,[FTypeSteps1]
,[FTypeSteps2]
,[FTypeSteps3]
,[FColorSteps]
,[PlQty]
,[PlThisQty]
,PlModelNo
,[FImagePath],
fMaterial)
VALUES ( ";
str_Add += "'" + sp.dPlApplyDate + "'," +
" '" + sp.strPlApplytime + "'," +
" '" + sp.strPlOperatorID + "'," +
" '" + sp.strPlOperator + "'," +
" '" + sp.strPlSerialNum + "'," +
" '" + sp.strPlWorkNumID + "'," +
" '" + sp.strPlGoodsID + "'," +
" '" + sp.strPlGoodsName + "'," +
" '" + sp.strPlKilnNo + "'," +
" '" + sp.strPlColor + "'," +
" '" + sp.strPlWorkshopId + "'," +
" " + sp.iPlNeedGlazed + "," +
" '" + sp.strPlModelFaults + "'," +
" '" + sp.strPlModelFaultsID + "'," +
" '" + sp.strPlGlazeFaults + "'," +
" '" + sp.strPlFireFaults + "'," +
" '" + sp.strPlLevels + "'," +
" '" + sp.strFTypeSteps1 + "'," +
" '" + sp.strFTypeSteps2 + "'," +
" '" + sp.strFTypeSteps3 + "'," +
" '" + sp.strFColorSteps + "'," +
" " + sp.iPlQty + "," +
"" + sp.iPlThisQty + "," +
" '" + sp.strPlModelNo + "'," +
"'" + sp.strFImagePath + "'," +
"'" + sp.FMaterial + "')";
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
