protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string Name = Session["Name"].ToString(); LabelName.Text = Name; HomeBLL bLL = new HomeBLL(); JoininforModel = bLL.HomeJoininfor(); homeModel = bLL.HomeProjectreleased(); int Toaudit1 = homeModel.Toaudit1; Session["Toaudit1"] = Toaudit1; int Toaudit = homeModel.Toaudit; Session["Toaudit"] = Toaudit; } }
public void top() { HomeBLL bLL = new HomeBLL(); Repeater1.DataSource = bLL.HomeTheuser(); Repeater1.DataBind(); Repeater2.DataSource = bLL.HomeTojoinin(); Repeater2.DataBind(); Repeater3.DataSource = bLL.Homeinvestment(); Repeater3.DataBind(); Repeater4.DataSource = bLL.HomeThe_capital(); Repeater4.DataBind(); JoininforModel = bLL.HomeJoininfor(); homeModel = bLL.HomeProjectreleased(); }
//加盟信息汇总 public HomeJoininforModel HomeJoininfor() { string sql = "SELECT COUNT(1) AS Toapply FROM dbo.addjoin;"; string sql1 = "SELECT COUNT(1)uid FROM dbo.joininfor;"; string sql2 = "SELECT COUNT(1) AS Jiadelete FROM dbo.joininfor WHERE Jdelete IS NOT NULL"; string sql3 = "SELECT COUNT(1) AS Hasbeenback FROM dbo.addjoin WHERE Ire=1"; string sql4 = "SELECT COUNT(1) AS Notreturn FROM dbo.addjoin WHERE Ire=0"; SqlDataReader reader = SQLHelper.ExecuteReader(sql); SqlDataReader reader1 = SQLHelper.ExecuteReader(sql1); SqlDataReader reader2 = SQLHelper.ExecuteReader(sql2); SqlDataReader reader3 = SQLHelper.ExecuteReader(sql3); SqlDataReader reader4 = SQLHelper.ExecuteReader(sql4); HomeJoininforModel model = new HomeJoininforModel(); if (reader.HasRows) { while (reader.Read()) { model.Toapply = Convert.ToInt32(reader["Toapply"]); } reader.Close(); } if (reader1.HasRows) { while (reader1.Read()) { model.uid = Convert.ToInt32(reader1["uid"]); } reader1.Close(); } if (reader2.HasRows) { while (reader2.Read()) { model.Jiadelete = Convert.ToInt32(reader2["Jiadelete"]); } reader2.Close(); } if (reader3.HasRows) { while (reader3.Read()) { model.Hasbeenback = Convert.ToInt32(reader3["Hasbeenback"]); } reader3.Close(); } if (reader4.HasRows) { while (reader4.Read()) { model.Notreturn = Convert.ToInt32(reader4["Notreturn"]); } reader4.Close(); } return(model); }