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); }
public void ParceRequest() { HttpRequest r = _context.Request; HttpResponse res = _context.Response; string type = r["type"]; string jdata = r["jdata"]; string rResult = String.Empty; if (!String.IsNullOrWhiteSpace(type)) { switch (type) { case "getpage": int departmentId = Convert.ToInt32(r["departmentID"]); PageSettings gridSettings = JqGridSettings.GetPageSettings(_context); DataTable dtPage = AdminDocumets.GetPage(gridSettings, UserId, departmentId); JqGridResults jqGridResults = AdminDocumets.BuildJqGridResults(dtPage, gridSettings); rResult = new JavaScriptSerializer().Serialize(jqGridResults); break; case "getreplaypage": rResult = GetReplayPage(r); break; case "getpagedoc": int depId = Convert.ToInt32(r["dep"]); GetPageRtf(depId); break; } if (!String.IsNullOrWhiteSpace(rResult)) { res.Write(rResult); } } }
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)); }
public void GetPageRtf(int departmentId) { HttpRequest request = _context.Request; Filter filters = new Filter(); filters.Rules = new List <Rule>(); string[] fields = { "CreationDate", "CreationDateStart", "CreationDateEnd", "Number", "ExternalNumber", "DocumentCodeID", "Content", "OrganizationName", "InnerNumber", "Controlled", "EndDateFrom", "EndDateTo", "IsInput", "IsDepartmentOwner", "ControlledInner", "InnerEndDateFrom", "InnerEndDateTo", "LableID", "DocStatusID" }; foreach (var f in fields) { string data = request[f]; if (!String.IsNullOrWhiteSpace(data)) { filters.AddRule(new Rule { Field = f, Data = data, Op = "cn" }); } } PageSettings gridSettings = new PageSettings { IsSearch = bool.Parse(request["_search"] ?? "false"), PageIndex = int.Parse(request["page"] ?? "1"), PageSize = int.Parse(request["rows"] ?? "50"), SortColumn = request["sidx"] ?? "", SortOrder = request["sord"] ?? "asc", Where = filters }; DataTable dtPage = AdminDocumets.GetPage(gridSettings, UserId, departmentId); JqGridResults jqGridResults = AdminDocumets.BuildJqGridResults(dtPage, gridSettings); _context.Response.Clear(); RtfDocument rtf = new RtfDocument(); rtf.FontTable.Add(new RtfFont("Times New Roman")); RtfFormattedParagraph header = new RtfFormattedParagraph(new RtfParagraphFormatting(14, RtfTextAlign.Center)); header.AppendText(""); header.AppendParagraph(); RtfTable tbl = new RtfTable(RtfTableAlign.Center, 8, dtPage.Rows.Count + 1); tbl.Width = TwipConverter.ToTwip(489, MetricUnit.Point); tbl.DefaultCellStyle = new RtfTableCellStyle(RtfBorderSetting.All, new RtfParagraphFormatting(12, RtfTextAlign.Center)); tbl.Columns[0].Width = TwipConverter.ToTwip(14, MetricUnit.Point); tbl.Columns[1].Width = TwipConverter.ToTwip(60, MetricUnit.Point); tbl.Columns[2].Width = TwipConverter.ToTwip(30, MetricUnit.Point); tbl.Columns[3].Width = TwipConverter.ToTwip(30, MetricUnit.Point); tbl.Columns[4].Width = TwipConverter.ToTwip(30, MetricUnit.Point); tbl.Columns[5].Width = TwipConverter.ToTwip(70, MetricUnit.Point); tbl.Columns[5].DefaultCellStyle = new RtfTableCellStyle(RtfBorderSetting.All, new RtfParagraphFormatting(12, RtfTextAlign.Left)); tbl.Columns[6].Width = TwipConverter.ToTwip(85, MetricUnit.Point); tbl.Columns[6].DefaultCellStyle = new RtfTableCellStyle(RtfBorderSetting.All, new RtfParagraphFormatting(12, RtfTextAlign.Left)); tbl.Columns[7].Width = TwipConverter.ToTwip(170, MetricUnit.Point); tbl.Columns[7].DefaultCellStyle = new RtfTableCellStyle(RtfBorderSetting.All, new RtfParagraphFormatting(10, RtfTextAlign.Left)); foreach (RtfTableRow row in tbl.Rows) { row.Height = TwipConverter.ToTwip(20, MetricUnit.Point); } tbl.Rows[0].Height = TwipConverter.ToTwip(30, MetricUnit.Point); //tbl.Rows[0].Cells[5].Formatting = new RtfParagraphFormatting(12, RtfTextAlign.Center); tbl[0, 0].AppendText(""); tbl[1, 0].AppendText("Дата створення"); tbl[2, 0].AppendText("Шифр"); tbl[3, 0].AppendText("№"); tbl[4, 0].AppendText("№ внутрішній"); tbl[5, 0].AppendText("№ в організації"); tbl[6, 0].AppendText("Організація"); tbl[7, 0].AppendText("Зміст"); int numRow = 1; foreach (JqGridRow dr in jqGridResults.rows) { tbl[0, numRow].AppendText(numRow.ToString()); tbl[1, numRow].AppendText(dr.cell[2]); tbl[2, numRow].AppendText(dr.cell[16]); tbl[3, numRow].AppendText(dr.cell[3]); tbl[4, numRow].AppendText(dr.cell[23]); tbl[5, numRow].AppendText(dr.cell[4]); tbl[6, numRow].AppendText(dr.cell[19]); tbl[7, numRow].AppendText(dr.cell[5]); numRow++; } RtfFormattedParagraph footer = new RtfFormattedParagraph(new RtfParagraphFormatting(14, RtfTextAlign.Left)); footer.AppendParagraph(); footer.AppendText(String.Format("Список станом на ")); footer.AppendParagraph(); footer.AppendText(String.Format("Всього документів: {0}", dtPage.Rows.Count)); footer.AppendParagraph(); footer.AppendText("Виконав ______________________"); rtf.Contents.AddRange(new RtfDocumentContentBase[] { header, tbl, footer }); RtfWriter rtfWriter = new RtfWriter(); StringBuilder sb = new StringBuilder(); using (TextWriter writer = new StringWriter(sb)) { rtfWriter.Write(writer, rtf); } string fileName = String.Format("docTempates_({0}).rtf", DateTime.Now.ToString("yyyy.MM.dd")); _context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); _context.Response.ContentType = "application/rtf"; _context.Response.Write(sb.ToString()); }
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 void ParceRequest() { HttpRequest r = _context.Request; HttpResponse res = _context.Response; string type = r["type"]; string jdata = r["jdata"]; string rResult = String.Empty; if (!String.IsNullOrWhiteSpace(type)) { switch (type) { case "getblank": if (!String.IsNullOrWhiteSpace(jdata)) { int id; if (int.TryParse(jdata, out id)) { rResult = GetDocTemplateBlank(id); } else { throw new ArgumentException("Inuput id is not valid", "jdata"); } } else { throw new ArgumentNullException("jdata", "Inuput id is not valid"); } break; case "getpage": int departmentId = Convert.ToInt32(r["departmentID"]); PageSettings gridSettings = JqGridSettings.GetPageSettings(_context); DataTable dtPage = WorkerDocumets.GetPage(gridSettings, UserId, Worker.DepartmentID); JqGridResults jqGridResults = WorkerDocumets.BuildPageResults(dtPage, gridSettings); rResult = new JavaScriptSerializer().Serialize(jqGridResults); break; case "getoutputpage": rResult = GetOutputPage(r); break; case "getdraftpage": rResult = GetDraftPage(r); break; case "getreplaypage": rResult = GetReplayPage(r); break; case "draft": if (!String.IsNullOrWhiteSpace(jdata)) { DocTemplate docTemplate = null; try { docTemplate = JsonConvert.DeserializeObject <DocTemplate>(jdata, new DateTimeConvertorSql()); } catch (Exception) { throw new CustomException.CustomException("Not valid json object"); } if (docTemplate.ID == 0) { ProcessingResult pr = InsertDocTemplate(docTemplate); rResult = new JavaScriptSerializer().Serialize(pr); } else { ProcessingResult pr = UpdateDocTemplate(docTemplate); rResult = new JavaScriptSerializer().Serialize(pr); } } else { throw new ArgumentNullException("jdata", "Inuput id is not valid"); } break; case "del": if (!String.IsNullOrWhiteSpace(jdata)) { int id; if (int.TryParse(jdata, out id)) { ProcessingResult pr = DeleteDocTemplate(id); rResult = new JavaScriptSerializer().Serialize(pr); } else { throw new ArgumentException("Inuput id is not valid", "jdata"); } } else { throw new ArgumentNullException("jdata", "Inuput id is not valid"); } break; case "getstpage": rResult = GetStatementsPage(r); break; case "getstblank": if (!String.IsNullOrWhiteSpace(jdata)) { int id; if (int.TryParse(jdata, out id)) { rResult = GetDocStatementBlank(id); } else { throw new ArgumentException("Inuput id is not valid", "jdata"); } } else { throw new ArgumentNullException("jdata", "Inuput id is not valid"); } break; case "getstcount": int departmentId2 = Convert.ToInt32(r["dep"]); rResult = WorkerDocumets.GetCountNotOpenByDocStatement(UserId, departmentId2).ToString(); break; case "getdtcount": int departmentId3 = Convert.ToInt32(r["dep"]); rResult = WorkerDocumets.GetCountNotOpenByDocTemplate(UserId, departmentId3).ToString(); break; case "getstconcount": int departmentId4 = Convert.ToInt32(r["dep"]); rResult = WorkerDocumets.GetCountControlledByDocStatement(UserId, departmentId4).ToString(); break; case "getdtconcount": int departmentId5 = Convert.ToInt32(r["dep"]); rResult = WorkerDocumets.GetCountControlledByDocTemplate(UserId, departmentId5).ToString(); break; case "openworker": int controlCardId = 0; int documentId = 0; if (String.IsNullOrWhiteSpace(r["DocumentID"])) { throw new ArgumentNullException("DocumentID", "Inuput controlCardId is not valid"); } else { documentId = Convert.ToInt32(r["DocumentID"]); } if (!String.IsNullOrWhiteSpace(r["ControlCardID"])) { controlCardId = Convert.ToInt32(r["ControlCardID"]); } if (documentId > 0) { rResult = SetOpenWorker(documentId, controlCardId).ToString(); } else { throw new ArgumentException("Inuput DocumentID is not valid", "DocumentID"); } break; } if (!String.IsNullOrWhiteSpace(rResult)) { res.Write(rResult); } } }
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); }