/// <summary> /// 主檔搜索 /// </summary> /// <param name="row"></param> /// <param name="page"></param> /// <param name="Model"></param> /// <returns></returns> public static string PlanSearch(int row, int page, PlanSearchModel Model) { DateTime?Begin_Date; DateTime?End_Date; int? status; if (Model.BeginDate != "") { Begin_Date = Convert.ToDateTime(Model.BeginDate); } else { Begin_Date = null; } if (Model.EndData != "") { End_Date = Convert.ToDateTime(Model.EndData); } else { End_Date = null; } if (Model.status != "") { status = Convert.ToInt32(Model.status); } else { status = null; } using (var db = new VehicleEntities()) { var Searchlist = from hdr in db.vw_Plan.Where(p => (p.LastUpdDate >= Begin_Date || Begin_Date == null) && (p.LastUpdDate <= End_Date || End_Date == null) && (p.carID == Model.carID || string.IsNullOrEmpty(Model.carID)) && (p.driverID == Model.driverID || string.IsNullOrEmpty(Model.driverID)) && (p.status == status || string.IsNullOrEmpty(Model.status)) ).OrderByDescending(p => p.LastUpdDate).Skip((page - 1) * row).Take(row) select hdr; var AllList = from hdr in db.vw_Plan.Where(p => (p.LastUpdDate >= Begin_Date || Begin_Date == null) && (p.LastUpdDate <= End_Date || End_Date == null) && (p.carID.Contains(Model.carID) || string.IsNullOrEmpty(Model.carID)) && (p.driverID.Contains(Model.driverID) || string.IsNullOrEmpty(Model.driverID)) && (p.status == status || string.IsNullOrEmpty(Model.status)) ).OrderByDescending(p => p.LastUpdDate) select hdr; var total = AllList.Count(); string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = Searchlist }); return(JsonGrid); } }
/// <summary> /// 主檔搜索 /// </summary> public void PlanSearch() { rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); page = Request["page"] == null ? 1 : int.Parse(Request["page"]); string driverID = Request.Form["driverID"]; string carID = Request.Form["carID"]; string status = Request.Form["status"]; string BeginDate = Request.Form["BeginDate"]; string EndData = Request.Form["EndDate"]; PlanSearchModel Model = new PlanSearchModel(); Model.carID = carID; Model.driverID = driverID; Model.status = status; Model.BeginDate = BeginDate; Model.EndData = EndData; string Json = Vehicle_adminDispatch.PlanSearch(rows, page, Model); Response.ContentType = "Application/json"; Response.Write(Json); Response.End(); }