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