public ActionResult PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize)
{
if (ModelState.IsValid)
{
int pageNo = currentPageNo ?? 0;
int pageSize = currentPageSize ?? 20;
if (Request["PageNo"] != null)
{
pageNo = Convert.ToInt32(Request["PageNo"]);
}
if (Request["PageSize"] != null)
{
pageSize = Convert.ToInt32(Request["PageSize"]);
}
using (EquipmentReasonCodeServiceClient client = new EquipmentReasonCodeServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <EquipmentReasonCode> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
}
}
return(PartialView("_ListPartial"));
}
//
// GET: /FMM/ReasonCode/
public ActionResult Index()
{
using (EquipmentReasonCodeServiceClient client = new EquipmentReasonCodeServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 1,
OrderBy = "Key"
};
MethodReturnResult <IList <EquipmentReasonCode> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
}
return(View(new EquipmentReasonCodeQueryViewModel()));
}
public ActionResult Query(EquipmentReasonCodeQueryViewModel model)
{
if (ModelState.IsValid)
{
using (EquipmentReasonCodeServiceClient client = new EquipmentReasonCodeServiceClient())
{
StringBuilder where = new StringBuilder();
if (model != null)
{
if (!string.IsNullOrEmpty(model.Name))
{
where.AppendFormat(" {0} Key LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.Name);
}
if (model.Type != null)
{
where.AppendFormat(" {0} Type = '{1}'"
, where.Length > 0 ? "AND" : string.Empty
, Convert.ToInt32(model.Type));
}
}
PagingConfig cfg = new PagingConfig()
{
OrderBy = "Key",
Where = where.ToString()
};
MethodReturnResult <IList <EquipmentReasonCode> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
}
}
return(PartialView("_ListPartial"));
}
public IEnumerable <SelectListItem> GetEquipmentReasonCodeName(EnumEquipmentReasonCodeType type)
{
using (EquipmentReasonCodeServiceClient client = new EquipmentReasonCodeServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format("Type='{0}'", Convert.ToInt32(type))
};
MethodReturnResult <IList <EquipmentReasonCode> > result = client.Get(ref cfg);
if (result.Code <= 0)
{
IEnumerable <SelectListItem> lst = from item in result.Data
select new SelectListItem()
{
Text = item.Key,
Value = item.Key
};
return(lst);
}
}
return(new List <SelectListItem>());
}
