/// <summary> /// 获取红包实体 /// </summary> /// <param name="ID">红包编号</param> /// <returns></returns> public HongBao GetInfo(string Id) { HongBao model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT ID , UserID , IssueTime , HongBaoJinE ,UserName,ContactName FROM view_hongbao WHERE ID =@ID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ID", System.Data.DbType.AnsiStringFixedLength, Id); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { model = new HongBao(); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.UserID = dr.GetString(dr.GetOrdinal("UserID")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.HongBaoJinE = dr.GetDecimal(dr.GetOrdinal("HongBaoJinE")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); } } return model; }
/// <summary> /// 添加一个红包 /// </summary> /// <param name="info">红包</param> /// <returns></returns> public int Insert(HongBao info) { if (string.IsNullOrEmpty(info.UserID)) return 0; info.ID = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; int result = dal.Insert(info); if (result == 1)//修改账户金额 { Eyousoft_yhq.BLL.BConDetaile bll = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile con = new Eyousoft_yhq.Model.MConDetaile(); con.JiaoYiHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.DingDanBianHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.JinE = info.HongBaoJinE; con.JiaoYiShiJian = DateTime.Now; con.XFway = Eyousoft_yhq.Model.XFfangshi.红包抽奖; con.HuiYuanID = info.UserID; bll.Add(con); } return result; }
/// <summary> /// 修改红包金额 /// </summary> /// <param name="model">红包</param> /// <returns></returns> public int Update(HongBao info) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE tbl_HongBao SET HongBaoJinE = @HongBaoJinE WHERE ID=@ID"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ID", System.Data.DbType.AnsiStringFixedLength, info.ID); this._db.AddInParameter(cmd, "HongBaoJinE", System.Data.DbType.Decimal, info.HongBaoJinE); return DbHelper.ExecuteSql(cmd, this._db); }
/// <summary> /// 添加一个红包 /// </summary> /// <param name="info">红包</param> /// <returns></returns> public int Insert(HongBao info) { StringBuilder strSql = new StringBuilder(); strSql.Append(" INSERT INTO tbl_HongBao (ID ,UserID ,IssueTime ,HongBaoJinE) VALUES (@ID ,@UserID ,@IssueTime ,@HongBaoJinE) "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ID", System.Data.DbType.AnsiStringFixedLength, info.ID); this._db.AddInParameter(cmd, "UserID", System.Data.DbType.AnsiStringFixedLength, info.UserID); this._db.AddInParameter(cmd, "IssueTime", System.Data.DbType.DateTime, info.IssueTime); this._db.AddInParameter(cmd, "HongBaoJinE", System.Data.DbType.Decimal, info.HongBaoJinE); 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<HongBao> GetList(int PageSize, int PageIndex, ref int RecordCount, HongBaoSer serModel) { IList<HongBao> list = new List<HongBao>(); string tableName = "view_hongbao"; string fileds = " ID , UserID , IssueTime , HongBaoJinE,UserName,ContactName "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.UserID)) { query.AppendFormat(" and userid = '{0}' ", serModel.UserID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { HongBao model = new HongBao(); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.UserID = dr.GetString(dr.GetOrdinal("UserID")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.HongBaoJinE = dr.GetDecimal(dr.GetOrdinal("HongBaoJinE")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); list.Add(model); } } return list; }
/// <summary> /// 修改红包金额 /// </summary> /// <param name="model">红包</param> /// <returns></returns> public int Update(HongBao info) { if (string.IsNullOrEmpty(info.ID)) return 0; var yuan = GetInfo(info.ID); if (yuan == null) return 0; decimal yuanJinE = yuan.HongBaoJinE; int result = dal.Update(info); return result; }