private void DoQuery()
{
List<SqlParameter> paramValues = new List<SqlParameter>();
string condition = "Where 1=1";
JsonTable jsonTable = new JsonTable();
if (GetParam("GameUserID").Length > 0)
{
condition += " and UserID=@UserID";
paramValues.Add(SqlParamHelper.MakeInParam("@UserID", SqlDbType.VarChar, 0, GetParam("GameUserID")));
}
if (GetParam("IsTasked").Length > 0)
{
condition += " and IsTasked=@IsTasked";
paramValues.Add(SqlParamHelper.MakeInParam("@IsTasked", SqlDbType.Bit, 0, GetParamAsInt("IsTasked")));
}
if (GetParam("FromDate").Length > 0)
{
condition += " and CreateDate>=@fromDate";
paramValues.Add(SqlParamHelper.MakeInParam("@fromDate", SqlDbType.VarChar, 0, GetParam("FromDate")));
}
if (GetParam("ToDate").Length > 0)
{
condition += " and CreateDate<=@toDate";
paramValues.Add(SqlParamHelper.MakeInParam("@toDate", SqlDbType.VarChar, 0, GetParam("ToDate")));
}
var service = new DdzDataService(GameID, ServerID);
AppendPageParam(paramValues, PageIndex, PageSize);
var getter = service.Get<PrizeGetter>(condition, PageIndex, PageSize, paramValues);
jsonTable.rows = getter.GetData();
jsonTable.total = getter.RecordCount;
_context.Response.Write(jsonTable.ToJson());
}
public void Map_Null_ReturnsNull()
{
var mapper = CreateMapper();
JsonTable actual = mapper.Map(null);
Check.That(actual).IsNull();
}
public Column(RectTransform container, string title)
{
cells = new List <Cell>();
lblHeader = JsonTable.CreateInstance(container);
lblHeader.fontStyle = FontStyles.Bold;
lblHeader.text = title;
lblHeader.name = $"Column - {title}";
trColumn = lblHeader.GetComponent <RectTransform>();
}
public JsonTableExcelResult(JsonExcelParameter parameter)
{
_arg = parameter;
_jTable = _arg.Table;
_workbook = new Workbook();
_worksheet = _workbook.Worksheets[0];
_worksheet.Name = _arg.TableName.Length > 30 ? _arg.TableName.Substring(0, 30) : _arg.TableName;
_cells = _worksheet.Cells;
BuildStyle();
}
private void DoQuery()
{
List <SqlParameter> paramValues = new List <SqlParameter>();
string condition = "Where 1=1";
JsonTable jsonTable = new JsonTable();
if (GetParam("NickName").Length > 0)
{
condition += " and NickName like @NickName";
paramValues.Add(SqlParamHelper.MakeInParam("@NickName", SqlDbType.VarChar, 0, "%" + GetParam("NickName") + "%"));
}
if (GetParam("Pid").Length > 0)
{
condition += " and Pid=@Pid";
paramValues.Add(SqlParamHelper.MakeInParam("@Pid", SqlDbType.VarChar, 0, GetParam("Pid")));
}
if (GetParam("UserStatus").Length > 0)
{
condition += " and UserStatus=@UserStatus";
paramValues.Add(SqlParamHelper.MakeInParam("@UserStatus", SqlDbType.VarChar, 0, GetParam("UserStatus")));
}
if (GetParam("MsgState").Length > 0)
{
condition += " and MsgState=@MsgState";
paramValues.Add(SqlParamHelper.MakeInParam("@MsgState", SqlDbType.VarChar, 0, GetParam("MsgState")));
}
if (GetParam("fromDate").Length > 0)
{
condition += " and CreateDate>=@fromDate";
paramValues.Add(SqlParamHelper.MakeInParam("@fromDate", SqlDbType.VarChar, 0, GetParam("fromDate")));
}
if (GetParam("toDate").Length > 0)
{
condition += " and CreateDate<=@toDate";
paramValues.Add(SqlParamHelper.MakeInParam("@toDate", SqlDbType.VarChar, 0, GetParam("toDate")));
}
if (IsChannel)
{
condition += " and RetailID=@ChannelID";
paramValues.Add(SqlParamHelper.MakeInParam("@ChannelID", SqlDbType.VarChar, 0, EmpRetailId));
}
var service = new DdzDataService(GameID, ServerID);
AppendPageParam(paramValues, PageIndex, PageSize);
var getter = service.Get <UserGetter>(condition, PageIndex, PageSize, paramValues);
jsonTable.rows = getter.GetData();
jsonTable.total = getter.RecordCount;
_context.Response.Write(jsonTable.ToJson());
}
private void DoQuery()
{
List<SqlParameter> paramValues = new List<SqlParameter>();
string condition = "Where 1=1";
JsonTable jsonTable = new JsonTable();
if (GetParam("NickName").Length > 0)
{
condition += " and NickName like @NickName";
paramValues.Add(SqlParamHelper.MakeInParam("@NickName", SqlDbType.VarChar, 0, "%" + GetParam("NickName") + "%"));
}
if (GetParam("Pid").Length > 0)
{
condition += " and Pid=@Pid";
paramValues.Add(SqlParamHelper.MakeInParam("@Pid", SqlDbType.VarChar, 0, GetParam("Pid")));
}
if (GetParam("UserStatus").Length > 0)
{
condition += " and UserStatus=@UserStatus";
paramValues.Add(SqlParamHelper.MakeInParam("@UserStatus", SqlDbType.VarChar, 0, GetParam("UserStatus")));
}
if (GetParam("MsgState").Length > 0)
{
condition += " and MsgState=@MsgState";
paramValues.Add(SqlParamHelper.MakeInParam("@MsgState", SqlDbType.VarChar, 0, GetParam("MsgState")));
}
if (GetParam("fromDate").Length > 0)
{
condition += " and CreateDate>=@fromDate";
paramValues.Add(SqlParamHelper.MakeInParam("@fromDate", SqlDbType.VarChar, 0, GetParam("fromDate")));
}
if (GetParam("toDate").Length > 0)
{
condition += " and CreateDate<=@toDate";
paramValues.Add(SqlParamHelper.MakeInParam("@toDate", SqlDbType.VarChar, 0, GetParam("toDate")));
}
if (IsChannel)
{
condition += " and RetailID=@ChannelID";
paramValues.Add(SqlParamHelper.MakeInParam("@ChannelID", SqlDbType.VarChar, 0, EmpRetailId));
}
var service = new DdzDataService(GameID, ServerID);
AppendPageParam(paramValues, PageIndex, PageSize);
var getter = service.Get<UserGetter>(condition, PageIndex, PageSize, paramValues);
jsonTable.rows = getter.GetData();
jsonTable.total = getter.RecordCount;
_context.Response.Write(jsonTable.ToJson());
}
public static string ToJson(object Target)
{
var s = new System.Web.Script.Serialization.JavaScriptSerializer();
s.MaxJsonLength = int.MaxValue; //Change to Max Length (Huge 4 MB!!!)
if (Target != null && Target.GetType().Equals(typeof(System.Data.DataSet)))
{
#region Serializacion Especial para un Dataset
System.Data.DataSet dsToFragment = (System.Data.DataSet)Target;
List <JsonTable> JsonDataset = new List <JsonTable>();
foreach (System.Data.DataTable dtable in dsToFragment.Tables)
{
JsonTable _jsonTable = new JsonTable();
//--------------------------------------------------------------------------------------------------
//----[ Add Reference to Columns
_jsonTable.columns = new List <JsonTable.JsonColumn>();
foreach (System.Data.DataColumn col in dtable.Columns)
{
JsonTable.JsonColumn column = new JsonTable.JsonColumn();
column.datattype = col.DataType.ToString();
column.name = col.ColumnName;
_jsonTable.columns.Add(column);
}
//--------------------------------------------------------------------------------------------------
//--------------------------------------------------------------------------------------------------
//----[ Add rows data
_jsonTable.rows = new List <object[]>();
foreach (System.Data.DataRow row in dtable.Rows)
{
_jsonTable.rows.Add(row.ItemArray);
}
//--------------------------------------------------------------------------------------------------
JsonDataset.Add(_jsonTable);
}
return((s).Serialize(JsonDataset));
#endregion
}
else
{
return((s).Serialize(Target));
}
}
public JsonTableGroupExcelResult(JsonExcelParameter parameter)
{
_arg = parameter;
_jTable = _arg.Table;
_workbook = new Workbook();
_worksheet = _workbook.Worksheets[0];
_worksheet.Name = _arg.TableName.Length > 30 ? _arg.TableName.Substring(0, 30) : _arg.TableName;
_cells = _worksheet.Cells;
_isSumRowColumnName = parameter.totalColumns;
_sumGroupColumnName = parameter.sumGroupColumnName;
_isTotal = parameter.isTotal;
if (!string.IsNullOrEmpty(_sumGroupColumnName))
{
GroupJtable(_sumGroupColumnName, _isTotal, _isSumRowColumnName);
}
BuildStyle();
}
/// <summary>
/// Parse the language out of a JSON string.
/// </summary>
/// <param name="_JSON">The JSON string to load.</param>
public bool Load(string _JSON)
{
if (_JSON.Length <= 2)
{
return(false);
}
JsonObject obj = Json.Decode(_JSON);
JsonTable tbl = obj.ToTable();
foreach (string key in tbl.Keys)
{
texts.Add(key, (string)tbl[key]);
}
return(true);
}
private JsonTable BuildBondIssuMaturesTopTable(DataTable table)
{
var jTable = new JsonTable();
var headers = GetIssuMaturesTopTableHeaders();
var columns = GetIssuMaturesTopTableColumns();
for (int i = 0; i < headers.Length; i++)
{
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = columns[i], Name = headers[i]
});
}
var typeName = "TypeCn";
var subTypeName = "SubTypeCn";
if (CultureHelper.IsEnglishCulture())
{
typeName = "TypeEn";
subTypeName = "SubTypeEn";
}
foreach (DataRow row in table.Rows)
{
var currentRow = new Dictionary <string, string>
{
{ "TypeValue", row["Type"].ToString() },
{ "Type", row[typeName].ToString() },
{ "SubType", row[subTypeName].ToString() },
{ "SubTypeValue", row["SubType"].ToString() },
{ "isParent", row["isParent"].ToString() },
{ "EndBalance", UIGenerator.FormatCellValue(row["EndBalance"], "decimal") },
{ "InitialBalance", UIGenerator.FormatCellValue(row["InitialBalance"], "decimal") },
{ "Issues", row["Issues"].ToString() },
{ "IssuesPercent", UIGenerator.FormatCellValue(row["IssuesPercent"], "decimal") },
{ "IssuesAmount", UIGenerator.FormatCellValue(row["IssuesAmount"], "decimal") },
{ "IssuesAmountPercent", UIGenerator.FormatCellValue(row["IssuesAmountPercent"], "decimal") },
{ "MaturityBonds", row["MaturityBonds"].ToString() },
{ "MaturityAmount", UIGenerator.FormatCellValue(row["MaturityAmount"], "decimal") },
{ "EndIssues", row["EndIssues"].ToString() },
{ "EndIssuesPercent", UIGenerator.FormatCellValue(row["EndIssuesPercent"], "decimal") }
};
jTable.RowData.Add(currentRow);
}
return(jTable);
}
private IEnumerator SendScores(bool _Multiplayer, string _Mode, CScoreEntry[] _Entries)
{
// Generate json table
JsonTable info = new JsonTable();
info.Add("multiplayer", _Multiplayer);
info.Add("mode", _Mode);
info.Add("count", _Entries.Length);
JsonTable entry;
for (int i = 0; i < _Entries.Length; i++)
{
entry = new JsonTable();
entry.Add("name", _Entries[i].Name.Replace(" ", ""));
entry.Add("score", _Entries[i].Score);
entry.Add("time", Mathf.Round(_Entries[i].TotalTime * 100.0f) / 100.0f);
info.Add("entry" + i, entry);
}
//Debug.Log("Json: " + info.ToJson());
// Get complete url
string json = UploadScoresURL + "?json=" + info.ToJson();
Debug.Log("URL: " + json);
// Send string to server
WWW post = new WWW(json);
//Debug.Log("URL: " + post.url);
// Await response
yield return(post);
if (post.error != null)
{
Debug.LogError("CScoreCommunicator::SendScores - Error uploading scores to '" + UploadScoresURL + "' with data '" + info.ToJson() + "'. Error: " + post.error);
}
else
{
Debug.Log("CScoreCommunicator::SendScores - Uploaded scores with result: " + post.text);
}
}
public JsonTable BuidJsonTable(DataTable table)
{
var jTable = new JsonTable();
var columns = new string[table.Columns.Count];
for (int i = 0; i < table.Columns.Count; i++)
{
columns[i] = table.Columns[i].ColumnName;
}
foreach (DataRow row in table.Rows)
{
var currentRow = new Dictionary <string, string>();
foreach (var column in columns)
{
currentRow.Add(column, row[column].ToString());
}
jTable.RowData.Add(currentRow);
}
return(jTable);
}
public ActionResult CategorySidevar(int datavalue)
{
List <JsonTable> jsonData = new List <JsonTable>();
var data = _repo.GetCategoryWithDeptId(datavalue).ToList();
for (var i = 0; i < data.Count(); i++)
{
var id = data[i].Id.ToString();
JsonTable datanew = new JsonTable()
{
Id = data[i].Id.ToString(),
Name = data[i].Name
};
jsonData.Add(datanew);
}
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
private JsonTable BuildHomeItemTable(DataTable table, int total, int startPage, int pageSize)
{
var jTable = new JsonTable();
jTable.CurrentPage = startPage;
jTable.PageSize = pageSize;
jTable.Total = total;
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "MODULENAME", Name = "MODULENAME", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "NAMECN", Name = "NAMECN", ColumnStyle = "width: 200px; overflow: hidden; text-overflow: ellipsis; display: inline-block;", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "NAMEEN", Name = "NAMEEN", ColumnStyle = "width: 200px; overflow: hidden; text-overflow: ellipsis; display: inline-block;", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "TYPE", Name = "TYPE", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "TYPEVALUE", Name = "TYPEVALUE", ColumnStyle = "width: 200px; overflow: hidden; text-overflow: ellipsis; display: inline-block;", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "MTIME", Name = "MTIME", ColumnType = "text"
});
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = "ID", Name = "ID"
});
for (int j = 0; j < table.Rows.Count; j++)
{
var currentRow = new Dictionary <string, string>();
for (int i = 0; i < jTable.ColumTemplate.Count; i++)
{
currentRow.Add(jTable.ColumTemplate[i].ColumnName, table.Rows[j][jTable.ColumTemplate[i].ColumnName].ToString());
}
jTable.RowData.Add(currentRow);
}
return(jTable);
}
private void DoQuery()
{
List <SqlParameter> paramValues = new List <SqlParameter>();
string condition = "Where 1=1";
JsonTable jsonTable = new JsonTable();
if (GetParam("GameUserID").Length > 0)
{
condition += " and UserID=@UserID";
paramValues.Add(SqlParamHelper.MakeInParam("@UserID", SqlDbType.VarChar, 0, GetParam("GameUserID")));
}
if (GetParam("IsTasked").Length > 0)
{
condition += " and IsTasked=@IsTasked";
paramValues.Add(SqlParamHelper.MakeInParam("@IsTasked", SqlDbType.Bit, 0, GetParamAsInt("IsTasked")));
}
if (GetParam("FromDate").Length > 0)
{
condition += " and CreateDate>=@fromDate";
paramValues.Add(SqlParamHelper.MakeInParam("@fromDate", SqlDbType.VarChar, 0, GetParam("FromDate")));
}
if (GetParam("ToDate").Length > 0)
{
condition += " and CreateDate<=@toDate";
paramValues.Add(SqlParamHelper.MakeInParam("@toDate", SqlDbType.VarChar, 0, GetParam("ToDate")));
}
var service = new DdzDataService(GameID, ServerID);
AppendPageParam(paramValues, PageIndex, PageSize);
var getter = service.Get <PrizeGetter>(condition, PageIndex, PageSize, paramValues);
jsonTable.rows = getter.GetData();
jsonTable.total = getter.RecordCount;
_context.Response.Write(jsonTable.ToJson());
}
private new JsonTable BuidJsonTable(DataTable table, IEnumerable <REPORTCOLUMNDEFINITION> colTemplate, int total, int currentPage, int pageSize)
{
var jTable = new JsonTable();
jTable.CurrentPage = currentPage;
jTable.PageSize = pageSize;
jTable.Total = total;
foreach (var column in colTemplate)
{
jTable.ColumTemplate.Add(new JsonColumn {
ColumnName = column.COLUMN_NAME, ColumnType = column.COLUMN_TYPE, Name = column.DisplayName
});
}
var columns = new string[table.Columns.Count];
for (int i = 0; i < table.Columns.Count; i++)
{
columns[i] = table.Columns[i].ColumnName;
}
foreach (DataRow row in table.Rows)
{
var currentRow = new Dictionary <string, string>();
foreach (var column in columns)
{
if (column == "PUBLISHED")
{
currentRow.Add(column, Convert.ToDateTime(row[column]).ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
currentRow.Add(column, row[column].ToString());
}
}
jTable.RowData.Add(currentRow);
}
return(jTable);
}
public DimSumBondData(List <Dictionary <string, string> > topTable, ChartData chart, JsonTable bottomTable)
{
this.TopTable = topTable;
this.Chart = chart;
this.BottomTable = bottomTable;
}
/// <summary>
/// Converts Google.Analytics.DataFeed into a JsonDataTable
/// </summary>
/// <param name="jsKey">a unique key for the javascript variable. variable is created as var {jsKey}_JsonTable = {};</param>
/// <returns></returns>
public string ResultsAsJsonTable(string jsKey)
{
string x = queryResults.ToString();
if (queryResults.Entries.Count == 0)
{
return("{}");
}
JsonTable tab = new JsonTable(jsKey);
int idx = 0;
foreach (DataEntry entry in queryResults.Entries)
{
JsonRow row = new JsonRow();
foreach (Dimension dimension in entry.Dimensions)
{
if (idx == 0)
{
tab.Columns.Add(new JsonColumn()
{
ID = dimension.Name, Label = getLabelFriendlyName(dimension.Name), Type = JsonType.STRING
});
}
JsonCell cell = new JsonCell();
cell.Type = JsonType.STRING;
int valAsNumDate;
if (int.TryParse(dimension.Value, out valAsNumDate))
{
string year = dimension.Value.Substring(0, 4);
string month = dimension.Value.Substring(4, 2);
string day = dimension.Value.Substring(6);
cell.Value = month + '/' + day + '/' + year;
}
else
{
cell.Value = dimension.Value;
}
row.Cells.Add(cell);
}
foreach (Metric metric in entry.Metrics)
{
if (idx == 0)
{
tab.Columns.Add(new JsonColumn()
{
ID = metric.Name, Label = getLabelFriendlyName(metric.Name), Type = JsonType.NUMBER
});
}
JsonCell cell = new JsonCell();
cell.Type = JsonType.NUMBER;
cell.Value = metric.Value;
row.Cells.Add(cell);
}
idx++;
tab.Rows.Add(row);
}
return(tab.ToString());
}
public IssueTrendData(JsonTable topTable, object chart, JsonTable bottomTable)
{
TopTable = topTable;
Chart = chart;
BottomTable = bottomTable;
}
private JsonTable BuildDetailJsonTable(string period, string viewBy, int years, string unit, int id, string page)
{
var issuerFundamental = _repository.GetFoundamentalData(page, id, period, viewBy, years, unit);
if (issuerFundamental == null || issuerFundamental.Count() == 0)
{
return(new JsonTable());
}
var startYear = issuerFundamental.Min(f => f.EndDate).Year;
var endYear = issuerFundamental.Max(f => f.EndDate).Year;
var jTable = new JsonTable();
jTable.RowData = ConvertToRowData(issuerFundamental, page, period);
if (period == "Y")
{
jTable.ColumTemplate.Add(new JsonColumn {
Name = Resources.Global.Fundation_PeriodEndDate, ColumnName = "Item"
});
for (int i = endYear; i >= startYear; i--)
{
var endDates = issuerFundamental.Where(f => f.EndDate.Year == i).Select(f => f.EndDate).FirstOrDefault();
if (endDates == null)
{
continue;
}
jTable.ColumTemplate.Add(new JsonColumn {
Name = endDates.ToString("yyyy-MM-dd"), ColumnName = "Y" + i.ToString()
});
}
}
else
{
jTable.ExtraHeaders = new List <JsonExtraColumn> {
new JsonExtraColumn {
Name = string.Empty, ColSpan = 1
}
};
jTable.ColumTemplate.Add(new JsonColumn {
Name = Resources.Global.Fundation_PeriodEndDate, ColumnName = "Item"
});
for (var i = endYear; i >= startYear; i--)
{
var endDates = issuerFundamental.Where(f => f.EndDate.Year == i).OrderByDescending(f => f.EndDate).Select(f => f.EndDate).ToList();
if (endDates == null)
{
continue;
}
jTable.ExtraHeaders.Add(new JsonExtraColumn {
Name = i.ToString(), ColSpan = endDates.Count()
});
for (var j = 0; j < endDates.Count(); j++)
{
jTable.ColumTemplate.Add(new JsonColumn
{
Name = endDates.ElementAt(j).ToString("yyyy-MM-dd"),
ColumnName =
"Y" + i + "Q" +
(Convert.ToInt32(endDates.ElementAt(j).Month) / 3)
});
}
}
}
return(jTable);
}
private static string GetIsaBreakdownJson(string isaCsv)
{
if (isaCsv == null)
{
return(null);
}
var tableRows = new List <JsonTableRow>();
using (var reader = new StringReader(isaCsv))
using (var csv = new CsvReader(reader, new CsvHelper.Configuration.Configuration {
HasHeaderRecord = false
}))
{
while (csv.Read())
{
var field0 = csv.GetField(0);
string field1, field2, field3, field4;
if (field0.Contains("label"))
{
field1 = field2 = field3 = field4 = "";
}
else
{
field1 = csv.GetField(1);
field2 = csv.GetField(2);
field3 = csv.GetField(3);
field4 = csv.GetField(4);
}
tableRows.Add(new JsonTableRow
{
Data = new[]
{
field0,
field1,
field2,
field3,
field4
//csv.GetField(5),
}
});
}
}
var table = new JsonTable
{
Header = new JsonTableRow
{
Data = new[]
{
"Offset",
"OpCode",
"Parameters",
"Category",
"Cycles",
//"Binary"
}
},
Rows = tableRows
};
return(table.ToJson());
}
private JsonTable BuildBondIssuMaturesChartDataForExcel(string rate, string columnType, DateTime start, DateTime end, string category, string itemList, string unit, int isUseSubCategory = 0, string subCategory = "Bond_Class", string subCategoryValue = "", bool isTotal = false)
{
var jTable = new JsonTable();
var typeName = "TypeCn";
var subTypeName = "SubTypeCn";
if (CultureHelper.IsEnglishCulture())
{
typeName = "TypeEn";
subTypeName = "SubTypeEn";
}
var yearsDic = new Dictionary <string, DataTable>();
var dates = PopulateRateTimes(start, end, rate);
for (var i = 0; i < dates.Count; i += 2)
{
var currentStart = dates[i];
var currentEnd = dates[i + 1];
var summaryData = BondReportRepository.GetBondDepositoryBalanceChart(columnType, currentStart, currentEnd, category, itemList, unit, isUseSubCategory, subCategory, subCategoryValue);
yearsDic.Add(rate == "y" ? currentEnd.ToString("yyyy") : currentEnd.ToString("yyyy-M"), summaryData);
}
var rows = yearsDic.FirstOrDefault().Value.Rows;
var typeList = new Dictionary <string, string>();
string header;
foreach (DataRow row in rows)
{
header = (string.IsNullOrEmpty(subCategoryValue) || subCategoryValue == "undefined")
? row[typeName].ToString()
: String.Format("{0}({1})", row[typeName], row[subTypeName]);
typeList.Add(row["Type"].ToString(), header);
}
jTable.ColumTemplate.Add(new JsonColumn {
Name = Resources.Global.Date, ColumnName = "Date"
});
if (!isTotal)
{
foreach (var t in typeList)
{
jTable.ColumTemplate.Add(new JsonColumn {
Name = t.Value, ColumnName = t.Key + "_" + t.Value
});
}
}
else
{
jTable.ColumTemplate.Add(new JsonColumn {
Name = Resources.Global.Total, ColumnName = "Total"
});
}
foreach (var f in yearsDic)
{
var currentRow = new Dictionary <string, string>();
currentRow.Add("Date", f.Key);
if (isTotal)
{
double total = 0;
foreach (DataRow v in f.Value.Rows)
{
total += Convert.ToDouble(v[columnType]);
}
currentRow.Add("Total", total.ToString(CultureInfo.InvariantCulture));
}
else
{
foreach (DataRow v in f.Value.Rows)
{
var name = (string.IsNullOrEmpty(subCategoryValue) || subCategoryValue == "undefined")
? v[typeName]
: String.Format("{0}({1})", v[typeName], v[subTypeName]);
currentRow.Add(v["Type"] + "_" + name, v[columnType].ToString());
}
}
jTable.RowData.Add(currentRow);
}
return(jTable);
}
public JsonTable buildJsonTable(BaseReport report)
{
var table = new JsonTable();
switch (report.GetType().Name)
{
case "StandardReport":
var data = (StandardReport)report;
if (data.ResultDataTable.Rows.Count > 0)
{
table.ReportDate = ((DateTime)data.ResultDataTable.Rows[0]["REDATE"]).ToString("yyyy-MM");
}
foreach (var column in data.Columns)
{
table.ColumTemplate.Add(new JsonColumn()
{
ColumnName = column.ColumnName.ToLower(),
ColumnStyle = column.ColumnStyle,
ColumnType = column.ColumnType,
Name = column.Culture == "zh-CN" ? column.ColumnHeaderCN : column.ColumnHeaderEN
});
}
table.ExtraHeaders = new List <JsonExtraColumn>();
foreach (var extraHeader in data.ExtraHeaderCollection)
{
table.ExtraHeaders.Add(new JsonExtraColumn()
{
Name = extraHeader.Culture == "zh-CN" ? extraHeader.HeaderTextCN : extraHeader.HeaderTextEN,
ColumnStyle = extraHeader.HeaderStyle,
ColSpan = extraHeader.HeaderColumnSpan,
HeaderLevel = extraHeader.HeaderLevel
});
}
table.RowData = new List <Dictionary <string, string> >();
foreach (DataRow row in data.ResultDataTable.Rows)
{
var currentRow = new Dictionary <string, string>();
foreach (var column in data.Columns)
{
if (!currentRow.Keys.Contains(column.ColumnName))
{
currentRow.Add(column.ColumnName.ToLower(), UIGenerator.FormatCellValue(row, column));
}
}
if (row.Table.Columns.Contains("id"))
{
currentRow.Add("id", row["id"].ToString());
}
if (row.Table.Columns.Contains("last_update"))
{
currentRow.Add("last_update", row["last_update"].ToString());
}
if (row.Table.Columns.Contains("row_index"))
{
currentRow.Add("row_index", row["row_index"].ToString());
}
if (row.Table.Columns.Contains("chart_source"))
{
currentRow.Add("chart_source", row["chart_source"].ToString());
}
if (row.Table.Columns.Contains("row_level"))
{
currentRow.Add("row_level", row["row_level"].ToString());
}
table.RowData.Add(currentRow);
}
break;
}
return(table);
}
private IEnumerator RequestScores(bool _Multiplayer, string _Mode, int _Amount, ScoreDownloadHandler _Callback)
{
// Create JsonTable with necessary data
JsonTable info = new JsonTable();
info.Add("multiplayer", _Multiplayer);
info.Add("mode", _Mode);
info.Add("amount", _Amount);
//Debug.Log("Json: " + info.ToJson());
// Attach info to url
string json = GetScoresURL + "?json=" + info.ToJson();
//Debug.Log("URL: " + json);
// Load url
WWW get = new WWW(json);
// Await response
yield return(get);
if (get.error != null)
{
Debug.LogError("CScoreCommunicator::RequestScores - Error getting scores from '" + GetScoresURL + "' with data '" + info.ToJson() + "'. Error: " + get.error);
if (_Callback != null)
{
_Callback(null);
}
yield break;
}
json = get.text;
//Debug.Log("CScoreCommunicator::RequestScores - Recieved scores: " + text);
List <CScoreEntry> result = new List <CScoreEntry>(_Amount);
if (json.Length > 2)
{
JsonObject obj = Json.Decode(json);
info = obj.ToTable();
JsonTable entry;
for (int i = 0; i < _Amount; i++)
{
entry = info.GetSubtable("entry" + i);
if (entry != null)
{
result.Add(new CScoreEntry(entry.ToString("name"),
(float)entry.ToDouble("score"),
(float)entry.ToDouble("time"),
_Multiplayer,
_Mode,
i));
//Debug.Log("Entry " + i + ": " + entry["name"] + ", " + entry["score"] + ", " + entry["time"]);
}
else
{
result.Add(new CScoreEntry(_Multiplayer, _Mode[0].ToString().ToUpper(), i, false));
//Debug.Log("Entry " + i + ": No entry available.");
}
}
}
else
{
for (int i = 0; i < _Amount; i++)
{
result.Add(new CScoreEntry(_Multiplayer, _Mode[0].ToString().ToUpper(), i, false));
//Debug.Log("Entry " + i + ": No entry available.");
}
}
if (_Callback != null)
{
_Callback(result.ToArray());
}
}
