/// <summary> /// 判断当日用户是否抽奖 /// </summary> /// <param name="userid"></param> /// <returns></returns> public bool Exists(ChouJiang info) { StringBuilder ExistStr = new StringBuilder(); ExistStr.Append("select count(1) from tbl_ChouJiang where CONVERT(varchar(20), ChouJiangShiJian, 23) =@ChouJiangShiJian AND CaoZuoRenID=@CaoZuoRenID and FangShi=@FangShi "); DbCommand ExistsCmd = this._db.GetSqlStringCommand(ExistStr.ToString()); this._db.AddInParameter(ExistsCmd, "ChouJiangShiJian", System.Data.DbType.String, info.ChouJiangShiJian.ToString("yyyy-MM-dd")); this._db.AddInParameter(ExistsCmd, "CaoZuoRenID", System.Data.DbType.String, info.CaoZuoRenID); this._db.AddInParameter(ExistsCmd, "FangShi", System.Data.DbType.Byte, info.FangShi); return DbHelper.Exists(ExistsCmd, this._db); }
/// <summary> /// 抽奖 /// </summary> void getFxResult() { EyouSoft.Model.SSOStructure.MUserInfo m = null; bool isLogin = EyouSoft.Common.Page.HuiyuanPage.IsLogin(out m); if (!isLogin) { Utils.RCWE_AJAX("0", "请登录后重新操作"); } var hongbao = new Eyousoft_yhq.BLL.BHongBao().GetInfoByUserID(Utils.GetQueryStringValue("huiyuanid")); //判断是否存在红包 if (hongbao == null) { return; } if (hongbao.HongBaoJinE <= 1M) { Utils.RCWE_AJAX("0", "红包被分光啦"); } //判断用户当日是否已经抽奖 bool isExists = new Eyousoft_yhq.BLL.BChouJiang().Exists(new Eyousoft_yhq.Model.ChouJiang() { CaoZuoRenID = m.UserID, ChouJiangShiJian = DateTime.Now, FangShi = JiangLiFangShi.分享 }); if (isExists) { Utils.RCWE_AJAX("0", "每天分享第一次才可以获得奖励"); } Eyousoft_yhq.Model.ChouJiang info = new Eyousoft_yhq.Model.ChouJiang(); info.ID = hongbao.ID; info.CaoZuoRenID = m.UserID; info.JieGuo = ChouJiangJieGuo.未中奖; info.DianShu = 1M; info.FangShi = JiangLiFangShi.分享; int result = new Eyousoft_yhq.BLL.BChouJiang().Insert(info); Utils.RCWE_AJAX(result == 1 ? "1" : "0", result == 1 ? "操作成功" : "操作失败"); //抽奖 //返回结果 }
/// <summary> /// 添加一条抽奖记录 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Insert(ChouJiang info) { info.ChouJiangShiJian = DateTime.Now; info.ChouJiangID = Guid.NewGuid().ToString(); info.LiuShuiHao = DateTime.Now.ToString("yyyyMMddHHmmssfff"); int result = dal.Insert(info); if (result == 1) { var hongbao = new Eyousoft_yhq.BLL.BHongBao().GetInfo(info.ID); if (hongbao != null) { new Eyousoft_yhq.BLL.BHongBao().Update(new HongBao() { HongBaoJinE = hongbao.HongBaoJinE - info.DianShu, ID = hongbao.ID }); } var model = new Eyousoft_yhq.BLL.Member().GetModel(info.CaoZuoRenID); if (model != null) { new Eyousoft_yhq.BLL.Member().setMoney(info.CaoZuoRenID, model.YuE + info.DianShu); } } return result; }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<ChouJiang> GetList(int PageSize, int PageIndex, ref int RecordCount, ChouJiangSer serModel) { IList<ChouJiang> list = new List<ChouJiang>(); string tableName = "view_ChouJiang"; string fileds = " * "; string orderByString = "ChouJiangShiJian desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.CaoZuoRenID)) { query.AppendFormat(" and CaoZuoRenID = '{0}' ", serModel.CaoZuoRenID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { ChouJiang model = new ChouJiang(); model.CaoZuoRenID = dr.GetString(dr.GetOrdinal("CaoZuoRenID")); model.ChouJiangID = dr.GetString(dr.GetOrdinal("ChouJiangID")); model.ChouJiangShiJian = dr.GetDateTime(dr.GetOrdinal("ChouJiangShiJian")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.DianShu = dr.GetDecimal(dr.GetOrdinal("DianShu")); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.JieGuo = (ChouJiangJieGuo)dr.GetByte(dr.GetOrdinal("JieGuo")); model.LiuShuiHao = dr.GetString(dr.GetOrdinal("LiuShuiHao")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); model.FangShi = (JiangLiFangShi)dr.GetByte(dr.GetOrdinal("FangShi")); list.Add(model); } } return list; }
/// <summary> /// 抽奖 /// </summary> void getResult() { EyouSoft.Model.SSOStructure.MUserInfo m = null; bool isLogin = EyouSoft.Common.Page.HuiyuanPage.IsLogin(out m); if (!isLogin) { Utils.RCWE_AJAX("0", "未登录"); } var hongbao = new Eyousoft_yhq.BLL.BHongBao().GetInfoByUserID(Utils.GetQueryStringValue("huiyuanid")); //判断是否存在红包 if (hongbao == null) { Utils.RCWE_AJAX("0", "该用户未设置红包"); } if (hongbao.UserID == m.UserID) { Utils.RCWE_AJAX("0", "不能抽取自己的红包"); } //判断用户当日是否已经抽奖 bool isExists = new Eyousoft_yhq.BLL.BChouJiang().Exists(new Eyousoft_yhq.Model.ChouJiang() { CaoZuoRenID = m.UserID, ChouJiangShiJian = DateTime.Now, FangShi = JiangLiFangShi.抽奖 }); if (isExists) { Utils.RCWE_AJAX("0", "每天只能抽奖一次"); } Eyousoft_yhq.Model.ChouJiang info = new Eyousoft_yhq.Model.ChouJiang(); info.ID = hongbao.ID; info.CaoZuoRenID = m.UserID; int i = new Random().Next(1000); if (i > 700) { info.JieGuo = ChouJiangJieGuo.中奖; info.DianShu = Utils.GetDecimal(getResultMoney(hongbao.HongBaoJinE)); } else { info.JieGuo = ChouJiangJieGuo.未中奖; info.DianShu = 0M; } int result = new Eyousoft_yhq.BLL.BChouJiang().Insert(info); if (result == 1) { if (info.JieGuo == ChouJiangJieGuo.中奖) { Utils.RCWE_AJAX("1", "恭喜中奖", info.DianShu); } else { Utils.RCWE_AJAX("-99", "未中奖,明天再来或分享红包领取奖励", info.DianShu); } } else { Utils.RCWE_AJAX("0", "操作异常"); } //抽奖 //返回结果 }
/// <summary> /// 判断当日用户是否抽奖 /// </summary> /// <param name="userid"></param> /// <returns></returns> public bool Exists(ChouJiang info) { if (string.IsNullOrEmpty(info.CaoZuoRenID) || info.ChouJiangShiJian == DateTime.MinValue) return false; return dal.Exists(info); }
/// <summary> /// 添加一条抽奖记录 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Insert(ChouJiang info) { StringBuilder strSql = new StringBuilder(); strSql.Append(" INSERT INTO tbl_ChouJiang (ChouJiangID ,LiuShuiHao ,ID ,CaoZuoRenID ,ChouJiangShiJian ,JieGuo ,DianShu,FangShi) VALUES ( @ChouJiangID , @LiuShuiHao , @ID , @CaoZuoRenID , @ChouJiangShiJian , @JieGuo , @DianShu ,@FangShi) "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ChouJiangID", System.Data.DbType.AnsiStringFixedLength, info.ChouJiangID); this._db.AddInParameter(cmd, "LiuShuiHao", System.Data.DbType.String, info.LiuShuiHao); this._db.AddInParameter(cmd, "ID", System.Data.DbType.AnsiStringFixedLength, info.ID); this._db.AddInParameter(cmd, "CaoZuoRenID", System.Data.DbType.AnsiStringFixedLength, info.CaoZuoRenID); this._db.AddInParameter(cmd, "ChouJiangShiJian", System.Data.DbType.DateTime, info.ChouJiangShiJian); this._db.AddInParameter(cmd, "JieGuo", System.Data.DbType.Byte, info.JieGuo); this._db.AddInParameter(cmd, "DianShu", System.Data.DbType.Decimal, info.DianShu); this._db.AddInParameter(cmd, "FangShi", System.Data.DbType.Byte, info.FangShi); return DbHelper.ExecuteSql(cmd, this._db); }
/// <summary> /// 获取列表数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<ChouJiang> GetList(ChouJiangSer serModel) { IList<ChouJiang> list = new List<ChouJiang>(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM view_ChouJiang WHERE 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.CaoZuoRenID)) { strSql.AppendFormat(" and CaoZuoRenID = '{0}' ", serModel.CaoZuoRenID); } if (!string.IsNullOrEmpty(serModel.ID)) { strSql.AppendFormat(" and ID = '{0}' ", serModel.ID); } } strSql.Append(" order by ChouJiangShiJian desc "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { ChouJiang model = new ChouJiang(); model.CaoZuoRenID = dr.GetString(dr.GetOrdinal("CaoZuoRenID")); model.ChouJiangID = dr.GetString(dr.GetOrdinal("ChouJiangID")); model.ChouJiangShiJian = dr.GetDateTime(dr.GetOrdinal("ChouJiangShiJian")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.DianShu = dr.GetDecimal(dr.GetOrdinal("DianShu")); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.JieGuo = (ChouJiangJieGuo)dr.GetByte(dr.GetOrdinal("JieGuo")); model.LiuShuiHao = dr.GetString(dr.GetOrdinal("LiuShuiHao")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); list.Add(model); } } return list; }