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>()); }