/// <summary>
/// 添加
/// </summary>
/// <param name="goodsProperty"></param>
/// <returns></returns>
public int Add(GoodsProperty goodsProperty)
{
StringBuilder sb = new StringBuilder();
var PropertyKeyId = Common.GenerateTools.PrimaryKey();
sb.Append($@" INSERT dbo.GoodsPropertyKey
(
Id,
Name,
CategoryId,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{PropertyKeyId}', -- Id - nvarchar(50)
N'{goodsProperty.Name}', -- Name - nvarchar(50)
N'{goodsProperty.CategoryId}', -- CategoryId - nvarchar(50)
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsProperty.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsProperty.CreateTime}, -- CreateTime - bigint
N'{goodsProperty.EditUserId}', -- EditUserId - nvarchar(50)
{goodsProperty.EditTime} -- EditTime - bigint
);");
foreach (var item in goodsProperty.PropertyVal)
{
sb.Append($@" INSERT dbo.GoodsPropertyVal
(
Id,
Name,
PropertyKeyId,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{Common.GenerateTools.PrimaryKey()}', -- Id - nvarchar(50)
N'{item.Name}', -- Name - nvarchar(50)
N'{PropertyKeyId}', -- PropertyKeyId - nvarchar(50)
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsProperty.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsProperty.CreateTime}, -- CreateTime - bigint
N'{goodsProperty.EditUserId}', -- EditUserId - nvarchar(50)
{goodsProperty.EditTime} -- EditTime - bigint
);");
}
return(db.Transaction(sb.ToString()));
}
protected override void InitLoadedMinDmo(ButcheryGoods mMinDmo)
{
base.InitLoadedMinDmo(mMinDmo);
if (mMinDmo.GoodsProperty_ID.HasValue)
{
mMinGoodsProperty = BIFactory.Create <IGoodsPropertyBL>().LoadMinDmo(mMinDmo.GoodsProperty_ID.Value);
if (mMinGoodsProperty == null)
{
throw new Exception("存货上的存货属性在数据库中已不存在");
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="goodsProperty"></param>
/// <returns></returns>
public int Edit(GoodsProperty goodsProperty)
{
StringBuilder sb = new StringBuilder();
StringBuilder sub = new StringBuilder();
List <string> propertyValId = new List <string>();
sb.Append($@" UPDATE dbo.GoodsPropertyKey SET Name='{goodsProperty.Name}' WHERE Id='{goodsProperty.Id}' ;");
foreach (var item in goodsProperty.PropertyVal)
{
if (string.IsNullOrEmpty(item.Id))
{
sub.Append($@" INSERT dbo.GoodsPropertyVal
(
Id,
Name,
PropertyKeyId,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{Common.GenerateTools.PrimaryKey()}', -- Id - nvarchar(50)
N'{item.Name}', -- Name - nvarchar(50)
N'{item.PropertyKeyId}', -- PropertyKeyId - nvarchar(50)
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsProperty.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsProperty.CreateTime}, -- CreateTime - bigint
N'{goodsProperty.EditUserId}', -- EditUserId - nvarchar(50)
{goodsProperty.EditTime} -- EditTime - bigint
);");
}
else
{
sub.Append($" UPDATE dbo.GoodsPropertyVal SET Name='{item.Name}' WHERE Id='{item.Id}';");
propertyValId.Add(item.Id);
}
}
if (propertyValId.Count > 0)
{
sb.Append($" UPDATE dbo.GoodsPropertyVal SET IsDelete=1 WHERE PropertyKeyId='' AND Id NOT IN('{string.Join("','", propertyValId)}');");
}
sb.Append(sub.ToString());
return(db.Transaction(sb.ToString()));
}
public int AddProperty(GoodsProperty m)
{
string procName = "AddProperty";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter {
ParameterName = "@GoodsId", DbType = DbType.Guid, Direction = ParameterDirection.Input, Value = m.GoodsId
},
new SqlParameter {
ParameterName = "@SId", DbType = DbType.Guid, Direction = ParameterDirection.Input, Value = m.SId
},
new SqlParameter {
ParameterName = "@CId", DbType = DbType.Guid, Direction = ParameterDirection.Input, Value = m.CId
}
};
return(dBHelper.ExecuteNonQueryProc(procName, param));
}
public int AddProperty([FromForm] GoodsProperty m)
{
return(goodsBLL.AddProperty(m));
}
