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