private static GridColumnModelList<GeneralProgram> CreatProColumns()
{
GridColumnModelList<GeneralProgram> cn = new GridColumnModelList<GeneralProgram>();
cn.Add(p => p.Gid).SetAsPrimaryKey().SetEditable(false);
cn.Add(p => p.Name.Matter).AddEvent("change", "doCascade").SetCaption("中文名");
cn.Add(p => p.ProgUrl).AddEvent("change", "doCascade");
return cn;
}
private static GridColumnModelList<Person> CreatePersonColumns()
{
GridColumnModelList<Person> cn = new GridColumnModelList<Person>();
cn.Add(p => p.PersonId).SetAsPrimaryKey();
cn.Add(p => p.FirstName).AddEvent("change", "doCascade");
cn.Add(p => p.LastName).AddEvent("change", "doCascade");
cn.Add(p => p.City != null ? p.City.Id : Guid.Empty).SetName("City.Id").SetCaption("CityId").SetColumnRenderer(new ComboColumnRenderer("/Renderers/GetCities"));
cn.Add(p => p.FirstName + "_computed_" + p.LastName).SetName("Computed").SetCaption("Computed example").SetEditable(false);
return cn;
}
public ActionResult ListProgs(SearchModel searchModel)
{
IQueryable<GeneralProgNode> oPrograms = dbEntity.GeneralProgNodes.Include("Name").Where(p => p.Deleted == false).AsQueryable();
int i = 2052;
GridColumnModelList<GeneralProgNode> columns = new GridColumnModelList<GeneralProgNode>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Name.GetResource(i)).SetName("Name.Matter");
columns.Add(p => p.Code);
GridData gridData = oPrograms.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// ActionList函数
/// </summary>
/// <param name="seachModel">searchModel</param>
/// <returns>返回Json数据</returns>
public ActionResult ActionList(SearchModel seachModel)
{
try
{
IQueryable<GeneralAction> actions = dbEntity.GeneralActions.AsQueryable();
GridColumnModelList<GeneralAction> columns = new GridColumnModelList<GeneralAction>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.ActID);
columns.Add(p => p.ActionSourceName);
columns.Add(p => p.ClassName);
columns.Add(p => p.RefTypeName);
columns.Add(p => p.RefID);
columns.Add(p => p.ActionLevelName);
columns.Add(p => p.Matter);
columns.Add(p => p.Keyword);
GridData gridData = actions.ToGridData(seachModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
catch
{
return RedirectToAction("Error");
}
}
public ActionResult ArticlePublishList(SearchModel searchModel)
{
IQueryable<MallArtPublish> oMallArticles = (from o in dbEntity.MallArtPublishes where (o.Deleted == false) select o).AsQueryable();
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
GridColumnModelList<MallArtPublish> ArtPublishColumns = new GridColumnModelList<MallArtPublish>();
ArtPublishColumns.Add(cs => cs.Gid).SetAsPrimaryKey();
ArtPublishColumns.Add(cs => cs.Article.Code).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.ArtID);
ArtPublishColumns.Add(cs => cs.Channel.Code).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.ChlID);
ArtPublishColumns.Add(cs => cs.Position.Code).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.PosID);
ArtPublishColumns.Add(cs => cs.Sorting).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.Sorting);
ArtPublishColumns.Add(cs => cs.Show).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.Show);
ArtPublishColumns.Add(cs => cs.TotalRank).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.TotalRank);
ArtPublishColumns.Add(cs => cs.MatterRank).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.MatterRank);
ArtPublishColumns.Add(cs => cs.LayoutRank).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.LayoutRank);
ArtPublishColumns.Add(cs => cs.ComfortRank).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.ComfortRank);
ArtPublishColumns.Add(cs => cs.StartTime == null ? "" : cs.StartTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.StartTime).SetName("StartTime");
ArtPublishColumns.Add(cs => cs.EndTime == null ? "" : cs.EndTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPublish.EndTime).SetName("EndTime");
GridData gridData = oMallArticles.ToGridData(searchModel, ArtPublishColumns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
public ActionResult SensitiveWordList(SearchModel searchModel)
{
IQueryable<MallSensitiveWord> oMallSensitiveWord = (from o in dbEntity.MallSensitiveWords where (o.Deleted == false && o.OrgID == gOrgId && o.ChlID == gChlId) select o).AsQueryable();
GridColumnModelList<MallSensitiveWord> columns = new GridColumnModelList<MallSensitiveWord>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Keyword).SetCaption(@LiveAzure.Resource.Model.Mall.MallSensitiveWord.Keyword);
columns.Add(p => p.Channel.FullName.GetResource(CurrentSession.Culture)).SetName("Channel").SetCaption(@LiveAzure.Resource.Model.Mall.MallSensitiveWord.ChlID);
columns.Add(p => p.Organization.FullName.GetResource(CurrentSession.Culture)).SetName("Organization").SetCaption(@LiveAzure.Resource.Model.Mall.MallSensitiveWord.OrgID);
GridData gridData = oMallSensitiveWord.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
private static GridColumnModelList<GeneralResItem> GetCashColumns()
{
GridColumnModelList<GeneralResItem> columns = new GridColumnModelList<GeneralResItem>();
columns.Add(i => i.Gid)
.SetAsPrimaryKey()
.SetHidden(true);
columns.Add(i => i.Culture)
.SetHidden(true);
columns.Add(i => i.Currency)
.SetWidth("300")
//.SetColumnRenderer(new ComboColumnRenderer("/Resource/GetCurrencyUnits"))
.SetEditable(false)
.SetCaption("货币");
columns.Add(i => i.Cash)
.SetWidth("300")
.SetCaption("值");
return columns;
}
/// <summary>
/// GeneralOptionalItems Grid列表
/// </summary>
/// <param name="optionalSearchModel"></param>
/// <returns></returns>
public ActionResult OptionalItemList(SearchModel optionalSearchModel)
{
IQueryable<GeneralOptItem> oGeneralOptionalItem = dbEntity.GeneralOptItems.Include("Name").Where(g=>g.OptID==optid && g.Deleted == false).AsQueryable();
GridColumnModelList<GeneralOptItem> columns = new GridColumnModelList<GeneralOptItem>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Optional.Name.GetResource(CurrentSession.Culture)).SetName("Optional");
columns.Add(p => p.Name.GetResource(CurrentSession.Culture)).SetName("Name");
columns.Add(p => p.Code);
columns.Add(p => p.Sorting);
GridData optionalGridData = oGeneralOptionalItem.ToGridData(optionalSearchModel, columns);
return Json(optionalGridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 列出对应的促销方案的商品信息
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPromotionProductInfomation(SearchModel searchModel)
{
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
IQueryable<PromotionProduct> oPromotionProductInfo = dbEntity.PromotionProducts.Include("Promotion").Include("OnSkuItem").Include("Price").Where(p => p.Deleted == false).AsQueryable();
GridColumnModelList<PromotionProduct> columns = new GridColumnModelList<PromotionProduct>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Promotion.Name.GetResource(CurrentSession.Culture)).SetName("PromotionName");
columns.Add(p => p.OnSkuItem.SkuItem.Code + "(" + p.OnSkuItem.OnSale.Code + ")").SetName("PromotionProductCode");
columns.Add(p => p.OnSkuItem.FullName.GetResource(CurrentSession.Culture)).SetName("PromotionProductName");
columns.Add(p => p.Quantity);
columns.Add(p => p.Price.Cash).SetName("ProductPrice");
columns.Add(p => p.Remark);
GridData gridData = oPromotionProductInfo.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 订单编辑页面的产品列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult OrderItemEditList(SearchModel searchModel)
{
if (isBackList == true)
{//如果是还原状态 则全局变量重新加载次
isBackList = false;
OrderInformation oOldOrder = dbEntity.OrderInformations.Include("OrderItems").Where(o => o.Gid == oNewOrder.Gid).FirstOrDefault();
foreach (var item in oOldOrder.OrderItems)
{
listNewOrderItem.Add(item);
}
}
IQueryable<OrderItem> listOrderItem = listNewOrderItem.AsQueryable();
GridColumnModelList<OrderItem> columns = new GridColumnModelList<OrderItem>();
columns.Add(p => p.OnSkuID).SetAsPrimaryKey().SetHidden(true);
columns.Add(p => p.Name).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.Name);
columns.Add(p => p.SkuItem.Code).SetCaption(@LiveAzure.Resource.Model.Product.ProductOnItem.SkuItem);
columns.Add(p => p.SkuItem.Barcode).SetCaption(@LiveAzure.Resource.Model.Product.ProductInfoItem.Barcode);
columns.Add(p => p.ExecutePrice).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.ExecutePrice);
columns.Add(p => p.SalePrice).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.SalePrice);
columns.Add(p => p.Quantity).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.Quantity);
columns.Add(p => getStdUnit(p.SkuItem.StdUnit)).SetName("StdUnit");
columns.Add(p => Math.Round(p.Shipped,p.SkuItem.Percision) + "(" + Math.Round(p.TobeShip,p.SkuItem.Percision) + ")").SetName("ShipMessage");
columns.Add(p => Math.Round(p.Returned,p.SkuItem.Percision) + "(" + Math.Round(p.BeReturn,p.SkuItem.Percision) + ")").SetName("ReturnMessage");
columns.Add(p => p.ExecutePrice * p.Quantity).SetName("Amount").SetCaption("小计");
GridData gridData = listOrderItem.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
public ActionResult ListAttribute(SearchModel searchModel)
{
//Guid id = new Guid();
//MemberOrgAttribute attributes;
//if (Session["sessionId"] != null)
//{
// string sid = Session["sessionId"].ToString();
// id = new Guid(sid);
// attributes = dbEntity.MemberOrgAttributes.Where(o => o.OrgID == id && o.Deleted == false);
//}
//else
//{
// attributes = dbEntity.MemberOrgAttributes.Where(o => o.Deleted == false);
//}
//List<MemberOrgAttribute> attributeList = new List<MemberOrgAttribute>();
//attributeList.AddRange(attributes);
//return Json(attributeList.AsQueryable().ToGridData(searchModel, new[] { "Gid", "OptID", "OptResult", "Matter" }), JsonRequestBehavior.AllowGet);
Guid id = new Guid();
IQueryable<MemberOrgAttribute> memorgattr;
if (Session["sessionId"] != null)
{
string sid = Session["sessionId"].ToString();
id = new Guid(sid);
memorgattr = dbEntity.MemberOrgAttributes.Where(p => p.OrgID == id && p.Deleted == false).AsQueryable();
}
else
{
memorgattr = dbEntity.MemberOrgAttributes.Where(p => p.Deleted == false).AsQueryable();
}
GridColumnModelList<MemberOrgAttribute> columns = new GridColumnModelList<MemberOrgAttribute>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Optional.Name.Matter);
columns.Add(p => p.OptionalResult.Name.Matter);
columns.Add(p => p.Matter);
GridData gridData = memorgattr.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
public ActionResult ListOrderUser(SearchModel searchModel)
{
Guid userOrgId = OrganizationGuidGeneralOrder;
Guid userGid = oNewOrder.UserID;
if (userGid.Equals(null) || userGid.Equals(Guid.Empty))
{
return null;
}
IQueryable<MemberAddress> oMemberAddress = dbEntity.MemberAddresses.Include("User").Where(p => p.Deleted == false && p.UserID == userGid).AsQueryable();
GridColumnModelList<MemberAddress> columns = new GridColumnModelList<MemberAddress>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.User.LoginName);
columns.Add(p => p.User.LastName);
columns.Add(p => p.User.FirstName);
columns.Add(p => p.Code);
columns.Add(p => p.FullAddress);
GridData gridData = oMemberAddress.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
public ActionResult ListOrderProcess(SearchModel searchModel)
{
//需要换成全局的订单
Guid orderGid = Guid.Parse("e1c5e9ad-73de-e011-bcc4-4437e63336bd");
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
IQueryable<OrderProcess> oOrderProcess = dbEntity.OrderProcesses.Include("Order").Where(p => p.Deleted == false && p.OrderID == orderGid).AsQueryable();
GridColumnModelList<OrderProcess> columns = new GridColumnModelList<OrderProcess>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.Order.Code);
columns.Add(p => p.Matter);
columns.Add(p => p.LastModifiedBy == null ? "" : dbEntity.MemberUsers.Find(p.LastModifiedBy).LoginName).SetName("Modifier");
columns.Add(p => p.LastModifyTime == null ? "" : p.LastModifyTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("ModifyTime");
columns.Add(p => p.Remark);
GridData gridData = oOrderProcess.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 订单列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListOrderInformation(SearchModel searchModel)
{
IQueryable<OrderInformation> oOrderInfomation = null;
/*判断是否进行了搜索*/
if (searchKey != "")
{
oOrderInfomation = dbEntity.OrderInformations.Include("Organization").Include("Channel").Include("User").Include("OrderItems").Where(p => p.Deleted == false && p.OrgID == OrganizationGuidGeneralOrder && p.ChlID == ChannelGuidGeneralOrder && p.WhID == WarehouseGuidSelected).AsQueryable();
switch (searchType)
{
case "OrderCode":
oOrderInfomation = oOrderInfomation.Where(p => p.Code.Contains(searchKey));
break;
case "Nick":
oOrderInfomation = oOrderInfomation.Where(p => p.User.NickName.Contains(searchKey));
break;
case "SKUCode":
{
List<Guid> gidList = dbEntity.ProductInfoItems.Where(p => p.Deleted == false && p.Code.Contains(searchKey)).Select(p => p.Gid).ToList();
oOrderInfomation = (from oi in dbEntity.OrderInformations.AsEnumerable()
join oii in dbEntity.OrderItems.AsEnumerable() on oi.Gid equals oii.OrderID
join pii in dbEntity.ProductInfoItems.AsEnumerable() on oii.SkuID equals pii.Gid
where pii.Code.Contains(searchKey) && pii.OrgID == OrganizationGuidGeneralOrder && oi.OrgID == OrganizationGuidGeneralOrder
select oi).AsQueryable();
}
break;
case "Tel":
oOrderInfomation = oOrderInfomation.Where(p => p.Telephone.Contains(searchKey) || p.Mobile.Contains(searchKey));
break;
default:
RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no error" });
break;
}
}
else
{
oOrderInfomation = dbEntity.OrderInformations.Include("Organization").Include("Channel").Include("User").Where(p => p.Deleted == false && p.OrgID == OrganizationGuidGeneralOrder && p.ChlID == ChannelGuidGeneralOrder && p.WhID == WarehouseGuidSelected).AsQueryable();
}
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
GridColumnModelList<OrderInformation> columns = new GridColumnModelList<OrderInformation>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(x => x.Code);
//columns.Add(x => x.Organization.FullName.Matter).SetName("Organization");
//columns.Add(x => x.Channel.FullName.Matter).SetName("Channel");
columns.Add(x => x.User.DisplayName);
columns.Add(x => x.Consignee);
columns.Add(x => x.CreateTime == null ? "" : x.CreateTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("CreateTime");
columns.Add(x => x.ExecuteAmount);
columns.Add(x => x.SaleAmount);
columns.Add(x => x.Pieces).SetName("Pieces");
columns.Add(x => x.TotalPaid);
columns.Add(x => x.OrderAmount);
columns.Add(x => x.PostComment);
columns.Add(x => x.LockStatusName);
columns.Add(x => x.OrderStatusName);
columns.Add(x => x.PayStatusName);
columns.Add(x => x.HangStatusName);
GridData gridData = oOrderInfomation.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 日志列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListGeneralAction(SearchModel searchModel)
{
searchModel.SortOrder = "desc";
IQueryable<GeneralAction> oAction = dbEntity.GeneralActions.Include("User").Where(p => p.RefID == oNewOrder.Gid).AsQueryable().OrderByDescending(p=>p.LastModifyTime);
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
GridColumnModelList<GeneralAction> columns = new GridColumnModelList<GeneralAction>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.UserID==Guid.Empty ? "" : p.User.LoginName).SetName("Name");
columns.Add(p => p.LastModifyTime.Value.ToString(culture.DateTimeFormat.FullDateTimePattern)).SetName("Time");
columns.Add(p => p.Matter);
GridData gridData = oAction.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 搜索产品
/// </summary>
/// <param name="searchModel"></param>
/// <param name="orderSearchMode">搜索的条件</param>
/// <param name="orderSearchValue">搜索的值</param>
/// <param name="orderSearchProperty">搜索的字段</param>
/// <param name="orderSearchRelationship">多条件时的关系</param>
/// <returns></returns>
public ActionResult OrderItemSearchList(SearchModel searchModel, string orderSearchMode, string orderSearchValue, string orderSearchProperty, string orderSearchRelationship)
{
if (orderSearchMode == null)
{ return null; }
Guid organizationId = oNewOrder.OrgID;
Guid channleId = oNewOrder.ChlID;
string[] OrderSearchMode = orderSearchMode.Split('|');
string[] OrderSearchValue = orderSearchValue.Split('|');
string[] OrderSearchProperty = orderSearchProperty.Split('|');
string[] OrderSearchRelationship = orderSearchRelationship.Split('|');
List<ProductOnItem> listSearchSku_0 = new List<ProductOnItem>();
List<ProductOnItem> listSearchSku_1 = new List<ProductOnItem>();
List<ProductOnItem> listSearchSku_2 = new List<ProductOnItem>();
List<ProductOnItem> result_1 = new List<ProductOnItem>();
List<ProductOnItem> result_2 = new List<ProductOnItem>();
ArrayList listSearchSku = new ArrayList{listSearchSku_0,listSearchSku_1,listSearchSku_2};
//先列出该组织，该渠道下的 商品
List<ProductOnItem> list = dbEntity.ProductOnItems.Where(p => p.SkuItem.OrgID == organizationId && p.OnSale.ChlID == channleId && p.Deleted == false).ToList();
// string sSqlLine = @"SELECT * FROM ProductOnItem poi
// JOIN ProductItem pi ON pi.Gid = poi.SkuID
// JOIN viewResourceMatter rm ON poi.FullName = rm.Gid
// WHERE rm.Matter LIKE '%'
//
// ";
// List<ProductOnItem> list2 = dbEntity.Database.SqlQuery<ProductOnItem>(sSqlLine);
for (var i = 0; i <= 2; i++)
{
if (i > 0)
{
if (OrderSearchRelationship[i-1] == "undefined") continue;
}
switch (OrderSearchProperty[i])
{
case "Code":
if (OrderSearchMode[i] == "0") listSearchSku[i] = (from p in list
where p.SkuItem.Code.StartsWith(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
if (OrderSearchMode[i] == "1") listSearchSku[i] = (from p in list
where p.SkuItem.Code.Contains(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
if (OrderSearchMode[i] == "2") listSearchSku[i] = (from p in list
where p.SkuItem.Code.EndsWith(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
break;
case "FullName":
if (OrderSearchMode[i] == "0") listSearchSku[i] = (from p in list
where p.FullName.GetResource(CurrentSession.Culture).StartsWith(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
if (OrderSearchMode[i] == "1") listSearchSku[i] = (from p in list
where p.FullName.GetResource(CurrentSession.Culture).Contains(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
if (OrderSearchMode[i] == "2") listSearchSku[i] = (from p in list
where p.FullName.GetResource(CurrentSession.Culture).EndsWith(OrderSearchValue[i])
//&& p.SkuItem.OrgID == organizationId
//&& p.OnSale.ChlID == channleId
//&& p.Deleted == false
select p).ToList();
break;
}
}
listSearchSku_0 = (List<ProductOnItem>)listSearchSku[0];
listSearchSku_1 = (List<ProductOnItem>)listSearchSku[1];
listSearchSku_2 = (List<ProductOnItem>)listSearchSku[2];
if (OrderSearchRelationship[0] != "undefined")
{
if (OrderSearchRelationship[0] == "AND")// 取交集
{
foreach (var item in listSearchSku_0)
{
if (listSearchSku_1.Contains(item))
result_1.Add(item);
}
}
else//取并集
{
result_1 = listSearchSku_0;
foreach (var item in listSearchSku_1)
{
if (!listSearchSku_0.Contains(item))
result_1.Add(item);
}
}
}
else
{
result_1 = listSearchSku_0;
}
if (OrderSearchRelationship[1] != "undefined")
{
if (OrderSearchRelationship[1] == "AND")
{
foreach (var item in result_1)
{
if (listSearchSku_2.Contains(item))
result_2.Add(item);
}
}
else
{
result_2 = result_1;
foreach (var item in listSearchSku_2)
{
if (!result_1.Contains(item))
result_2.Add(item);
}
}
}
else
{
result_2 = result_1;
}
IQueryable<ProductOnItem> Result = result_2.AsQueryable();
GridColumnModelList<ProductOnItem> columns = new GridColumnModelList<ProductOnItem>();
columns.Add(p => p.Gid).SetAsPrimaryKey().SetHidden(true);
columns.Add(p => p.FullName.GetResource(CurrentSession.Culture)).SetName("FullName.Matter");
columns.Add(p => p.SkuItem.Code);
GridData gridData = Result.ToGridData(searchModel, columns);
return Json(gridData,JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 订单添加的商品列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult OrderItemList(SearchModel searchModel)
{
IQueryable<OrderItem> listOrderItem = listNewOrderItem.AsQueryable();
GridColumnModelList<OrderItem> columns = new GridColumnModelList<OrderItem>();
columns.Add(p => p.OnSkuID).SetAsPrimaryKey().SetHidden(true);
columns.Add(p => p.Name).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.Name);
columns.Add(p => p.SkuItem.Code).SetCaption(@LiveAzure.Resource.Model.Product.ProductOnItem.SkuItem);
columns.Add(p => p.SkuItem.Barcode).SetCaption(@LiveAzure.Resource.Model.Product.ProductInfoItem.Barcode);
columns.Add(p => p.ExecutePrice).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.ExecutePrice);
columns.Add(p => p.SalePrice).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.SalePrice);
columns.Add(p => p.Quantity).SetCaption(@LiveAzure.Resource.Model.Order.OrderItem.Quantity);
columns.Add(p => getStdUnit(p.SkuItem.StdUnit)).SetName("StdUnit");
columns.Add(p => p.ExecutePrice * p.Quantity).SetName("Amount").SetCaption("小计");
GridData gridData = listOrderItem.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 所选择组织下的所有广告位列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ArtPositionList(SearchModel searchModel)
{
IQueryable<MallArtPosition> oMallArtPosition = (from o in dbEntity.MallArtPositions where (o.Deleted == false && o.OrgID == gOrgId) select o).AsQueryable();
GridColumnModelList<MallArtPosition> columns = new GridColumnModelList<MallArtPosition>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p=>p.Code).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPosition.Code);
columns.Add(p=>p.Name.Matter).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPosition.Name);
columns.Add(p=>p.Width).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPosition.Width);
columns.Add(p => p.Height).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPosition.Height);
columns.Add(p => p.Matter).SetCaption(@LiveAzure.Resource.Model.Mall.MallArtPosition.Matter);
GridData gridData = oMallArtPosition.ToGridData(searchModel,columns);
return Json(gridData,JsonRequestBehavior.AllowGet);
}
/// <summary>
/// Index页面中Grid
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult List(SearchModel searchModel)
{
//var organs = from o in dbEntity.MemberOrganizations.Include("FullName").Include("ShortName")
// where o.Deleted == false
// select o;
//List<MemberOrganization> model = new List<MemberOrganization>();
//model.AddRange(organs);
//return Json(model.AsQueryable().ToGridData(searchModel,
// new[] { "Gid", "Code", "FullName", "ShortName", "Ostatus","Otype" }),
// JsonRequestBehavior.AllowGet);
int oType = 1; //oType为上一页面传入值，这里默认为0.
IQueryable<MemberOrganization> organs = dbEntity.MemberOrganizations.Include("FullName").Include("ShortName").Where(p => p.Deleted == false&&p.Otype==oType).AsQueryable();
//int i = 2052;
GridColumnModelList<MemberOrganization> columns = new GridColumnModelList<MemberOrganization>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.FullName.Matter);
columns.Add(p => p.ShortName.Matter);
columns.Add(p => p.Ostatus);
columns.Add(p => p.Sorting);
GridData gridData = organs.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 促销列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPromotionInfomation(SearchModel searchModel)
{
//获取当前用户的语言
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
IQueryable<PromotionInformation> oPromotionInfo = dbEntity.PromotionInformations.Include("Name").Where(p => p.Deleted == false && p.OrgID == promotionOrgGid && p.ChlID == promotionChlGid).AsQueryable();
GridColumnModelList<PromotionInformation> columns = new GridColumnModelList<PromotionInformation>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.Name == null ? "" : p.Name.GetResource(CurrentSession.Culture)).SetName("PromotionName");
columns.Add(p => p.Matter);
columns.Add(p => p.Pstatus);
columns.Add(p => p.IssueType);
columns.Add(p => p.IssueStart == null ? "" : p.IssueStart.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("IssueStart");
columns.Add(p => p.IssueEnd == null ? "" : p.IssueEnd.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("IssueEnd");
columns.Add(p => p.StartTime == null ? "" : p.StartTime.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("StartName");
columns.Add(p => p.EndTime == null ? "" : p.EndTime.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("EndTime");
columns.Add(p => p.EffectDays);
GridData gridData = oPromotionInfo.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 促销券的信息列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPromotionCouponInfomation(SearchModel searchModel)
{
CultureInfo culture = new CultureInfo(CurrentSession.Culture);
IQueryable<PromotionCoupon> oPromotionCoupon = dbEntity.PromotionCoupons.Include("Promotion").Include("Currency").Where(p => p.PromID == globlePromotionGid && p.Deleted == false).AsQueryable();
GridColumnModelList<PromotionCoupon> columns = new GridColumnModelList<PromotionCoupon>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Promotion.Name.GetResource(CurrentSession.Culture)).SetName("PromotionName");
columns.Add(p => p.Code);
columns.Add(p => p.Passcode);
columns.Add(p => p.CouponStatusName).SetName("Cstatus");
columns.Add(p => p.Currency.Code).SetName("Currency");
columns.Add(p => p.Amount);
columns.Add(p => p.MinCharge);
columns.Add(p => p.Cashier);
columns.Add(p => p.OnceUse);
columns.Add(p => p.StartTime == null ? "" : p.StartTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("StartTime");
columns.Add(p => p.EndTime == null ? "" : p.EndTime.Value.ToString(culture.DateTimeFormat.ShortDatePattern)).SetName("EndTime");
columns.Add(p => p.Remark);
GridData gridData = oPromotionCoupon.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// grid显示函数
/// </summary>
/// <param name="searchModel">grid搜索模型</param>
/// <returns>程序功能节点</returns>
public ActionResult ListNodes(SearchModel searchModel)
{
IQueryable<GeneralProgNode> oPrograms = dbEntity.GeneralProgNodes.Include("Name").Where(p => p.Deleted == false && p.ProgID == progNodeGidGrid).AsQueryable();
GridColumnModelList<GeneralProgNode> columns = new GridColumnModelList<GeneralProgNode>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.Name.GetResource(CurrentSession.Culture)).SetName("Name.Matter");
columns.Add(p => (p.Optional == null) ? "": p.Optional.GetResource(CurrentSession.Culture)).SetName("Optional.Matter");
GridData gridData = oPrograms.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 互斥促销的首页列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPromotionMutexInfomation(SearchModel searchModel)
{
IQueryable<PromotionMutex> oPromotionMutexInfo = dbEntity.PromotionMutexes.Include("Promotion").Include("Mutex").Where(p => p.Deleted == false && p.PromID == globlePromotionGid || p.MutexID == globlePromotionGid).AsQueryable();
GridColumnModelList<PromotionMutex> columns = new GridColumnModelList<PromotionMutex>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Promotion.Name.GetResource(CurrentSession.Culture)).SetName("PromotionName");
columns.Add(p => p.Mutex.Name.GetResource(CurrentSession.Culture)).SetName("MutexName");
columns.Add(p => p.RelationName).SetName("RelationName");
columns.Add(p => p.Remark);
GridData gridData = oPromotionMutexInfo.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 从数据库读取Index方法保存的对象所对应的下拉框选项
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult OptionalItemList(SearchModel searchModel)
{
IQueryable<GeneralOptItem> oGeneralOptionalItem = dbEntity.GeneralOptItems.Include("Name").Where(g=>g.OptID==optionals.Gid).Where(g => g.Deleted == false).AsQueryable();
//int i = 2052;
GridColumnModelList<GeneralOptItem> columns = new GridColumnModelList<GeneralOptItem>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.Name.Matter).SetName("Name.Matter");
columns.Add(p => p.Sorting);
GridData gridData = oGeneralOptionalItem.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 列出促销方案对应的组织所属的上架商品
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPromotionProductSKUOnsale(SearchModel searchModel)
{
//查出促销规则对应的上架商品信息
IQueryable<ProductOnItem> oOnProductInfo = dbEntity.ProductOnItems.Include("OnSale").Include("SkuItem").Include("FullName").Where(p => p.Deleted == false && p.OnSale.OrgID == promotionOrgGid).AsQueryable();
GridColumnModelList<ProductOnItem> columns = new GridColumnModelList<ProductOnItem>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.OnSale.Code);
columns.Add(p => p.SkuItem.Code).SetName("SKUCode");
columns.Add(p => p.FullName.GetResource(CurrentSession.Culture)).SetName("SKUFullName");
GridData gridData = oOnProductInfo.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 仓库授权列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ListPrivWarehouse(SearchModel searchModel)
{
IQueryable<WarehouseInformation> organs = (from o in dbEntity.WarehouseInformations.Include("ShortName")
from p in dbEntity.MemberPrivItems
where (o.Deleted == false && o.Otype == 2 && p.Deleted == false && o.Gid == p.RefID)
select o).AsQueryable();
GridColumnModelList<WarehouseInformation> columns = new GridColumnModelList<WarehouseInformation>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Code);
columns.Add(p => p.ShortName.Matter);
GridData gridData = organs.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// GeneralOptional Grid列表
/// </summary>
/// <param name="optionalItemSearchModel"></param>
/// <returns></returns>
public ActionResult OptionalList(SearchModel optionalItemSearchModel)
{
Guid OrgID=GetOrganization();
IQueryable<GeneralOptional> oGeneralOptional = dbEntity.GeneralOptionals.Include("Name").Where(g => g.Deleted == false && g.OrgID == ((orgId == null) ? OrgID : orgId)).AsQueryable();
GridColumnModelList<GeneralOptional> columns = new GridColumnModelList<GeneralOptional>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.Otype);
columns.Add(p => p.Code);
columns.Add(p => p.Name.GetResource(CurrentSession.Culture)).SetName("Name");
columns.Add(p => p.Sorting);
columns.Add(p => p.InputMode);
GridData optionalItemGridData = oGeneralOptional.ToGridData(optionalItemSearchModel, columns);
return Json(optionalItemGridData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 文章列表
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public ActionResult ArticleGridList(SearchModel searchModel)
{
IQueryable<MallArticle> oMallArticles = (from o in dbEntity.MallArticles where (o.Deleted == false && o.Acategory == gCategoryId && o.OrgID == gOrgId) select o).AsQueryable();
int n =oMallArticles.ToList().Count;
GridColumnModelList<MallArticle> ArticleColumns = new GridColumnModelList<MallArticle>();
ArticleColumns.Add(cs => cs.Gid).SetAsPrimaryKey();
ArticleColumns.Add(cs => cs.Code).SetCaption(@LiveAzure.Resource.Model.Mall.MallArticle.Code);
ArticleColumns.Add(cs => cs.ArticleType.Name.Matter).SetCaption(@LiveAzure.Resource.Model.Mall.MallArticle.Atype);
ArticleColumns.Add(cs => cs.UserName).SetCaption(@LiveAzure.Resource.Model.Mall.MallArticle.UserID);
ArticleColumns.Add(cs => cs.Title.Matter).SetCaption(@LiveAzure.Resource.Model.Mall.MallArticle.Title);
//foreach (var item in oMallArticles)
//{
// MallArticle oMallArticle = item.Parent;
// if (oMallArticle != null)
// {
// ArticleColumns.Add(cs => cs.Parent.Code);
// }
// else ArticleColumns.Add(null);
//}
GridData gridData = oMallArticles.ToGridData(searchModel,ArticleColumns);
return Json(gridData,JsonRequestBehavior.AllowGet);
}
private static GridColumnModelList<GeneralResItem> GetMatterColumns()
{
GridColumnModelList<GeneralResItem> columns = new GridColumnModelList<GeneralResItem>();
columns.Add(i => i.Gid)
.SetAsPrimaryKey()
.SetHidden(true);
columns.Add(i => i.Culture)
.SetHidden(true);
columns.Add(i => i.CultureName)
.SetWidth("300")
.SetEditable(false)
.SetCaption("国家地区");
columns.Add(i => i.Matter)
.SetWidth("300")
.SetCaption("值");
return columns;
}
public ActionResult DisableIPListDetail(SearchModel searchModel)
{
IQueryable<MallDisabledIp> oMallDisableIP = (from o in dbEntity.MallDisabledIps where (o.Deleted == false && o.OrgID == gOrgId && o.ChlID == gChlId) select o).AsQueryable();
int n = oMallDisableIP.ToList().Count;
GridColumnModelList<MallDisabledIp> columns = new GridColumnModelList<MallDisabledIp>();
columns.Add(p => p.Gid).SetAsPrimaryKey();
columns.Add(p => p.IpAddress).SetCaption(@LiveAzure.Resource.Model.Mall.MallDisabledIp.IpAddress);
columns.Add(p => p.Channel.FullName.GetResource(CurrentSession.Culture)).SetName("Channel").SetCaption(@LiveAzure.Resource.Model.Mall.MallDisabledIp.ChlID);
columns.Add(p => p.Organization.FullName.GetResource(CurrentSession.Culture)).SetName("Organization").SetCaption(@LiveAzure.Resource.Model.Mall.MallDisabledIp.OrgID);
GridData gridData = oMallDisableIP.ToGridData(searchModel, columns);
return Json(gridData, JsonRequestBehavior.AllowGet);
}
