/// <summary>
/// 現場會員匯入
/// </summary>
protected void SetOnSiteRegistrationTrans(DataSet dsOnSite)
{
BOnSiteRegistration bOnsite = new BOnSiteRegistration();
//刪除所有年會報名資料
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg年會報到資料");
bOnsite.DelAll();
lbState.Invoke((Action <string>)SetStatus, "從access取年會報到資料移到FoodOrg");
lbl_OnSiteAll.Invoke((Action <string>)SetOnSiteAll, dsOnSite.Tables[0].Rows.Count.ToString());
int intOnSiteCount = 0;
foreach (DataRow dr in dsOnSite.Tables[0].Rows)
{
if (!(dr["MemberID"].ToString().IndexOf("-1") > 0))
{
MOnSiteRegistration mod = new MOnSiteRegistration();
mod.TWYear = SetTWYear(dr["Period"].ToString());
mod.MemberType = dr["MemberType"].ToString();
mod.MemberID = SetMemberGed(dr["MemberID"].ToString());
mod.RegisterName = dr["RegisterName"].ToString();
mod.Company = dr["Company"].ToString();
mod.Fee2 = Convert.ToInt32(dr["Fee1"].ToString());
mod.Fee3 = Convert.ToInt32(dr["Fee2"].ToString());
mod.PayType = dr["FeeType"].ToString();
mod.Attend = Convert.ToBoolean(dr["Attend"].ToString());
mod.MealType = dr["MealType"].ToString();
mod.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
mod.CreateUser = dr["CreateUser"].ToString();
mod.UpdateDate = Convert.ToDateTime(dr["UpdateDate"].ToString());
mod.UpdateUser = dr["UpdateUser"].ToString();
if (mod.MemberType == "P")
{
MFeeP mFee = new MFeeP();
mFee.MemberPID = mod.MemberID;
mFee.TWYear = mod.TWYear;
mFee.PayType = mod.PayType;
mFee.Fee1 = 0;
mFee.Fee2 = mod.Fee2;
mFee.Fee3 = mod.Fee3;
mFee.PayDate = mod.UpdateDate;
mFee.Remark = "";
mod.FeeID = new BFeeP().Add(mFee);
}
new BOnSiteRegistration().Add(mod);
intOnSiteCount++;
lbOnSiteCount.Invoke((Action <int>)SetOnSite, intOnSiteCount);
}
}
}
/// <summary>
/// 費用匯入
/// </summary>
protected void SetFeeTrans(DataSet dsFee)
{
lbState.Invoke((Action <string>)SetStatus, "從access取費用資料移到FoodOrg");
lbl_VoteAll.Invoke((Action <string>)SetVoteAll, dsFee.Tables[0].Rows.Count.ToString());
int intFeeCount = 0;
//TB_Fee在轉的時後，把orderid 放到新的TB_FeeP的時後，把OrderID放到Remark
foreach (DataRow dr in dsFee.Tables[0].Rows)
{
if (!(dr["MemberID"].ToString().IndexOf("-1") > 0))
{
MFeeP mod = new MFeeP();
mod.MemberPID = SetMemberGed(dr["MemberID"].ToString());
mod.TWYear = SetTWYear(dr["Period"].ToString());
if (dr["Store"].ToString().Length == 0)
{
mod.PayType = "虛擬帳戶";
}
else
{
mod.PayType = "超商條碼";
}
//Access為總計 只有三種金額 400 500 900
int intFeeTotalCount = Convert.ToInt32(dr["Fee"].ToString());
//switch(intFeeCount)
//{
// case 400:
// //
// mod.Fee1 = 0;
// break;
// case 500:
// //
// mod.Fee1 = 0;
// break;
// case 900:
// //
// mod.Fee1 = 0;
// break;
//}
int intPayType = Convert.ToInt32(dr["FeeType"].ToString());
switch (intPayType)
{
//常年會費+年會出席費
case 1:
//200 400 500 600 900 有這幾種價格
mod.Fee1 = 0;
switch (intFeeTotalCount)
{
case 200:
mod.Fee1 = 0;
mod.Fee2 = 200;
mod.Fee3 = 0;
break;
case 400:
//
if (mod.MemberPID.Length == 0)
{
mod.Fee1 = 0;
mod.Fee2 = 400;
mod.Fee3 = 0;
}
else
{
MMemberP Member = new BMemberP().GetModel(mod.MemberPID);
if (Member == null)
{
mod.Fee1 = 0;
mod.Fee2 = 400;
mod.Fee3 = 0;
}
else
{
if (Member.MemberClass == "永久")
{
mod.Fee1 = 0;
mod.Fee2 = 0;
mod.Fee3 = 400;
}
else
{
mod.Fee1 = 0;
mod.Fee2 = 200;
mod.Fee3 = 200;
}
}
}
break;
case 500:
//
mod.Fee1 = 0;
if (mod.MemberPID == "10980" | mod.MemberPID == "11048" | mod.MemberPID == "11083" | mod.MemberPID == "05862")
{
mod.Fee2 = 300;
mod.Fee3 = 200;
}
else
{
mod.Fee2 = 500;
mod.Fee3 = 0;
}
break;
case 600:
//
mod.Fee1 = 0;
mod.Fee2 = 200;
mod.Fee3 = 400;
break;
case 900:
//
mod.Fee1 = 0;
mod.Fee2 = 500;
mod.Fee3 = 400;
break;
}
break;
//常年會費
case 2:
//
mod.Fee1 = 0;
mod.Fee2 = intFeeTotalCount;
mod.Fee3 = 0;
break;
//年會出席費
case 3:
//
mod.Fee1 = 0;
mod.Fee2 = 0;
mod.Fee3 = intFeeTotalCount;
break;
}
mod.PayDate = Convert.ToDateTime(dr["PayDate"].ToString());
mod.Remark = dr["OrderID"].ToString();
//dr["RecDate"].ToString();
new BFeeP().Add(mod);
intFeeCount++;
lbVoteCount.Invoke((Action <int>)SetFee, intFeeCount);
}
}
}
