/// <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);
}
}
/// <summary>
/// 論文匯入
/// </summary>
protected void SetPaperTrans(DataSet dsPaper)
{
//有三項要轉
//1.paper
//2.paperDomainSeq
//3.PaperSuggestion
TestLibrary.BLL.BAccessTable bll = new TestLibrary.BLL.BAccessTable();
BPaper bPaper = new BPaper();
//刪除所有paper
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg論文資料");
bPaper.DelAll();
bPaper.DelPaperSuggestionAll();
bPaper.DelPaperDomainSeqAll();
lbState.Invoke((Action <string>)SetStatus, "從access取論文資料移到FoodOrg");
//1取得所有paper
//DataSet dsPaper = new BAccessTable().GetPaperList();
lbl_PaperAll.Invoke((Action <string>)SetPaperAll, dsPaper.Tables[0].Rows.Count.ToString());
int intPaperCount = 1;
foreach (DataRow dr in dsPaper.Tables[0].Rows)
{
MPaper mPaper = new MPaper();
mPaper.PaperID = Convert.ToInt32(dr["PaperID"].ToString());
mPaper.TWYear = SetTWYear(dr["Period"].ToString());
mPaper.PaperTitle = dr["PaperTitle"].ToString();
mPaper.PaperAuthor = dr["PaperAuthor"].ToString();
mPaper.Company = dr["Company"].ToString();
mPaper.SummaryC = dr["SummaryC"].ToString().Replace("\r\n", "");
mPaper.SummaryE = dr["SummaryE"].ToString().Replace("\r\n", "");
mPaper.MemberType = dr["MemberType"].ToString();
mPaper.MemberID = SetMemberGed(dr["MARK"].ToString());
mPaper.Tel1 = dr["Tel1"].ToString();
mPaper.Tel2 = dr["Tel2"].ToString();
mPaper.Ext = dr["Ext"].ToString();
mPaper.Fax1 = dr["Fax1"].ToString();
mPaper.Fax2 = dr["Fax2"].ToString();
mPaper.Email = dr["Email"].ToString();
mPaper.UploadDate = Convert.ToDateTime(dr["UploadDate"].ToString());
mPaper.PaperDomainID = dr["PaperDomainID"].ToString();
mPaper.PublishType = dr["PublishType"].ToString();
mPaper.Publish = Convert.ToBoolean(dr["Publish"].ToString());
mPaper.FileExtension = dr["FileExtension"].ToString();
mPaper.Examine = dr["Examine"].ToString();
if (dr["ExamineDate"].ToString().Length != 0)
{
mPaper.ExamineDate = Convert.ToDateTime(dr["ExamineDate"].ToString());
}
mPaper.PaperNo = dr["PaperNo"].ToString();
bPaper.Add(mPaper);
int intPaperID = mPaper.PaperID;
//2.paperDomainSeq
DataSet dsPaperDomainSeq = bll.GetPaperDomainSeqListByPaperID(Convert.ToInt32(dr["PaperID"].ToString()));
foreach (DataRow drDomainSeq in dsPaperDomainSeq.Tables[0].Rows)
{
MPaperDomainSeq mDomainSeq = new MPaperDomainSeq();
mDomainSeq.PaperID = intPaperID;
mDomainSeq.PaperDomainID = drDomainSeq["PaperDomainID"].ToString();
mDomainSeq.Seq = Convert.ToInt32(drDomainSeq["Seq"].ToString());
new BPaperDomainSeq().Add(mDomainSeq);
}
//3.PaperSuggestion
DataSet dsPaperSuggestion = bll.GetPaperSuggestionListByPaperID(Convert.ToInt32(dr["PaperID"].ToString()));
foreach (DataRow drSuggestion in dsPaperSuggestion.Tables[0].Rows)
{
MPaperSuggestion mSuggestion = new MPaperSuggestion();
mSuggestion.PaperID = intPaperID;
mSuggestion.PaperSuggestion = drSuggestion["PaperSuggestion"].ToString();
mSuggestion.CreateDate = Convert.ToDateTime(drSuggestion["CreateDate"].ToString());
new BPaperSuggestion().Add(mSuggestion);
}
lbPaperCount.Invoke((Action <int>)SetPaper, intPaperCount);
intPaperCount++;
}
}