var beginDate = $("#in_FilledStartDate").val();
var endDate = $("#in_FilledEndDate").val();
var jsonData = '<%=jsonData%>';
var db = eval('(' + jsonData + ')');
var photosStr = new Array();
var btScore = 0;
var puyuScore = 0;
var jingfen = 0;
var GoldOxjf = 0;
for (var i = 0; i < db.Rows.length; i++) {
photosStr.push("<tr class=\"tdbg\" id=\"p" + i + "\" data-date=\"" + db.Rows[i].DateTime + "\" data-id=\"" + i + "\">");
photosStr.push("<td>" + db.Rows[i].DateTime + "</td>");
var kindidArry = db.Rows[i].KindID.split(',');
var scoreArray = db.Rows[i].Score.split(',');
var kindArray = arrStr.split(',');
var dataArray = {
data: Array(),
get: function (key) {
return this.data[key];
},
set: function (key, value) {
this.data[key] = value;
return;
}
}
for (var n = 0; n < kindidArry.length; n++) {
dataArray.set(kindidArry[n], scoreArray[n]);
}
for (var j = 0; j < kindArray.length; j++) {
if (typeof (dataArray.get(kindArray[j])) == "undefined") {
photosStr.push('<td>0</td>');
} else {
if (dataArray.get(kindArray[j]) == 0) {
photosStr.push('<td>0</td>');
} else {
if (kindArray[j] == 129) {
btScore = db.Rows[i].btScore;
jingfen = db.Rows[i].jfscore;
puyuScore = parseFloat(dataArray.get(kindArray[j])) + parseFloat(jingfen) + parseFloat(btScore);
photosStr.push('<td>' + (puyuScore).formatMoney() + '<span style="float:right;color:red;">∨</span></td>');
}
else if (kindArray[j] == 139) {
GoldOxjf = parseFloat(db.Rows[i].GoldOxjf);
photosStr.push('<td>' + (parseFloat(dataArray.get(kindArray[j])) - GoldOxjf).formatMoney() + '<span style="float:right;color:red;">∨</span></td>');
}
else {
photosStr.push('<td>' + parseFloat(dataArray.get(kindArray[j])).formatMoney() + '<span style="float:right;color:red;">∨</span></td>');
}
}
}
}
photosStr.push('<td>' + (parseFloat(db.Rows[i].TotalScore) + parseFloat(btScore) + parseFloat(jingfen) - GoldOxjf).formatMoney() + '</td>');
photosStr.push('</tr >');
}
$("#dataTable tbody").empty().append(photosStr.join(""));
$("#dataTable").show();
$("#dataTable tbody tr td").hover(function () { $(this).css("background-color", "#bfdfff") }, function () { $(this).css("background-color", "#E1F4EE") });
};
Number.prototype.formatMoney = function (places, symbol, thousand, decimal) {
places = !isNaN(places = Math.abs(places)) ? places : 0;
symbol = symbol !== undefined ? symbol : "";
thousand = thousand || ",";
decimal = decimal || ".";
var number = this,
negative = number < 0 ? "-" : "",
i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
j = (j = i.length) > 3 ? j % 3 : 0;
return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(0) : "");
};
select CONVERT(VARCHAR(50), KindID)+ ',' from tabled FOR XML PATH('')
把竖行的值转为横一列的逗号相隔
100,101,102,103,105,106,112,113,114,115
using System.Security;
using System.Security.Cryptography;
using System.Text;
using System.Web.Script.Serialization;
using System.Collections.Generic;
jsondata= strJson = "{\"Rows\":" + Helper.Serialize(dt) + "}";
public static string Serialize(DataTable dt)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> result = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
result.Add(dc.ColumnName, dr[dc].ToString());
}
list.Add(result);
}
return serializer.Serialize(list); ;
}