tycrm/Fenxi/Feiyong/Feiyong2List.aspx.cs

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

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

using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Data.SqlClient;
using qpsmartweb.Public;

using System.Collections;

namespace tycrm.Fenxi.Feiyong
{
    public partial class Feiyong2List : 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 (!Page.IsPostBack)
            {

                try
                {
                    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 SQL_GetList_all = "select sum(A.jine) as AllShuliang from [qp_crm_FeiYong] as [A] inner join [qp_crm_DataFile] as [B] on [A].[Leibie] = [B].id  inner join [qp_crm_Customer] as [C] on [A].[KhId] = [C].id where A.Zhuangtai='2' and C.IfDel=0 and CHARINDEX(','+C.Username+',',','+(select RyUsername from qp_crm_JianKong where ZgUsername='" + Session["username"] + "')+',') > 0 and ((Shijian between '" + ViewState["Starttime"] + "'and  '" + ViewState["Endtime"] + "') or datediff(dd,Shijian,'" + ViewState["Starttime"] + "')=0 or datediff(dd,Shijian,'" + ViewState["Endtime"] + "')=0)";
                    SqlDataReader NewReader_all = List.GetList(SQL_GetList_all);
                    if (NewReader_all.Read())
                    {
                        if (NewReader_all["AllShuliang"].ToString() == "")
                        {
                            ViewState["countalls"] = "0";
                        }
                        else
                        {
                            ViewState["countalls"] = NewReader_all["AllShuliang"].ToString();
                        }
                    }
                    else
                    {
                        ViewState["countalls"] = "0";
                    }
                    NewReader_all.Close();

                    if (ViewState["countalls"].ToString() == "0")
                    {
                        ViewState["showlb"] = "<tr><td class=\"newtd2\" colspan=\"4\"><div align=\"center\"><font color=red>无相关数据</font></div></td> </tr>";
                    }
                    else
                    {
                        string SQL_mx = "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";
                        int ids = 1;
                        SqlDataReader NewReader_mx = List.GetList(SQL_mx);
                        while (NewReader_mx.Read())