tycrm/Fenxi/Hetong/Hetong6.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.Hetong
{
    public partial class Hetong6 : 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
                {
                    string SQL_GetList_all = "select sum(A.jine) as AllShuliang from  [qp_crm_HeTong] as [A] inner join [qp_crm_DataFile] as [B] on [A].[Fenlei] = [B].id  inner join [qp_crm_Customer] as [C] on [A].[KhId] = [C].id where C.IfDel=0 and  CHARINDEX(','+C.Username+',',','+(select RyUsername from qp_crm_JianKong where ZgUsername='" + Session["username"] + "')+',') > 0";
                    SqlDataReader NewReader_all = List.GetList(SQL_GetList_all);
                    if (NewReader_all.Read())
                    {
                        if (NewReader_all["AllShuliang"].ToString() == "")
                        {
                            ViewState["countalls"] = "0.00";
                        }
                        else
                        {
                            ViewState["countalls"] = string.Format("{0:N}", NewReader_all["AllShuliang"]);
                        }
                    }
                    else
                    {
                        ViewState["countalls"] = "0.00";
                    }
                    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 username,realname from qp_crm_Username where  CHARINDEX(','+Username+',',','+(select RyUsername from qp_crm_JianKong where ZgUsername='" + Session["username"] + "')+',') > 0 ";
                        int ids = 1;
                        SqlDataReader NewReader_mx = List.GetList(SQL_mx);
                        while (NewReader_mx.Read())
                        {
                            string SQL_GetList_syz = "select sum(A.jine) as AllShuliang from  [qp_crm_HeTong] as [A] inner join [qp_crm_DataFile] as [B] on [A].[Fenlei] = [B].id  inner join [qp_crm_Customer] as [C] on [A].[KhId] = [C].id where C.IfDel=0 and  CHARINDEX(','+C.Username+',',','+(select RyUsername from qp_crm_JianKong where ZgUsername='" + Session["username"] + "')+',') > 0 and A.IfDel=0  and C.username='" + NewReader_mx["username"].ToString() + "' ";
                            SqlDataReader NewReader_syz = List.GetList(SQL_GetList_syz);