//
// GET: /Home/
public ActionResult Index()
{
JQGridModel <invheader> model = new JQGridModel <invheader>("JsonExample");
model.Grid.DataUrl = Url.Action("Data");
return(View(model));
}
/// <summary>
/// Created By: Bhushan Dod
/// Created Date: Oct-13-2017
/// List of Passenger tracking route according to service type in jqgrid list.
/// </summary>
/// <param name="UserId"></param>
/// <param name="pageIndex"></param>
/// <param name="numberOfRows"></param>
/// <param name="sortColumnName"></param>
/// <param name="sortOrderBy"></param>
/// <param name="locationId"></param>
/// <param name="textSearch"></param>
/// <param name="statusType"></param>
/// <returns></returns>
public JQGridModel <eFleetPassengerTrackingModel> GetListeFleetPassengerRoutewithJQGridDetails(int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long?statusType)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objeFleetPassengerTrackingModel = new JQGridModel <eFleetPassengerTrackingModel>();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
var objeFleetRoute = new eFleetPassengerTrackingModel();
var Results = db.eFleetPassengerTrackingRoutes.Where(a => (a.IsDeleted == false) &&
(((statusType == 0) ? null : statusType) == null || a.ServiceType == statusType)).Select(a => new eFleetPassengerTrackingModel()
{
DropPoint = a.DropPoint,
EndDate = a.EndDate,
PickUpPoint = a.PickUpPoint,
ServiceTypeName = a.GlobalCode.CodeName,
StartDate = a.StartDate,
RouteID = a.RouteID,
RouteName = a.RouteName,
CreatedDate = a.CreatedDate
}).OrderByDescending(x => x.CreatedDate).ToList();
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
objeFleetPassengerTrackingModel.pageindex = pageindex;
objeFleetPassengerTrackingModel.total = totalPages;
objeFleetPassengerTrackingModel.records = totRecords;
objeFleetPassengerTrackingModel.rows = Results.ToList();
return(objeFleetPassengerTrackingModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "JQGridModel<eFleetPassengerTrackingModel> GetListeFleetPassengerRoutewithJQGridDetails(int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long? statusType)", "Exception While fetching ", statusType);
throw;
}
}
public string QueryInterfaceProgramList(JQGridModel model)
{
try
{
int Total = 0;
model.Sidx = "OrderIndex";
List <InterfaceProgramModel> List = new DocumentInterfaceDAL().QueryInterfaceProgramList(model, ref Total);
//构造集合对象
var JQGridContent = new
{
total = Total, //总页数
page = model.Page, //当前页
records = model.Rows, //查询出的记录数
rows = List //包含实际数据的数组
};
//将集合对象序列化
string Result = new JavaScriptSerializer().Serialize(JQGridContent);
return(Result);
}
catch (Exception e)
{
logger.Error(e.ToString());
return("");
}
}
public JsonResult Data()
{
JQGridModel <invheader> model = new JQGridModel <invheader>();
using (DataContext ctx = new DataContext())
{
return(model.Grid.DataBind(ctx.InvoiceHeader.AsQueryable()));
}
}
/// <summary>
/// Created By: Bhushan Dod
/// Created Date: Nov-08-2017
/// List of fueling according to service type in jqgrid list.
/// </summary>
/// <param name="UserId"></param>
/// <param name="pageIndex"></param>
/// <param name="numberOfRows"></param>
/// <param name="sortColumnName"></param>
/// <param name="sortOrderBy"></param>
/// <param name="locationId"></param>
/// <param name="textSearch"></param>
/// <param name="statusType"></param>
/// <returns></returns>
public JQGridModel <FuelJQGridList> GetListeFleetFuelingForJQGridDetails(long?locationid, int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long?statusType, DateTime FromDate, DateTime ToDate)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objeeFleetFuelingModelForService = new JQGridModel <FuelJQGridList>();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
var objeFleetFuel = new FuelJQGridList();
var Results = db.eFleetFuelings.Where(a => (a.IsDeleted == false) &&
(((locationid == 0) ? null : locationid) == null || a.LocationID == locationid) &&
(a.CreatedDate >= FromDate && a.CreatedDate <= ToDate) &&
(((textSearch == null ? null : textSearch) == null || a.VehicleNumber.Contains(textSearch)) ||
((textSearch == null ? null : textSearch) == null || a.DriverName.Contains(textSearch))
)
//&& (((textSearch == null) ? null : textSearch) == null || a.VehicleNumber == textSearch)
).Select(a => new FuelJQGridList()
{
FuelID = a.FuelID,
VehicleNumber = a.VehicleNumber,
QRCodeID = a.QRCodeID,
Mileage = a.Mileage,
// CurrentFuel = a.CurrentFuel,
FuelTypeName = a.GlobalCode.CodeName,
//ReceiptNo = a.ReceiptNo,
FuelingDate = a.FuelingDate,
Gallons = a.Gallons,
PricePerGallon = a.PricePerGallon,
Total = a.Total,
GasStatioName = a.GasStatioName,
//CardNo = a.CardNo,
DriverName = a.DriverName,
FuelReceiptImage = a.FuelReceiptImage
}).OrderByDescending(x => x.FuelingDate).ToList();
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
objeeFleetFuelingModelForService.pageindex = pageindex;
objeeFleetFuelingModelForService.total = totalPages;
objeeFleetFuelingModelForService.records = totRecords;
objeeFleetFuelingModelForService.rows = Results.ToList();
return(objeeFleetFuelingModelForService);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "JQGridModel<eFleetPassengerTrackingModel> GetListeFleetPassengerRoutewithJQGridDetails(int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long? statusType)", "Exception While fetching ", statusType);
throw;
}
}
/// <summary>
/// 查询接口参数列表
/// </summary>
/// <param name="model"></param>
/// <param name="programID"></param>
/// <param name="total"></param>
/// <returns></returns>
public List <InterfaceParameterModel> QueryInterfaceParameterList(JQGridModel model, int interfaceID, ref int total)
{
try
{
string SQLString = string.Format("SELECT ParameterID,InterfaceID,ProgramID,ParameterType,ParameterCode,ParameterName,CheckContent,DataType,Remark,OrderIndex FROM dbo.InterfaceParameter WHERE IsDelete=0 AND InterfaceID={0}", interfaceID);
MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB");
DataTable Result = SQLHelper.ExecutePageDatatable(SQLString, model.Page, model.Rows, "OrderIndex", model.OrderMethod);
total = int.Parse(Result.ExtendedProperties["Total"].ToString());
return(Result.ToList <InterfaceParameterModel>());
}
catch (Exception e)
{
_log.Error(e.Message);
return(null);
}
}
/// <summary>
/// 查询接口程序列表
/// </summary>
/// <param name="model"></param>
/// <param name="total"></param>
/// <returns></returns>
public List <InterfaceProgramModel> QueryInterfaceProgramList(JQGridModel model, ref int total)
{
try
{
string SQLString = "SELECT ProgramID,ProgramName,SvnUrl,OrderIndex,CreateTime,UpdateTime FROM dbo.InterfaceProgram WHERE IsDelete=0";
MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB");
DataTable Result = SQLHelper.ExecutePageDatatable(SQLString, model.Page, model.Rows, "OrderIndex", model.OrderMethod);
total = int.Parse(Result.ExtendedProperties["Total"].ToString());
return(Result.ToList <InterfaceProgramModel>());
}
catch (Exception e)
{
_log.Error(e.Message);
return(null);
}
}
public string QueryDocumentInterfaceItemList(JQGridModel model, int programID)
{
return(new DocumentInterfaceBLL().QueryInterfaceItemList(model, programID));
}
public string QueryDocumentInterfaceProgramList(JQGridModel model)
{
return(new DocumentInterfaceBLL().QueryInterfaceProgramList(model));
}
public string QueryDocumentInterfaceParamterList(JQGridModel model, int interfaceID)
{
return(new DocumentInterfaceBLL().QueryInterfaceParameterList(model, interfaceID));
}
