/// <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); }