public void Insert(int? CashOrderID,int? CashCompanyID,int CashSum,int? CreatedBy,DateTime? CreatedOn,int? ModifiedBy,DateTime? ModifiedOn)
{
OrdersCashCompany item = new OrdersCashCompany();
item.CashOrderID = CashOrderID;
item.CashCompanyID = CashCompanyID;
item.CashSum = CashSum;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.Save(UserName);
}
public static bool SaveSaleRate(Order data, SysMember member,out string message)
{
message = string.Empty;
//赠送积分＝(现金支付＋储值支付) ＊ 赠送比例
data.OrderPoint = (data.OrderPay + data.OrderPayCash) * data.OrderRate;
if (data.OrderPoint.HasValue && data.OrderPoint > 0)
{
if (CompanyBLL.IsMaxPointLevel(data.OrderSellerID, data.OrderPoint.Value))
{
message = "累计赠送的积分已经超过500，须进行积分结算后才能继续操作系统";
return false;
}
}
data.Save( );
//data.OrderPoint = (AppContextBase.Context.Company.CompanyType == 2) ? (data.OrderPayCash * data.OrderRate) : ((data.OrderPay + data.OrderPayCash) * data.OrderRate);
//推荐好友奖励
RewardBLL.RewardMemberPoint(member, data);
if (data.OrderPoint > 0M)
{
new Payment
{
PaymentDate = data.OrderDate,
PaymentCompanyID = data.OrderSellerID,
PaymentMemberID = data.OrderMemberID,
PaymentMemo = string.Format("在【{0}】消费{1:0.00}元,并获赠{2:0.00}个积分", AppContextBase.Context.Company.CompanyName,data.OrderSumOk, data.OrderPoint.Value.ToString("#####0.00")),
PaymentStatus = 1,
PaymentSum = Convert.ToDecimal(data.OrderPoint),
PaymentType = 1,
PaymentOrderID = data.Id,
PaymentCode = data.OrderCode,
PaymentEmail = string.Empty
}.Save( );
}
if (data.OrderPayPoint > 0M)
{
new Payment
{
PaymentDate = data.OrderDate,
PaymentCompanyID = data.OrderSellerID,
PaymentMemberID = data.OrderMemberID,
PaymentMemo = string.Format("在【{0}】消费{1:0.00}元，其中使用{2:0.00}个积分抵扣", AppContextBase.Context.Company.CompanyName, data.OrderSumOk, Math.Abs(data.OrderPayPoint.Value).ToString("#####0.00")),
PaymentStatus = 1,
PaymentSum = -Convert.ToDecimal(data.OrderPayPoint),
PaymentType = 2,
PaymentOrderID = data.Id,
PaymentCode = data.OrderCode,
PaymentEmail = string.Empty
}.Save( );
}
if (data.OrderPayCash > 0M)
{
#region hot company
if (CompanyBLL.GetCompanyType(AppContextBase.Context.Company.CompanyType) == CompanyType.MealCompany)
{
string queryCode = string.Concat(AreaBLL.GetCompanyCodePrefix(AppContextBase.Context.Company.CompanyCode), "%");
//queryCode = queryCode.Substring(0, queryCode.Length - 2) + "%";
var query = DB.Select("CashCompanyID", "sum(CashSum) as CashSum")
.From<SysMemberCash>( ).InnerJoin(SysCompany.IdColumn, SysMemberCash.CashCompanyIDColumn)
.Where(SysMemberCash.CashMemberIDColumn).IsEqualTo(member.Id)
.And(SysCompany.CompanyCodeColumn).Like(queryCode)
.ConstraintExpression("Group By CashCompanyID");
DataTable result = query.ExecuteDataTable( );
foreach (DataRow row in result.Rows)
{
if (!Utilities.IsNull(row["CashSum"]) && Convert.ToDecimal(row["CashSum"]) > 0M)
{
OrdersCashCompany orders_cashcompany = new OrdersCashCompany
{
CashCompanyID = Convert.ToInt32(row["CashCompanyID"]),
CashOrderID = data.Id,
CashSum = Convert.ToInt32(data.OrderPayCash)
};
if (Convert.ToInt32(row["CashCompanyID"]) != data.OrderSellerID)
{
orders_cashcompany.Save( );
}
new PaymentCash
{
PaymentCashDate = data.OrderDate,
PaymentCashCompanyID = orders_cashcompany.CashCompanyID,
PaymentCashMemberID = data.OrderMemberID,
PaymentMemo = string.Format("在【{0}】消费{1:0.00}元，使用储值支付{2:0.00}元", AppContextBase.Context.Company.CompanyName, data.OrderSumOk, Math.Abs(data.OrderPayCash.Value).ToString("######.##")),
PaymentStatus = 1,
PaymentCashSum = -Convert.ToDecimal(data.OrderPayCash),
PaymentType = 2,
PaymentOrderID = data.Id,
PaymentCashCode = data.OrderCode
}.Save( );
new SysMemberCash
{
CashCompanyID = orders_cashcompany.CashCompanyID,
CashMemberID = data.OrderMemberID,
CashOrderID = data.Id,
CashDate = data.OrderDate,
CashSum = -data.OrderPayCash,
CashRate = 0M,
CashPoint = 0,
CashMemo = "储值支付",
CashRateSale = 0,
}.Save( );
}
}
}
#endregion
else
{
new PaymentCash
{
PaymentCashDate = data.OrderDate,
PaymentCashCompanyID = data.OrderSellerID,
PaymentCashMemberID = data.OrderMemberID,
PaymentMemo = string.Format("在【{0}】消费{1:0.00}元，其中储值支付{2:0.00}元", AppContextBase.Context.Company.CompanyName, data.OrderSumOk, Math.Abs(data.OrderPayCash.Value).ToString("#######.##")),
PaymentStatus = 1,
PaymentCashSum = -Convert.ToDecimal(data.OrderPayCash),
PaymentType = 2,
PaymentOrderID = data.Id,
PaymentCashCode = data.OrderCode
}.Save( );
new SysMemberCash
{
CashCompanyID = data.OrderSellerID,
CashMemberID = data.OrderMemberID,
CashOrderID = data.Id,
CashDate = data.OrderDate,
CashSum = -(data.OrderPayCash),
CashRate = 0M,
CashPoint = 0,
CashMemo = "储值支付",
CashRateSale = 0
}.Save( );
}
}
return true;
}
public void Update(int Id,int? CashOrderID,int? CashCompanyID,int CashSum,int? CreatedBy,DateTime? CreatedOn,int? ModifiedBy,DateTime? ModifiedOn)
{
OrdersCashCompany item = new OrdersCashCompany();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.CashOrderID = CashOrderID;
item.CashCompanyID = CashCompanyID;
item.CashSum = CashSum;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.Save(UserName);
}
