谢谢了
public class Vote
{
public SqlDataReader GetVotes()
{
SQLHelper.SQLHelper sqlHelper=new SQLHelper.SQLHelper();
SqlDataReader dr=null;
try
{
sqlHelper.RunProc("Pr_GetVotes",out dr);
}
catch(Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message,ex);
}
return (dr);
}
public int AddVote(string sitem)
{
SQLHelper.SQLHelper sqlHelper=new SQLHelper.SQLHelper();
SqlParameter[] paramList={sqlHelper.CreateInparam("@item",SqlDbtype.varchar,100,sitem)};
try
{
return (sqlHelper.Runproc("pr_AddVote",paramList));
}
catch(Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message,ex);
}
}
public int updateVote(int nVoteID)
{
SQLHelper.SQLHelper sqlHelper=new SQLHelper.SQLHelper();
SqlParameter[] paramList={sqlHelper.CreateInparam("@vid",SqlDbtype.Int,4,nVoteID)};
try
{
sqlHelper.RunProc("Pr_UpdateVotes",paramList);
}
catch(Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message,ex);
}
}
public int DeleteVote(int nVoteID)
{
SQLHelper.SQLHelper sqlHelper=new SQLHelper.SQLHelper();
SqlParameter[] paramList={sqlHelper.CreateInparam("@vid",SqlDbtype.Int,4,nVoteID)};
try
{
sqlHelper.RunProc("Pr_DeleteVotes",paramList);
}
catch(Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message,ex);
}
}