public void Update(CommissionSettlementInfo commissionSettlementInfo) { DataCommand dc = DataCommandManager.GetDataCommand("UpdateCommissionSettlementInfo"); dc.SetParameterValue("@SysNo", commissionSettlementInfo.SysNo); dc.SetParameterValue("@CommissionAmt", commissionSettlementInfo.CommissionAmt); dc.SetParameterValue("@ConfirmCommissionAmt", commissionSettlementInfo.CommissionAmt); dc.ExecuteNonQuery(); }
public void Insert(CommissionSettlementInfo commissionSettlementInfo) { DataCommand dc = DataCommandManager.GetDataCommand("InsertCommissionSettlementInfo"); dc.SetParameterValue("@UserSysNo", commissionSettlementInfo.UserSysNo); dc.SetParameterValue("@Status", commissionSettlementInfo.Status); dc.SetParameterValue("@SettledBeginDate", commissionSettlementInfo.SettledBeginDate); dc.SetParameterValue("@SettledEndDate", commissionSettlementInfo.SettledEndDate); dc.SetParameterValue("@InUser", commissionSettlementInfo.OperateUser); dc.ExecuteNonQuery(); }
public void ProcessUserSettledCommissionInfo(int userSysNo) { var endDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var beginDate = endDate.AddMonths(-1); var commissionSettlementItemInfoList = ObjectFactory <ICommissionSettlementItemDA> .Instance.GetCommissionSettlementItemInfoListByUserSysNo( userSysNo, beginDate, endDate, FinanceStatus.Unsettled); var commissionSettlementInfo = new CommissionSettlementInfo { UserSysNo = userSysNo, Status = FinanceStatus.Settled, SettledBeginDate = beginDate, SettledEndDate = endDate, OperateUser = "******" }; ObjectFactory <ICommissionSettlementDA> .Instance.Insert(commissionSettlementInfo); if (commissionSettlementInfo.SysNo.HasValue) { commissionSettlementItemInfoList.ForEach(item => { item.CommissionSettlementItemSOItemCalculateInfoList = item.Type == CPSOrderType.SO ? GetSOCalculateInfo(item.OrderSysNo) : GetRMACalculateInfo(item.OrderSysNo); item.CommissionAmt = item.CommissionSettlementItemSOItemCalculateInfoList.Sum(i => i.Price * i.Qty * i.Percentage); item.Status = FinanceStatus.Settled; item.CommissionSettlementSysNo = commissionSettlementInfo.SysNo; item.OperateUser = "******"; ObjectFactory <ICommissionSettlementItemDA> .Instance.Update(item); }); decimal totalAmt = 0; commissionSettlementItemInfoList.ForEach(item => { if (item.Type == CPSOrderType.SO) { totalAmt += item.CommissionAmt; } else { totalAmt -= item.CommissionAmt; } }); commissionSettlementInfo.CommissionAmt = totalAmt; ObjectFactory <ICommissionSettlementDA> .Instance.Update(commissionSettlementInfo); ObjectFactory <ICpsUserDA> .Instance.AddUserBalanceAmt(userSysNo, totalAmt); } }