public JsonResult SelectByPageDataTable([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, MachineMtn machineMtn)
{
//DataTables.
int pageSize = requestModel.Length != 0 ? requestModel.Length : 10;
int pageNumber = requestModel.Start / requestModel.Length + 1;
string where = " where 1=1 ";
string where_MachineID = "";
string where_FrequencyID = "";
string where_MaintenanceDate = "";
string where_Shift = "";
string where_Week = "";
string where_Month = "";
string where_Year = "";
if (!string.IsNullOrEmpty(machineMtn.MachineID))
{
where_MachineID = " and tMachineMtn.MachineID = '" + machineMtn.MachineID + "'";
}
if (machineMtn.FrequencyID != 0)
{
where_FrequencyID = " and tMachineMtn.FrequencyID = '" + machineMtn.FrequencyID + "' ";
}
if (machineMtn.MaintenanceDate != DateTime.MinValue)
{
where_MaintenanceDate = " and tMachineMtn.MaintenanceDate = '" + machineMtn.MaintenanceDate + "' ";
}
if (machineMtn.Shift != 0)
{
where_Shift = " and Shift = '" + machineMtn.Shift + "' ";
}
if (machineMtn.Week != 0)
{
where_Week += " AND Week = '" + machineMtn.Week + "' ";
}
if (machineMtn.Month != 0)
{
where_Month += " AND Month = '" + machineMtn.Month + "' ";
}
if (machineMtn.Year != 0)
{
where_Year += " AND Year = '" + machineMtn.Year + "' ";
}
//tong hop cau lenh where.
if (machineMtn.FrequencyID == 0) // lay tat ca.
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
where += where_Week + where_Month + where_Year;
}
if (machineMtn.FrequencyID == 1)
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
}
if (machineMtn.FrequencyID == 2)
{
where += where_MachineID + where_FrequencyID + where_Week + where_Year;
}
if (machineMtn.FrequencyID == 3 || machineMtn.FrequencyID == 4 || machineMtn.FrequencyID == 5)
{
where += where_MachineID + where_FrequencyID + where_Month + where_Year;
}
if (machineMtn.FrequencyID == 6)
{
where += where_MachineID + where_FrequencyID + where_Year;
}
if (!string.IsNullOrEmpty(machineMtn.CheckerResult))
{
where += " AND CheckerResult = '" + machineMtn.CheckerResult + "' ";
}
if (!string.IsNullOrEmpty(machineMtn.Result))
{
where += " AND Result = '" + machineMtn.Result + "' ";
}
//Execute.
ReturnMachineMtn _returnMachineMtn = machineMtnDB.SelectByPage(where, pageNumber, pageSize);
// DataTables.
// Avoid from datatables.net getting stuck (if data=null).
if (_returnMachineMtn.lstMachineMtn == null)
{
_returnMachineMtn.lstMachineMtn = new List <MachineMtn>();
}
//Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
IEnumerable <MachineMtn> IEnum_MachineMtn = _returnMachineMtn.lstMachineMtn.OrderBy(orderByString ==
string.Empty ? "MachineID asc" : orderByString);
_returnMachineMtn.lstMachineMtn = IEnum_MachineMtn.ToList <MachineMtn>();
//Permission.
_returnMachineMtn.permisionControllerVM = this.getPermisionControllerViewModel();
//DataTables.
//return View.
var DataTablesResponse = new
{
draw = requestModel.Draw,
data = _returnMachineMtn,
recordsFiltered = _returnMachineMtn.Total,
recordsTotal = _returnMachineMtn.Total
};
return(Json(DataTablesResponse, JsonRequestBehavior.AllowGet));
}
public JsonResult InsertMachineMtn(MachineMtn machineMtn)
{
return(Json(machineMtnDB.Insert(machineMtn), JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateCheckerResult_ByMachineMtnID(MachineMtn machineMtn)
{
return(Json(machineMtnDB.UpdateCheckerResult_ByMachineMtnID(machineMtn), JsonRequestBehavior.AllowGet));
}
