利用ViewData產生JavaScript數組

   這次用JSCharts做報表，發現對於產生報表參數很是惱火，它有兩種參數：

   一是Line：var myData = new Array([10, 20], [15, 10], [20, 30], [25, 10], [30, 5]);

   二是Bar：var myData = new Array(['unit', 20], ['unit two', 10], ['unit three', 30], ['other unit', 10], ['last unit', 30]);

   如何將Controller中獲得的資料產生JavaScript的數組呢？

   一種是toJson的方法：

 

        public static string ToJSON(this object obj)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
return serializer.Serialize(obj);
        }

public static string ToJSON(object obj, int recursionDepth)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            serializer.RecursionLimit = recursionDepth;
return serializer.Serialize(obj);
        }

 var data=new Array();
        $(document).ready(function(){
var content=<%=ViewData["Schedules"]==null?0:ViewData["Schedules"] %>;
if(content!=0)
        {
            $.each(content, function(i, item) {
            data.push(new Array(item["ItemA"],item["ItemB"],item["ItemC"]));           
            });         
        }
        }); 

   參考：http://www.soaspx.com/dotnet/asp.net/DPattern/dpattern_20091104_1419.html
   

另一種是foreach ViewData，我選的這種：

  

public class Address
{
public string Line1 { get; set; }
public string City { get; set; }
}

// in your controller code
ViewData["Addresses"] = new List<Address>(new Address[] { new Address() { Line1="bla", City="somewhere"}, new Address() {Line1="foo", City="somewhereelse"}});

   前台：

<script type="text/javascript">
var addresses = new Array(
<% for (int i = 0; i < ViewData["Addresses"].Count; i++) { %>
<%= i > 0 : "," : "" %>({line1:"<%= addr.Line1 %>", city:"<%= addr.City %>"})
<% } %>);
</script>   

還可以這樣：

var cityList = new Array();
function addCity(cityId, cityName) {
var city = new Object();
    city.CityID = cityId;
    city.CityName = cityName

    cityList .push(city);
}
<% foreach (Something.DB.City item in ViewData["Cities"] as List<City>)
   { %>
   addCity(item.Id, item.Name);
<% } %>

   有幾點需要注意，My Code如下：

  var callin = new Array();
function addReport( callin, callout) {
var data = new Array(callin, callout);
        array.push(data);
    }
    '<%foreach(var item in ViewData["reports"] as List<CDRDayReport>){ %>'
    addReport('<%=item.CallIn %>','<%=item.CallOut %>'); //string
    //addReport(<%=item.CallIn %>,<%=item.CallOut %>);   //number
     '<%} %>'

   PS:JSCharts的需要的參數，是數組嵌套數組。開始我一直沒弄明白怎麼產生這樣的資料，其實很簡單：

 var array = new Array();
var data = new Array(10, 2);
var data2 = new Array(12, 3);
         array.push(data);
         array.push(data2);

   唯一需要注意的是，如果只有1個data，JSCharts會報錯，因為一個點產生不了line嘛，後來才想通。