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(); }