tycrm/Fenxi/Caigou/Caigou11List.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using qpsmartweb.Public;

using System.IO;
namespace tycrm.Fenxi.Caigou
{
    public partial class Caigou11List : System.Web.UI.Page
    {
        Db List = new Db();
        
        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;
            }

            if (!IsPostBack)
            {

                ViewState["Starttime"] = "" + Request.QueryString["SYear"].ToString() + "-" + Request.QueryString["SMonth"].ToString() + "-01";
                ViewState["Endtime"] = "" + System.DateTime.Parse("" + Request.QueryString["EYear"].ToString() + "-" + Request.QueryString["EMonth"].ToString() + "-01").AddMonths(1).AddDays(-1) + "";

                string userstr = null;

                string SQL_Check_user = "select username  from qp_crm_Username where id in (" + Request.QueryString["UserId"] + ")";
                SqlDataReader MyReader_user = List.GetList(SQL_Check_user);
                while (MyReader_user.Read())
                {
                    userstr += "'" + MyReader_user["username"] + "',";
                }
                MyReader_user.Close();

                userstr += "'0'";//获取用户名

                mx.Text = null;

                this.mx.Text += "<table cellspacing=\"1\" cellpadding=\"5\" border=\"0\" id=\"GridView1\" style=\"background-color: #4D77B1; border-color: #4D77B1; border-width: 1px; border-style: None; width: 100%; font-size: 12px\">";
                this.mx.Text += "<tr onmouseover=\"javascript:setMouseOverColor(this);\" onmouseout=\"javascript:setMouseOutColor(this);\"style=\"color: #E7E7FF; background-color: #4A3C8C; font-weight: bold; white-space: nowrap;\"><th class=\"newtitle\" scope=\"col\" style=\"color: White; white-space: nowrap;\">姓名</th>";


                string SQL_Check_bt = "select * from qp_crm_FenxiMonth where id<=(select id from qp_crm_FenxiMonth where ProMonth='" + Request.QueryString["EMonth"].ToString() + "' and ProYear='" + Request.QueryString["EYear"].ToString() + "')  and  id>=(select id from qp_crm_FenxiMonth where ProMonth='" + Request.QueryString["SMonth"].ToString() + "' and ProYear='" + Request.QueryString["SYear"].ToString() + "')   order by id asc";
                SqlDataReader MyReader_bt = List.GetList(SQL_Check_bt);
                while (MyReader_bt.Read())
                {
                    this.mx.Text += "<th class=\"newtitle\" scope=\"col\" style=\"color: White; white-space: nowrap;\">" + MyReader_bt["ProYear"].ToString() + "年" + MyReader_bt["ProMonth"].ToString() + "月</th>";
                }//得到表头---对应月份
                MyReader_bt.Close();

                mx.Text += " <th class=\"newtitle\" scope=\"col\" style=\"color: White; white-space: nowrap;\">小计</th></tr>";//得到表头--小计

                string SQL_Check_zj = "select username,realname from qp_crm_Username where id in (" + Request.QueryString["UserId"] + ") order by id desc";