阅读 54

c#图标、显示图表、图形、json echarts实例 数据封装【c#】

page:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ViewxxxxChartsInfo.ascx.cs" Inherits="DotNetNuke.Modules.HRAddUser.ViewxxxxChartsInfo" %>
  

    

  

controller:

using System;
using System.Data;
using System.Web.UI.WebControls;
using DotNetNuke.Modules.ControllerData;
using DotNetNuke.Security;
using DotNetNuke.Services.Localization;

namespace DotNetNuke.Modules.ControllerData
{
    public partial class ViewxxxxChartsInfo : DotNetNuke.Entities.Modules.PortalModuleBase, DotNetNuke.Entities.Modules.IActionable
    {
        private ControllerData CD = new ControllerData();
        private DataTable dtTosxxxInfo = new DataTable();

        protected void Page_Load(object sender, EventArgs e)
        {
           
            FillDG();

            if (!IsPostBack)
            {
                FillUI();
            }
        }

        private void FillDG()
        {

            string swhere = " where xxxxName like ‘%" + tbxInfoxxxxxName.Text + "%‘ ";
            bool OnlyExpire;
            if (ddlDateArray.Text == "全部")
                OnlyExpire = false;
            else
                OnlyExpire = true;

            dtTosxxxInfo = CD.GetTosxxxxChartsInfo(swhere, ddlDateArray.Text);
        }

        private void FillUI()
        {
            Type1.Text = Convert.ToString(dtTosxxxInfo.Rows[0]["jsons"]);
            Type2.Text = Convert.ToString(dtTosxxxInfo.Rows[1]["jsons"]);
            Type3.Text = Convert.ToString(dtTosxxxInfo.Rows[2]["jsons"]);
            Type4.Text = Convert.ToString(dtTosxxxInfo.Rows[3]["jsons"]);
            Type5.Text = Convert.ToString(dtTosxxxInfo.Rows[4]["jsons"]);
        }
		//页面响应移动代码
        #region IActionable 成员

        DotNetNuke.Entities.Modules.Actions.ModuleActionCollection DotNetNuke.Entities.Modules.IActionable.ModuleActions
        {
            get
            {
                Entities.Modules.Actions.ModuleActionCollection Actions = new
                Entities.Modules.Actions.ModuleActionCollection();
                Actions.Add(GetNextActionID(),
                Localization.GetString(Entities.Modules.Actions.ModuleActionType.AddContent,
                LocalResourceFile), Entities.Modules.Actions.ModuleActionType.AddContent, "", "",
                EditUrl(), false, SecurityAccessLevel.Edit, true, false);
                return Actions;
            }
        }

        #endregion
        protected void btnselect_Click(object sender, EventArgs e)
        {
            FillDG();
            FillUI();
        }
    }
}

  

data:

     /// 
        /// 获取xxxxxx收入、应缴、实缴、尚欠金额统计json.
        /// 
        /// 
        /// 
        /// 
        public DataTable GetTosxxxChartsInfo(string where, string DateA)
        {
            DataTable dtchart = new DataTable();
            dtchart.Columns.Add("jsons");

            List list1 = new List();
            List list2 = new List();
            List list3 = new List();
            List list4 = new List();
            List list5 = new List();

            DataTable dtbc = GetTosxxxViewInfo(where, DateA);//数据层-统计计算封装表
            if (dtbc.Rows.Count > 0)
            {
                string Tosxxxname = "";
                decimal  Total2 = 0, Total3 = 0, Total4 = 0, Total5 = 0;
                for (int t = 0; t < dtbc.Rows.Count; t++)
                {
                    Tosxxxname = Convert.ToString(dtbc.Rows[t]["OAxxxxName"]);
                    Total2 = Convert.ToDecimal(dtbc.Rows[t]["xxxxIngahter"]);
                    Total3 = Convert.ToDecimal(dtbc.Rows[t]["xxxxAdminFee"]);
                    Total4 = Convert.ToDecimal(dtbc.Rows[t]["xxxAdminFee"]);
                    Total5 = Convert.ToDecimal(dtbc.Rows[t]["xxxxAdminFee"]);
                    list1.Add(Tosxxxname);
                    list2.Add(Total2);
                    list3.Add(Total3);
                    list4.Add(Total4);
                    list5.Add(Total5);
                }
            }
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list1) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list2) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list3) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list4) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list5) });
            return dtchart;
        }
		
		

  

 

原文:https://www.cnblogs.com/liuguiqing/p/15233694.html

文章分类
代码人生
版权声明:本站是系统测试站点,无实际运营。本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 XXXXXXo@163.com 举报,一经查实,本站将立刻删除。
相关推荐