private string GetDataXML()
{
DBSCMDataContext dc = new DBSCMDataContext();
var table = GetSafeInfo.GetAllSafetyCountByDept(cbbUnit.SelectedItem.Value, dfBegin.SelectedDate, dfEnd.SelectedDate).Tables[0];
try
{
var group = from t in table.AsEnumerable().ToList()
orderby int.Parse(t["YZD"].ToString()) descending, Convert.ToInt32(t["YHALL"]) + Convert.ToInt32(t["SWALL"]) descending
select new
{
//Key = t.Field<string>("DEPTNAME"),
//Total = t.Field<int>("YZD"),
//Fine = t.Field<int>("YHALL") + t.Field<int>("SWALL")
Key = t["DEPTNAME"].ToString(),
Total = int.Parse(t["YZD"].ToString()),
Fine = Convert.ToInt32(t["YHALL"]) + Convert.ToInt32(t["SWALL"])
};
Store1.DataSource = group;
Store1.DataBind();
if (group.Count() == 0)
{
return "<chart />";
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='走动情况分析' xAxisName='单位名称' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='走动次数' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='问题数量' color='8BBA00' showValues='1'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Fine + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append("</chart>");
return chartBuilder.ToString();
}
catch
{
//Store1.DataSource = null;
//Store1.DataBind();
return "<chart />";
}
}
public void storebind()
{
if (dfBegin.SelectedDate > dfEnd.SelectedDate)
{
Ext.Msg.Alert("提示", "请选择正确日期").Show();
return;
}
// DataSet ds = new DataSet();
//var data = ds;
//var datayh = (from sw in dc.Getyhinput
// where
// sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate
// select sw).ToList();
//var groupyh = from sw in datayh
// group sw by new{
// sw.Deptid,
// sw.Deptname,
// sw.Unitid
// }
// into g
// select new
// {
// g.Key.Deptid,
// g.Key.Deptname,
// g.Key.Unitid,
// Total = g.Count(),
// Pass = g.Count(p => p.Status == "复查通过"),
// NPass = g.Count(p => p.Status != "复查通过")
// };
//var groupsw= from sw in dc.Nswinput
// group sw by sw.
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
if (cbbUnit.SelectedIndex > -1 && cbbUnit.SelectedItem.Value != "-1")
{
var data = GetSafeInfo.GetAllSafetyCountByDept(cbbUnit.SelectedItem.Value, dfBegin.SelectedDate, dfEnd.SelectedDate);
Store1.DataSource = data;
Store1.DataBind();
}
else
{
var data = GetSafeInfo.GetAllSafetyCountByDept("", dfBegin.SelectedDate, dfEnd.SelectedDate);
Store1.DataSource = data;
Store1.DataBind();
}
}
else
{
var data = GetSafeInfo.GetAllSafetyCountByDept(SessionBox.GetUserSession().DeptNumber, dfBegin.SelectedDate, dfEnd.SelectedDate);
Store1.DataSource = data;
Store1.DataBind();
}
}
private string GetDataXML()
{
DBSCMDataContext dc = new DBSCMDataContext();
if (cbbKind.SelectedItem.Value == "1" || cbbKind.SelectedItem.Value == "")
{
var table = GetSafeInfo.GetAllSafetyCountByDept(cbbUnit.SelectedItem.Value, dfBegin.SelectedDate, dfEnd.SelectedDate).Tables[0];
try
{
//var group = from t in table.AsEnumerable()
// where (t["YHALL"].ToString() != "0" || t["YHYZG"].ToString() != "0" || t["YHWZG"].ToString()!="0")
// orderby int.Parse(t["YHALL"].ToString()) descending
// select new
// {
// Key = t["DEPTNAME"].ToString(),
// Total = t["YHALL"].ToString(),
// Pass = t["YHYZG"].ToString(),
// NPass = t["YHWZG"].ToString()
// };
var data = (from sw in dc.Getyhinput
where sw.Unitid == cbbUnit.SelectedItem.Value &&
sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate
select sw).ToList();
var group = from sw in data
group sw by sw.Deptname into g
select new
{
Key = g.Key,
Total = g.Count(),
Pass = g.Count(p => p.Status == "复查通过" || p.Status == "现场整改"),
NPass = g.Count(p => p.Status != "复查通过" && p.Status != "现场整改")
};
GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
Store1.DataSource = group;
Store1.DataBind();
if (group.Count() == 0)
{
return("<chart />");
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='1'>";
string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='1'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Pass + "' />";
dataset3 += "<set value='" + r.NPass + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
dataset3 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append(dataset3);
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
catch
{
Store1.DataSource = null;
Store1.DataBind();
return("<chart />");
}
}
else
{
var date = (from sw in dc.Getyhinput
where sw.Unitid == cbbUnit.SelectedItem.Value &&
sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate
select sw).ToList();
var group = from sw in date
group sw by sw.Placename into g
orderby g.Count() descending
select new
{
Key = g.Key,
Total = g.Count(),
Pass = g.Count(p => p.Status == "复查通过" || p.Status == "现场整改"),
NPass = g.Count(p => p.Status != "复查通过" && p.Status != "现场整改")
};
GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
Store1.DataSource = group;
Store1.DataBind();
if (group.Count() == 0)
{
return("<chart />");
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='1'>";
string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='1'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Pass + "' />";
dataset3 += "<set value='" + r.NPass + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
dataset3 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append(dataset3);
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
//GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
//Store1.DataSource = group;
//Store1.DataBind();
//if (group.Count() == 0)
//{
// return "<chart />";
//}
//StringBuilder chartBuilder = new StringBuilder();
//chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
//string categories = "<categories>";
//string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='0'>";
//string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='0'>";
//string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='0'>";
//foreach (var r in group)
//{
// categories += "<category label='" + r.Key + "' />";
// dataset1 += "<set value='" + r.Total + "' />";
// dataset2 += "<set value='" + r.Pass + "' />";
// dataset3 += "<set value='" + r.NPass + "' />";
//}
//categories += "</categories>";
//dataset1 += "</dataset>";
//dataset2 += "</dataset>";
//dataset3 += "</dataset>";
//chartBuilder.Append(categories);
//chartBuilder.Append(dataset1);
//chartBuilder.Append(dataset2);
//chartBuilder.Append(dataset3);
//chartBuilder.Append("</chart>");
//return chartBuilder.ToString();
}