public bool GetProportionDataDetail(string proportioned)
{
if (ProportionData.IndexOf(proportioned) >= 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult OrderCountryData(DateTime st, DateTime et, string a, string p)
{
var sqlWhere = SqlWhere(st, et, a, p);
IList <object[]> objs = NSession.CreateQuery(string.Format("select Country,COUNT(Id) from OrderType {0} group by Country", sqlWhere)).List <object[]>();
object obj =
NSession.CreateQuery(string.Format("select COUNT(Id) from OrderType {0} ", sqlWhere))
.UniqueResult();
decimal sum = Convert.ToDecimal(obj);
List <ProportionData> list = new List <ProportionData>();
foreach (object[] objectse in objs)
{
ProportionData pd = new ProportionData();
pd.Count = Convert.ToInt32(objectse[1]);
pd.Key = objectse[0].ToString();
pd.Proportion = Math.Round((Convert.ToDecimal(pd.Count) / sum) * 100, 2);
list.Add(pd);
}
List <object> footers = new List <object>();
footers.Add(new { Count = sum });
return(Json(new { rows = list.OrderByDescending(f => f.Proportion), footer = footers, total = list.Count }));
}
public ActionResult OrderCountryData(DateTime st, DateTime et, string a, string p)
{
var sqlWhere = SqlWhere(st, et, a, p);
IList<object[]> objs = NSession.CreateQuery(string.Format("select Country,COUNT(Id) from OrderType {0} group by Country", sqlWhere)).List<object[]>();
object obj =
NSession.CreateQuery(string.Format("select COUNT(Id) from OrderType {0} ", sqlWhere))
.UniqueResult();
decimal sum = Convert.ToDecimal(obj);
List<ProportionData> list = new List<ProportionData>();
foreach (object[] objectse in objs)
{
ProportionData pd = new ProportionData();
pd.Count = Convert.ToInt32(objectse[1]);
pd.Key = objectse[0].ToString();
pd.Proportion = Math.Round((Convert.ToDecimal(pd.Count) / sum) * 100, 2);
list.Add(pd);
}
List<object> footers = new List<object>();
footers.Add(new { Count = sum });
return Json(new { rows = list.OrderByDescending(f => f.Proportion), footer = footers, total = list.Count });
}