/// <summary>
/// 年會報名匯入
/// </summary>
protected void SetRegisterTrans(DataSet dsRegister)
{
BRegister bRegister = new BRegister();
//刪除所有年會報名
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg線上報名資料");
bRegister.DelAll();
lbState.Invoke((Action <string>)SetStatus, "從access取年會報名資料移到FoodOrg");
lbl_RegisterAll.Invoke((Action <string>)SetRegisterAll, dsRegister.Tables[0].Rows.Count.ToString());
int intRegisterCount = 0;
foreach (DataRow dr in dsRegister.Tables[0].Rows)
{
MRegister mod = new MRegister();
mod.TWYear = SetTWYear(dr["Period"].ToString());
mod.MemberID = SetMemberGed(dr["MemberID"].ToString());
//dr[""].ToString()
mod.MemberType = dr["MemberType"].ToString();
mod.RegisterName = dr["RegisterName"].ToString();
//格式 03-5223191*327
string strTEL = dr["Tel1"].ToString();
if (strTEL.Trim().Length > 0)
{
strTEL += "-";
}
strTEL += dr["Tel2"].ToString();
if (dr["Ext"].ToString().Trim().Length > 0)
{
strTEL += "*" + dr["Ext"].ToString().Trim();
}
mod.TEL = strTEL;
mod.Email1 = dr["Email1"].ToString();
mod.Email2 = dr["Email2"].ToString();
mod.ZipCode = "";
mod.City = "";
mod.Area = "";
mod.Address = dr["Address"].ToString();
mod.MealType = dr["MealType"].ToString();
mod.RegisterDate = Convert.ToDateTime(dr["RegisterDate"].ToString());
mod.UpdateDate = Convert.ToDateTime(dr["UpdtaeDate"].ToString());
new BRegister().Add(mod);
intRegisterCount++;
lbRegisterCount.Invoke((Action <int>)SetRegister, intRegisterCount);
}
}
