public List<ProductPrice> LoadProductPrice(IEnumerable<int> productSysNoList)
{
IDataCommand cmd = IocManager.Instance.Resolve<IDataCommand>();
cmd.CreateCommand("ProductPrice_GetByProdcutSysNos");
if (productSysNoList == null || productSysNoList.Count() == 0) return null;
//DataCommand cmd = new DataCommand("ProductPrice_GetByProdcutSysNos");
cmd.CommandText = cmd.CommandText.Replace("#ProductSysNos#", cmd.SetSafeParameter(string.Join(",", productSysNoList)));
return cmd.ExecuteEntityList<ProductPrice>();
}
/// <summary>
/// 获取商品所有属性值信息
/// </summary>
public List <ProductProperty> LoadProductProperty(int ProductCommonSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadProductProperty");
//DataCommand cmd = new DataCommand("LoadProductProperty");
cmd.CommandText = cmd.CommandText.Replace("#ProductCommonSysNo#", cmd.SetSafeParameter(ProductCommonSysNo.ToString()));
return(cmd.ExecuteEntityList <ProductProperty>());
}
public void WriteLog(OperationLog log)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("ControlPanel_InsertOperationLog");
// DataCommand cmd = new DataCommand("ControlPanel_InsertOperationLog");
cmd.CommandText = cmd.CommandText.Replace("#BizObjectName#", cmd.SetSafeParameter(log.BizObjectType));
cmd.SetParameter <OperationLog>(log);
cmd.ExecuteNonQuery();
}
public List <CountdownInfo> LoadCountdown(IEnumerable <int> productSysNoList)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("Countdown_GetByProductSysNos");
if (productSysNoList == null || productSysNoList.Count() == 0)
{
return(null);
}
//DataCommand cmd = new DataCommand("Countdown_GetByProductSysNos");
cmd.CommandText = cmd.CommandText.Replace("#ProductSysNos#", cmd.SetSafeParameter(string.Join(",", productSysNoList)));
return(cmd.ExecuteEntityList <CountdownInfo>());
}