/// <summary>
/// 選票匯入
/// </summary>
protected void SetVoteTrans(DataSet dsVote)
{
BVote bVote = new BVote();
//刪除所有Vote
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg選票資料");
bVote.DelAll();
lbState.Invoke((Action <string>)SetStatus, "從access取選票資料移到FoodOrg");
lbl_VoteAll.Invoke((Action <string>)SetVoteAll, dsVote.Tables[0].Rows.Count.ToString());
int intVoteCount = 0;
foreach (DataRow dr in dsVote.Tables[0].Rows)
{
MVote mod = new MVote();
mod.TWYear = SetTWYear(dr["Period"].ToString());
mod.MemberID = SetMemberGed(dr["MemberID"].ToString());
mod.AgentMemberID = dr["AgentMemberID"].ToString();
mod.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
mod.CreateUser = dr["CreateUser"].ToString();
new BVote().Add(mod);
intVoteCount++;
lbVoteCount.Invoke((Action <int>)SetVote, intVoteCount);
}
}
public void DeleteVoteByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from tb_vote where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@ID", OleDbType.Integer, 4, "ID", objvote.ID)
};
OleDbHelper.ExecuteSql(sb.ToString(), param);
}
public DataTable SelectVoteByID(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from tb_vote where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@ID", OleDbType.Integer, 4, "ID", objvote.ID)
};
DataTable dt = OleDbHelper.ExecuteDt(sb.ToString(), param);
return(dt);
}
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)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_vote set disagreeQty=@DisagreeQty where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@DisagreeQty", OleDbType.Integer, 4, "disagreeQty", objvote.DisagreeQty),
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);
}
}
public bool InsertIntoVote(MVote objvote)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO tb_vote (voteTitle, voteContent,agreeQty,disagreeQty) VALUES (@VoteTitle,@VoteContent,0,0)");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@VoteTitle", OleDbType.VarWChar, 50, "voteTitle", objvote.VoteTitle),
OleDbHelper.GetParameter("@VoteContent", OleDbType.LongVarWChar, "voteContent", objvote.VoteContent)
};
bool is_succeed = OleDbHelper.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");
SqlParameter[] param =
{
SQLDbHelper.GetParameter("@AgreeQty", SqlDbType.Int, 4, "agreeQty", objvote.AgreeQty),
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 void DeleteVoteByID(MVote objvote)
{
votes.DeleteVoteByID(objvote);
}
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));
}
