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