public static bool UpdateProductLine(ProductLineInfo productLine)
{
Globals.EntityCoding(productLine, true);
bool flag = ProductProvider.Instance().UpdateProductLine(productLine);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditProductLine, string.Format(CultureInfo.InvariantCulture, "修改了产品线", new object[0]));
}
return(flag);
}
public virtual ProductLineInfo Create(ProductLineInfo entity)
{
ValidateProductLine(entity);
using (TransactionScope scope = new TransactionScope())
{
entity = da.Create(entity);
da.CreateChangePool(entity.SysNo.Value, null, null);
scope.Complete();
}
return(entity);
}
/// <summary>
/// 更新产品线信息
/// </summary>
/// <param name="info"></param>
public void UpdateProductLine(ProductLineInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductLine");
cmd.SetParameterValue("@ProductLineName", info.ProductLineName);
cmd.SetParameterValue("@ProductLineCategorySysNo", info.ProductLineCategorySysNo);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@UserName", info.User.UserName);
cmd.SetParameterValue("@UseScopeDescription", info.UseScopeDescription);
cmd.SetParameterValue("@SysNo", info.SysNo);
cmd.ExecuteNonQuery();
}
private void LoadControl()
{
ProductLineInfo productLine = ProductLineHelper.GetProductLine(this.lineId);
if (productLine == null)
{
base.GotoResourceNotFound();
return;
}
Globals.EntityCoding(productLine, false);
this.txtProductLineName.Text = productLine.Name;
this.dropSuppliers.SelectedValue = productLine.SupplierName;
}
private void ValidateProductLine(ProductLineInfo entity)
{
if (entity == null)
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult1"));
}
if (!entity.C2SysNo.HasValue || entity.C2SysNo <= 0)
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult2"));
}
if (entity.PMUserSysNo <= 0)
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult3"));
}
if (entity.MerchandiserSysNo <= 0)
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult4"));
}
var message = new List <string>();
if (!da.C2IsValid(entity.C2SysNo.Value))
{
message.Add(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult5"));
}
if (entity.BrandSysNo.HasValue && !da.BrandIsValid(entity.BrandSysNo.Value))
{
message.Add(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult6"));
}
if (!da.PMIsValid(entity.PMUserSysNo))
{
message.Add(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult7"));
}
if (!da.PMIsValid(entity.MerchandiserSysNo))
{
message.Add(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult8"));
}
if (message.Any())
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult9") + message.Join(","));
}
if (!entity.SysNo.HasValue || entity.SysNo <= 0)
{
var isexists = da.IsExists(entity.C2SysNo.Value, entity.BrandSysNo);
//是否会导致新分类重复
if (isexists)
{
throw new BizException(ResouceManager.GetMessageString("IM.Product", "ValidateProductLineResult10"));
}
}
}
public virtual ProductLineInfo Update(ProductLineInfo entity)
{
ValidateProductLine(entity);
using (TransactionScope scope = new TransactionScope())
{
entity = da.Update(entity);
if (!da.HasSameChange(entity.SysNo.Value, entity.PMUserSysNo))
{
da.CreateChangePool(entity.SysNo.Value, null, null);
}
scope.Complete();
}
return(entity);
}
public ProductLineInfo Update(ProductLineInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("ProductLine_UpdateProductLine");
cmd.SetParameterValue("@SysNo", entity.SysNo);
cmd.SetParameterValue("@BrandSysNo", entity.BrandSysNo);
cmd.SetParameterValue("@C2SysNo", entity.C2SysNo);
cmd.SetParameterValue("@PMSysNo", entity.PMUserSysNo);
cmd.SetParameterValue("@BackupPMSysNoList", entity.BackupPMSysNoList);
cmd.SetParameterValue("@MerchandiserSysNo", entity.MerchandiserSysNo);
cmd.SetParameterValue("@EditUser", entity.EditUser);
cmd.ExecuteNonQuery();
return(entity);
}
private void SetSendEmailAddress(int productsysno, ProductPriceRequestInfo entity)
{
ProductLineInfo plentity = ObjectFactory <IProductLineDA> .Instance.GetPMByProductSysNo(productsysno);
if (plentity != null)
{
entity.PMUserEmailAddress = ObjectFactory <IProductManagerDA> .Instance.GetProductManagerInfoByUserSysNo(plentity.PMUserSysNo).UserInfo.EmailAddress;
entity.BackupPMUserEmailAddress = GetBackupPMUserEmailAddress(plentity.BackupPMSysNoList);
entity.CreateUserEmailAddress = ObjectFactory <IProductManagerDA> .Instance.GetProductManagerInfoByUserSysNo(entity.CreateUser.SysNo.Value).UserInfo.EmailAddress;
entity.CurrentUserEmailAddress = ObjectFactory <IProductManagerDA> .Instance.GetProductManagerInfoByUserSysNo(ServiceContext.Current.UserSysNo).UserInfo.EmailAddress;
}
}
/// <summary>
/// 创建产品线信息
/// </summary>
/// <param name="info"></param>
public ProductLineInfo CreateProductLine(ProductLineInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateProductLine");
cmd.SetParameterValue("@ProductLineName", info.ProductLineName);
cmd.SetParameterValue("@ProductLineCategorySysNo", info.ProductLineCategorySysNo);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@UseScopeDescription", info.UseScopeDescription);
cmd.SetParameterValue("@UserName", info.User.UserName);
cmd.SetParameterValue("@ComPanyCode", info.CompanyCode);
cmd.SetParameterValue("@LanguageCode", info.LanguageCode);
cmd.ExecuteNonQuery();
info.SysNo = (int)cmd.GetParameterValue("@SysNo");
return(info);
}
public ProductLineInfo Create(ProductLineInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("ProductLine_Create");
cmd.SetParameterValue("@BrandSysNo", entity.BrandSysNo);
cmd.SetParameterValue("@C2SysNo", entity.C2SysNo);
cmd.SetParameterValue("@PMSysNo", entity.PMUserSysNo);
cmd.SetParameterValue("@BackupPMSysNoList", entity.BackupPMSysNoList);
cmd.SetParameterValue("@MerchandiserSysNo", entity.MerchandiserSysNo);
cmd.SetParameterValue("@InUser", entity.InUser);
cmd.SetParameterValue("@CompanyCode", entity.CompanyCode);
cmd.ExecuteNonQuery();
entity.SysNo = (int)cmd.GetParameterValue("@SysNo");
return(entity);
}
/// <summary>
/// 创建产品线信息
/// </summary>
/// <param name="info"></param>
public void CreateProductLine(ProductLineInfo info)
{
if (!productLineDA.IsExistsProductLine(info))
{
using (TransactionScope scope = new TransactionScope())
{
ProductLineInfo product = productLineDA.CreateProductLine(info);
//创建之后修改优先级
productLineDA.UpdatePriority(product.SysNo);
scope.Complete();
}
}
else
{
throw new BizException("产品线名称在该类别下已存在,不能创建!");
}
}
/// <summary>
/// 更新产品线信息
/// </summary>
/// <param name="info"></param>
public void UpdateProductLine(ProductLineInfo info)
{
if (!productLineDA.IsExistsProductLine(info))
{
using (TransactionScope scope = new TransactionScope())
{
productLineDA.UpdateProductLine(info);
//更新基本信息后，在更新优先级
productLineDA.UpdatePriority(info.SysNo);
scope.Complete();
}
}
else
{
throw new BizException("产品线名称在该类别下已存在,不能修改!");
}
}
/// <summary>
/// 检查是否在同一个类别下,已存在该产品线
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool IsExistsProductLine(ProductLineInfo info)
{
DataCommand cmd;
if (info.SysNo > 0)
{
cmd = DataCommandManager.GetDataCommand("IsExistsProductLineByUpdate");
cmd.SetParameterValue("@SysNo", info.SysNo);
}
else
{
cmd = DataCommandManager.GetDataCommand("IsExistsProductLine");
}
cmd.SetParameterValue("@ProductLineName", info.ProductLineName);
cmd.SetParameterValue("@ProductLineCategorySysNo", info.ProductLineCategorySysNo);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@Flag") > 0);
}
public void HasRightByPMUser(int pmusersysno, int c3sysno, int brandsysno, EventHandler <RestClientEventArgs <bool> > callback)
{
string relativeUrl = "/IMService/ProductLine/HasRightByPMUser";
ProductLineInfo entity = new ProductLineInfo();
entity.C3SysNo = c3sysno;
entity.BrandSysNo = brandsysno;
entity.PMUserSysNo = pmusersysno;
restClient.Query <bool>(relativeUrl, entity, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
public override IList <ProductLineInfo> GetProductLineList()
{
IList <ProductLineInfo> list = new List <ProductLineInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_ProductLines");
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (reader.Read())
{
ProductLineInfo item = new ProductLineInfo
{
LineId = (int)reader["LineId"],
Name = (string)reader["Name"]
};
list.Add(item);
}
}
return(list);
}
public override IList <ProductLineInfo> GetProductLineList()
{
IList <ProductLineInfo> list = new List <ProductLineInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_ProductLines");
if (HiContext.Current.User.UserRole == UserRole.Distributor)
{
sqlStringCommand.CommandText = sqlStringCommand.CommandText + " WHERE LineId IN (SELECT LineId FROM Hishop_DistributorProductLines WHERE UserId = @UserId)";
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, HiContext.Current.User.UserId);
}
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (null != reader && reader.Read())
{
ProductLineInfo productLineInfo = new ProductLineInfo();
productLineInfo.LineId = (int)reader["LineId"];
productLineInfo.Name = (string)reader["Name"];
ProductLineInfo item = productLineInfo;
list.Add(item);
}
}
return(list);
}
public abstract bool UpdateProductLine(ProductLineInfo productLine);
/// <summary>
/// 更新产品线信息
/// </summary>
/// <param name="info"></param>
public void UpdateProductLine(ProductLineInfo info)
{
processor.UpdateProductLine(info);
}
/// <summary>
/// 创建产品线信息
/// </summary>
/// <param name="info"></param>
public void CreateProductLine(ProductLineInfo info)
{
processor.CreateProductLine(info);
}
public bool HasRightByPMUser(ProductLineInfo entity)
{
return(ObjectFactory <ProductLineProcessor> .Instance.HasRightByPMUser(entity));
}
public ProductLineInfo Update(ProductLineInfo entity)
{
return(ObjectFactory <ProductLineProcessor> .Instance.Update(entity));
}
public void UpdateProductLine(ProductLineInfo info)
{
ObjectFactory <ProductLineAppService> .Instance.UpdateProductLine(info);
}
public virtual ProductLineInfo UpdateProductLine(ProductLineInfo entity)
{
return(ObjectFactory <ProductLineAppService> .Instance.Update(entity));
}
public virtual bool HasRightByPMUser(ProductLineInfo entity)
{
return(ObjectFactory <ProductLineAppService> .Instance.HasRightByPMUser(entity));
}
public bool HasRightByPMUser(ProductLineInfo entity)
{
return(da.HasRightByPMUser(entity));
}
public void BatchUpdate(BatchUpdatePMEntity entity)
{
if (entity == null)
{
throw new Exception("Argument is null");
}
if (entity.ProductLineList == null || entity.ProductLineList.Count == 0)
{
string error = string.Empty;
if (entity.IsEmptyC2Create)
{
error = ResouceManager.GetMessageString("IM.Product", "ProductLineBatchUpdateResult1");
}
else
{
error = ResouceManager.GetMessageString("IM.Product", "ProductLineBatchUpdateResult2");
}
throw new BizException(error);
}
StringBuilder failtstring = new StringBuilder();
foreach (var item in entity.ProductLineList)
{
if (entity.IsEmptyC2Create)
{
item.PMUserSysNo = entity.PMUserSysNo.Value;
item.MerchandiserSysNo = entity.MerchandiserSysNo.Value;
item.BackupPMSysNoList = entity.BackupPMSysNoList;
item.InUser = entity.InUser;
item.CompanyCode = entity.CompanyCode;
item.LanguageCode = entity.LanguageCode;
try
{
Create(item);
}
catch (BizException ex)
{
failtstring.AppendLine(string.Format(ResouceManager.GetMessageString("IM.Product", "ProductLineBatchUpdateResult3"), item.C2Name, ex.Message));
}
}
else
{
ProductLineInfo olditem = LoadBySysNo(item.SysNo.Value);
if (entity.PMUserSysNo.HasValue)
{
olditem.PMUserSysNo = entity.PMUserSysNo.Value;
}
if (entity.MerchandiserSysNo.HasValue)
{
olditem.MerchandiserSysNo = entity.MerchandiserSysNo.Value;
}
olditem.EditUser = entity.InUser;
try
{
olditem.BackupPMSysNoList = ProcessBakPMList(olditem.BackupPMSysNoList, entity.BackupPMList, entity.BakPMUpdateType);
Update(olditem);
}
catch (BizException ex)
{
failtstring.AppendLine(string.Format(ResouceManager.GetMessageString("IM.Product", "ProductLineBatchUpdateResult4"), item.SysNo, ex.Message));
}
}
}
if (failtstring.Length > 0)
{
throw new BizException(failtstring.ToString());
}
}
public abstract bool AddProductLine(ProductLineInfo productLine);
