/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
ProductAttributesValueModel productattributesvalue = new ProductAttributesValueModel();
ret = DbUtil.Current.DeleteMultiple(productattributesvalue, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productattributesvalue">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(ProductAttributesValueModel productattributesvalue, ParameterCollection pc)
{
int ret = 0;
productattributesvalue.ModifiedBy = SessionUtil.Current.UserId;
productattributesvalue.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(productattributesvalue, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productattributesvalue">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(ProductAttributesValueModel productattributesvalue)
{
int ret = 0;
productattributesvalue.ModifiedBy = SessionUtil.Current.UserId;
productattributesvalue.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(productattributesvalue);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="valueid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string valueid)
{
int ret = 0;
ProductAttributesValueModel productattributesvalue = new ProductAttributesValueModel();
productattributesvalue.ValueId = valueid;
ret = DbUtil.Current.Delete(productattributesvalue);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <ProductAttributesValueModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <ProductAttributesValueModel> productattributesvalues = new List <ProductAttributesValueModel>();
ProductAttributesValueModel productattributesvalue = new ProductAttributesValueModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(productattributesvalue, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
productattributesvalue = new ProductAttributesValueModel();
productattributesvalue.ConvertFrom(dt, i);
productattributesvalues.Add(productattributesvalue);
}
return(productattributesvalues);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="valueid"></param>
/// <returns>实体</returns>
public ProductAttributesValueModel Retrieve(string valueid)
{
ProductAttributesValueModel productattributesvalue = new ProductAttributesValueModel();
productattributesvalue.ValueId = valueid;
DataTable dt = DbUtil.Current.Retrieve(productattributesvalue);
if (dt.Rows.Count < 1)
{
return(null);
}
productattributesvalue.ConvertFrom(dt);
return(productattributesvalue);
}
public bool CreateProductInfo(ProductInfoDomainModel productInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (productInfo == null || productInfo.BasicInfo == null || productInfo.AttributeList == null)
{
message = "操作失败，产品参数不完整";
return(false);
}
ProductCategoryInfoModel catInfo = ProductCategoryInfoService.Instance.GetProductCategoryInfoById(productInfo.BasicInfo.CategoryId);
Dictionary <string, ProductCategoryAttributesModel> catAttList = ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(productInfo.BasicInfo.CategoryId, false);
if (catAttList == null)
{
message = "操作失败，不存在的产品类型ID";
return(false);
}
string InsProductSQL = GetCreateProductSQL(catInfo, productInfo, catAttList);
try
{
BeginTransaction();
if (Create(productInfo.BasicInfo) == 1)
{
ProductAttributesValueModel valueInfo = null;
foreach (KeyValuePair <string, string> item in productInfo.AttributeList)
{
valueInfo = new ProductAttributesValueModel();
valueInfo.ValueId = GetGuid();
valueInfo.AttributeId = item.Key;
valueInfo.AttributeValue = item.Value;
valueInfo.ProductCategoryId = productInfo.BasicInfo.CategoryId;
valueInfo.ProductId = productInfo.BasicInfo.ProductId;
if (ProductAttributesValueService.Instance.Create(valueInfo) != 1)
{
RollbackTransaction();
message = "操作失败，保存产品属性值失败";
return(false);
}
}
if (ExecuteNonQuery(InsProductSQL) != 1)
{
RollbackTransaction();
message = "操作失败，插入产品信息表失败";
return(false);
}
CommitTransaction();
message = "成功创建产品信息";
GetProductDomainInfoByProductId(productInfo.BasicInfo.ProductId, true);
result = true;
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("创建产品信息异常", ex);
throw ex;
}
return(result);
}
