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