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