1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 12
 13public partial class hy_cwgl : System.Web.UI.Page
 14...{
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        if (!IsPostBack)
 18        ...{
 19            if (Session["aid"] == null)
 20            ...{ Response.Write("<script language=javascript>top.location.href='login.aspx';alert('您未登录！');</script>"); }
 21            else
 22            ...{
 23                bind();
 24            }
 25        }
 26    }
 27    void bind()
 28    ...{
 29        string sql = "select * from webhww_hy where id=" + Request.QueryString["cid"] + " ";
 30        DataTable dt = new DataTable();
 31        dt = access.GreatDs(sql).Tables[0];
 32        int cj = int.Parse(dt.Rows[0]["webhww_ceng"].ToString()) + 2;
 33        if (dt.Rows.Count > 0)
 34        ...{
 35            //自加入以来的奖金累积
 36            Label12.Text = dt.Rows[0]["webhww_hysr"].ToString();
 37            //直接销售额       
 38            Label19.Text = dt.Rows[0]["webhww_zjlsey"].ToString();
 39            Label1.Text = Convert.ToString(int.Parse(dt.Rows[0]["webhww_zjlsey"].ToString()) + int.Parse(dt.Rows[0]["webhww_zjlsen"].ToString()));
 40
 41            //间接零售额
 42            Label20.Text = dt.Rows[0]["webhww_jjlsey"].ToString();
 43            Label2.Text = Convert.ToString(int.Parse(dt.Rows[0]["webhww_jjlsey"].ToString()) + int.Parse(dt.Rows[0]["webhww_jjlsen"].ToString()));
 44
 45            Label9.Text =Convert.ToString( double.Parse(dt.Rows[0]["webhww_zjlsey"].ToString()) * 0.2 + double.Parse(dt.Rows[0]["webhww_jjlsey"].ToString())*0.1);
 46            //保险补贴
 47            double bxbt = 0;
 48            if ((access.GreatDs("select webhww_ceng from webhww_hy where webhww_ceng=" + cj + "").Tables[0].Rows.Count == 9))
 49            ...{
 50                bxbt = (int.Parse(dt.Rows[0]["webhww_xsze"].ToString()) - (int.Parse(dt.Rows[0]["webhww_zjlsey"].ToString()) + int.Parse(dt.Rows[0]["webhww_jjlsey"].ToString()))) * 0.02;
 51
 52            }
 53            Label11.Text = bxbt.ToString();
 54        }
 55        string str = "select * from webhww_hy where webhww_tjrbh='" + dt.Rows[0]["webhww_hybh"].ToString() + "'";
 56        DataTable dt1 = new DataTable();
 57        dt1 = access.GreatDs(str).Tables[0];       
 58        //A
 59        DataRow[] dr3 = dt1.Select("webhww_hywz=0");
 60        int a = 0;
 61        if (dr3.Length > 0)
 62        ...{
 63            Label3.Text = dr3[0]["webhww_xgje"].ToString();
 64            Label13.Text = dr3[0]["webhww_sh"].ToString();
 65            a = int.Parse(dr3[0]["webhww_xgje"].ToString());
 66        }
 67        else
 68        ...{
 69            Label3.Text = "未开通";
 70        }
 71        //B
 72        DataRow[] dr4 = dt1.Select("webhww_hywz=1");
 73        int b=0;
 74        if (dr4.Length > 0)
 75        ...{
 76            Label4.Text = dr4[0]["webhww_xgje"].ToString();
 77            Label14.Text = dr4[0]["webhww_sh"].ToString();
 78            b = int.Parse(dr4[0]["webhww_xgje"].ToString());
 79        }
 80        else
 81        ...{
 82            Label4.Text = "未开通";
 83        }
 84        //C
 85        DataRow[] dr5 = dt1.Select("webhww_hywz=2");
 86        int c = 0;
 87        if (dr5.Length > 0)
 88        ...{
 89            Label5.Text = dr5[0]["webhww_xgje"].ToString();
 90            Label15.Text = dr3[0]["webhww_sh"].ToString();
 91            c = int.Parse(dr5[0]["webhww_xgje"].ToString());
 92        }
 93        else
 94        ...{
 95            Label5.Text = "未开通";
 96        }
 97        //D
 98        DataRow[] dr6 = dt1.Select("webhww_hywz=3");
 99        int d = 0;
100        if (dr6.Length > 0)
101        ...{
102            Label6.Text = dr6[0]["webhww_xgje"].ToString();
103            Label16.Text = dr6[0]["webhww_sh"].ToString();
104            d = int.Parse(dr6[0]["webhww_xgje"].ToString());
105        }
106        else
107        ...{
108            Label6.Text = "未开通";
109        }
110        //E
111        DataRow[] dr7 = dt1.Select("webhww_hywz=4");
112        int e = 0;
113        if (dr7.Length > 0)
114        ...{
115            Label7.Text = dr7[0]["webhww_xgje"].ToString();
116            Label17.Text = dr7[0]["webhww_sh"].ToString();
117            e = int.Parse(dr7[0]["webhww_xgje"].ToString());
118        }
119        else
120        ...{
121            Label7.Text = "未开通";
122        }
123        //F
124        DataRow[] dr8 = dt1.Select("webhww_hywz=5");
125        int f = 0;
126        if (dr6.Length > 0)
127        ...{
128            Label8.Text = dr8[0]["webhww_xgje"].ToString();
129            Label18.Text = dr8[0]["webhww_sh"].ToString();
130            f = int.Parse(dr8[0]["webhww_xgje"].ToString());
131        }
132        else
133        ...{
134            Label8.Text = "未开通";
135        }      
136        //开拓提成
137        if (dt1.Rows.Count == 3)
138        ...{
139            Label10.Text =Convert.ToString((a + b + c) * 0.1);
140        }
141        else if (dt1.Rows.Count == 9)
142        ...{
143            Label10.Text = Convert.ToString((a + b + c + d + e + f) * 0.1);
144        }
145        else
146        ...{
147            Label10.Text = "0";
148        }
149    }
150}
151