public new static JqGridResults BuildJqGridResults(DataTable dataTable) { JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); foreach (DataRow dr in dataTable.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["ControlCardID"]; row.cell = new string[13]; row.cell[0] = dr["ControlCardID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = dr["CardNumber"].ToString(); row.cell[3] = ((DateTime)dr["StartDate"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); row.cell[4] = ((DateTime)dr["EndDate"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); row.cell[5] = (string)dr["CardStatusName"]; row.cell[6] = FormatHelper.FormatToLastNameAndInitials((string)dr["WorkerLastName"], (string)dr["WorkerFirstName"], (string)dr["WorkerMiddleName"]); row.cell[7] = (string)dr["ControlResponse"]; row.cell[8] = (string)dr["Resolution"]; row.cell[9] = "завантажити"; if (dr["GroupID"] == DBNull.Value) { row.cell[10] = "0"; } else { row.cell[10] = dr["GroupID"].ToString(); } row.cell[11] = dr["InnerNumber"] == DBNull.Value ? String.Empty : (string)dr["InnerNumber"]; row.cell[12] = dr["ActionCommentID"].ToString(); rows.Add(row); } result.rows = rows.ToArray(); result.page = 1; result.total = dataTable.Rows.Count; result.records = dataTable.Rows.Count; return(result); }
public static JqGridResults BuildJqGridResults(DataTable dataTable, PageSettings pageSettings) { JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["WorkerID"]; row.cell = new string[9]; row.cell[0] = dr["WorkerID"].ToString(); row.cell[1] = (string)dr["LastName"]; row.cell[2] = (string)dr["FirstName"]; row.cell[3] = (string)dr["MiddleName"]; row.cell[4] = dr["PostID"].ToString(); row.cell[5] = (string)dr["PostName"]; row.cell[6] = dr["DepartmentID"].ToString(); row.cell[7] = (string)dr["DepartmentName"]; row.cell[8] = dr["IsDismissed"].ToString(); rows.Add(row); } } result.rows = rows.ToArray(); result.page = pageSettings.PageIndex; if (pageSettings.TotalRecords % pageSettings.PageSize == 0) { result.total = pageSettings.TotalRecords / pageSettings.PageSize; } else { result.total = pageSettings.TotalRecords / pageSettings.PageSize + 1; } result.records = pageSettings.TotalRecords; return(result); }
private object getCarDataExec(IList <Car> cars, bool GridData) { JsonJqGridData data = new JsonJqGridData(); data.rows = new List <JqGridRow>(); IList <object> DataList = new List <object>(); var gpsinfos = this.service.GetGenericService <LastestGpsInfo>().Query().ToList(); var OneTimeAgo = DateTime.Now.AddHours(-4); var allogs = this.service.GetGenericService <AlarmLog>().Query() .Where(exp => exp.AlarmTime >= OneTimeAgo).ToList(); var infos = from car in cars join gpsinfo in gpsinfos on car.TerminalID equals gpsinfo.TerminalID orderby car.CarNo select new { Id = car.ID , CustomNo = car.ID , TerminalId = car.TerminalID , CarType = car.CarTypeID != null ? car.CarTypeID : "" , SimNo = car.SIM , Longtidue = gpsinfo.Longtidue , Latitude = gpsinfo.Latitude , Speed = gpsinfo.Speed , Height = gpsinfo.Height , Direction = gpsinfo.Direction , Oil = gpsinfo.Oil , Distance = gpsinfo.Distance , AccFlag = gpsinfo.AccFlag != null ? gpsinfo.AccFlag : "3" , BeaterStatus = gpsinfo.BeaterStatus != null ? gpsinfo.BeaterStatus : "4" , Sendtime = gpsinfo.Sendtime , StatusName = car.GPSStatus != null ? car.GPSStatus : "" , //Driver = car.Status != null ? car.Status.CurrentDriverName : "" // , //DriverTel = car.Status != null ? car.Status.CurrentDriverTel : "" //, Driver = getCarDriver(car.ID) , DriverTel = "" , DayCount = this.service.ShippingDocument.Query().Count(s => s.IsEffective && //优化 s.ProduceDate >= DateTime.Now.Date && s.ProduceDate <= DateTime.Now.Date.AddDays(1).AddSeconds(-1) && s.CarID == car.ID) //今天的调度运输单车次 , MonthCount = this.service.ShippingDocument.Query().Count(s => s.IsEffective && s.ProduceDate >= new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1) && s.ProduceDate <= new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddSeconds(-1) && s.CarID == car.ID) //这个月的调度运输单车次 }; data.records = infos.Count(); data.page = 1; data.total = infos.Count(); foreach (var item in infos.ToList().OrderBy(c => c.CustomNo)) { ShippingDocument shippingdocument = this.service.ShippingDocument.Query().OrderByDescending(p => p.BuildTime) .FirstOrDefault(p => p.IsEffective == true && p.CarID == item.Id && (item.StatusName == GpsCarStatus.Arrived || item.StatusName == GpsCarStatus.Back || item.StatusName == GpsCarStatus.Burden || item.StatusName == GpsCarStatus.Go)); var row = new JqGridRow(); var cells = new List <string>(); //计算报警数 List <GPS_CarAlarmInfo> alarmInfos = this.service.AlarmLog.GetAlarams(item.TerminalId, cars, gpsinfos, allogs); int alarmCount = alarmInfos.Count(); var alarmInfostr = Newtonsoft.Json.JsonConvert.SerializeObject(alarmInfos, Newtonsoft.Json.Formatting.Indented); var itemTaskName = string.Empty; var itemTaskStatus = string.Empty; var ParCube = string.Empty; var taskInfo = shippingdocument; if (taskInfo != null) { itemTaskName = taskInfo.ProjectName + ":" + taskInfo.CastMode + ":" + taskInfo.ConsPos + ":" + taskInfo.ConStrength; itemTaskStatus = taskInfo.Status; ParCube = taskInfo.ParCube.ToString(); } if (GridData) { row.id = item.Id.ToString(); cells.Add(item.Id.ToString()); cells.Add(item.TerminalId); cells.Add(alarmCount + ""); cells.Add(alarmCount + ""); cells.Add(item.CustomNo); cells.Add(item.CarType); cells.Add(item.Longtidue + ""); cells.Add(item.Latitude + ""); cells.Add(item.AccFlag); cells.Add(item.BeaterStatus); cells.Add(item.StatusName); cells.Add(itemTaskStatus); cells.Add(itemTaskName); cells.Add(ParCube); cells.Add(item.Sendtime.ToString()); cells.Add(item.SimNo); cells.Add(item.Oil.HasValue ? item.Oil.Value + "" : "--"); cells.Add(item.Speed.HasValue ? item.Speed + "" : "--"); cells.Add(item.Height.HasValue ? item.Height + "" : "--"); cells.Add(item.Direction.HasValue ? item.Direction + "" : "--"); cells.Add(item.Distance.HasValue ? item.Distance.Value.ToString(".0") : "--"); cells.Add(item.Driver); cells.Add(item.DriverTel); cells.Add(""); //参考地址 cells.Add(alarmInfostr); cells.Add(item.DayCount.ToString()); cells.Add(item.MonthCount.ToString()); row.cell = cells; data.rows.Add(row); } else { var dataitem = new { Id = item.Id, TerminalId = item.TerminalId, AlarmCount = alarmCount, CustomNo = item.CustomNo, Longtidue = item.Longtidue, Latitude = item.Latitude, AccFlag = item.AccFlag, BeaterStatus = item.BeaterStatus, StatusName = item.StatusName, TaskName = itemTaskName, itemTaskStatus = itemTaskStatus, Sendtime = item.Sendtime.ToString(), SimNo = item.SimNo, CarType = item.CarType, ParCube = taskInfo.ParCube, DayCount = item.DayCount, MonthCount = item.MonthCount, Oil = item.Oil.HasValue ? item.Oil.Value + "" : "--", Speed = item.Speed.HasValue ? item.Speed + "" : "--", Height = item.Height.HasValue ? item.Height + "" : "--", Direction = item.Direction.HasValue ? item.Direction + "" : "--", Distance = item.Distance.HasValue ? item.Distance.Value.ToString(".0") : "--", Driver = item.Driver, DriverTel = item.DriverTel, AlarmInfos = alarmInfostr }; DataList.Add(dataitem); } } object returndata; if (GridData) { returndata = data; } else { returndata = DataList; } return(returndata); }
public static JqGridResults BuildJqGridResults(DataTable dataTable, PageSettings pageSettings) { JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["DocAdminServiceID"]; row.cell = new string[20]; row.cell[0] = dr["DocAdminServiceID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = ((DateTime)dr["CreationDate"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); row.cell[3] = (string)dr["Number"]; row.cell[4] = dr["DocumentCode"].ToString(); row.cell[5] = (string)dr["SubjectRequest"]; row.cell[6] = (string)dr["ServiceName"]; row.cell[7] = (string)dr["ObjectForService"]; row.cell[8] = (string)dr["Content"]; row.cell[9] = (string)dr["Notes"]; row.cell[10] = dr["IsControlled"].ToString(); row.cell[11] = dr["ExecutiveDepartmentID"].ToString(); row.cell[12] = (string)dr["ExecutiveDepartmentName"]; if ((DateTime)dr["DateReceivedToDepartment"] > (DateTime)SqlDateTime.MinValue) { row.cell[13] = ((DateTime)dr["DateReceivedToDepartment"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); } else { row.cell[13] = String.Empty; } row.cell[14] = dr["ReceivedWorkerID"].ToString(); if ((DateTime)dr["DateReturnFromDepartment"] > (DateTime)SqlDateTime.MinValue) { row.cell[15] = ((DateTime)dr["DateReturnFromDepartment"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); } else { row.cell[15] = String.Empty; } row.cell[16] = dr["ReturnWorkerID"].ToString(); row.cell[17] = (string)dr["ServiceResult"]; if ((DateTime)dr["DateResponseToClient"] > (DateTime)SqlDateTime.MinValue) { row.cell[18] = ((DateTime)dr["DateResponseToClient"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); } else { row.cell[18] = String.Empty; } row.cell[19] = (string)dr["ResponseClientInfo"]; /* * row.cell[20] = dr["DocStatusID"].ToString(); * row.cell[21] = (string)dr["DocStatusName"]; */ rows.Add(row); } } result.rows = rows.ToArray(); result.page = pageSettings.PageIndex; if (pageSettings.TotalRecords % pageSettings.PageSize == 0) { result.total = pageSettings.TotalRecords / pageSettings.PageSize; } else { result.total = pageSettings.TotalRecords / pageSettings.PageSize + 1; } result.records = pageSettings.TotalRecords; return(result); }
private string GetReplayPage(HttpRequest r) { int documentId = Convert.ToInt32(r["documentId"]); PageSettings gridSettings = JqGridSettings.GetPageSettings(_context); DataTable dtPage = AdminDocumets.GetReplayPage(gridSettings, UserId, documentId); JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dtPage != null) { foreach (DataRow dr in dtPage.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["DocTemplateID"]; row.cell = new string[20]; row.cell[0] = dr["DocTemplateID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = ((DateTime)dr["CreationDate"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); row.cell[3] = (string)dr["Number"]; row.cell[4] = dr["ExternalNumber"].ToString(); row.cell[5] = (string)dr["Content"]; row.cell[6] = (string)dr["Changes"]; row.cell[7] = (string)dr["Notes"]; row.cell[8] = dr["IsControlled"].ToString(); row.cell[9] = dr["IsSpeciallyControlled"].ToString(); row.cell[10] = dr["IsIncreasedControlled"].ToString(); row.cell[11] = dr["IsInput"].ToString(); row.cell[12] = dr["DocTypeID"].ToString(); row.cell[13] = (string)dr["DocTypeName"]; row.cell[14] = dr["DocStatusID"].ToString(); row.cell[15] = (string)dr["DocStatusName"]; row.cell[16] = dr["DocumentCodeID"].ToString(); row.cell[17] = dr["QuestionTypeID"].ToString(); row.cell[18] = (string)dr["QuestionTypeName"]; string destination = String.Empty; if (DBNull.Value != dr["OrganizationID"] && (int)dr["OrganizationID"] > 0) { destination = (string)dr["OrganizationName"]; } if (DBNull.Value != dr["DepartmentID"] && (int)dr["DepartmentID"] > 0) { destination = destination == String.Empty ? destination : ", "; destination = destination + (string)dr["DepartmentName"]; } if (DBNull.Value != dr["WorkerID"] && (int)dr["WorkerID"] > 0) { destination = destination == String.Empty ? destination : ", "; destination = destination + FormatHelper.FormatToLastNameAndInitials((string)dr["WorkerLastName"], (string)dr["WorkerFirstName"], (string)dr["WorkerMiddleName"]); } row.cell[19] = destination; rows.Add(row); } } result.rows = rows.ToArray(); result.page = gridSettings.PageIndex; if (gridSettings.TotalRecords % gridSettings.PageSize == 0) { result.total = gridSettings.TotalRecords / gridSettings.PageSize; } else { result.total = gridSettings.TotalRecords / gridSettings.PageSize + 1; } result.records = gridSettings.TotalRecords; return(new JavaScriptSerializer().Serialize(result)); }
private string GetStatementsPage(HttpRequest r) { int documentId = Convert.ToInt32(r["documentId"]); PageSettings pageSettings = JqGridSettings.GetPageSettings(_context); DataTable dataTable = WorkerDocumets.GetStatementsPage(pageSettings, UserId, Worker.DepartmentID); JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["DocStatementID"]; row.cell = new string[20]; row.cell[0] = dr["DocStatementID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = ((DateTime)dr["CreationDate"]).ToString("yyyy-MM-dd"); row.cell[3] = FormatHelper.FormatToLastNameAndInitials((string)dr["CitizenLastName"], (string)dr["CitizenFirstName"], (string)dr["CitizenMiddleName"]); row.cell[4] = String.Format("{0} {1} {2}", dr["CitizenLastName"], dr["CitizenFirstName"], dr["CitizenMiddleName"]); if ((string)dr["CityObjectTypeShortName"] == "н") { row.cell[5] = (string)dr["Address"]; } else { row.cell[5] = FormatHelper.FormatAddress((string)dr["Address"], (string)dr["CityObjectTypeShortName"], (string)dr["CityObjectName"], (string)dr["HouseNumber"], (string)dr["Corps"], (string)dr["ApartmentNumber"]); } row.cell[6] = FormatHelper.FormatToLastNameAndInitials((string)dr["HeadLastName"], (string)dr["HeadFirstName"], (string)dr["HeadMiddleName"]); row.cell[7] = (string)dr["Number"]; row.cell[8] = dr["ExternalNumber"].ToString(); row.cell[9] = (string)dr["Content"]; row.cell[10] = dr["DeliveryTypeID"].ToString(); row.cell[11] = dr["InputDocTypeID"].ToString(); row.cell[12] = dr["InputMethodID"].ToString(); row.cell[13] = dr["InputSignID"].ToString(); row.cell[14] = dr["InputSubjectTypeID"].ToString(); row.cell[15] = dr["ControlCardID"].ToString(); row.cell[16] = dr["OpenWorker"].ToString(); row.cell[17] = dr["HasSubCards"].ToString(); row.cell[18] = dr["IsControlled"].ToString(); if (DBNull.Value == dr["ControlEndDate"]) { row.cell[19] = String.Empty; } else { row.cell[19] = ((DateTime)dr["ControlEndDate"]).ToString("yyyy-MM-dd"); } rows.Add(row); } } result.rows = rows.ToArray(); result.page = pageSettings.PageIndex; if (pageSettings.TotalRecords % pageSettings.PageSize == 0) { result.total = pageSettings.TotalRecords / pageSettings.PageSize; } else { result.total = pageSettings.TotalRecords / pageSettings.PageSize + 1; } result.records = pageSettings.TotalRecords; return(new JavaScriptSerializer().Serialize(result)); }
public static JqGridResults BuildJqGridResults(DataTable dataTable, PageSettings pageSettings) { JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { bool isInput = (bool)dr["IsInput"]; JqGridRow row = new JqGridRow(); row.id = (int)dr["DocTemplateID"]; row.cell = new string[25]; row.cell[0] = dr["DocTemplateID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = ((DateTime)dr["CreationDate"]).ToString("dd.MM.yyyy", CultureInfo.CurrentCulture); row.cell[3] = isInput ? dr["DestinationNumber"].ToString() : dr["SourceNumber"].ToString(); row.cell[4] = isInput ? dr["SourceNumber"].ToString() : dr["DestinationNumber"].ToString(); row.cell[5] = (string)dr["Content"]; row.cell[6] = (string)dr["Changes"]; row.cell[7] = (string)dr["Notes"]; row.cell[8] = dr["IsControlled"].ToString(); row.cell[9] = dr["IsSpeciallyControlled"].ToString(); row.cell[10] = dr["IsIncreasedControlled"].ToString(); row.cell[11] = dr["IsInput"].ToString(); row.cell[12] = dr["DocTypeID"].ToString(); row.cell[13] = (string)dr["DocTypeName"]; row.cell[14] = dr["DocStatusID"].ToString(); row.cell[15] = (string)dr["DocStatusName"]; row.cell[16] = dr["DocumentCodeID"].ToString(); row.cell[17] = dr["QuestionTypeID"].ToString(); row.cell[18] = (string)dr["QuestionTypeName"]; string destination = String.Empty; if (isInput) { if (DBNull.Value != dr["SourceOrganizationID"] && (int)dr["SourceOrganizationID"] > 0) { destination = (string)dr["SourceOrganizationName"]; } if (DBNull.Value != dr["SourceDepartmentID"] && (int)dr["SourceDepartmentID"] > 0) { destination = destination == String.Empty ? destination : destination + ", "; destination = destination + (string)dr["SourceDepartmentName"]; } if (DBNull.Value != dr["SourceWorkerID"] && (int)dr["SourceWorkerID"] > 0) { destination = destination == String.Empty ? destination : destination + ", "; destination = destination + FormatHelper.FormatToLastNameAndInitials((string)dr["SourceWorkerLastName"], (string)dr["SourceWorkerFirstName"], (string)dr["SourceWorkerMiddleName"]); } } else { if (DBNull.Value != dr["DestinationOrganizationID"] && (int)dr["DestinationOrganizationID"] > 0) { destination = (string)dr["DestinationOrganizationName"]; } if (DBNull.Value != dr["DestinationDepartmentID"] && (int)dr["DestinationDepartmentID"] > 0) { destination = destination == String.Empty ? destination : destination + ", "; destination = destination + (string)dr["DestinationDepartmentName"]; } if (DBNull.Value != dr["DestinationWorkerID"] && (int)dr["DestinationWorkerID"] > 0) { destination = destination == String.Empty ? destination : destination + ", "; destination = destination + FormatHelper.FormatToLastNameAndInitials((string)dr["DestinationWorkerLastName"], (string)dr["DestinationWorkerFirstName"], (string)dr["DestinationWorkerMiddleName"]); } } row.cell[19] = destination; row.cell[20] = dr["DepartmentID"].ToString(); row.cell[21] = dr["SourceDepartmentID"].ToString(); row.cell[22] = dr["DestinationDepartmentID"].ToString(); row.cell[23] = DBNull.Value != dr["InnerNumber"] ? dr["InnerNumber"].ToString() : String.Empty; row.cell[24] = DBNull.Value != dr["ControlCardID"] ? dr["ControlCardID"].ToString() : String.Empty; rows.Add(row); } } result.rows = rows.ToArray(); result.page = pageSettings.PageIndex; if (pageSettings.TotalRecords % pageSettings.PageSize == 0) { result.total = pageSettings.TotalRecords / pageSettings.PageSize; } else { result.total = pageSettings.TotalRecords / pageSettings.PageSize + 1; } result.records = pageSettings.TotalRecords; return(result); }
public static JqGridResults BuildJqGridResults(DataTable dataTable, PageSettings pageSettings) { JqGridResults result = new JqGridResults(); List <JqGridRow> rows = new List <JqGridRow>(); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { JqGridRow row = new JqGridRow(); row.id = (int)dr["DocStatementID"]; row.cell = new string[19]; row.cell[0] = dr["DocStatementID"].ToString(); row.cell[1] = dr["DocumentID"].ToString(); row.cell[2] = ((DateTime)dr["CreationDate"]).ToString("yyyy-MM-dd"); row.cell[3] = FormatHelper.FormatToLastNameAndInitials((string)dr["CitizenLastName"], (string)dr["CitizenFirstName"], (string)dr["CitizenMiddleName"]); row.cell[4] = String.Format("{0} {1} {2}", dr["CitizenLastName"], dr["CitizenFirstName"], dr["CitizenMiddleName"]); if ((string)dr["CityObjectTypeShortName"] == "н") { row.cell[5] = (string)dr["Address"]; } else { row.cell[5] = FormatHelper.FormatAddress((string)dr["Address"], (string)dr["CityObjectTypeShortName"], (string)dr["CityObjectName"], (string)dr["HouseNumber"], (string)dr["Corps"], (string)dr["ApartmentNumber"]); } row.cell[6] = FormatHelper.FormatToLastNameAndInitials((string)dr["HeadLastName"], (string)dr["HeadFirstName"], (string)dr["HeadMiddleName"]); row.cell[7] = (string)dr["Number"]; row.cell[8] = dr["ExternalNumber"].ToString(); row.cell[9] = (string)dr["Content"]; row.cell[10] = dr["DeliveryTypeID"].ToString(); row.cell[11] = dr["InputDocTypeID"].ToString(); row.cell[12] = dr["InputMethodID"].ToString(); row.cell[13] = dr["InputSignID"].ToString(); row.cell[14] = dr["InputSubjectTypeID"].ToString(); row.cell[15] = dr["DepartmentID"].ToString(); row.cell[16] = DBNull.Value != dr["InnerNumber"] ? dr["InnerNumber"].ToString() : String.Empty; row.cell[17] = DBNull.Value != dr["ControlCardID"] ? dr["ControlCardID"].ToString() : String.Empty; row.cell[18] = dr["IsControlled"].ToString(); rows.Add(row); } } result.rows = rows.ToArray(); result.page = pageSettings.PageIndex; if (pageSettings.TotalRecords % pageSettings.PageSize == 0) { result.total = pageSettings.TotalRecords / pageSettings.PageSize; } else { result.total = pageSettings.TotalRecords / pageSettings.PageSize + 1; } result.records = pageSettings.TotalRecords; return(result); }