/// <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();
}
