tycrm/Fenxi/Feiyong/Feiyong6.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.Feiyong
{
    public partial class Feiyong6 : 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)
            {

                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 id,name from qp_crm_DataFile where type='16'  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["name"].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 CHARINDEX(','+Username+',',','+(select RyUsername from qp_crm_JianKong where ZgUsername='" + Session["username"] + "')+',') > 0";
                SqlDataReader MyReader_zj = List.GetList(SQL_Check_zj);
                while (MyReader_zj.Read())//人员列表
                {
                    this.mx.Text += "<tr onmouseover=\"javascript:setMouseOverColor(this);\" onmouseout=\"javascript:setMouseOutColor(this);\"  style=\"color: Black; background-color: #FBFCFE;\"><td align=\"center\" style=\"white-space: nowrap;\">" + MyReader_zj["realname"] + "</td>";

                    decimal xiaolvzhi = 0;//每类型每个人员客户数统计
                    string SQL_Check_btbd = "select id,name from qp_crm_DataFile where type='16'  order by id asc";
                    SqlDataReader MyReader_btbd = List.GetList(SQL_Check_btbd);
                    while (MyReader_btbd.Read())
                    {
                 
                        string SQL_GetList_ry_tj = "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  A.Leibie='" + MyReader_btbd["id"] + "' and  C.username='" + MyReader_zj["username"] + "'";
                        SqlDataReader NewReader_ry_tj = List.GetList(SQL_GetList_ry_tj);