public ActionResult <string> Get(int id)
{
IocManager.Instance.Resolve <CookieHelper>().SaveCookie("cookieName", "123");
//IDataCommand command = IocManager.Instance.Resolve<IDataCommand>();
cmd.CreateCommand("GetAllChannelList");
var list = cmd.ExecuteEntityList <Channel>();
return("value");
}
public static List <ProductCategory> LoadTopCategories()
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadTopCategories");
//var cmd = new DataCommand("LoadTopCategories");
return(cmd.ExecuteEntityList <ProductCategory>());
}
/// <summary>
/// 分页查询Area
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public List <QR_Saler> GetSalerList()
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetSalerList");
//DataCommand cmd = new DataCommand("GetSalerList");
return(cmd.ExecuteEntityList <QR_Saler>());
}
/// <summary>
/// 预约商品列表
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static List <GetReservationProduct> GetReservationProduct(int customerSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetReservationProduct");
//DataCommand cmd = new DataCommand("GetReservationProduct");
cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo);
return(cmd.ExecuteEntityList <GetReservationProduct>());
}
public List <SOStatistics> GetSOStatistics(int customersysno)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetSOStatistics");
//DataCommand cmd = new DataCommand("GetSOStatistics");
cmd.SetParameter("@CustomerSysNo", DbType.Int32, customersysno);
return(cmd.ExecuteEntityList <SOStatistics>());
}
public List <SOItem> GetSOItemProducts(List <int> sosysnos)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetSOItemProducts");
//DataCommand cmd = new DataCommand("GetSOItemProducts");
cmd.QuerySetCondition("si.SOSysNo", ConditionOperation.In, DbType.Int32, sosysnos);
return(cmd.ExecuteEntityList <SOItem>("#DynamicParameters#"));
}
public static List <ProductCategory> LoadCategoriesByParentCategoryCode(string parentCategoryCode)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadCategoriesByParentCategoryCode");
//var cmd = new DataCommand("LoadCategoriesByParentCategoryCode");
cmd.SetParameter("@ParentCategoryCode", DbType.String, parentCategoryCode);
return(cmd.ExecuteEntityList <ProductCategory>());
}
/// <summary>
/// 根据MasterSysNo获取列表
/// </summary>
/// <param name="rmaMasterSysNo"></param>
/// <returns></returns>
public List <RMAItem> LoadRMAItems(int rmaMasterSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadRMAItems");
//DataCommand cmd = new DataCommand("LoadRMAItems");
cmd.SetParameter("@RMASysNo", DbType.Int32, rmaMasterSysNo);
return(cmd.ExecuteEntityList <RMAItem>());
}
public static List <CountdownInfo> GetAllCountDown(int CountdownStatus = 10)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("Seckill_GetAllCountDown");
//DataCommand dataCommand = new DataCommand("Seckill_GetAllCountDown");
cmd.SetParameter("@CountdownStatus", DbType.Int32, CountdownStatus);
return(cmd.ExecuteEntityList <CountdownInfo>());
}
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>();
}
public List <RecommendProductInfo> GetAllRecommendProductInfo(int CommonStatus = 1)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("Seckill_GetAllRecommendProductInfo");
//DataCommand dataCommand = new DataCommand("Seckill_GetAllRecommendProductInfo");
cmd.SetParameter("@CommonStatus", DbType.Int32, CommonStatus);
return(cmd.ExecuteEntityList <RecommendProductInfo>());
}
/// <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 List <SOItem> GetSOItemBySOSysNo(int sosysno)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetSOItemBySOSysNo");
//DataCommand cmd = new DataCommand("GetSOItemBySOSysNo");
cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno);
return(cmd.ExecuteEntityList <SOItem>());
}
/// <summary>
/// 加载自提收货地址
/// </summary>
/// <returns></returns>
public List <QR_ShippingAddress> QuerySelfPickupAddresses()
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QuerySelfPickupAddresses");
//DataCommand cmd = new DataCommand("QuerySelfPickupAddresses");
List <QR_ShippingAddress> result = cmd.ExecuteEntityList <QR_ShippingAddress>();
return(result);
}
/// <summary>
/// 获取单个PromotionProduct信息
/// </summary>
public static List <PromotionProduct> LoadPromotionProduct(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadPromotionProduct");
//DataCommand cmd = new DataCommand("LoadPromotionProduct");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
List <PromotionProduct> result = cmd.ExecuteEntityList <PromotionProduct>();
return(result);
}
public List <ProductImage> LoadProductImageByProductSysNo(int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadProductImageByProductSysNo");
//DataCommand cmd = new DataCommand("LoadProductImageByProductSysNo");
cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo);
var result = cmd.ExecuteEntityList <ProductImage>();
return(result);
}
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>());
}
/// <summary>
/// 获取广告信息
/// </summary>
/// <param name="pageID">页面ID</param>
/// <param name="pageType">页面类型</param>
/// <param name="positionID">广告位ID</param>
/// <returns>广告信息列表</returns>
public List <PageRecommendInfo> GetBannerInfoByPositionID(int?pageID, PageType pageType, BannerPosition?positionID)
{
IDataCommand dataCommand = IocManager.Instance.Resolve <IDataCommand>();
dataCommand.CreateCommand("Content_GetBannerInfoByPositionID");
///DataCommand dataCommand = new DataCommand("Content_GetBannerInfoByPositionID");
dataCommand.SetParameter("@PageID", DbType.AnsiStringFixedLength, pageID);
dataCommand.SetParameter("@PageType", DbType.Int32, pageType);
dataCommand.SetParameter("@PositionID", DbType.String, positionID);
List <PageRecommendInfo> entitys = dataCommand.ExecuteEntityList <PageRecommendInfo>();
return(entitys);
}
