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