HumanManage/Htfx_syjbgzfx.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;
using System.Data.OleDb;
using qiupeng.Public;
using System.IO;
namespace qphr.HumanManage
{
    public partial class Htfx_syjbgzfx : System.Web.UI.Page
    {
        Db List = new Db();

        public  string showjg, showlb;
        public  string syzcounts, sydqcounts, sxzcounts, ydqcounts, yjccounts;
        public  decimal syzcountf, sydqcountf, sxzcountf, ydqcountf, yjccountf;
        public  decimal syzcountw, sydqcountw, sxzcountw, ydqcountw, yjccountw;
        protected void Page_Load(object sender, EventArgs e)
        {

            if (this.Session["username"] == null)
            {
                this.Response.Write("<script language=javascript>alert('登陆超时！');window.parent.location = '../main_d.aspx'</script>");
                return;
            }

            try
{

            string SQL_GetList_all = "select count(id) from qp_hr_HtManage ";
            string countalls = "" + List.GetCount(SQL_GetList_all) + "";


            string SQL_mx = "select  * from qp_hr_Htfx_sz_sygz  order by id asc";
            showjg = null;
            showlb = null;
            int ids = 1;
            OleDbDataReader NewReader_mx = List.GetList(SQL_mx);
            while (NewReader_mx.Read())
            {
                string SQL_GetList_syz = "select count(id) from qp_hr_HtManage where ShiYongGz<=" + NewReader_mx["lastmoney"] + " and  ShiYongGz>=" + NewReader_mx["firstmoney"] + "";
                string counts = "" + List.GetCount(SQL_GetList_syz) + "";

                ids = ids + 1;

                string SQL_yz = "select  * from qp_hr_Htfx   where id='" + ids + "' order by id asc";
                OleDbDataReader NewReader_yz = List.GetList(SQL_yz);
                if (NewReader_yz.Read())
                {
                    showjg += "<set name='" + NewReader_mx["name"].ToString() + "(" + NewReader_mx["firstmoney"].ToString() + "至" + NewReader_mx["lastmoney"].ToString() + ")' value='" + counts + "' color='" + NewReader_yz["color"].ToString() + "'/>";
                }
                NewReader_yz.Close();