/// <summary>
/// 加载最新公告节点
/// </summary>
/// <returns></returns>
public ActionResult Announcement([DataSourceRequest] DataSourceRequest request)
{
if (request.Page <= 0)
{
request.Page = 1;
}
if (request.PageSize == 0)
{
request.PageSize = 10;
}
try
{
var condition = "[Type]=2";
int pageCount;
int totalCount;
this.configPageService = new ConfigPageService();
var paging = new Paging("[Config_Page]", null, "ID", condition, request.Page, request.PageSize, "CreateTime", 1);
var list = this.configPageService.Paging(paging, out pageCount, out totalCount);
var data = new DataSource
{
Data = list,
Total = totalCount
};
return Json(data);
}
catch (Exception exception)
{
TextLogger.Instance.Log("查询出错", Category.Error, exception);
}
return this.Json(string.Empty, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 查询系统用户列表执行方法
/// </summary>
/// <param name="request">
/// 数据源请求信息对象
/// </param>
/// <returns>
/// 执行方法结果
/// </returns>
public ActionResult QueryLog([DataSourceRequest] DataSourceRequest request)
{
this.systemLogService = new SystemLogService();
int pageCount;
int totalCount;
if (request.Page <= 0)
{
request.Page = 1;
}
var paging = new Paging("[System_Log]", null, "ID", null, request.Page, request.PageSize);
var list = this.systemLogService.Query(paging, out pageCount, out totalCount);
if (list == null)
{
return this.View();
}
var modelList = new List<System_Log>();
foreach (var systemRole in list)
{
modelList.Add(DataTransfer.Transfer<System_Log>(systemRole, typeof(System_Log)));
}
var result = new DataSourceResult { Data = modelList, Total = totalCount };
return this.Json(result, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// The query product sold out.
/// </summary>
/// <param name="request">
/// The request.
/// </param>
/// <param name="productName">
/// The product name.
/// </param>
/// <param name="barcode">
/// The barcode.
/// </param>
/// <param name="parentCategoryID">
/// The parent category id.
/// </param>
/// <param name="productCategoryID">
/// The product category id.
/// </param>
/// <param name="parentBrandID">
/// The parent brand id.
/// </param>
/// <param name="productBrandID">
/// The product brand id.
/// </param>
/// <param name="minPrice">
/// The min price.
/// </param>
/// <param name="maxPrice">
/// The max price.
/// </param>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult QueryProductOnSale([DataSourceRequest] DataSourceRequest request, string productName, string barcode, string parentCategoryID, string productCategoryID, string parentBrandID, string productBrandID, string minPrice, string maxPrice)
{
int totalCount;
var stringBuilder = new StringBuilder();
stringBuilder.Append("[Status] = 2");
if (!string.IsNullOrEmpty(productName))
{
stringBuilder.Append(string.Format(" And [Name] like '%{0}%' ", productName));
}
if (!string.IsNullOrEmpty(barcode))
{
stringBuilder.Append(string.Format(" And [Barcode] like '%{0}%' ", barcode));
}
if (!string.IsNullOrEmpty(parentCategoryID) && parentCategoryID != "-1")
{
stringBuilder.Append(string.Format(" And [ParentCategoryID] = {0} ", parentCategoryID));
}
if (!string.IsNullOrEmpty(productCategoryID) && productCategoryID != "-1")
{
stringBuilder.Append(string.Format(" And [ProductCategoryID] = {0} ", productCategoryID));
}
if (!string.IsNullOrEmpty(parentBrandID) && parentBrandID != "-1")
{
stringBuilder.Append(string.Format(" And [ParentBrandID] = {0} ", parentBrandID));
}
if (!string.IsNullOrEmpty(productBrandID) && productBrandID != "-1")
{
stringBuilder.Append(string.Format(" And [ProductBrandID] = '{0}' ", productBrandID));
}
if (!string.IsNullOrEmpty(minPrice))
{
stringBuilder.Append(string.Format(" And [GoujiuPrice] >= '{0}' ", minPrice));
}
if (!string.IsNullOrEmpty(maxPrice))
{
stringBuilder.Append(string.Format(" And [GoujiuPrice] <= '{0}' ", maxPrice));
}
var condition = stringBuilder.ToString();
var paging = new Paging("view_Product_Paging", null, "ID", condition, request.Page, request.PageSize, "CreateTime", 1);
var productSearchResultModelList = new List<ProductSearchResultModel>();
try
{
int pageCount;
var searchResult = this.ProductService.Query(paging, out pageCount, out totalCount);
if (searchResult != null)
{
foreach (var productSearchResult in searchResult)
{
var item = DataTransfer.Transfer<ProductSearchResultModel>(
productSearchResult,
typeof(ProductSearchResult));
productSearchResultModelList.Add(item);
}
}
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
var result = new DataSourceResult { Data = productSearchResultModelList, Total = totalCount };
return this.Json(result);
}
/// <summary>
/// 查询会员促销列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 会员促销列表
/// </returns>
public List<Promote_Vip> Query(Paging paging, out int pageCount, out int totalCount)
{
return this.promoteVipDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// 限时抢购.
/// </summary>
/// <param name="request">
/// The request.
/// </param>
/// <param name="promoteName">
/// 限时抢购促销名称.
/// </param>
/// <param name="startStartTime">
/// 活动开始时间范围起始时间.
/// </param>
/// <param name="startEndTime">
/// 活动开始时间范围结束时间.
/// </param>
/// <param name="endStartTime">
/// 活动结束时间范围起始时间.
/// </param>
/// <param name="endEndTime">
/// 活动结束时间范围结束时间.
/// </param>
/// <param name="searchStatus">
/// The search Status.
/// </param>
/// <returns>
/// The <see cref="JsonResult"/>.
/// </returns>
public JsonResult QueryLimitedDiscount(
[DataSourceRequest] DataSourceRequest request,
string promoteName,
string productName,
string startStartTime,
string startEndTime,
string endStartTime,
string endEndTime,
string searchStatus)
{
this.promoteLimitedDiscountService = new PromoteLimitedDiscountService();
if (request.Page <= 0)
{
request.Page = 1;
}
if (request.PageSize == 0)
{
request.PageSize = 10;
}
int totalCount;
var stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(promoteName))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[Name] like '%" + promoteName + "%'");
}
if (!string.IsNullOrEmpty(productName))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[ProductName] like '%" + productName + "%'");
}
if (!string.IsNullOrEmpty(startStartTime))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[StartTime] >= '" + startStartTime + "'");
}
if (!string.IsNullOrEmpty(startEndTime))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[StartTime] <= '" + startEndTime + "'");
}
if (!string.IsNullOrEmpty(endStartTime))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[EndTime] >= '" + endStartTime + "'");
}
if (!string.IsNullOrEmpty(endEndTime))
{
CheckCondition(stringBuilder);
stringBuilder.Append("[EndTime] <= '" + endEndTime + "'");
}
switch (searchStatus)
{
case "1":
CheckCondition(stringBuilder);
stringBuilder.Append("[StartTime] > '" + DateTime.Now + "'");
break;
case "2":
CheckCondition(stringBuilder);
stringBuilder.Append("'" + DateTime.Now + "' Between [StartTime] And [EndTime]");
break;
case "3":
CheckCondition(stringBuilder);
stringBuilder.Append("([EndTime] < '" + DateTime.Now + "' or [Status] = 3)");
break;
}
var condition = stringBuilder.ToString();
List<Promote_Limited_Discount> list;
try
{
var paging = new Paging(
"[view_Promote_Limited_Discount]",
null,
"[ID]",
condition,
request.Page,
request.PageSize,
"[CreateTime]",
1);
int pageCount;
list = this.promoteLimitedDiscountService.Query(paging, out pageCount, out totalCount);
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
if (list != null)
{
var modelList = new List<PromoteLimitedDiscountModel>();
foreach (var limitedDiscount in list)
{
modelList.Add(
DataTransfer.Transfer<PromoteLimitedDiscountModel>(limitedDiscount, typeof(Promote_Limited_Discount)));
}
var data = new DataSource { Data = modelList, Total = totalCount };
return this.Json(data, JsonRequestBehavior.AllowGet);
}
return this.Json(string.Empty);
}
/// <summary>
/// 查询满减券绑定列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 满减券绑定列表
/// </returns>
public List<Coupon_Decrease_Binding> Paging(Paging paging, out int pageCount, out int totalCount)
{
return this.SqlServer.Paging<Coupon_Decrease_Binding>(paging, out pageCount, out totalCount, null);
}
/// <summary>
/// 查询多瓶装促销列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 多瓶装列表
/// </returns>
public List<Promote_MuchBottled> Paging(Paging paging, out int pageCount, out int totalCount)
{
return this.SqlServer.Paging<Promote_MuchBottled>(paging, out pageCount, out totalCount, null);
}
/// <summary>
/// 查询系统权限列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 系统权限列表
/// </returns>
public List<System_Permission> Query(Paging paging, out int pageCount, out int totalCount)
{
return this.systemPermissionDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// The query product attribute.
/// </summary>
/// <param name="categoryID">
/// The category ID.
/// </param>
/// <param name="request">
/// The request.
/// </param>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult QueryAttribute(string categoryID, [DataSourceRequest] DataSourceRequest request)
{
if (request.PageSize == 0)
{
request.PageSize = 10;
}
DataSourceResult result;
try
{
var condition = "1 = 1";
if (!string.IsNullOrEmpty(categoryID) && categoryID != "-1")
{
condition += string.Format(" and [ProductCategoryID] = {0} ", categoryID);
}
var paging = new Paging("[Product_Attribute]", null, "ID", condition, request.Page, request.PageSize);
int pageCount;
int totalCount;
var list = this.ProductAttributeService.Query(paging, out pageCount, out totalCount);
result = new DataSourceResult();
if (list != null)
{
var modelList = new List<ProductAttributeModel>();
foreach (var product in list)
{
modelList.Add(
DataTransfer.Transfer<ProductAttributeModel>(product, typeof(Product_Attribute)));
}
result.Data = modelList;
result.Total = totalCount;
return Json(result);
}
result.Data = null;
result.Total = 0;
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
return Json(result);
}
/// <summary>
/// 查询用户列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 用户列表
/// </returns>
public List<System_Log> Paging(Paging paging, out int pageCount, out int totalCount)
{
try
{
return this.SqlServer.Paging<System_Log>(paging, out pageCount, out totalCount, null);
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
}
public JsonResult ViewPaging([DataSourceRequest] DataSourceRequest request, string condition)
{
int totalCount;
List<View_GroupBuy_Product> list;
this.channelGroupBuyService = new ChannelGroupBuyService();
try
{
var paging = new Paging("view_GroupBuy_Product", null, "ProductId", condition, request.Page, request.PageSize);
int pageCount;
list = this.channelGroupBuyService.Query(paging, out pageCount, out totalCount);
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
var modelList = new List<ViewGroupBuyProductModel>();
if (list != null)
{
foreach (var viewGroupBuyProduct in list)
{
modelList.Add(DataTransfer.Transfer<ViewGroupBuyProductModel>(viewGroupBuyProduct, typeof(View_GroupBuy_Product)));
}
}
var data = new DataSource
{
Data = modelList,
Total = totalCount
};
return this.Json(data, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 根据ProductID查询商品的团购信息
/// </summary>
/// <param name="productId">ProductID</param>
/// <returns></returns>
public PartialViewResult QueryChannelGroupByProductId(string productId)
{
string condition = string.Empty;
if (!string.IsNullOrEmpty(productId))
{
condition = "ProductId=" + productId + string.Empty;
}
try
{
int totalCount = -1;
int totalPage = -1;
this.channelGroupBuyService = new ChannelGroupBuyService();
var paging = new Paging("view_GroupBuy_Product", null, "ProudtcId", condition, 1, 1);
var list = this.channelGroupBuyService.Query(paging, out totalCount, out totalPage);
var ModelList = new List<ViewGroupBuyProductModel>();
if (list != null && list.Any())
{
foreach (var viewGroupBuyProduct in list)
{
ModelList.Add(DataTransfer.Transfer<ViewGroupBuyProductModel>(viewGroupBuyProduct, typeof(View_GroupBuy_Product)));
}
}
ViewGroupBuyProductModel singleModel = ModelList.FirstOrDefault();
return this.PartialView("QueryChannelGroupByProductId", singleModel);
}
catch (Exception exception)
{
throw new ArgumentNullException(exception.Message, exception);
}
}
/// <summary>
/// 查询满就送促销列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 满就送列表
/// </returns>
public List<Promote_MeetMoney> Paging(Paging paging, out int pageCount, out int totalCount)
{
return this.SqlServer.Paging<Promote_MeetMoney>(paging, out pageCount, out totalCount, null);
}
/// <summary>
/// LP活动列表.
/// </summary>
/// <param name="request">
/// The request.
/// </param>
/// <param name="filterYear">
/// The filter Year.
/// </param>
/// <param name="filterMonth">
/// The filter Month.
/// </param>
/// <returns>
/// The <see cref="JsonResult"/>.
/// </returns>
public JsonResult QueryLandingPage(
[DataSourceRequest] DataSourceRequest request,
string filterYear,
string filterMonth)
{
this.promoteLandingPageService = new PromoteLandingPageService();
if (request.Page <= 0)
{
request.Page = 1;
}
var stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(filterYear))
{
CheckCondition(stringBuilder);
stringBuilder.Append("DATEDIFF(yyyy,CreateTime,'" + filterYear + "')=0");
}
if (!string.IsNullOrEmpty(filterMonth))
{
CheckCondition(stringBuilder);
stringBuilder.Append("DATEDIFF(mm,CreateTime,'" + filterMonth + "-1')=0"); // (-1补全日期)
}
CheckCondition(stringBuilder);
stringBuilder.Append("[IsDelete] = 0");
var condition = stringBuilder.ToString();
try
{
var paging = new Paging("[Promote_LandingPage]", null, "ID", condition, request.Page, request.PageSize, "CreateTime", 1);
int pageCount;
int totalCount;
var list = this.promoteLandingPageService.QueryList(paging, out pageCount, out totalCount);
if (list == null)
{
return this.Json(null);
}
var modelList = new List<PromoteLandingPageModel>();
foreach (var userLevelPrice in list)
{
var model = DataTransfer.Transfer<PromoteLandingPageModel>(
userLevelPrice,
typeof(Promote_LandingPage));
if (model.EndTime > DateTime.Now)
{
switch (model.Status)
{
case 1:
model.StatusName = "正常";
break;
case 2:
model.StatusName = "暂停";
break;
case 3:
model.StatusName = "停止";
break;
}
}
else
{
model.StatusName = "过期";
}
modelList.Add(model);
}
var result = new DataSourceResult { Data = modelList, Total = totalCount };
return this.Json(result, JsonRequestBehavior.AllowGet);
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
}
/// <summary>
/// 商品查询分页方法
/// </summary>
/// <param name="paging">
/// 分页对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 商品查询结果列表
/// </returns>
public List<int> QueryProductID(Paging paging, out int pageCount, out int totalCount)
{
return this.productDA.SelectProductID(paging, out pageCount, out totalCount);
}
public JsonResult GetProductSubCategory(string parentCategoryID)
{
int totalCount;
int pageCount;
var condition = string.Format("ParentID = {0} And layer = 2 ", parentCategoryID);
var paging = new Paging("[Product_Category]", null, "ID", condition, 1, 100);
var list = this.ProductCategoryService.Query(paging, out pageCount, out totalCount);
if (list == null || list.Count == 0) return null;
var query = from p in list
select new
{
id = p.ID,
name = p.CategoryName
};
return this.Json(query);
}
/// <summary>
/// 获取链接的值
/// </summary>
/// <param name="request"></param>
/// <param name="brandId"></param>
/// <returns></returns>
public ActionResult QueryBrandLinkSource([DataSourceRequest] DataSourceRequest request, int brandId)
{
try
{
string condidtion = "Type=4 And PID=" + brandId.ToString() + "";
var paging = new Paging("Config_Page", null, "ID", condidtion, request.Page, request.PageSize);
int pageCount;
int totalCount;
this.configPageService = new ConfigPageService();
var list = this.configPageService.Paging(paging, out pageCount, out totalCount);
var data = new DataSource
{
Data = list,
Total = totalCount,
TotalPages = pageCount
};
return Json(data, JsonRequestBehavior.AllowGet);
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
}
/// <summary>
/// The query product attribute value.
/// </summary>
/// <param name="productAttrID">
/// The product attr id.
/// </param>
/// <param name="request">
/// The request.
/// </param>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult QueryAttributeValue(string productAttrID, [DataSourceRequest] DataSourceRequest request)
{
DataSourceResult result;
try
{
int totalCount;
int pageCount;
if (request.PageSize == 0)
{
request.PageSize = 10;
}
string condition = string.Format("AttributeID = {0}", productAttrID);
var paging = new Paging("[Product_AttributeValue]", null, "ID", condition, request.Page,
request.PageSize);
var list = this.ProductAttributeValueService.Query(paging, out pageCount, out totalCount);
result = new DataSourceResult();
if (list != null)
{
var modelList = new List<ProductAttributeValueModel>();
foreach (var product in list)
{
modelList.Add(
DataTransfer.Transfer<ProductAttributeValueModel>(product, typeof(Product_AttributeValue)));
}
result.Data = modelList;
result.Total = totalCount;
return Json(result);
}
result.Data = null;
result.Total = 0;
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
return Json(result);
}
/// <summary>
/// 查询分页列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 查询结果
/// </returns>
public List<Order_Product> Paging(Paging paging, out int pageCount, out int totalCount)
{
paging.TableName = "view_Order_Products";
return this.SqlServer.Paging<Order_Product>(paging, out pageCount, out totalCount, null);
}
/// <summary>
/// 查询满就送促销列表
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// 满就送列表
/// </returns>
public List<Promote_MeetMoney> Query(Paging paging, out int pageCount, out int totalCount)
{
return this.promoteMeetMoneyDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// The query.
/// </summary>
/// <param name="paging">
/// The paging.
/// </param>
/// <param name="pageCount">
/// The page count.
/// </param>
/// <param name="totalCount">
/// The total count.
/// </param>
/// <returns>
/// The.
/// </returns>
public List<Product_AttributeValue> Query(Paging paging, out int pageCount, out int totalCount)
{
return this.productAttributeValueDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// 查询子权限列表
/// </summary>
/// <param name="request">
/// 数据源请求信息对象
/// </param>
/// <param name="permissionID">
/// 上级权限编号
/// </param>
/// <returns>
/// 执行方法结果
/// </returns>
public ActionResult QueryPermissionByID([DataSourceRequest] DataSourceRequest request, int permissionID)
{
this.systemPermissionService = new SystemPermissionService();
int pageCount;
int totalCount;
var paging = new Paging("[System_Permission]", null, "ID", string.Format("ParentID = {0}", permissionID), request.Page, request.PageSize);
var list = this.systemPermissionService.Query(paging, out pageCount, out totalCount);
if (request.Page <= 0)
{
request.Page = 1;
}
if (list == null)
{
return this.View();
}
var permissionModels = new List<PermissionModel>();
foreach (var systemPermission in list)
{
permissionModels.Add(DataTransfer.Transfer<PermissionModel>(systemPermission, typeof(System_Permission)));
}
var result = new DataSourceResult { Data = permissionModels, Total = totalCount };
return this.Json(result, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="paging"></param>
/// <param name="pageCount"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Advertise_Config> Paging(Paging paging, out int pageCount, out int totalCount)
{
return this.advertiseConfigDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// The query select list.
/// </summary>
/// <param name="id">
/// The id.
/// </param>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult QueryPermissionTreeViewItems(int? id)
{
if (id == null)
{
id = 0;
}
this.systemPermissionService = new SystemPermissionService();
int pageCount;
int totalCount;
var paging = new Paging("[System_Permission]", null, "ID", string.Format("ParentID = {0}", id), 1, 1000);
var list = this.systemPermissionService.Query(paging, out pageCount, out totalCount);
if (list == null)
{
return this.Json(null);
}
var modelList = new List<dynamic>();
foreach (var systemPermission in list)
{
modelList.Add(new { id = systemPermission.ID, Name = systemPermission.Name, hasChildren = this.systemPermissionService.HasChildren(systemPermission.ID) });
}
return this.Json(modelList, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 查询LP列表（编码、父级编码、名称、制作人）.
/// </summary>
/// <param name="paging">
/// 分页数据对象
/// </param>
/// <param name="pageCount">
/// 总页数
/// </param>
/// <param name="totalCount">
/// 总记录数
/// </param>
/// <returns>
/// LP列表
/// </returns>
public List<Promote_LandingPage> QueryList(Paging paging, out int pageCount, out int totalCount)
{
return this.landingPageDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// 查询子权限选择项列表
/// </summary>
/// <param name="permissionID">
/// The permission ID.
/// </param>
/// <returns>
/// 子权限选择项列表
/// </returns>
public ActionResult QuerySubPermissionSelectListItems(int permissionID)
{
this.systemPermissionService = new SystemPermissionService();
int pageCount;
int totalCount;
var paging = new Paging("[System_Permission]", null, "ID", string.Format("ParentID = {0}", permissionID), 1, 1000);
var list = this.systemPermissionService.Query(paging, out pageCount, out totalCount);
return list != null ? this.Json(list, JsonRequestBehavior.AllowGet) : this.Json(null);
}
/// <summary>
/// 分页查询运费信息
/// </summary>
/// <param name="paging">
/// 分页对象
/// </param>
/// <param name="pageCount">
/// 页数
/// </param>
/// <param name="totalCount">
/// 行数
/// </param>
/// <returns>
/// 查询结果
/// </returns>
public List<Config_Delivery_Cost> Query(Paging paging, out int pageCount, out int totalCount)
{
return this.configDeliveryCostDA.Paging(paging, out pageCount, out totalCount);
}
/// <summary>
/// 获取商品属性列表
/// </summary>
/// <param name="categoryID">
/// 商品类别编号
/// </param>
/// <returns>
/// 商品属性列表
/// </returns>
private IEnumerable<Product_Attribute> GetAttributes(string categoryID)
{
var condition = "1 = 1";
if (!string.IsNullOrEmpty(categoryID))
{
condition += " and [ProductCategoryID] = '" + categoryID + "' ";
}
int totalCount;
int pageCount;
var paging = new Paging("[Product_Attribute]", null, "ID", condition, 1, 1000);
var productAttributes = this.ProductAttributeService.Query(paging, out pageCount, out totalCount);
if (productAttributes != null)
{
foreach (var productAttribute in productAttributes)
{
if (productAttribute == null)
{
continue;
}
paging = new Paging("[Product_AttributeValue]", null, "[ID]", string.Format("AttributeID = {0}", productAttribute.ID), 1, 1000);
productAttribute.ProductAttributeValues = this.ProductAttributeValueService.Query(paging, out pageCount, out totalCount);
}
}
return productAttributes;
}
public ActionResult QueryProductOnSaleSimple(int pageIndex, int pageSize, string sortField, string sortOrder, string Name, string condition = "")
{
int totalCount, pageCount;
var stringBuilder = new StringBuilder();
stringBuilder.Append("[Status] = 2");
if (!string.IsNullOrEmpty(Name))
{
stringBuilder.Append(string.Format(" And [Name] like '%{0}%' ", Name));
}
if (string.IsNullOrEmpty(sortField))
{
sortField = "CreateTime";
}
if (string.IsNullOrEmpty(sortOrder))
{
sortOrder = "1";
}
if (string.IsNullOrEmpty(condition))
{
condition = stringBuilder.ToString();
}
else
{
condition += " And " + stringBuilder.ToString();
}
var paging = new Paging("view_Product_Paging", null, "ID", condition, pageIndex, pageSize, sortField, int.Parse(sortOrder));
var searchResult = this.ProductService.Query(paging, out pageCount, out totalCount);
foreach (var result in searchResult)
{
result.Path = Utils.GetProductImage(result.Path, "0");
}
return this.Json(new { data = searchResult, total = totalCount });
}
public JsonResult GetProductParentCategory()
{
int totalCount;
int pageCount;
var paging = new Paging("[Product_Category]", null, "ID", "ParentID = 0 and layer = 1 ", 1, 10);
var list = this.ProductCategoryService.Query(paging, out pageCount, out totalCount);
if (list == null || list.Count == 0) return null;
var query = from p in list
select new
{
id = p.ID,
name = p.CategoryName
};
return this.Json(query);
}
