/// <summary>
/// Load
/// </summary>
private void Form1_Load(object sender, EventArgs e)
{
TestLibrary.BLL.BAccessTable bll = new TestLibrary.BLL.BAccessTable();
DataSet dsMemberG = bll.GetACCMemberG();
DataSet dsMemberP = bll.GetACCMemberP();
DataSet dsFee = bll.GetFeeList();
DataSet dsPaper = bll.GetPaperList();
DataSet dsOnSite = bll.GetOnSiteList();
DataSet dsRegister = bll.GetRegister();
DataSet dsReceipt = bll.GetReceipt();
DataSet dsVote = bll.GetVote();
int intMemberGCount = dsMemberG.Tables[0].Rows.Count;
int intMemberPCount = dsMemberP.Tables[0].Rows.Count;
int intFeeCount = dsFee.Tables[0].Rows.Count;
int intPaperCount = dsPaper.Tables[0].Rows.Count;
int intOnsite = dsOnSite.Tables[0].Rows.Count;
int intRegister = dsRegister.Tables[0].Rows.Count;
int intReceipt = dsReceipt.Tables[0].Rows.Count;
int intVote = dsVote.Tables[0].Rows.Count;
lbl_MemberGAll.Text = intMemberGCount.ToString();
lbl_MemberPAll.Text = intMemberPCount.ToString();
lbl_FeeAll.Text = intFeeCount.ToString();
lbl_PaperAll.Text = intPaperCount.ToString();
lbl_OnSiteAll.Text = intOnsite.ToString();
lbl_RegisterAll.Text = intRegister.ToString();
lbl_ReceiptAll.Text = intReceipt.ToString();
lbl_VoteAll.Text = intVote.ToString();
}
/// <summary>
/// 在背景所執行的動作
/// </summary>
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
try
{
TestLibrary.BLL.BAccessTable bll = new TestLibrary.BLL.BAccessTable();
#region 前置取得DataSet
DataSet dsMemberG = bll.GetACCMemberG();
DataSet dsMemberP = bll.GetACCMemberP();
DataSet dsYear = bll.GetYearList();
DataSet dsPaper = bll.GetPaperList();
//年會相關
DataSet dsOnSite = bll.GetOnSiteList();
DataSet dsRegister = bll.GetRegister();
DataSet dsReceipt = bll.GetReceipt();
DataSet dsVote = bll.GetVote();
//費用
DataSet dsFee = bll.GetFeeList();
BFeeP bFeeP = new BFeeP();
bFeeP.DelAll();
lbState.Invoke((Action <string>)SetStatus, "刪除foodorg所有個人費用資料");
#endregion
//團體會員
SetMemberGTrans(dsMemberG);
//個人會員
SetMemberPTrans(dsMemberP);
///論文轉換
SetPaperTrans(dsPaper);
#region 年會部份
///收據
SetReceiptTrans(dsReceipt);
///選票
SetVoteTrans(dsVote);
///年會報名
SetRegisterTrans(dsRegister);
///現場會員
SetOnSiteRegistrationTrans(dsOnSite);
#endregion
///Fee的費用轉換
SetFeeTrans(dsFee);
lbState.Invoke((Action <string>)SetStatus, "完成");
string message = "轉換完成";
string title = "完成";
MessageBoxButtons buttons = MessageBoxButtons.OK;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.OK)
{
if (!backgroundWorker1.IsBusy)
{
//LoadData();
}
}
}
catch (Exception ex)
{
lbState.Invoke((Action <string>)SetStatus, ex.ToString());
//MessageBox.Show(this,ex.ToString);
}
}