public void DeleteVoteByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from tb_vote where ID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"ID",objvote.ID)
};
SQLDbHelper.ExecuteSql(sb.ToString(), param);
}
public DataTable SelectVoteByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from tb_vote where ID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"ID",objvote.ID)
};
DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param);
return dt;
}
public bool UpdateVoteDisagreeQtyByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_vote set disagreeQty=@DisagreeQty where ID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@DisagreeQty",SqlDbType.Int,4,"agreeQty",objvote.DisagreeQty),
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"ID",objvote.ID)
};
bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
return true;
else
return false;
}
public bool InsertIntoVote(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO tb_vote (voteTitle, voteContent,agreeQty,disagreeQty) VALUES (@VoteTitle,@VoteContent,0,0)");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@VoteTitle",SqlDbType.VarChar,50,"voteTitle",objvote.VoteTitle),
SQLDbHelper.GetParameter("@VoteContent",SqlDbType.Text,"voteContent",objvote.VoteContent)
};
bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
return true;
else
return false;
}
public bool UpdateVoteAgreeQtyByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_vote set agreeQty=@AgreeQty where ID=@ID");
OleDbParameter[] param = {
OleDbHelper.GetParameter("@AgreeQty",OleDbType.Integer,4,"agreeQty",objvote.AgreeQty),
OleDbHelper.GetParameter("@ID",OleDbType.Integer,4,"ID",objvote.ID)
};
bool is_succeed = OleDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
return true;
else
return false;
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
vote votes = new vote();
MVote objvotes = new MVote();
objvotes.VoteTitle = txtTitle.Text.ToString();
objvotes.VoteContent = txtContent.Text.ToString();
bool bl = votes.InsertIntoVote(objvotes);
if (bl)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('数据提交成功!');</script>");
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('网络故障,数据提交失败!');</script>");
}
}
public bool UpdateVoteDisagreeQtyByID(MVote objvote)
{
return votes.UpdateVoteDisagreeQtyByID(objvote);
}
public DataTable SelectVoteByID(MVote objvote)
{
return votes.SelectVoteByID(objvote);
}
public bool InsertIntoVote(MVote objvote)
{
return votes.InsertIntoVote(objvote);
}
public void DeleteVoteByID(MVote objvote)
{
votes.DeleteVoteByID(objvote);
}
