public List<Stars> GetSomeStars(string sex,int classid,int areid) //选择不同的明星查看票数
{
String sql = string.Format("exec dbo.FilterStars '{0}',{1},{2}",sex,classid ,areid);
SqlDataReader dat = DBHelper.GetReader(sql);
List<Stars> list = new List<Stars>();
while (dat.Read())
{
Stars star = new Stars();
star.Starid = Convert.ToInt16(dat["starId"].ToString());
star.Starname = dat["starName"].ToString();
star.Starsex = dat["starSex"].ToString();
star.Starareaid = Convert.ToInt16(dat["starAreaId"]);
star.Starclassid = Convert.ToInt16(dat["starClassId"]);
list.Add(star);
}
dat.Close();
return SelectList (list); //调用生成子对象的方法
} private List<Stars> SelectList(List<Stars> list) // 遍历集合合成子对象
{
foreach (Stars star in list)
{
String str = String.Format("SELECT COUNT(*) as votetatol FROM VOTE WHERE voteWho ={0}", star.Starid);
int votetatle = DBHelper.GetScalar(str);
star.Votetotal = votetatle;
string str1 = string.Format("select * from dbo.starclass where starclassid={0}", star.Starclassid);
SqlDataReader dat1 = DBHelper.GetReader(str1);
while (dat1.Read())
{
StarClass starclass = new StarClass();
starclass.Starclassid = star.Starclassid;
starclass.Starclass = dat1["starClass"].ToString();
star.Starclass = starclass;
}
dat1.Close();
string str2 = string.Format("select * from dbo.stararea where starareaid={0}", star.Starareaid);
SqlDataReader dat2 = DBHelper.GetReader(str2);
while (dat2.Read())
{
StarArea stararea = new StarArea();
stararea.Starareaid = star.Starareaid;
stararea.Stararea = dat2["starArea"].ToString();
star.Stararea = stararea;
}
dat2.Close(); }
return list;
}
public Stars GetStarById(int userid) //通过ID获得明星
{
string str = string.Format("select * from stars where starid={0}", userid);
SqlDataReader dr = DBHelper.GetReader(str);
Stars star = new Stars(); while (dr.Read())
{ star.Starid = userid;
star.Starname = dr["starName"].ToString();
star.Starsex = dr["starSex"].ToString();
star.Starareaid = int.Parse (dr["StarAreaid"].ToString());
star.Starclassid = int.Parse (dr["starClassId"].ToString());
}
dr.Close();
str = String.Format("SELECT COUNT(*) as votetatol FROM VOTE WHERE voteWho ={0}", star.Starid);
int votetatle = DBHelper.GetScalar(str);
star.Votetotal = votetatle;
str = string.Format("select * from starclass where starclassid={0}",star.Starclassid);
dr = DBHelper.GetReader(str);
while (dr.Read())
{
StarClass starclass = new StarClass();
starclass.Starclassid = star.Starclassid;
starclass.Starclass = dr["starClass"].ToString();
star.Starclass = starclass;
}
dr.Close();
str = string.Format("select * from stararea where starareaid={0}", star.Starareaid);
dr = DBHelper.GetReader(str);
while (dr.Read())
{
StarArea stararea = new StarArea();
stararea.Starareaid = star.Starareaid;
stararea.Stararea = dr["starArea"].ToString();
star.Stararea = stararea;
}
dr.Close(); return star;
} public int GetMonthTotal(int userid) //获得月得票
{
string sql = string.Format("exec dbo.selectMonthTotal {0}", userid);
SqlDataReader dr = DBHelper.GetReader(sql);
int monthtotal=0;
while (dr.Read() ){
monthtotal = int.Parse(dr[0].ToString());
}
dr.Close ();
//string str = string.Format("select * from stars where starid={0}",userid);
//dr = DBHelper.GetReader(str);
//Stars star = new Stars();
//while (dr.Read())
//{
// star.Votetotal = monthtotal;
// star.Starid = userid;
// star.Starname = dr["starName"].ToString();
// star.Starsex = dr["starSex"].ToString();
//}
//dr.Close();
return monthtotal;
就是 是一个投票系统 想知道它总票数怎么实现的 ?
还有一个问题是用ASP.NET SQL 做的程序的服务器是什么?就像JAVA里的TOMCAT
{
String sql = string.Format("exec dbo.FilterStars '{0}',{1},{2}",sex,classid ,areid);
SqlDataReader dat = DBHelper.GetReader(sql);
List<Stars> list = new List<Stars>();
while (dat.Read())
{
Stars star = new Stars();
star.Starid = Convert.ToInt16(dat["starId"].ToString());
star.Starname = dat["starName"].ToString();
star.Starsex = dat["starSex"].ToString();
star.Starareaid = Convert.ToInt16(dat["starAreaId"]);
star.Starclassid = Convert.ToInt16(dat["starClassId"]);
list.Add(star);
}
dat.Close();
return SelectList (list); //调用生成子对象的方法
} private List<Stars> SelectList(List<Stars> list) // 遍历集合合成子对象
{
foreach (Stars star in list)
{
String str = String.Format("SELECT COUNT(*) as votetatol FROM VOTE WHERE voteWho ={0}", star.Starid);
int votetatle = DBHelper.GetScalar(str);
star.Votetotal = votetatle;
string str1 = string.Format("select * from dbo.starclass where starclassid={0}", star.Starclassid);
SqlDataReader dat1 = DBHelper.GetReader(str1);
while (dat1.Read())
{
StarClass starclass = new StarClass();
starclass.Starclassid = star.Starclassid;
starclass.Starclass = dat1["starClass"].ToString();
star.Starclass = starclass;
}
dat1.Close();
string str2 = string.Format("select * from dbo.stararea where starareaid={0}", star.Starareaid);
SqlDataReader dat2 = DBHelper.GetReader(str2);
while (dat2.Read())
{
StarArea stararea = new StarArea();
stararea.Starareaid = star.Starareaid;
stararea.Stararea = dat2["starArea"].ToString();
star.Stararea = stararea;
}
dat2.Close(); }
return list;
}
public Stars GetStarById(int userid) //通过ID获得明星
{
string str = string.Format("select * from stars where starid={0}", userid);
SqlDataReader dr = DBHelper.GetReader(str);
Stars star = new Stars(); while (dr.Read())
{ star.Starid = userid;
star.Starname = dr["starName"].ToString();
star.Starsex = dr["starSex"].ToString();
star.Starareaid = int.Parse (dr["StarAreaid"].ToString());
star.Starclassid = int.Parse (dr["starClassId"].ToString());
}
dr.Close();
str = String.Format("SELECT COUNT(*) as votetatol FROM VOTE WHERE voteWho ={0}", star.Starid);
int votetatle = DBHelper.GetScalar(str);
star.Votetotal = votetatle;
str = string.Format("select * from starclass where starclassid={0}",star.Starclassid);
dr = DBHelper.GetReader(str);
while (dr.Read())
{
StarClass starclass = new StarClass();
starclass.Starclassid = star.Starclassid;
starclass.Starclass = dr["starClass"].ToString();
star.Starclass = starclass;
}
dr.Close();
str = string.Format("select * from stararea where starareaid={0}", star.Starareaid);
dr = DBHelper.GetReader(str);
while (dr.Read())
{
StarArea stararea = new StarArea();
stararea.Starareaid = star.Starareaid;
stararea.Stararea = dr["starArea"].ToString();
star.Stararea = stararea;
}
dr.Close(); return star;
} public int GetMonthTotal(int userid) //获得月得票
{
string sql = string.Format("exec dbo.selectMonthTotal {0}", userid);
SqlDataReader dr = DBHelper.GetReader(sql);
int monthtotal=0;
while (dr.Read() ){
monthtotal = int.Parse(dr[0].ToString());
}
dr.Close ();
//string str = string.Format("select * from stars where starid={0}",userid);
//dr = DBHelper.GetReader(str);
//Stars star = new Stars();
//while (dr.Read())
//{
// star.Votetotal = monthtotal;
// star.Starid = userid;
// star.Starname = dr["starName"].ToString();
// star.Starsex = dr["starSex"].ToString();
//}
//dr.Close();
return monthtotal;
就是 是一个投票系统 想知道它总票数怎么实现的 ?
还有一个问题是用ASP.NET SQL 做的程序的服务器是什么?就像JAVA里的TOMCAT
String sql = string.Format("exec dbo.FilterStars '{0}',{1},{2}",sex,classid ,areid);//要执行的sql语句(格式化字符串)
SqlDataReader dat = DBHelper.GetReader(sql);//生成DataReader对象,用来读取数据
List<Stars> list = new List<Stars>();//定义泛型(集合中只能添加Stars的对象)
while (dat.Read())//
{
//定义Stars对象,为对象的属性赋值
Stars star = new Stars();
star.Starid = Convert.ToInt16(dat["starId"].ToString());
star.Starname = dat["starName"].ToString();
star.Starsex = dat["starSex"].ToString();
star.Starareaid = Convert.ToInt16(dat["starAreaId"]);
star.Starclassid = Convert.ToInt16(dat["starClassId"]);
list.Add(star);
}
dat.Close();//关闭兑取对象
return SelectList (list); //调用生成子对象的方法
}