/// <summary> /// 修改图号 /// </summary> /// <param name="objDrawing"></param> /// <returns></returns> public bool ModifyMaterial(MaterialModel objMaterial) { SQLHelper.connString = Globals.connStrGroupDBName; //string sql = "update code_Drawing set DrawingClassId=@DrawingClassId, DrawingCode=@DrawingCode, MaterialName=@MaterialName, MaterialSpec=@MaterialSpec, Weight=@Weight, Unit=@Unit, HeatTreatment=@HeatTreatment, SurfaceTreatment=@SurfaceTreatment, Brand=@Brand, PurchaseTypeId=@PurchaseTypeId, SelectionTypeId=@SelectionTypeId, DrawingStatusId=@DrawingStatusId, Revision=@Revision, DocIdModel=@DocIdModel, ReMark=@ReMark, UpdateId=@UpdateId, UpdateUser=@UpdateUser, UpdateDate=@UpdateDate, UpdateInfo=@UpdateInfo where DrawingId=@DrawingId"; string sql = "update code_Material set MaterialName=@MaterialName, MaterialSpec=@MaterialSpec, MaterialType=@MaterialType, Mquality=@Mquality, Weight=@Weight, Unit=@Unit, ImportanceGrade=@ImportanceGrade, DraftFeatureId=@DraftFeatureId, MachiningPropertyId=@MachiningPropertyId, PaintingColor=@PaintingColor, HeatTreatment=@HeatTreatment, SurfaceTreatment=@SurfaceTreatment, BrandId=@BrandId, ReMark=@ReMark, UpdateId=@UpdateId, UpdateUser=@UpdateUser, UpdateDate=@UpdateDate, UpdateInfo=@UpdateInfo where MaterialId=@MaterialId"; SqlParameter[] param = new SqlParameter[] { //只封装一部分主要的参数 new SqlParameter("@MaterialId", objMaterial.MaterialId), //new SqlParameter("@MaterialClassId",objMaterial.MaterialClassId), //new SqlParameter("@MaterialCode",objMaterial.MaterialCode), //new SqlParameter("@FactoryCode",objMaterial.FactoryCode), //new SqlParameter("@IsPublic",objMaterial.IsPublic), //new SqlParameter("@MaterialCategoryId",objMaterial.MaterialCategoryId), //new SqlParameter("@DrawingCode",objMaterial.DrawingCode), new SqlParameter("@MaterialName", objMaterial.MaterialName), new SqlParameter("@MaterialSpec", objMaterial.MaterialSpec), new SqlParameter("@MaterialType", objMaterial.MaterialType), new SqlParameter("@Mquality", objMaterial.Mquality), new SqlParameter("@Weight", objMaterial.Weight), new SqlParameter("@Unit", objMaterial.Unit), new SqlParameter("@ImportanceGrade", ConvertEx.SqlNull(objMaterial.ImportanceGrade)), new SqlParameter("@DraftFeatureId", ConvertEx.SqlNull(objMaterial.DraftFeatureId)), new SqlParameter("@MachiningPropertyId", ConvertEx.SqlNull(objMaterial.MachiningPropertyId)), new SqlParameter("@PaintingColor", ConvertEx.SqlNull(objMaterial.PaintingColor)), new SqlParameter("@HeatTreatment", objMaterial.HeatTreatment), new SqlParameter("@SurfaceTreatment", objMaterial.SurfaceTreatment), new SqlParameter("@BrandId", ConvertEx.SqlNull(objMaterial.BrandId)), //new SqlParameter("@StatusId",objMaterial.StatusId), //new SqlParameter("@Revision",objMaterial.Revision), //new SqlParameter("@DocIdModel",objMaterial.DocIdModel), new SqlParameter("@ReMark", objMaterial.ReMark), new SqlParameter("@UpdateId", objMaterial.UpdateId), new SqlParameter("@UpdateUser", objMaterial.UpdateUser), new SqlParameter("@UpdateDate", objMaterial.UpdateDate), new SqlParameter("@UpdateInfo", objMaterial.UpdateInfo) }; int result = SQLHelper.Update(sql, param, false); return(result != 0); }
/// <summary> /// 新增物料编码 /// </summary> /// <param name="objMaterial"></param> /// <returns></returns> public bool AddMaterial(MaterialModel objMaterial) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = "insert into code_Material(MaterialClassId, MaterialCode, FactoryCode, IsPublic, MaterialCategoryId, DrawingCode, MaterialName, MaterialSpec, MaterialType, Mquality, Weight, Unit, ImportanceGrade, DraftFeatureId, MachiningPropertyId, PaintingColor, HeatTreatment, SurfaceTreatment, BrandId, StatusId, Revision, DocIdModel, ReMark, CreateFrom, CreateId, CreateUser, CreateDate, CreateInfo) values(@MaterialClassId, @MaterialCode, @FactoryCode, @IsPublic, @MaterialCategoryId, @DrawingCode, @MaterialName, @MaterialSpec, @MaterialType, @Mquality, @Weight, @Unit, @ImportanceGrade, @DraftFeatureId, @MachiningPropertyId, @PaintingColor, @HeatTreatment, @SurfaceTreatment, @BrandId, @StatusId, @Revision, @DocIdModel, @ReMark, @CreateFrom, @CreateId, @CreateUser, @CreateDate, @CreateInfo)"; SqlParameter[] param = new SqlParameter[] { //只封装一部分主要的参数 new SqlParameter("@MaterialClassId", objMaterial.MaterialClassId), new SqlParameter("@MaterialCode", objMaterial.MaterialCode), new SqlParameter("@FactoryCode", objMaterial.FactoryCode), new SqlParameter("@IsPublic", objMaterial.IsPublic), new SqlParameter("@MaterialCategoryId", objMaterial.MaterialCategoryId), new SqlParameter("@DrawingCode", objMaterial.DrawingCode), new SqlParameter("@MaterialName", objMaterial.MaterialName), new SqlParameter("@MaterialSpec", objMaterial.MaterialSpec), new SqlParameter("@MaterialType", objMaterial.MaterialType), new SqlParameter("@Mquality", objMaterial.Mquality), new SqlParameter("@Weight", objMaterial.Weight), new SqlParameter("@Unit", objMaterial.Unit), new SqlParameter("@ImportanceGrade", ConvertEx.SqlNull(objMaterial.ImportanceGrade)), new SqlParameter("@DraftFeatureId", ConvertEx.SqlNull(objMaterial.DraftFeatureId)), new SqlParameter("@MachiningPropertyId", ConvertEx.SqlNull(objMaterial.MachiningPropertyId)), new SqlParameter("@PaintingColor", ConvertEx.SqlNull(objMaterial.PaintingColor)), new SqlParameter("@HeatTreatment", objMaterial.HeatTreatment), new SqlParameter("@SurfaceTreatment", objMaterial.SurfaceTreatment), new SqlParameter("@BrandId", ConvertEx.SqlNull(objMaterial.BrandId)), new SqlParameter("@StatusId", objMaterial.StatusId), new SqlParameter("@Revision", objMaterial.Revision), new SqlParameter("@DocIdModel", objMaterial.DocIdModel), new SqlParameter("@ReMark", objMaterial.ReMark), new SqlParameter("@CreateFrom", objMaterial.CreateFrom), new SqlParameter("@CreateId", objMaterial.CreateId), new SqlParameter("@CreateUser", objMaterial.CreateUser), new SqlParameter("@CreateDate", objMaterial.CreateDate), new SqlParameter("@CreateInfo", objMaterial.CreateInfo) }; int result = SQLHelper.Update(sql, param, false); return(result != 0); }