Exemple #1
0
        /// <summary>
        /// 添加一条新规则
        /// </summary>
        /// <param name="rule"></param>
        /// <returns></returns>
        public static bool Add(Model.Rule rule)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("insert into rules (rulename,ruletype,rulevalue,msgtype,msgvalue,rank,idtime,videotitle,videodescription)");
            sb.Append(" values (@rulename,@ruletype,@rulevalue,@msgtype,@msgvalue,@rank,@idtime,@videotitle,@videodescription)");
            SqlParameter[] paras =
            {
                new SqlParameter("@rulename",         rule.RuleName),
                new SqlParameter("@ruletype",         rule.RuleType),
                new SqlParameter("@rulevalue",        rule.RuleValue),
                new SqlParameter("@msgtype",          rule.MsgType),
                new SqlParameter("@msgvalue",         rule.MsgValue),
                new SqlParameter("@rank",             rule.Rank),
                new SqlParameter("@idtime",           rule.IdTime),
                new SqlParameter("@videotitle",       rule.VideoTitle),
                new SqlParameter("@videodescription", rule.VideoDescription)
            };
            int n = SqlDbHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, paras);

            if (n == 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
Exemple #2
0
        /// <summary>
        /// 更新规则
        /// </summary>
        /// <param name="rule"></param>
        /// <returns></returns>
        public static bool Update(Model.Rule rule)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("update rules set rulename=@rulename,");
            sb.Append("msgtype=@msgtype,msgvalue=@msgvalue,");
            sb.Append("ruletype=@ruletype,rulevalue=@rulevalue,");
            sb.Append("rank=@rank,idtime=@idtime,");
            sb.Append("videotitle=@videotitle,videodescription=@videodescription");
            sb.Append(" where id = " + rule.ID);
            SqlParameter[] paras =
            {
                new SqlParameter("@rulename",         rule.RuleName),
                new SqlParameter("@msgtype",          rule.MsgType),
                new SqlParameter("@msgvalue",         rule.MsgValue),
                new SqlParameter("@ruletype",         rule.RuleType),
                new SqlParameter("@rulevalue",        rule.RuleValue),
                new SqlParameter("@rank",             rule.Rank),
                new SqlParameter("@idtime",           rule.IdTime),
                new SqlParameter("@videotitle",       rule.VideoTitle),
                new SqlParameter("@videodescription", rule.VideoDescription)
            };
            int n = SqlDbHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, paras);

            if (n == 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
Exemple #3
0
        /// <summary>
        /// 根据ID获取规则详细信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static Model.Rule GetRuleById(int id)
        {
            Model.Rule    rule = new Model.Rule();
            StringBuilder sb   = new StringBuilder();

            sb.Append("select id,rulename,msgtype,msgvalue,ruletype,rulevalue,rank,idtime,videotitle,videodescription from rules");
            sb.Append(" where id = " + id);
            SqlDataReader sdr = SqlDbHelper.ExecuteReader(sb.ToString());

            if (sdr.Read())
            {
                rule.ID               = id;
                rule.RuleName         = sdr["rulename"].ToString();
                rule.MsgType          = sdr["msgtype"].ToString();
                rule.MsgValue         = sdr["msgvalue"].ToString();
                rule.RuleType         = sdr["ruletype"].ToString();
                rule.RuleValue        = sdr["rulevalue"].ToString();
                rule.Rank             = Convert.ToInt32(sdr["rank"]);
                rule.IdTime           = Convert.ToDateTime(sdr["idtime"]);
                rule.VideoTitle       = sdr["videotitle"].ToString();
                rule.VideoDescription = sdr["videodescription"].ToString();
                return(rule);
            }
            return(null);
        }
Exemple #4
0
 private ListViewItem CreateListViewItem(Model.Rule rule)
 {
     return
         (new ListViewItem
     {
         Text = rule.Name,
         SubItems = { string.Join(" И ", rule.Premise), string.Join(", ", rule.Conclusion), rule.Reason },
         Tag = rule
     });
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            mgs.type   = "video";
            mgs.offset = 0;
            mgs.count  = 50;
            string corpId = ConfigurationManager.AppSettings["qyhCorpId"];
            string secret = ConfigurationManager.AppSettings["qyhSecret"];

            qyhModel.Auths.Access_Token qyh = qyhBLL.Require.GetAccessToken(corpId, secret, ref err);
            if (err.errcode == 0)
            {
                string mcRet = qyhBLL.Material.GetMaterialCount(qyh.access_token);
                mCount = JsonConvert.DeserializeObject <qyhModel.MaterialCount>(mcRet);
                //获取视频
                string strRet = qyhBLL.Material.GetMaterialListPermanent(qyh.access_token, mgs);
                mList = JsonConvert.DeserializeObject <qyhModel.MaterialListPermanent>(strRet);
                item.Add("video", mList);
                //获取图文
                mgs.type = "mpnews";
                string mpnewsRet = qyhBLL.Material.GetMaterialListPermanent(qyh.access_token, mgs);
                mpnewsList = JsonConvert.DeserializeObject <qyhModel.MPNews>(mpnewsRet);
                item.Add("mpnews", mpnewsList);

                strRet  = qyhBLL.Tag.GetTagList(qyh.access_token);
                tagList = JsonConvert.DeserializeObject <qyhModel.TagList>(strRet);
            }

            if (Request["act"] == null)
            {
                act = "add";
                return;
            }
            act = Request["act"];
            if (act == "edit")
            {
                if (Request["id"] == null)
                {
                    act = "add";
                    return;
                }
                else
                {
                    int id = Convert.ToInt32(Request["id"]);
                    rule = Bll.Rule.GetRuleById(id);
                }
            }
        }
Exemple #6
0
        /// <summary>
        /// 判断规则是否存在,存在:返回true,不存在:返回false
        /// </summary>
        /// <param name="rule"></param>
        /// <returns></returns>
        public static bool CheckRule(Model.Rule rule)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("select count(*) from rules");
            sb.AppendFormat(" where ruletype='{0}' and rulevalue='{1}'", rule.RuleType, rule.RuleValue);
            int n = Convert.ToInt32(SqlDbHelper.ExecuteScalar(sb.ToString()));

            if (n == 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }