//
// GET: /Ims/PaypalApi/
public ActionResult Index(PaypalApiRequest request)
{
var result = this.ImsService.GetPaypalApiList(request);
return(View(result));
}
public ActionResult Datatable(PaypalApiRequest request)
{
#region 自定义动作
if (!string.IsNullOrEmpty(request.customActionType))
{
string[] id_Array = Request.Params.GetValues("id[]");
List <int> ids = new List <int>();
foreach (string i in id_Array)
{
ids.Add(int.Parse(i));
}
switch (request.customActionType)
{
case "group_action":
switch (request.customActionName)
{
case "delete":
this.ImsService.DeleteAssociation(ids);
break;
}
break;
case "delete":
this.ImsService.DeleteAssociation(ids);
break;
}
}
#endregion
var allAssociation = this.ImsService.GetAssociationList(null);
IEnumerable <Association> filterAssociation = allAssociation;
#region 搜索
//if (!string.IsNullOrEmpty(request.search))
//{
// var isNameSearchable = Convert.ToBoolean(Request["columns[1][searchable]"]);
//}
//else if (request.action == "filter")
//{
// var NameFilter = Convert.ToString(Request["name"]).Trim().ToLower();
// var SkuFilter = Convert.ToString(Request["sku"]).Trim().ToLower();
// var PackingWeightFilter = Convert.ToString(Request["packingweight"]).Trim().ToLower();
// var isNameSearchable = Convert.ToBoolean(Request["columns[1][searchable]"].ToString());
// if (isNameSearchable)
// {
// filterProduct = filterProduct.Where(c => c.Name.ToLower().Contains(NameFilter));
// }
// var isSkuSearchable = Convert.ToBoolean(Request["columns[2][searchable]"].ToString());
// if (isSkuSearchable)
// {
// filterProduct = filterProduct.Where(c => c.Sku.ToLower().Contains(SkuFilter));
// }
// var isPackingWeightSearchable = Convert.ToBoolean(Request["columns[3][searchable]"].ToString());
// if (isPackingWeightSearchable && !string.IsNullOrEmpty(PackingWeightFilter))
// {
// filterProduct = filterProduct.Where(c => c.PackWeight == PackingWeightFilter.ToInt());
// }
//}
//else if (request.action == "filter_cancel")
//{
// filterProduct = allProduct;
//}
//else
//{
// filterProduct = allProduct;
//}
#endregion
#region 排序
//var isPPAccountSortable = Convert.ToBoolean(Request["columns[1][orderable]"]);
//var isApiUserNameSortable = Convert.ToBoolean(Request["columns[2][orderable]"]);
//var isIsActiveSortable = Convert.ToBoolean(Request["columns[3][orderable]"]);
//var sortColumnIndex = Convert.ToInt32(Request["order[0][column]"]);
//Func<PaypalApi, string> orderingFunction = (c =>
// sortColumnIndex == 1 && isPPAccountSortable ? c.PPAccount :
// sortColumnIndex == 2 && isApiUserNameSortable ? c.ApiUserName :
// sortColumnIndex == 3 && isIsActiveSortable ? c.IsActive.ToString() :
// "");
//var sortDirection = Request["order[0][dir]"]; // asc or desc
//if (sortDirection == "asc")
//{
// filterPaypalApi = filterPaypalApi.OrderBy(orderingFunction);
//}
//if (sortDirection == "desc")
//{
// filterPaypalApi = filterPaypalApi.OrderByDescending(orderingFunction);
//}
#endregion
var displayedAssociation = filterAssociation.Skip(request.start).Take(request.length);
var result = from c in displayedAssociation
select new[] {
Convert.ToString(c.ID)
, c.ItemNumber
, c.ItemTitle //c.OrderTime.ToCnDataString()
, c.PaypalApi.PPAccount //c.TransactionID
, c.Product.Sku.ToString()
, c.SellingPlace
, c.StorePlace
, Convert.ToString(c.ID)
};
return(Json(new
{
draw = request.draw, //param.sEcho,
recordsTotal = allAssociation.Count(), //alltransactions.Count(),
recordsFiltered = filterAssociation.Count(),
data = result
},
JsonRequestBehavior.AllowGet));
}
