/// <summary>
/// 奖励积分
/// </summary>
/// <param name="id">模板ID</param>
/// <param name="Integral">积分</param>
/// <returns></returns>
public static string MemberIntegralTemplateEnumIntegral(MemberIntegralTemplateEnum id, decimal Integral)
{
string s = "";
switch (id)
{
case MemberIntegralTemplateEnum.会员注册:
s = string.Format("{0:f0}", Integral);
break;
case MemberIntegralTemplateEnum.建档通过:
s = string.Format("{0:f0}", Integral);
break;
case MemberIntegralTemplateEnum.提交交易意向:
s = string.Format("每次{0:f0}", Integral);
break;
case MemberIntegralTemplateEnum.每日签到:
s = string.Format("每次{0:f0}", Integral);
break;
case MemberIntegralTemplateEnum.成交订单:
s = string.Format("成交金额×{0}", Integral.ToString().TrimEnd('0').TrimEnd('.'));
break;
}
return(s);
}
/// <summary>
/// 频率
/// </summary>
/// <param name="id">模板ID</param>
/// <returns></returns>
public static string MemberIntegralTemplateEnumFrequency(MemberIntegralTemplateEnum id)
{
string s = "";
switch (id)
{
case MemberIntegralTemplateEnum.会员注册:
s = "一次";
break;
case MemberIntegralTemplateEnum.建档通过:
s = "一次";
break;
case MemberIntegralTemplateEnum.提交交易意向:
s = "每天10次";
break;
case MemberIntegralTemplateEnum.每日签到:
s = "每天一次";
break;
case MemberIntegralTemplateEnum.成交订单:
s = "无限制";
break;
}
return(s);
}
/// <summary>
/// 赠送积分
/// </summary>
/// <param name="uid">会员ID</param>
/// <param name="integral">积分</param>
/// <param name="remarks">描述</param>
/// <param name="isFanHuan">返回积分不更新积分表</param>
public void PresentIntegral(int uid, int integral, string remarks, bool isFanHuan = false)
{
MemberIntegralTemplateEnum me = MemberIntegralTemplateEnum.赠送积分;
MemberIntegralLock ml = new MemberIntegralLock();
if (!ml.isAllow(uid, me))
{
return;
}
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction tran = conn.BeginTransaction();
try
{
//更新积分表
if (!isFanHuan)
{
string sql = string.Format(@"IF NOT EXISTS( SELECT * FROM dbo.MemberIntegral WHERE uid={0})
INSERT INTO MemberIntegral VALUES({0},{1},{1})
ELSE
UPDATE MemberIntegral SET integral=integral+{1},realityIntegral=realityIntegral+{1} WHERE uid={0}", uid, integral);
db.ExecuteNonQuery(db.GetSqlStringCommand(sql), tran);
}
SOSOshop.BLL.Integral.MemberIntegralDetail bll = new MemberIntegralDetail();
SOSOshop.Model.Integral.MemberIntegralDetail model = new Model.Integral.MemberIntegralDetail();
model.action = "增加";
model.created = DateTime.Now;
model.integral = integral;
model.remarks = remarks;
model.uid = uid;
bll.Add(model, tran);
tran.Commit();
ml.created = (DateTime)model.created;
ml.mte = me;
ml.uid = uid;
ml.insert();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
}
}
/// <summary>
/// 是否允许积分
/// </summary>
/// <param name="uid"></param>
/// <param name="mte"></param>
/// <returns></returns>
public bool isAllow(int uid, MemberIntegralTemplateEnum mte)
{
if (mte == MemberIntegralTemplateEnum.建档通过)
{
return(db._mongoCollection.AsQueryable().Where(x => x.uid == uid && x.mte == mte).Count() == 0);
}
if (mte == MemberIntegralTemplateEnum.会员注册)
{
return(db._mongoCollection.AsQueryable().Where(x => x.uid == uid && x.mte == mte).Count() == 0);
}
if (mte == MemberIntegralTemplateEnum.每日签到)
{
return(db._mongoCollection.AsQueryable().Where(x => x.uid == uid && x.mte == mte && x.created > DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"))).Count() == 0);
}
if (mte == MemberIntegralTemplateEnum.提交交易意向)
{
return(db._mongoCollection.AsQueryable().Where(x => x.uid == uid && x.mte == mte && x.created > DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"))).Count() < 10);
}
return(true);
}
/// <summary>
/// 取得模板所能获取的积分数量
/// </summary>
/// <param name="me"></param>
/// <returns></returns>
public decimal GetIntegral(MemberIntegralTemplateEnum me)
{
return((decimal)base.ExecuteScalar("SELECT Integral FROM MemberIntegralTemplate WHERE id=" + me.GetHashCode()));
}
/// <summary>
/// 增加积分
/// </summary>
/// <param name="uid">会员ID</param>
/// <param name="price">如果是订单则传入订单金额</param>
/// <param name="me">模板类型</param>
/// <param name="msg">如果是订单则传入订单号</param>
public void AddIntegral(int uid, decimal price, MemberIntegralTemplateEnum me, string msg, string orderid = "")
{
string sql = "";
MemberIntegralLock ml = new MemberIntegralLock();
if (!ml.isAllow(uid, me))
{
return;
}
decimal dc = 0;
if (me == MemberIntegralTemplateEnum.成交订单)
{
// OTC
sql = "SELECT CompanyClass FROM dbo.memberaccount WHERE UID=" + uid;
string obj = ExecuteScalar(sql) as string;
if (obj == null)
{
return;
}
var cc = SOSOshop.Model.CompanyClass.GetModel(obj);
if (cc.Price == "Price_02")
{
DateTime time = (DateTime)ExecuteScalar(string.Format("SELECT ShopDate FROM dbo.Orders WHERE OrderId='{0}'", orderid));
OtcIntegralDay bll = new OtcIntegralDay();
var m = bll.GetList(((int)time.DayOfWeek).ToString());
if (m.Count > 0)
{
var model = m.First();
if (model.state)
{
dc = price * model.multiple;
}
}
}
else //批发
{
dc = new MemberIntegralTemplate().GetIntegral(me);
if (dc == 0)
{
return;
}
dc = price * dc;
}
}
else
{
dc = new MemberIntegralTemplate().GetIntegral(me);
}
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction tran = conn.BeginTransaction();
try
{
//更新积分表
sql = string.Format(@"IF NOT EXISTS( SELECT * FROM dbo.MemberIntegral WHERE uid={0})
INSERT INTO MemberIntegral VALUES({0},{1},{1})
ELSE
UPDATE MemberIntegral SET integral=integral+{1},realityIntegral=realityIntegral+{1} WHERE uid={0}", uid, (int)dc);
db.ExecuteNonQuery(db.GetSqlStringCommand(sql), tran);
SOSOshop.BLL.Integral.MemberIntegralDetail bll = new MemberIntegralDetail();
SOSOshop.Model.Integral.MemberIntegralDetail model = new Model.Integral.MemberIntegralDetail();
model.action = "增加";
model.created = DateTime.Now;
model.integral = (int)dc;
model.remarks = string.Format("{0}:{1}", me, msg);
model.uid = uid;
bll.Add(model, tran);
tran.Commit();
ml.created = (DateTime)model.created;
ml.mte = me;
ml.uid = uid;
ml.orderid = orderid;
ml.insert();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
}
}
