442 lines
18 KiB
C#
442 lines
18 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Text;
|
||
using System.Data;
|
||
using WeiSha.Common;
|
||
using Song.Entities;
|
||
using WeiSha.Data;
|
||
using Song.ServiceInterfaces;
|
||
using System.Data.Common;
|
||
|
||
|
||
|
||
namespace Song.ServiceImpls
|
||
{
|
||
public class ProfitSharingCom : IProfitSharing
|
||
{
|
||
#region 分润方案的管理
|
||
/// <summary>
|
||
/// 添加分润主题
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public int ThemeAdd(ProfitSharing entity)
|
||
{
|
||
//添加对象，并设置排序号
|
||
object obj = Gateway.Default.Max<ProfitSharing>(ProfitSharing._.Ps_Level, ProfitSharing._.Ps_IsTheme == true);
|
||
int tax = obj is int ? (int)obj : 0;
|
||
entity.Ps_Level = tax + 1;
|
||
entity.Ps_IsTheme = true;
|
||
Gateway.Default.Save<ProfitSharing>(entity);
|
||
return entity.Ps_ID;
|
||
}
|
||
/// <summary>
|
||
/// 修改
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ThemeSave(ProfitSharing entity)
|
||
{
|
||
Gateway.Default.Save<ProfitSharing>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 当前分润方案
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public ProfitSharing ThemeCurrent()
|
||
{
|
||
Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
if (org == null) return null;
|
||
return ThemeCurrent(org.Org_ID);
|
||
}
|
||
/// <summary>
|
||
/// 机构的分润方案
|
||
/// </summary>
|
||
/// <param name="orgid">机构id</param>
|
||
/// <returns></returns>
|
||
public ProfitSharing ThemeCurrent(int orgid)
|
||
{
|
||
//课程所在机构
|
||
Organization org = Business.Do<IOrganization>().OrganSingle(orgid);
|
||
if (org == null) return null;
|
||
//所属机构等级
|
||
OrganLevel olevel = Business.Do<IOrganization>().LevelSingle(org.Olv_ID);
|
||
if (olevel == null) return null;
|
||
//分润方案
|
||
ProfitSharing psTheme = this.ThemeSingle(olevel.Ps_ID);
|
||
if (psTheme == null) return null; //如果没有设置分润方案
|
||
if (!psTheme.Ps_IsUse) return null; //如果分润方案没有启用
|
||
return psTheme;
|
||
}
|
||
/// <summary>
|
||
/// 删除
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ThemeDelete(ProfitSharing entity)
|
||
{
|
||
this.ThemeDelete(entity.Ps_ID);
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void ThemeDelete(int identify)
|
||
{
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Delete<ProfitSharing>(ProfitSharing._.Ps_ID==identify);
|
||
tran.Delete<ProfitSharing>(ProfitSharing._.Ps_PID == identify);
|
||
tran.Commit();
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public ProfitSharing ThemeSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == identify).ToFirst<ProfitSharing>();
|
||
}
|
||
/// <summary>
|
||
/// 获取对象；即所有分类；
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public ProfitSharing[] ThemeAll(bool? isUse)
|
||
{
|
||
WhereClip wc = ProfitSharing._.Ps_IsTheme == true;
|
||
if (isUse != null) wc.And(ProfitSharing._.Ps_IsUse == (bool)isUse);
|
||
return Gateway.Default.From<ProfitSharing>().Where(wc).OrderBy(ProfitSharing._.Ps_Level.Asc).ToArray<ProfitSharing>();
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向上移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ThemeRemoveUp(int id)
|
||
{
|
||
//当前对象
|
||
ProfitSharing current = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == id).ToFirst<ProfitSharing>();
|
||
//当前对象排序号
|
||
int orderValue = (int)current.Ps_Level;
|
||
//上一个对象，即兄长对象；
|
||
ProfitSharing up = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_IsTheme == true && ProfitSharing._.Ps_Level < orderValue)
|
||
.OrderBy(ProfitSharing._.Ps_Level.Desc).ToFirst<ProfitSharing>();
|
||
//如果兄长对象不存在，则表示当前节点在兄弟中是老大；即是最顶点；
|
||
if (up == null) return false;
|
||
//交换排序号
|
||
current.Ps_Level = up.Ps_Level;
|
||
up.Ps_Level = orderValue;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<ProfitSharing>(current);
|
||
tran.Save<ProfitSharing>(up);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向下移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ThemeRemoveDown(int id)
|
||
{
|
||
//当前对象
|
||
ProfitSharing current = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == id).ToFirst<ProfitSharing>();
|
||
//当前对象排序号
|
||
int orderValue = (int)current.Ps_Level;
|
||
//下一个对象，即弟弟对象；
|
||
ProfitSharing down = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_IsTheme == true && ProfitSharing._.Ps_Level > orderValue)
|
||
.OrderBy(ProfitSharing._.Ps_Level.Asc).ToFirst<ProfitSharing>();
|
||
//如果弟对象不存在，则表示当前节点在兄弟中是老幺；即是最底端；
|
||
if (down == null) return false;
|
||
//交换排序号
|
||
current.Ps_Level = down.Ps_Level;
|
||
down.Ps_Level = orderValue;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<ProfitSharing>(current);
|
||
tran.Save<ProfitSharing>(down);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 分润等级比例设置
|
||
/// <summary>
|
||
/// 添加分润项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public int ProfitAdd(ProfitSharing entity)
|
||
{
|
||
//添加对象，并设置排序号
|
||
object obj = Gateway.Default.Max<ProfitSharing>(ProfitSharing._.Ps_Level, ProfitSharing._.Ps_PID == entity.Ps_PID);
|
||
int tax = obj is int ? (int)obj : 0;
|
||
entity.Ps_Level = tax + 1;
|
||
entity.Ps_IsTheme = false;
|
||
//验证资金分润比例之合，是否大于100
|
||
object objm = Gateway.Default.Sum<ProfitSharing>(ProfitSharing._.Ps_Moneyratio, ProfitSharing._.Ps_PID == entity.Ps_PID);
|
||
int summ = objm is int ? (int)objm : 0;
|
||
if ((summ + entity.Ps_Moneyratio) > 100) throw new Exception("资金分润比例之合，不得大于100");
|
||
//验证卡券分润比例之合，是否大于100
|
||
object objc = Gateway.Default.Sum<ProfitSharing>(ProfitSharing._.Ps_Moneyratio, ProfitSharing._.Ps_PID == entity.Ps_PID);
|
||
int sumc = objc is int ? (int)objc : 0;
|
||
if ((sumc + entity.Ps_Couponratio) > 100) throw new Exception("卡券分润比例之合，不得大于100");
|
||
Gateway.Default.Save<ProfitSharing>(entity);
|
||
return entity.Ps_ID;
|
||
}
|
||
/// <summary>
|
||
/// 修改
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ProfitSave(ProfitSharing entity)
|
||
{
|
||
//验证资金分润比例之合，是否大于100
|
||
object objm = Gateway.Default.Sum<ProfitSharing>(ProfitSharing._.Ps_Moneyratio, ProfitSharing._.Ps_PID == entity.Ps_PID && ProfitSharing._.Ps_ID != entity.Ps_ID);
|
||
int summ = objm is int ? (int)objm : 0;
|
||
if ((summ + entity.Ps_Moneyratio) > 100) throw new Exception("资金分润比例之合，不得大于100");
|
||
//验证卡券分润比例之合，是否大于100
|
||
object objc= Gateway.Default.Sum<ProfitSharing>(ProfitSharing._.Ps_Moneyratio, ProfitSharing._.Ps_PID == entity.Ps_PID && ProfitSharing._.Ps_ID != entity.Ps_ID);
|
||
int sumc = objc is int ? (int)objc : 0;
|
||
if ((sumc + entity.Ps_Couponratio) > 100) throw new Exception("卡券分润比例之合，不得大于100");
|
||
//保存
|
||
Gateway.Default.Save<ProfitSharing>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 删除
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ProfitDelete(ProfitSharing entity)
|
||
{
|
||
Gateway.Default.Delete<ProfitSharing>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void ProfitDelete(int identify)
|
||
{
|
||
Gateway.Default.Delete<ProfitSharing>(ProfitSharing._.Ps_ID == identify);
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public ProfitSharing ProfitSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == identify).ToFirst<ProfitSharing>();
|
||
}
|
||
/// <summary>
|
||
/// 获取对象；即所有分类；
|
||
/// </summary>
|
||
/// <param name="theme">方案主题的id</param>
|
||
/// <param name="isUse"></param>
|
||
/// <returns></returns>
|
||
public ProfitSharing[] ProfitAll(int theme, bool? isUse)
|
||
{
|
||
WhereClip wc = ProfitSharing._.Ps_IsTheme == false && ProfitSharing._.Ps_PID == theme;
|
||
if (isUse != null) wc.And(ProfitSharing._.Ps_IsUse == (bool)isUse);
|
||
return Gateway.Default.From<ProfitSharing>().Where(wc).OrderBy(ProfitSharing._.Ps_Level.Asc).ToArray<ProfitSharing>();
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向上移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ProfitRemoveUp(int id)
|
||
{
|
||
//当前对象
|
||
ProfitSharing current = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == id).ToFirst<ProfitSharing>();
|
||
//当前对象排序号
|
||
int orderValue = (int)current.Ps_Level;
|
||
//上一个对象，即兄长对象；
|
||
ProfitSharing up = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_PID == current.Ps_PID && ProfitSharing._.Ps_Level < orderValue)
|
||
.OrderBy(ProfitSharing._.Ps_Level.Desc).ToFirst<ProfitSharing>();
|
||
//如果兄长对象不存在，则表示当前节点在兄弟中是老大；即是最顶点；
|
||
if (up == null) return false;
|
||
//交换排序号
|
||
current.Ps_Level = up.Ps_Level;
|
||
up.Ps_Level = orderValue;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<ProfitSharing>(current);
|
||
tran.Save<ProfitSharing>(up);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向下移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ProfitRemoveDown(int id)
|
||
{
|
||
//当前对象
|
||
ProfitSharing current = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_ID == id).ToFirst<ProfitSharing>();
|
||
//当前对象排序号
|
||
int orderValue = (int)current.Ps_Level;
|
||
//下一个对象，即弟弟对象；
|
||
ProfitSharing down = Gateway.Default.From<ProfitSharing>().Where(ProfitSharing._.Ps_PID == current.Ps_PID && ProfitSharing._.Ps_Level > orderValue)
|
||
.OrderBy(ProfitSharing._.Ps_Level.Asc).ToFirst<ProfitSharing>();
|
||
//如果弟对象不存在，则表示当前节点在兄弟中是老幺；即是最底端；
|
||
if (down == null) return false;
|
||
//交换排序号
|
||
current.Ps_Level = down.Ps_Level;
|
||
down.Ps_Level = orderValue;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<ProfitSharing>(current);
|
||
tran.Save<ProfitSharing>(down);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 分润计算
|
||
/// <summary>
|
||
/// 计算分润
|
||
/// </summary>
|
||
/// <param name="couid">课程id,需要知道当前课程在哪个机构，哪个机构等级，从而获取分润方案</param>
|
||
/// <param name="money">消费的资金数</param>
|
||
/// <param name="coupon">消费的卡数</param>
|
||
/// <returns></returns>
|
||
public ProfitSharing[] Clac(int couid, double money, double coupon)
|
||
{
|
||
Course cou = Business.Do<ICourse>().CourseSingle(couid);
|
||
return Clac(cou, money, coupon);
|
||
}
|
||
public ProfitSharing[] Clac(Course cou, double money, double coupon)
|
||
{
|
||
if (cou == null) return null;
|
||
//分润方案
|
||
ProfitSharing psTheme = this.ThemeCurrent(cou.Org_ID);
|
||
if (psTheme == null) return null; //如果没有设置分润方案
|
||
if (!psTheme.Ps_IsUse) return null; //如果分润方案没有启用
|
||
ProfitSharing[] profits = this.ProfitAll(psTheme.Ps_ID, true);
|
||
if (profits.Length < 1) return null;
|
||
//计算
|
||
for (int i = 0; i < profits.Length; i++)
|
||
{
|
||
profits[i].Ps_MoneyValue = (decimal)profits[i].Ps_Moneyratio * ((decimal)money / 100);
|
||
profits[i].Ps_CouponValue = (int)Math.Floor(profits[i].Ps_Couponratio * ((double)coupon) / 100);
|
||
}
|
||
return profits;
|
||
}
|
||
/// <summary>
|
||
/// 分配利润
|
||
/// </summary>
|
||
/// <param name="cou">当前课程</param>
|
||
/// <param name="acc">当前学员账户</param>
|
||
/// <param name="money">消费的资金数</param>
|
||
/// <param name="coupon">消费的卡数</param>
|
||
public void Distribution(Course cou, Accounts acc, double money, double coupon)
|
||
{
|
||
Accounts[] parents = Business.Do<IAccounts>().Parents(acc);
|
||
if (parents.Length < 1) return;
|
||
//计算分润
|
||
ProfitSharing[] ps = this.Clac(cou, money, coupon);
|
||
if (ps == null) return;
|
||
int len = ps.Length > parents.Length ? parents.Length : ps.Length;
|
||
for (int i = 0; i < len; i++)
|
||
{
|
||
//写入资金分润
|
||
if (ps[i].Ps_MoneyValue > 0)
|
||
{
|
||
MoneyAccount ma = new MoneyAccount();
|
||
ma.Ma_Money = ps[i].Ps_MoneyValue;
|
||
ma.Ac_ID = parents[i].Ac_ID;
|
||
ma.Ma_Source = "分润";
|
||
ma.Ma_Info = string.Format("{0}（{1}）购买课程《{2}》,获取收益{3}", acc.Ac_Name, acc.Ac_AccName, cou.Cou_Name, ps[i].Ps_MoneyValue);
|
||
ma.Ma_From = 5; //
|
||
ma.Ma_IsSuccess = true;
|
||
ma.Org_ID = parents[i].Org_ID;
|
||
if (ma.Ma_Money > 0)
|
||
ma = Business.Do<IAccounts>().MoneyIncome(ma);
|
||
}
|
||
//写入卡券分润
|
||
if (ps[i].Ps_CouponValue > 0)
|
||
{
|
||
Song.Entities.CouponAccount ca = new CouponAccount();
|
||
ca.Ac_ID = parents[i].Ac_ID;
|
||
ca.Ca_Source = "分润";
|
||
ca.Ca_Value = ps[i].Ps_CouponValue;
|
||
ca.Ca_Total = parents[i].Ac_Coupon; //当前卡券总数
|
||
ca.Ca_Info = string.Format("{0}（{1}）购买课程《{2}》,获取收益{3}", acc.Ac_Name, acc.Ac_AccName, cou.Cou_Name, ps[i].Ps_CouponValue);
|
||
ca.Ca_From = 5;
|
||
if (ca.Ca_Value > 0) Business.Do<IAccounts>().CouponAdd(ca);
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
}
|
||
}
|