tycrm/Fenxi/Gengzong/JiihuiZT.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.Gengzong
{
    public partial class JiihuiZT : 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 count(A.id) from  [qp_crm_JiHui] as [A] inner join [qp_crm_DataFile] as [B] on [A].[Jieduan] = [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";
                    string countalls = "" + List.GetCount(SQL_GetList_all) + "";

                    if (countalls == "0")
                    {
                        ViewState["showlb"] = "<tr><td class=\"newtd2\" colspan=\"4\"><div align=\"center\"><font color=red>无相关数据</font></div></td> </tr>";
                    }
                    else
                    {
                        string SQL_mx = "select id,name from qp_crm_AllDataFile where type='3'  order by id asc";
                        int ids = 1;
                        SqlDataReader NewReader_mx = List.GetList(SQL_mx);
                        while (NewReader_mx.Read())
                        {
                            string SQL_GetList_syz = "select count(A.id) from  [qp_crm_JiHui] as [A] inner join [qp_crm_DataFile] as [B] on [A].[Jieduan] = [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.Zhuangtai='" + NewReader_mx["id"] + "'";
                            string counts = "" + List.GetCount(SQL_GetList_syz) + "";

                            ids = ids + 1;

                            if (counts != "0")
                            {
                                string SQL_yz = "select  * from qp_crm_Fenxi  where id='" + ids + "' order by id asc";
                                SqlDataReader NewReader_yz = List.GetList(SQL_yz);
                                if (NewReader_yz.Read())
                                {
                                    ViewState["showjg"] += "<set name='" + NewReader_mx["name"].ToString().Replace("%", "％") + "(" + counts + ")' value='" + counts + "' color='" + NewReader_yz["color"].ToString() + "'/>";
                                }
                                NewReader_yz.Close();
                            }

                            decimal countf = decimal.Round(decimal.Parse(counts) / (decimal.Parse(countalls)), 2) * 100;

                            ViewState["showlb"] += "<tr><td class=\"newtd2\"><div align=\"center\">" + NewReader_mx["name"].ToString() + "</div></td><td class=\"newtd2\"><div align=\"center\">" + counts + "</div></td> <td align=left class=\"newtd2\"> <img src=\"/images/bar2.gif\" width=\"" + countf + " * 2\" height=\"11\"/>" + countf + "%</td><td class=\"newtd2\"><div align=\"center\"><a href='javascript:void(0)' onclick='var num=Math.random();loc_x=(screen.availWidth-877)/2;loc_y=(screen.availHeight-600)/2;window.open (\"Jihui_list.aspx?tmp=\"+num+\"&Key=13&Zhuangtai=" + NewReader_mx["id"] + "\", \"_blank\", \"height=600, width=877,toolbar=no, menubar=no, scrollbars=yes,resizable=yes,location=no, status=no,top=\"+loc_y+\",left=\"+loc_x+\"\")'>详情</a></div></td> </tr>";