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