public JSDataTable GetJsDataTable() { JSDataTable jsdatatable = new JSDataTable(); List <JSDataTableColumnDescription> columns = new List <JSDataTableColumnDescription>(); for (int col = 0; col < dt.Columns.Count; col++) { JSDataTableColumnDescription column = new JSDataTableColumnDescription(); try { if (columnLabels[col].Trim() != "" && columnLabels[col] != null) { column.sTitle = columnLabels[col]; } else { column.sTitle = dt.Columns[col].ColumnName; } } catch { column.sTitle = dt.Columns[col].ColumnName; } if (dt.Columns[col].DataType == Type.GetType("System.DateTime")) { column.sType = "date"; } if (this.expandedColumns.Contains(column.sTitle)) { column.bDetail = true; column.bVisible = false; } columns.Add(column); } if (this.expandedColumns.Count() > 0 && this.expandedColumns.First().Trim() != "") { JSDataTableColumnDescription column = new JSDataTableColumnDescription(); column.sTitle = ""; column.bSortable = false; column.sClass = "center"; columns.Insert(0, column); } jsdatatable.columns = columns.ToArray(); object[] data = new object[dt.Rows.Count]; for (int row = 0; row < dt.Rows.Count; row++) { List <object> arr = new List <object>(); for (int col = 0; col < dt.Columns.Count; col++) { if (dt.Columns[col].DataType == Type.GetType("System.DateTime")) { if (dt.Rows[row][col] != DBNull.Value) { arr.Add(Convert.ToDateTime(dt.Rows[row][col]).ToShortDateString()); } else { arr.Add(""); } } else { arr.Add(dt.Rows[row][col]); } } if (this.expandedColumns.Count() > 0 && this.expandedColumns.First().Trim() != "") { arr.Insert(0, "<img src='" + HttpContext.Current.Request.ApplicationPath + "/ClientConfig/images/datatables/details_open.png'>"); } data[row] = arr.ToArray(); } jsdatatable.data = data; return(jsdatatable); }
public JSDataTable GetJsDataTable() { JSDataTable jsdatatable = new JSDataTable(); List<JSDataTableColumnDescription> columns = new List<JSDataTableColumnDescription>(); for (int col = 0; col < dt.Columns.Count; col++) { JSDataTableColumnDescription column = new JSDataTableColumnDescription(); try { if (columnLabels[col].Trim() != "" && columnLabels[col] != null) column.sTitle = columnLabels[col]; else column.sTitle = dt.Columns[col].ColumnName; } catch { column.sTitle = dt.Columns[col].ColumnName; } if (dt.Columns[col].DataType == Type.GetType("System.DateTime")) { column.sType = "date"; } if (this.expandedColumns.Contains(column.sTitle)) { column.bDetail = true; column.bVisible = false; } columns.Add(column); } if (this.expandedColumns.Count() > 0 && this.expandedColumns.First().Trim() != "") { JSDataTableColumnDescription column = new JSDataTableColumnDescription(); column.sTitle = ""; column.bSortable = false; column.sClass = "center"; columns.Insert(0, column); } jsdatatable.columns = columns.ToArray(); object[] data = new object[dt.Rows.Count]; for (int row = 0; row < dt.Rows.Count; row++) { List<object> arr = new List<object>(); for (int col = 0; col < dt.Columns.Count; col++) { if (dt.Columns[col].DataType == Type.GetType("System.DateTime")) { if (dt.Rows[row][col] != DBNull.Value) arr.Add(Convert.ToDateTime(dt.Rows[row][col]).ToShortDateString()); else arr.Add(""); } else { arr.Add(dt.Rows[row][col]); } } if (this.expandedColumns.Count() > 0 && this.expandedColumns.First().Trim() != "") { arr.Insert(0, "<img src='" + HttpContext.Current.Request.ApplicationPath + "/ClientConfig/images/datatables/details_open.png'>"); } data[row] = arr.ToArray(); } jsdatatable.data = data; return jsdatatable; }