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);
}
