public static bool InsertDB(ExeclRow entity, SqlConnection conn, ref string msg) { //基本信息 cl_Product productModel = new cl_Product(); productModel.ProductGUID = Guid.NewGuid(); productModel.ProductCode = entity.Code; productModel.ProductName = entity.Name; productModel.ProductTypeCode = entity.TypeCode; productModel.Unit = entity.Unit; productModel.QuotaAttributeNameList = entity.QuotaAttributeNameList; productModel.Source = "工具导入"; productModel.CreateTime = DateTime.Now; productModel.LastMenderDate = DateTime.Now; productModel.PutInStorageState = "已入库"; productModel.Remarks = entity.Remake; //扩展信息 cl_Product_Ext productExtModel = new cl_Product_Ext(); productExtModel.ID = Guid.NewGuid(); productExtModel.ProductGUID = productModel.ProductGUID; productExtModel.brandName = entity.BrandName; productExtModel.DHHQ = entity.ProductTime; productExtModel.YBFHQ = entity.ExampleTime; productExtModel.ProductModel = entity.ModelName; productExtModel.Specifications = entity.Format; //枚举信息 Tuple <List <p_Product2QuotaAttribute>, List <p_ProductAttributeValue> > tupleResult = AttributeInsertList(entity, productModel); List <p_Product2QuotaAttribute> product2QuotaAttributeList = tupleResult.Item1; List <p_ProductAttributeValue> productAttributeValueList = tupleResult.Item2; using (SqlTransaction transaction = conn.BeginTransaction()) { try { DataBaseCommand.SaveProduct(productModel, conn, transaction); //保存产品 DataBaseCommand.SaveProductExt(productExtModel, conn, transaction); //保存扩展信息 DataBaseCommand.SaveProduct2QuotaAttribute(product2QuotaAttributeList, conn, transaction); //保存枚举值产品关系 DataBaseCommand.SavaProductAttributeValue(productAttributeValueList, conn, transaction); //保存文本信息 DataBaseCommand.UpdateCodeFormatInfo(productModel.ProductCode, productModel.ProductGUID, conn, transaction); transaction.Commit(); msg = "成功"; return(true); } catch (Exception ex) { transaction.Rollback(); msg = ex.Message; Logger.GetLogger(ex.Message).Error(ex); return(false); } } }
/// <summary> /// 保存产品扩展信息 /// </summary> /// <param name="model"></param> /// <param name="conn"></param> /// <param name="transaction"></param> /// <returns></returns> public static int SaveProductExt(cl_Product_Ext model, SqlConnection conn, SqlTransaction transaction = null) { string sql = @"INSERT INTO [dbo].[cl_Product_Ext] ([ID] ,[ProductGUID] ,[brandName] ,[Specifications] ,[ProductModel] ,[YBFHQ] ,[DHHQ]) VALUES (@ID ,@ProductGUID ,@brandName ,@Specifications ,@ProductModel ,@YBFHQ ,@DHHQ)"; return(conn.Execute(sql, model, transaction)); }