/// <summary>
/// 获取波段列表
/// </summary>
public string GetIntegralRuleListData()
{
var form = Request("form").DeserializeJSONTo <IntegralRuleEntity>();
var service = new IntegralRuleBLL(CurrentUserInfo);
string content = string.Empty;
//string key = string.Empty;
//if (Request("IntegralSourceID") != null && Request("IntegralSourceID") != string.Empty)
//{
// key = Request("IntegralSourceID").ToString().Trim();
//}
var queryEntity = new IntegralRuleEntity();
queryEntity.IntegralSourceID = form.IntegralSourceID;
queryEntity.Integral = form.Integral;
int pageIndex = Utils.GetIntVal(FormatParamValue(Request("page"))) - 1;
var data = service.GetList(queryEntity, pageIndex, PageSize);
var dataTotalCount = service.GetListCount(queryEntity);
content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}",
data.ToJSON(),
dataTotalCount);
return(content);
}
/// <summary>
/// GetList
/// </summary>
/// <param name="entity">entity</param>
/// <param name="Page">分页页码。从0开始</param>
/// <param name="PageSize">每页的数量。未指定时默认为15</param>
/// <returns></returns>
public IList <IntegralRuleEntity> GetList(IntegralRuleEntity entity, int Page, int PageSize)
{
if (PageSize <= 0)
{
PageSize = 15;
}
IList <IntegralRuleEntity> list = new List <IntegralRuleEntity>();
DataSet ds = new DataSet();
ds = _currentDAO.GetList(entity, Page, PageSize);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
list = DataTableToObject.ConvertToList <IntegralRuleEntity>(ds.Tables[0]);
}
return(list);
}
/// <summary>
/// 获取信息
/// </summary>
public string GetIntegralRuleInfoById()
{
var service = new IntegralRuleBLL(CurrentUserInfo);
IntegralRuleEntity obj = new IntegralRuleEntity();
string content = string.Empty;
string key = string.Empty;
if (Request("IntegralRuleID") != null && Request("IntegralRuleID") != string.Empty)
{
key = Request("IntegralRuleID").ToString().Trim();
}
obj = service.GetByID(key);
var jsonData = new JsonData();
jsonData.totalCount = obj == null ? "0" : "1";
jsonData.data = obj;
content = jsonData.ToJSON();
return(content);
}
/// <summary>
/// GetListCount
/// </summary>
/// <param name="entity">entity</param>
public int GetListCount(IntegralRuleEntity entity)
{
return(_currentDAO.GetListCount(entity));
}
public void Update(IntegralRuleEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(IntegralRuleEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(IntegralRuleEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(IntegralRuleEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <IntegralRuleEntity> PagedQueryByEntity(IntegralRuleEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public IntegralRuleEntity[] QueryByEntity(IntegralRuleEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(IntegralRuleEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(IntegralRuleEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(IntegralRuleEntity pEntity)
{
Update(pEntity, true);
}
/// <summary>
/// 验证真伪得积分
/// </summary>
public string SetCheckReal()
{
string content = string.Empty;
var respData = new SetCheckRealRespData();
try
{
string openId = Request["openID"];
//openId = "o8Y7Ejl1zl5RHXDvPONCNqoC5Md8";
Loggers.Debug(new DebugLogInfo()
{
Message = string.Format(
"OpenID:{0}", openId)
});
var currentUser = Default.GetLoggingSession();
VipBLL vipBLL = new VipBLL(currentUser);
IntegralRuleBLL integralRuleBLL = new IntegralRuleBLL(currentUser);
VipIntegralDetailBLL vipIntegralDetailBLL = new VipIntegralDetailBLL(currentUser);
VipIntegralBLL vipIntegralBLL = new VipIntegralBLL(currentUser);
string vipId = null;
if (true)
{
VipEntity vipIdData = null;
var vipIdDataList = vipBLL.QueryByEntity(new VipEntity()
{
WeiXinUserId = openId
}, null);
if (vipIdDataList == null || vipIdDataList.Length == 0 || vipIdDataList[0] == null ||
vipIdDataList[0].VIPID == null)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = "未查询到Vip会员";
return(respData.ToJSON());
}
else
{
vipIdData = vipIdDataList[0];
vipId = vipIdData.VIPID;
}
}
// SysIntegralSource: 10
string integralSourceId = "10";
int integralValue = 0;
if (true)
{
IntegralRuleEntity integralRuleData = null;
var integralRuleDataList = integralRuleBLL.QueryByEntity(new IntegralRuleEntity()
{
IntegralSourceID = integralSourceId
}, null);
if (integralRuleDataList == null || integralRuleDataList.Length == 0 || integralRuleDataList[0] == null)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = "未查询到积分规则";
return(respData.ToJSON());
}
else
{
integralRuleData = integralRuleDataList[0];
integralValue = int.Parse(integralRuleData.Integral);
}
}
#region 保存积分
if (true)
{
string tmpVipId = vipId;
int tmpIntegralValue = integralValue;
string tmpIntegralSourceId = integralSourceId;
string tmpOpenId = openId;
string msgModel = "【验真品，送积分】活动，您本次验证赢得{0}点积分。您当前的总积分是{1}点。";
// 插入积分明细
VipIntegralDetailEntity vipIntegralDetailEntity = new VipIntegralDetailEntity();
vipIntegralDetailEntity.VipIntegralDetailID = CPOS.Common.Utils.NewGuid();
vipIntegralDetailEntity.VIPID = tmpVipId;
vipIntegralDetailEntity.FromVipID = tmpVipId;
vipIntegralDetailEntity.SalesAmount = 0;
vipIntegralDetailEntity.Integral = tmpIntegralValue;
vipIntegralDetailEntity.IntegralSourceID = tmpIntegralSourceId;
vipIntegralDetailEntity.IsAdd = 1;
//vipIntegralDetailBLL.Create(vipIntegralDetailEntity);
// 更新积分
VipIntegralEntity vipIntegralEntity = new VipIntegralEntity();
var vipIntegralDataList = vipIntegralBLL.QueryByEntity(
new VipIntegralEntity()
{
VipID = vipId
}, null);
if (vipIntegralDataList == null || vipIntegralDataList.Length == 0 || vipIntegralDataList[0] == null)
{
vipIntegralEntity.VipID = tmpVipId;
vipIntegralEntity.BeginIntegral = 0; // 期初积分
vipIntegralEntity.InIntegral = tmpIntegralValue; // 增加积分
vipIntegralEntity.OutIntegral = 0; //消费积分
vipIntegralEntity.EndIntegral = tmpIntegralValue; //积分余额
vipIntegralEntity.InvalidIntegral = 0; // 累计失效积分
vipIntegralEntity.ValidIntegral = tmpIntegralValue; // 当前有效积分
//vipIntegralBLL.Create(vipIntegralEntity);
}
else
{
vipIntegralEntity.VipID = tmpVipId;
vipIntegralEntity.InIntegral = vipIntegralDataList[0].InIntegral + tmpIntegralValue;; // 增加积分
//vipIntegralEntity.OutIntegral = 0; //消费积分
vipIntegralEntity.EndIntegral = vipIntegralDataList[0].EndIntegral + tmpIntegralValue; //积分余额
//vipIntegralEntity.InvalidIntegral = 0; // 累计失效积分
vipIntegralEntity.ValidIntegral = vipIntegralDataList[0].ValidIntegral + tmpIntegralValue; // 当前有效积分
//vipIntegralBLL.Update(vipIntegralEntity, false);
}
// 更新VIP
VipEntity vipEntity = new VipEntity();
var vipEntityDataList = vipBLL.QueryByEntity(
new VipEntity()
{
VIPID = tmpVipId
}, null);
if (vipEntityDataList == null || vipEntityDataList.Length == 0 || vipEntityDataList[0] == null)
{
vipEntity.VIPID = tmpVipId;
vipEntity.Integration = vipIntegralEntity.ValidIntegral;
//vipEntity.HigherVipID = highOpenId;
vipEntity.ClientID = currentUser.CurrentUser.customer_id;
vipEntity.Status = 1;
vipBLL.Create(vipEntity);
}
else
{
vipEntity.VIPID = tmpVipId;
vipEntity.Integration = vipIntegralEntity.ValidIntegral;
//vipEntity.HigherVipID = highOpenId;
vipEntity.ClientID = currentUser.CurrentUser.customer_id;
vipBLL.Update(vipEntity, false);
}
// 推送消息
string msgUrl = ConfigurationManager.AppSettings["push_weixin_msg_url"].Trim();
string msgText = string.Format(msgModel, tmpIntegralValue, vipEntity.Integration);
string msgData = "<xml><OpenID><![CDATA[" + tmpOpenId + "]]></OpenID><Content><![CDATA[" + msgText + "]]></Content></xml>";
var msgResult = Common.Utils.GetRemoteData(msgUrl, "POST", msgData);
Loggers.Debug(new DebugLogInfo()
{
Message = string.Format("PushMsgResult:{0}", msgResult)
});
respData.Data = tmpIntegralValue.ToString();
}
#endregion
}
catch (Exception ex)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = ex.ToString();
}
content = respData.ToJSON();
return(content);
}
