关于用友华表Cell插件代码

最新推荐文章于 2025-08-12 15:02:14 发布

white__cat

最新推荐文章于 2025-08-12 15:02:14 发布

阅读量5.5k

点赞数

分类专栏： winform

winform 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一个使用 ASP.NET 和 SQL 进行数据检索、处理及报表展示的应用实例。该应用从数据库中获取实时数据，并通过 Cell 控件将数据以报表的形式展现出来，同时还实现了查询、编辑、打印预览等功能。

以下是cs

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using System.Collections;

public partial class index : System.Web.UI.Page
{
    public DataSet ds;
    public ArrayList arr;
    public string xuhao = "";
    public string nodeid = "";
    public string sensor = "";
    public string unit = "";
    public string placement = "";
    public string status = "";
    public string value = "";
    public string save_time = "";
    public string startTime = "";
    public string endTime = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            getValue();
        }
    }

    public void getValue()
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionstr"]);
        con.Open();
        string sql = "select id,node_id,sensor_name,unit,placement,case status when 0 then '正常' else '报警' end status,[value],";
        sql = sql + "save_time,starttime,endtime from m_realvalue200901";

        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        ds = new DataSet();
        da.Fill(ds, "m_realvalue200901");
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            xuhao += ds.Tables[0].Rows[i]["id"].ToString()+",";
            nodeid += ds.Tables[0].Rows[i]["node_id"].ToString()+",";
            sensor += ds.Tables[0].Rows[i]["sensor_name"].ToString()+",";
            unit += ds.Tables[0].Rows[i]["unit"].ToString()+",";
            placement += ds.Tables[0].Rows[i]["placement"].ToString() + ",";
            status += ds.Tables[0].Rows[i]["status"].ToString() + ",";
            value += ds.Tables[0].Rows[i]["value"].ToString() + ",";
            save_time += ds.Tables[0].Rows[i]["save_time"].ToString() + ",";
            startTime += ds.Tables[0].Rows[i]["startTime"].ToString() + ",";
            endTime += ds.Tables[0].Rows[i]["endTime"].ToString() + ",";
        }
        GC.Collect();
    }

    /// <summary>
    /// 填充arraylist
    /// </summary>
    public void GetList()
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionstr"]);
        con.Open();
        string sql = "select * from m_realvalue200901";
        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        ds = new DataSet();
        da.Fill(ds, "m_realvalue200901");
        arr = new ArrayList();
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            arr.Add(ds.Tables[0].Rows[i][0].ToString());
        }
    }

    /// <summary>
    /// 此处是读取数据
    /// </summary>
    /// <returns></returns>
    public DataSet GetDS()
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionstr"]);
        con.Open();
        ds = new DataSet();
        DataTable dt = new DataTable();
        string sql = "select * from m_realvalue200901";
        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            ds.Tables.Add(dt);
        }
        else
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "tishi", "<script language=javascript>alert('没有查到数据！')</script>");
        }
        return ds;
    }

    /// <summary>
    /// 逐行读取
    /// </summary>
    /// <returns></returns>
    public static string GetData()
    {
        string ConStrs = System.Configuration.ConfigurationManager.AppSettings["connectionstr"];
        string Sql = "select * from m_realvalue200901";
        string Result = string.Empty;
        using (SqlConnection Con = new SqlConnection(ConStrs))
        {
            using (SqlCommand Cmd = new SqlCommand(Sql, Con))
            {
                Con.Open();
                DataTable dt = new DataTable();
                using (SqlDataReader Dr = Cmd.ExecuteReader())
                {
                    while (Dr.Read())
                    {
                        Result += Dr[0].ToString() + ";";

                    }
                }
            }
        }
        return Result;
    }
}

===================================================================

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="index" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Cell(华表)</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

        //打印
        function btn_Print()
        {
            document.getElementById("cellweb1").PrintSheet(false, document.getElementById("cellweb1").GetCurSheet);
        }

        //保存
        function btn_Save()
        {
            document.getElementById("cellweb1").SaveFile();
        }

        function btn_SetPrint()
        {
            document.getElementById("cellweb1").PrintPageSetup();
        }

</head>

<body onload="onload()">
    <form id="form1" runat="server">
    <table width="100%">
        <tr>
            <td height="50px">
                <input id="btnquery" type="button" value="查询" onclick="return getValue()" /> 
                <input id="btnedit" type="button" value="编辑" onclick="return btn_Edit()" /> 
                <input id="btnpreprint" type="button" value="打印预览" onclick="return btn_PrePrint()" /> 
                <input id="btnsetprint" type="button" value="打印设置" onclick="return btn_SetPrint()" /> 
                <input id="btnprint" type="button" value="打印" onclick="return btn_Print()" /> 
                <input id="btnsave" type="button" value="保存" onclick="return btn_Save()" /> 
                <input type="hidden" name="myxuhao" id="myxuhao" value='<%=xuhao %>' />
                <input type="hidden" name="mynodeid" id="mynodeid" value='<%=nodeid %>' />
                <input type="hidden" name="mysensor" id="mysensor" value='<%=sensor %>' />
                <input type="hidden" name="myunit" id="myunit" value='<%=unit %>' />
                <input type="hidden" name="myplacement" id="myplacement" value='<%=placement %>' />
                <input type="hidden" name="mystatus" id="mystatus" value='<%=status %>' />
                <input type="hidden" name="myvalue" id="myvalue" value='<%=value %>' />
                <input type="hidden" name="mysave_time" id="mysave_time" value='<%=save_time %>' />
                <input type="hidden" name="mystartTime" id="mystartTime" value='<%=startTime %>' />
                <input type="hidden" name="myendTime" id="myendTime" value='<%=endTime %>' />
            </td>
        </tr>
        <tr>
            <td class="style1">
                <object id="cellweb1" style="z-index: 102; left: 14px; width: 95%; position: absolute;top: 70px; height: 100%;"
                classid="clsid:3f166327-8030-4881-8bd2-ea25350e574a">
                    <param name="_version" value="65536" />
                    <param name="_extentx" value="14182" />
                    <param name="_extenty" value="7197" />
                    <param name="_stockprops" value="0" />
                </object>
            </td>
        </tr>
    </table>
    </form>
</body>
</html>