/// <summary> /// 获取会员游记条数 /// </summary> /// <param name="huiYuanId">会员Id</param> /// <param name="times">最后查看时间</param> /// <returns></returns> public int GetYouJiNum(string huiYuanId) { IList <Eyousoft_yhq.Model.MHuiYuanDianZanInfo> items = new List <Eyousoft_yhq.Model.MHuiYuanDianZanInfo>(); var cmd = _db.GetSqlStringCommand("SELECT count(YouJiId) FROM tbl_HuiYouYouJi WHERE HuiYuanId=@HuiYuanId "); _db.AddInParameter(cmd, "HuiYuanId", DbType.AnsiStringFixedLength, huiYuanId); var rdr = DbHelper.GetSingle(cmd, _db); return(Convert.ToInt32(rdr.ToString())); }
/// <summary> /// 获取会员最新留言条数 /// </summary> /// <param name="huiYuanId">会员Id</param> /// <param name="times">最后查看时间</param> /// <returns></returns> public int GetLiuYanNum(string huiYuanId, DateTime times) { IList <Eyousoft_yhq.Model.MHuiYuanDianZanInfo> items = new List <Eyousoft_yhq.Model.MHuiYuanDianZanInfo>(); var cmd = _db.GetSqlStringCommand("SELECT count(IdentityId) FROM view_HuiYuan_LiuYan WHERE HuiYuanId2=@HuiYuanId And LiuYanTime>@Times"); _db.AddInParameter(cmd, "HuiYuanId", DbType.AnsiStringFixedLength, huiYuanId); _db.AddInParameter(cmd, "Times", DbType.DateTime, times); var rdr = DbHelper.GetSingle(cmd, _db); return(Convert.ToInt32(rdr.ToString())); }
/// <summary> /// 获取产品的留言数量 /// </summary> /// <param name="productID">产品编号</param> /// <returns></returns> public int GetCountNum(string productID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from tbl_Comment"); strSql.Append(" where ProductID=@ProductID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.String, productID); return(Convert.ToInt32(DbHelper.GetSingle(cmd, this._db))); }
/// <summary> /// 判断微信码是否可用 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Exists(Eyousoft_yhq.Model.Product model) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from tbl_Product"); strSql.Append(" where FavourCode=@FavourCode and DATEDIFF(day,@ValidiDate,GETDATE())<0"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "FavourCode", System.Data.DbType.String, model.FavourCode); this._db.AddInParameter(cmd, "ValidiDate", System.Data.DbType.DateTime, model.ValidiDate); return(Convert.ToInt32(DbHelper.GetSingle(cmd, this._db)) > 1 ? true : false); }
/// <summary> /// 统计当前分类产品优惠码领取次数 /// </summary> /// <param name="model">产品类别编号</param> /// <returns></returns> public int countTypeNum(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT COUNT(1) FROM tbl_SendMsg WHERE ProductID IN(SELECT tbl_Product.ProductID FROM tbl_Product WHERE ProductType=@ProductType) "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ProductType", DbType.Int32, id); return((int)DbHelper.GetSingle(cmd, this._db)); }
/// <summary> /// 统计当前产品优惠码领取次数 /// </summary> /// <param name="model">产品编号</param> /// <returns></returns> public int countNum(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT COUNT(1) FROM tbl_SendMSG WHERE ProductID=@ProductID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.AnsiStringFixedLength, id); return((int)DbHelper.GetSingle(cmd, this._db)); }
/// <summary> /// 获取所有帐户的充值和消费金额 /// </summary> /// <returns></returns> public int GetTotalMoney(TotalMoney Tmoney) { StringBuilder strSql = new StringBuilder(); if (Tmoney == TotalMoney.账户充值金额) { strSql.Append("select sum(YuE) from tbl_Member"); } else { strSql.Append("select sum(JinE) from tbl_ConDetailed where XiaoFeiFangShi <> 0"); } DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); return(Convert.ToInt32(DbHelper.GetSingle(cmd, this._db))); }
/// <summary> /// 获取列表数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public decimal getSumMoney(ChouJiangSer serModel) { IList <ChouJiang> list = new List <ChouJiang>(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT sum(DianShu) FROM view_ChouJiang WHERE 1=1 "); if (serModel == null) { if (!string.IsNullOrEmpty(serModel.CaoZuoRenID)) { strSql.AppendFormat(" and CaoZuoRenID = '{0}' ", serModel.CaoZuoRenID); } } DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); decimal sum = Convert.ToDecimal(DbHelper.GetSingle(cmd, this._db)); return(sum); }