public void Insert(DateTime? CashDate,int? CashMemberID,int? CashCompanyID,int? CashOrderID,decimal? CashSum,decimal? CashRate,decimal? CashRateSale,decimal? CashPoint,string CashMemo,int? CreatedBy,DateTime? CreatedOn,int? ModifiedBy,DateTime? ModifiedOn)
{
SysMemberCash item = new SysMemberCash();
item.CashDate = CashDate;
item.CashMemberID = CashMemberID;
item.CashCompanyID = CashCompanyID;
item.CashOrderID = CashOrderID;
item.CashSum = CashSum;
item.CashRate = CashRate;
item.CashRateSale = CashRateSale;
item.CashPoint = CashPoint;
item.CashMemo = CashMemo;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.Save(UserName);
}
void SaveMemberCash(DataRow row, SysMember user)
{
decimal dBalanceCash = row.Table.Columns.Contains(ColumnMap[SysMember.MemberBalanceCashColumn]) ? Utilities.ToDecimal(row[ColumnMap[SysMember.MemberBalanceCashColumn]]) : 0M,
dBalancePoint = row.Table.Columns.Contains(ColumnMap[SysMember.MemberBalanceColumn]) ? Utilities.ToInt(row[ColumnMap[SysMember.MemberBalanceColumn]]) : 0M,
dMemberRate = (row.Table.Columns.Contains(ColumnMap[SysMemberCash.CashRateColumn]) ? Utilities.ToDecimal(row[ColumnMap[SysMemberCash.CashRateColumn]]) : 0M) / 100M;
decimal dCashRateSale = 0M;
if (row.Table.Columns.Contains(ColumnMap[SysMemberCash.CashRateSaleColumn]))
dCashRateSale = Utilities.ToDecimal(row[ColumnMap[SysMemberCash.CashRateSaleColumn]]) / 100M;
if (dBalanceCash > 0)
{
SysMemberCash cash = new SysMemberCash
{
CashCompanyID = CurrentUser.CompanyId,
CashMemberID = user.Id,
CashDate = DateTime.Now,
CashMemo = GetMemberGrade(Utilities.ToString(row[ColumnMap[SysCompanyMemberGrade.GradeNameColumn]])).ToString( ),
CashOrderID = -1,
CashSum = dBalanceCash,
CashRate = dMemberRate,
CashPoint = 0,
CashRateSale = dCashRateSale
};
cash.Save( );
new PaymentCash
{
PaymentCashCode = string.Empty,
PaymentCashCompanyID = CurrentUser.CompanyId,
PaymentCashMemberID = user.Id,
PaymentCashDate = DateTime.Now,
PaymentMemo = string.Format("在【{0}】已经成功导入{1:0.00}元储值", AppContext.Context.Company.CompanyName, dBalanceCash.ToString("###0.00")),
PaymentOrderID = cash.CashID,
PaymentStatus = 1,
PaymentCashSum = dBalanceCash,
PaymentType = (int)PaymentCashType.Import
}.Save( );
}
if (dBalancePoint > 0)
{
new Payment
{
PaymentCode = string.Empty,
PaymentCompanyID = CurrentUser.CompanyId,
PaymentMemberID = user.Id,
PaymentDate = DateTime.Now,
PaymentMemo = string.Format("在【{0}】已经成功导入{1:0.00}个积分", AppContext.Context.Company.CompanyName, dBalancePoint.ToString("###0.00")),
PaymentOrderID = 0,
PaymentStatus = 1,
PaymentSum = dBalancePoint,
PaymentType = (int)PaymentType.Import,
PaymentEmail = string.Empty
}.Save( );
}
}
public static bool SaveMemberCash(SysMemberCash cash, SysMember user,out string message)
{
//check is owner user
//if (!CompanyBLL.CheckIsOwnerUser(user.Id, cash.CashCompanyID.Value))
//{
// new SysMemberCompany
// {
// MemberCompanyCompanyID = cash.CashCompanyID.Value,
// MemberCompanyDate = DateTime.Now,
// MemberCompanyMemberID = user.Id
// }.Save( );
//}
message = "";
if (cash.CashPoint.HasValue && cash.CashPoint.Value > 0)
{
if (CompanyBLL.IsMaxPointLevel(cash.CashCompanyID.Value, cash.CashPoint.Value))
{
message = "累计赠送的积分已经超过500，须进行积分结算后才能继续操作系统";
return false;
}
}
cash.Save( );
new PaymentCash
{
PaymentCashCode = "",
PaymentCashDate = DateTime.Now,
PaymentCashCompanyID = cash.CashCompanyID,
PaymentCashMemberID = cash.CashMemberID,
PaymentCashSum = Convert.ToDecimal(cash.CashSum),
PaymentOrderID = cash.CashID,
PaymentMemo = string.Format("在【{0}】充值{1:0.00}元，并获赠{2:0.00}个积分", AppContextBase.Context.Company.CompanyName, cash.CashSum, cash.CashPoint),
PaymentStatus = 1,
PaymentType = 1
}.Save( );
if (cash.CashPoint > 0)
{
new Payment
{
PaymentCode = "",
PaymentDate = DateTime.Now,
PaymentCompanyID = cash.CashCompanyID,
PaymentMemberID = cash.CashMemberID,
PaymentSum = Convert.ToDecimal(cash.CashPoint),
PaymentOrderID = cash.CashID,
PaymentMemo = string.Format("在【{0}】充值{1:0.00}元，并获赠{2:0.00}个积分", AppContextBase.Context.Company.CompanyName, cash.CashSum, cash.CashPoint),
PaymentStatus = 1,
PaymentType = 3,
PaymentEmail = ""
}.Save( );
}
return true;
}
