public override Result UpdatePriceStatus(decimal price, decimal shopPrice, decimal wholesalePrice, int status, int sysNo)
{
List <DBKey> keyList = new List <DBKey>();
keyList.Add(new DBKey()
{
KeyName = "WholesalePrice", Type = "decimal(18, 2)"
});
CheckKeyExcel(keyList);
Result result = new Result();
string Sql = string.Format("update DsSpecialPrice set Price = {0},ShopPrice = {3},WholesalePrice = {4},Status = {1} where SysNo = {2}", price, status, sysNo, shopPrice, wholesalePrice);
int rowsAffected = Context.Sql(Sql).Execute();
if (rowsAffected > 0)
{
result.Status = true;
result.Message = "更新成功";
result.StatusCode = 1;
}
else
{
result.Status = false;
result.Message = "更新上架状态失败";
result.StatusCode = -1;
return(result);
}
DsSpecialPrice entity = GetEntityBySysNo(sysNo);
string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + entity.ProductSysNo + "' ";
Context.Sql(sql).Execute();
return(result);
}
/// <summary>
/// 创建分销商产品特殊价格
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>系统编号</returns>
/// <remarks>2013-09-04 周瑜 创建</remarks>
public int Create(DsSpecialPrice model)
{
var sysNo = IDsSpecialPriceDao.Instance.Create(model);
SysLog.Instance.Info(LogStatus.系统日志来源.后台, "创建分销商产品特殊价格", LogStatus.系统日志目标类型.分销商特殊价格, sysNo);
return(sysNo);
}
/// <summary>
/// 获取特殊价格信息
/// </summary>
/// <param name="SysNo">分销商商品系统编号</param>
/// <returns>特殊价格信息</returns>
/// <remarks>2016-2-24 王耀发 创建</remarks>
//public override DsSpecialPrice GetEntityByProductSysNo(int ProductSysNo)
//{
// return Context.Sql("select * from DsSpecialPrice where ProductSysNo=@ProductSysNo")
// .Parameter("ProductSysNo", ProductSysNo)
// .QuerySingle<DsSpecialPrice>();
//}
public override Result UpdatePriceStatus(decimal price, decimal shopPrice, int status, int sysNo)
{
Result result = new Result();
string Sql = string.Format("update DsSpecialPrice set Price = {0},ShopPrice = {3},Status = {1} where SysNo = {2}", price, status, sysNo, shopPrice);
int rowsAffected = Context.Sql(Sql).Execute();
if (rowsAffected > 0)
{
result.Status = true;
result.Message = "更新成功";
result.StatusCode = 1;
}
else
{
result.Status = false;
result.Message = "更新上架状态失败";
result.StatusCode = -1;
return(result);
}
DsSpecialPrice entity = GetEntityBySysNo(sysNo);
string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + entity.ProductSysNo + "' ";
Context.Sql(sql).Execute();
return(result);
}
/// <summary>
/// 修改价格
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>受影响行</returns>
/// <remarks>2013-09-06 周瑜 创建</remarks>
public override int UpdatePrice(DsSpecialPrice model)
{
return(Context.Sql("update DsSpecialPrice set Price = @Price, LastUpdateBy = @LastUpdateBy, LastUpdateDate = @LastUpdateDate where SysNo = @SysNo")
.Parameter("Price", model.Price)
.Parameter("LastUpdateBy", model.LastUpdateBy)
.Parameter("LastUpdateDate", model.LastUpdateDate)
.Parameter("SysNo", model.SysNo)
.Execute());
}
/// <summary>
/// 更新分销商产品特殊价格
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>系统编号</returns>
/// <remarks>2013-09-04 周瑜 创建</remarks>
public override int Update(DsSpecialPrice model)
{
List <DBKey> keyList = new List <DBKey>();
keyList.Add(new DBKey()
{
KeyName = "WholesalePrice", Type = "decimal(18, 2)"
});
CheckKeyExcel(keyList);
return(Context.Update("DsSpecialPrice", model).AutoMap(x => x.SysNo).Where(x => x.SysNo).Execute());
}
/// <summary>
/// 修改特殊价格状态: 禁用/启用
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>受影响行</returns>
/// <remarks>2013-09-04 周瑜 创建</remarks>
public override int UpdateStatus(DsSpecialPrice model)
{
int sysno = Context.Sql("update DsSpecialPrice set Status = @Status, LastUpdateBy = @LastUpdateBy, LastUpdateDate = @LastUpdateDate where SysNo = @SysNo")
.Parameter("Status", model.Status)
.Parameter("LastUpdateBy", model.LastUpdateBy)
.Parameter("LastUpdateDate", model.LastUpdateDate)
.Parameter("SysNo", model.SysNo)
.Execute();
string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + model.ProductSysNo + "' ";
Context.Sql(sql).Execute();
return(sysno);
}
/// <summary>
/// 创建分销商产品特殊价格
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>系统编号</returns>
/// <remarks>2013-09-04 周瑜 创建</remarks>
public override int Create(DsSpecialPrice model)
{
List <DBKey> keyList = new List <DBKey>();
keyList.Add(new DBKey()
{
KeyName = "WholesalePrice", Type = "decimal(18, 2)"
});
CheckKeyExcel(keyList);
int sysno = Context.Insert("DsSpecialPrice", model).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo");
///更新库存信息，修改商品档案的更新时间
string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + model.ProductSysNo + "' ";
Context.Sql(sql).Execute();
return(sysno);
}
/// <summary>
/// 修改价格
/// </summary>
/// <param name="model">分销商产品特殊价格实体</param>
/// <returns>返回影响行</returns>
/// <remarks>2013-09-06 周瑜 创建</remarks>
public int UpdatePrice(DsSpecialPrice model)
{
SysLog.Instance.Info(LogStatus.系统日志来源.后台, "修改价格", LogStatus.系统日志目标类型.分销商特殊价格, model.SysNo);
return(IDsSpecialPriceDao.Instance.UpdatePrice(model));
}
public Result ImportSpecialPriceExcel(System.IO.Stream stream, int operatorSysno)
{
var result = new Result();
DataTable dt = null;
var cols = DisColsMapping.Select(p => p.Value).ToArray();
var existlst = new List <PdProduct>();
try
{
dt = ExcelUtil.ImportExcel(stream, cols);
}
catch (System.Exception ex)
{
//exception happened,some not caughted
result.Message = string.Format("数据导入错误,请选择正确的excel文件");
result.Status = false;
return(result);
}
if (dt == null)
{
//not all the cols mapped
result.Message = string.Format("请选择正确的excel文件!");
result.Status = false;
return(result);
}
string msg = "";
var excellst = new List <PdProductList>();
var lstToInsert = new List <PdProductList>();
var lstToUpdate = new List <PdProductList>();
List <PdProduct> productList = Hyt.BLL.Product.PdProductBo.Instance.GetAllProductDataBase();
List <DsSpecialPrice> specProductList = DsSpecialPriceBo.Instance.GetAllProductDsSpecialPrice();
IList <DsDealer> dealerList = DsDealerBo.Instance.GetAllDealerList();
for (var i = 0; i < dt.Rows.Count; i++)
{
int excelRow = i + 2;
for (var j = 0; j < dt.Columns.Count; j++)
{
if ((dt.Rows[i][j] == null || string.IsNullOrEmpty(dt.Rows[i][j].ToString().Trim())))
{
result.Message = string.Format("excel表第{0}行第{1}列数据不能有空值", excelRow, (j + 1));
result.Status = false;
return(result);
}
}
//商品编号
var ErpCode = dt.Rows[i][DisColsMapping["ErpCode"]].ToString().Trim();
//条形码.
var Barcode = dt.Rows[i][DisColsMapping["Barcode"]].ToString().Trim();
var DsDealerName = dt.Rows[i][DisColsMapping["DsDealerName"]].ToString().Trim();
var DsUserPrice = dt.Rows[i][DisColsMapping["DsUserPrice"]].ToString().Trim();
var ShopPrice = dt.Rows[i][DisColsMapping["ShopPrice"]].ToString().Trim();
var WholesalePrice = dt.Rows[i][DisColsMapping["WholesalePrice"]].ToString().Trim();
PdProduct tempProduct = productList.Find(p => p.ErpCode == ErpCode);
List <DsDealer> tempDealer = dealerList.Where(p => p.DealerName == DsDealerName).ToList();
if (tempProduct != null && tempDealer.Count > 0 && !string.IsNullOrEmpty(DsUserPrice) && !string.IsNullOrEmpty(ShopPrice))
{
DsSpecialPrice tempSpecialMod = specProductList.Find(p => p.DealerSysNo == tempDealer[0].SysNo && p.ProductSysNo == tempProduct.SysNo);
DsSpecialPrice specialMod;
try
{
specialMod = new DsSpecialPrice()
{
ProductSysNo = tempProduct.SysNo,
DealerSysNo = tempDealer[0].SysNo,
CreatedBy = 1,
CreatedDate = System.DateTime.Now,
LastUpdateBy = 1,
LastUpdateDate = System.DateTime.Now,
Price = decimal.Parse(DsUserPrice),
ShopPrice = decimal.Parse(ShopPrice),
WholesalePrice = decimal.Parse(WholesalePrice),
Status = 1
};
}
catch (System.Exception e) {
if (!string.IsNullOrEmpty(msg))
{
msg += ",";
}
msg += "商品编码:" + Barcode + "出现异常-" + e.Message;
continue;
}
if (tempSpecialMod == null)
{
DsSpecialPriceBo.Instance.Create(specialMod);
}
else
{
specialMod.SysNo = tempSpecialMod.SysNo;
DsSpecialPriceBo.Instance.Update(specialMod);
}
}
else
{
if (!string.IsNullOrEmpty(msg))
{
msg += ",";
}
if (tempProduct == null)
{
msg += "商品编码:" + Barcode + "出现异常-档案中无当前编码商品";
}
if (tempDealer.Count == 0)
{
msg += "商品编码:" + Barcode + "出现异常-无指定分销商存在";
}
if (string.IsNullOrEmpty(DsUserPrice))
{
msg += "商品编码:" + Barcode + "出现异常-分销商会员价格不能为空";
}
if (string.IsNullOrEmpty(ShopPrice))
{
msg += "商品编码:" + Barcode + "出现异常-分销商线下门店价格不能为空";
}
}
}
if (string.IsNullOrEmpty(msg))
{
result.Message = "操作成功";
}
else
{
result.Message = "操作成功-其中有部分商品有异常" + msg;
}
result.Status = true;
return(result);
}
/// <summary> /// 修改价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-06 周瑜 创建</remarks> public abstract int UpdatePrice(DsSpecialPrice model);
/// <summary> /// 修改特殊价格状态: 禁用/启用 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public abstract int UpdateStatus(DsSpecialPrice model);
/// <summary> /// 创建分销商产品特殊价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>系统编号</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public abstract int Create(DsSpecialPrice model);
