StatValueView.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class StatValueView : System.Web.UI.Page
{
    void functionQuery()
    {
        String strQuery = "";
        if (Department_ID.SelectedValue != "All")
        {
            strQuery = "Department_ID=" + Department_ID.SelectedValue;
        }
        Yuan yuan = new Yuan();
        DataSet ds_Yuan = yuan.GetDataSet(strQuery);

        DataTable T_Yuan = ds_Yuan.Tables["T_Yuan"];
        GV_Yuan.DataSource = T_Yuan;
        GV_Yuan.DataBind();
        Session["T_Yuan"] = T_Yuan;

        //统计平均积分
        int intRowCount = T_Yuan.Rows.Count;
        double intValue = 0;
        double intValuePJ = 0;
        if (intRowCount > 0)
        {
            for (int intIndex = 0; intIndex < intRowCount; intIndex++)
                intValue += double.Parse(T_Yuan.Rows[intIndex]["Yuan_Value"].ToString());
            intValuePJ = intValue / intRowCount;
            intValuePJ = Math.Round(intValuePJ, 3, MidpointRounding.AwayFromZero);
        }

        lblRen.Text = intRowCount.ToString();
        lblValue.Text = intValue.ToString();
        lblValuePJ.Text = intValuePJ.ToString();

    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            Department department = new Department();
            Department_ID.DataTextField = "Department_Name";
            Department_ID.DataValueField = "Department_ID";
            DataSet ds_Department = department.GetDataSet("");

            Department_ID.DataSource = ds_Department.Tables["T_Department"];
            Department_ID.DataBind();

            ListItem LI_Department = new ListItem();
            LI_Department.Text = "全部";