Beispiel #1
0
        public int DeleteNewsTab(int Newsid)
        {
            string sql    = "delete NewsTab where Newsid=@Newsid  ";
            int    result = DBHelpe.ExecuteSql(sql, new SqlParameter("Newsid", Newsid));

            return(result);
        }
Beispiel #2
0
        /// <summary>
        /// 查询总条数
        /// </summary>
        /// <param name="name"></param>
        /// <param name="statu"></param>
        /// <returns></returns>
        public int pageIndex(string name, int statu, int loantype, string loanstitles)
        {
            int    num = 0;
            string sdt = "and 1=1";

            if (loanstitles != "")
            {
                sdt += " and NTitle like '" + loanstitles + "%'";
            }
            if (loantype != -1)
            {
                sdt += " and TypeID=" + loantype + "";
            }
            string sql = "select Count(Newsid) from NewsTab where  audit=@statu " + sdt + " and UserName=@name";

            SqlParameter[] para =
            {
                new SqlParameter("@name",  SqlDbType.VarChar, 50),
                new SqlParameter("@statu", SqlDbType.Int, 4)
            };
            para[0].Value = name;
            para[1].Value = statu;
            num           = Convert.ToInt32(DBHelpe.GetSingle(sql, para));
            return(num);
        }
Beispiel #3
0
        public int UpdateNewsTabaudit(int newsid)
        {
            string sql = "Update NewsTab set Audit=5 where Newsid=@Newsid  ";//ɾ³ýÓà  ¸Ä±äÉóºË״̬

            SqlParameter[] ps = new SqlParameter[] {
                new SqlParameter("@Newsid", newsid)
            };
            int result = DBHelpe.ExecuteSql(sql, ps);

            return(result);
        }
Beispiel #4
0
        public int UpdateNewsTabUrl(string url, int newsid)
        {
            string sql = "Update NewsTab set urlhtml=@urlhtml where Newsid=@Newsid  ";

            SqlParameter[] ps = new SqlParameter[] {
                new SqlParameter("@urlhtml", url)
                , new SqlParameter("@Newsid", newsid)
            };
            int result = DBHelpe.ExecuteSql(sql, ps);

            return(result);
        }
Beispiel #5
0
        public string  GetMaxNewsId()
        {
            string  sql = "select Max(Newsid)as Newsid from NewsTab";
            DataSet set = DBHelpe.Query(sql);
            string  par = "";

            foreach (DataRow row in set.Tables[0].Rows)
            {
                par = row["Newsid"].ToString().Trim();
            }
            return(par);
        }
Beispiel #6
0
        //通过ID获取一个实体对象
        public ErrowTab GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab ");
            strSql.Append(" where Id=@Id ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            ErrowTab model = new ErrowTab();
            DataSet  ds    = DBHelpe.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
                {
                    model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
                }
                model.LinkURL          = ds.Tables[0].Rows[0]["LinkURL"].ToString();
                model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString();
                model.Connetions       = ds.Tables[0].Rows[0]["Connetions"].ToString();
                if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "")
                {
                    model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString());
                }
                if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "")
                {
                    model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString());
                }
                model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString();
                model.Descript      = ds.Tables[0].Rows[0]["Descript"].ToString();
                model.LoginName     = ds.Tables[0].Rows[0]["LoginName"].ToString();
                if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
                {
                    model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
                }
                if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
                {
                    model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
        public Tz888.Model.NewsTypeTab GetNewsTypeByTypeId(int typeId)
        {
            string  sql = "select TypeID ,TypeName from NewsTypeTab where TypeID=@typeid";
            DataSet set = DBHelpe.Query(sql, new SqlParameter("typeid", typeId));

            Tz888.Model.NewsTypeTab newstypetab = null;
            foreach (DataRow row in set.Tables[0].Rows)
            {
                newstypetab          = new Tz888.Model.NewsTypeTab();
                newstypetab.TypeID   = Convert.ToInt32(row["TypeID"]);
                newstypetab.TypeName = row["TypeName"].ToString().Trim();
            }
            return(newstypetab);
        }
Beispiel #8
0
        public int UpdateNewsTab(Tz888.Model.NewsTab newstab, int newsid)
        {
            string sql = "Update NewsTab set NTitle=@ntitle ,TypeID=@typeid,recommendID=@recommendID,urlhtml=@urlhtml where Newsid=@Newsid  ";

            SqlParameter[] ps = new SqlParameter[] {
                new SqlParameter("@ntitle", newstab.NTitle)
                , new SqlParameter("@typeid", newstab.TypeID)
                , new SqlParameter("@recommendID", newstab.RecommendID)
                , new SqlParameter("@urlhtml", newstab.Urlhtml)
                , new SqlParameter("@Newsid", newsid)
            };
            int result = DBHelpe.ExecuteSql(sql, ps);

            return(result);
        }
        public List <Tz888.Model.NewsTypeTab> GetAllNewsType()
        {
            string sql = "select TypeID ,TypeName from NewsTypeTab where BoolStar=1 and outid=1";
            List <Tz888.Model.NewsTypeTab> list = new List <NewsTypeTab>();
            DataSet set = null;

            set = DBHelpe.Query(sql);
            foreach (DataRow row in set.Tables[0].Rows)
            {
                Tz888.Model.NewsTypeTab newstypetab = new Tz888.Model.NewsTypeTab();
                newstypetab.TypeID   = Convert.ToInt32(row["TypeID"]);
                newstypetab.TypeName = row["TypeName"].ToString().Trim();
                list.Add(newstypetab);
            }
            return(list);
        }
Beispiel #10
0
        public int UpdateNewsViewTab(Tz888.Model.NewsViewTab newsviewtab, int newsid)
        {
            string sql = "Update NewsViewTab set Title=@title ,Keywords=@keywords,Description=@descript,NewView=@newview,form=@form,Author=@author,Zhaiyao=@zhaiyao where Newsid=@Newsid  ";

            SqlParameter[] ps = new SqlParameter[] {
                new SqlParameter("@title", newsviewtab.Title)
                , new SqlParameter("@keywords", newsviewtab.Keywords)
                , new SqlParameter("@descript", newsviewtab.Description)
                , new SqlParameter("@newview", newsviewtab.NewView)
                , new SqlParameter("@form", newsviewtab.Formid)
                , new SqlParameter("@author", newsviewtab.Author)
                , new SqlParameter("@zhaiyao", newsviewtab.Zhaiyao)
                , new SqlParameter("@Newsid", newsid)
            };
            int result = DBHelpe.ExecuteSql(sql, ps);

            return(result);
        }
Beispiel #11
0
        /// <summary>
        /// 增加错误处理的一条数据
        /// </summary>
        public int Add(ErrowTab model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ErrowTab(");
            strSql.Append("LoginName,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,createtime,updatetime)");
            strSql.Append(" values (");
            strSql.Append("@LoginName,@LinkURL,@QuestionDescript,@Connetions,@BoolChuLi,@BoolReturn,@ReturnContext,@Descript,@createtime,@updatetime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@LoginName",        SqlDbType.NVarChar,  300),
                new SqlParameter("@LinkURL",          SqlDbType.NVarChar,  300),
                new SqlParameter("@QuestionDescript", SqlDbType.Text),
                new SqlParameter("@Connetions",       SqlDbType.NVarChar,  300),
                new SqlParameter("@BoolChuLi",        SqlDbType.Int,         4),
                new SqlParameter("@BoolReturn",       SqlDbType.Int,         4),
                new SqlParameter("@ReturnContext",    SqlDbType.Text),
                new SqlParameter("@Descript",         SqlDbType.NVarChar,  500),
                new SqlParameter("@createtime",       SqlDbType.DateTime),
                new SqlParameter("@updatetime",       SqlDbType.DateTime)
            };
            parameters[0].Value = model.LoginName;
            parameters[1].Value = model.LinkURL;
            parameters[2].Value = model.QuestionDescript;
            parameters[3].Value = model.Connetions;
            parameters[4].Value = model.BoolChuLi;
            parameters[5].Value = model.BoolReturn;
            parameters[6].Value = model.ReturnContext;
            parameters[7].Value = model.Descript;
            parameters[8].Value = model.createtime;
            parameters[9].Value = model.updatetime;

            object obj = DBHelpe.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #12
0
        //修改数据
        public int Update(ErrowTab model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ErrowTab set ");
            strSql.Append("LinkURL=@LinkURL,");
            strSql.Append("QuestionDescript=@QuestionDescript,");
            strSql.Append("Connetions=@Connetions,");
            strSql.Append("BoolChuLi=@BoolChuLi,");
            strSql.Append("BoolReturn=@BoolReturn,");
            strSql.Append("ReturnContext=@ReturnContext,");
            strSql.Append("Descript=@Descript,");
            strSql.Append("LoginName=@LoginName,");
            strSql.Append("createtime=@createtime,");
            strSql.Append("updatetime=@updatetime");
            strSql.Append(" where Id=@Id ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id",               SqlDbType.Int,         4),
                new SqlParameter("@LinkURL",          SqlDbType.NVarChar,  300),
                new SqlParameter("@QuestionDescript", SqlDbType.Text),
                new SqlParameter("@Connetions",       SqlDbType.NVarChar,  300),
                new SqlParameter("@BoolChuLi",        SqlDbType.Int,         4),
                new SqlParameter("@BoolReturn",       SqlDbType.Int,         4),
                new SqlParameter("@ReturnContext",    SqlDbType.Text),
                new SqlParameter("@Descript",         SqlDbType.NVarChar,  500),
                new SqlParameter("@LoginName",        SqlDbType.NVarChar,  300),
                new SqlParameter("@createtime",       SqlDbType.DateTime),
                new SqlParameter("@updatetime",       SqlDbType.DateTime)
            };
            parameters[0].Value  = model.Id;
            parameters[1].Value  = model.LinkURL;
            parameters[2].Value  = model.QuestionDescript;
            parameters[3].Value  = model.Connetions;
            parameters[4].Value  = model.BoolChuLi;
            parameters[5].Value  = model.BoolReturn;
            parameters[6].Value  = model.ReturnContext;
            parameters[7].Value  = model.Descript;
            parameters[8].Value  = model.LoginName;
            parameters[9].Value  = model.createtime;
            parameters[10].Value = model.updatetime;

            return(DBHelpe.ExecuteCommand(strSql.ToString(), parameters));
        }
Beispiel #13
0
        public int InsertNewsTab(Tz888.Model.NewsTab newstab, Tz888.Model.NewsTypeTab newstypetab, Tz888.Model.NewsViewTab newsviewtab)
        {
            int rowsAffected = 0;

            SqlParameter[] parameters =
            {
                new SqlParameter("@TypeID",      SqlDbType.Int,           4),
                new SqlParameter("@UserName",    SqlDbType.VarChar,     200),
                new SqlParameter("@NTitle",      SqlDbType.VarChar,     200),
                new SqlParameter("@audit",       SqlDbType.Int,           4),
                new SqlParameter("@FromID",      SqlDbType.Int,           4),
                new SqlParameter("@urlhtml",     SqlDbType.VarChar,     200),
                new SqlParameter("@createdate",  SqlDbType.DateTime),
                new SqlParameter("@title",       SqlDbType.VarChar,     200),
                new SqlParameter("@keywords",    SqlDbType.VarChar,     200),
                new SqlParameter("@description", SqlDbType.VarChar,     200),
                new SqlParameter("@NewView",     SqlDbType.Text,      10000),
                new SqlParameter("@form",        SqlDbType.VarChar,    2000),
                new SqlParameter("@author",      SqlDbType.VarChar,     200),
                new SqlParameter("@zhaiyao",     SqlDbType.VarChar,     200),
                new SqlParameter("@recommendID", SqlDbType.Int,           4),
                new SqlParameter("@ImagesUrls",  SqlDbType.NVarChar, 400)
            };
            parameters[0].Value  = newstab.TypeID;
            parameters[1].Value  = newstab.UserName;
            parameters[2].Value  = newstab.NTitle;
            parameters[3].Value  = newstab.Audit;
            parameters[4].Value  = newstab.FromID;
            parameters[5].Value  = newstab.Urlhtml;
            parameters[6].Value  = newstab.Createdate;
            parameters[7].Value  = newsviewtab.Title;
            parameters[8].Value  = newsviewtab.Keywords;
            parameters[9].Value  = newsviewtab.Description;
            parameters[10].Value = newsviewtab.NewView;
            parameters[11].Value = newsviewtab.Formid;
            parameters[12].Value = newsviewtab.Author;
            parameters[13].Value = newsviewtab.Zhaiyao;
            parameters[14].Value = newstab.RecommendID;
            parameters[15].Value = "NULL";

            DBHelpe.RunProcedure("NewsTab_InsertList", parameters, out rowsAffected);
            return(rowsAffected);
        }
Beispiel #14
0
        //获取实体对象集合
        public List <ErrowTab> GetModelList()
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab ");

            List <ErrowTab> list = new List <ErrowTab>();
            DataSet         ds   = DBHelpe.Query(strSql.ToString());

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                ErrowTab model = new ErrowTab();
                if (row["Id"].ToString() != "")
                {
                    model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
                }
                model.LinkURL          = ds.Tables[0].Rows[0]["LinkURL"].ToString();
                model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString();
                model.Connetions       = ds.Tables[0].Rows[0]["Connetions"].ToString();
                if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "")
                {
                    model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString());
                }
                if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "")
                {
                    model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString());
                }
                model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString();
                model.Descript      = ds.Tables[0].Rows[0]["Descript"].ToString();
                model.LoginName     = ds.Tables[0].Rows[0]["LoginName"].ToString();
                if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
                {
                    model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
                }
                if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
                {
                    model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
                }
                list.Add(model);
            }
            return(list);
        }
Beispiel #15
0
        public Tz888.Model.NewsViewTab GetNewsViewByNewId(int NewId)
        {
            string sql = "select * from NewsViewTab where Newsid=@newid";

            Tz888.Model.NewsViewTab newsviewtab = null;
            DataSet set = DBHelpe.Query(sql, new SqlParameter("newid", NewId));

            foreach (DataRow row in set.Tables[0].Rows)
            {
                newsviewtab             = new Tz888.Model.NewsViewTab();
                newsviewtab.NViewID     = Convert.ToInt32(row["NViewID"]);
                newsviewtab.Newsid      = newstab.GetNewsTabByNewId(Convert.ToInt32(row["Newsid"]));
                newsviewtab.Title       = row["Title"].ToString().Trim();
                newsviewtab.Keywords    = row["Keywords"].ToString().Trim();
                newsviewtab.Description = row["Description"].ToString().Trim();
                newsviewtab.NewView     = row["NewView"].ToString().Trim();
                newsviewtab.Formid      = row["form"].ToString().Trim();
                newsviewtab.Author      = row["Author"].ToString().Trim();
                newsviewtab.Zhaiyao     = row["Zhaiyao"].ToString().Trim();
            }
            return(newsviewtab);
        }
Beispiel #16
0
        public Tz888.Model.NewsTab GetNewsTabByNewId(int NewId)
        {
            string sql = "select * from NewsTab where Newsid=@newid";

            Tz888.Model.NewsTab newstab = null;
            DataSet             set     = DBHelpe.Query(sql, new SqlParameter("newid", NewId));

            foreach (DataRow row in set.Tables[0].Rows)
            {
                newstab             = new Tz888.Model.NewsTab();
                newstab.Newsid      = Convert.ToInt32(row["Newsid"]);
                newstab.NTitle      = row["NTitle"].ToString().Trim();
                newstab.UserName    = row["UserName"].ToString().Trim();
                newstab.TypeID      = Convert.ToInt32(row["TypeID"]);
                newstab.Audit       = Convert.ToInt32(row["Audit"]);
                newstab.FromID      = Convert.ToInt32(row["FromID"]);
                newstab.Urlhtml     = row["urlhtml"].ToString().Trim();
                newstab.Createdate  = row["Createdate"].ToString().Trim();
                newstab.RecommendID = Convert.ToInt32(row["RecommendID"]);
            }
            return(newstab);
        }
Beispiel #17
0
        public string GetStringPerson(string name, int status, int index, int loantype, string loanstitles)
        {
            string        loansinfoIds     = "";
            string        loansTitles      = "";
            string        loanscreatetimes = "";
            string        loanstypes       = "";
            string        LoginNames       = "";
            string        auditings        = "";
            string        htmls            = "";
            string        updatetimes      = "";
            StringBuilder sb  = new StringBuilder();
            string        sdt = " and 1=1";

            if (loanstitles != "")
            {
                sdt += " and NTitle like '" + loanstitles + "%'";
            }
            if (loantype != -1)
            {
                sdt += " and TypeID=" + loantype + "";
            }
            string sql = "select top 20 Newsid,UserName,NTitle,TypeID,audit,urlhtml,createdate,recommendID from NewsTab where "
                         + " audit=@statu and UserName=@name " + sdt + "  and Newsid not in (select top " + 20 * index + " Newsid from NewsTab where  audit=@statu " + sdt + " and UserName=@name"
                         + " order by createdate desc) order by createdate desc";

            SqlParameter[] para =
            {
                new SqlParameter("@name",  SqlDbType.VarChar, 50),
                new SqlParameter("@statu", SqlDbType.Int, 4)
            };
            para[0].Value = name;
            para[1].Value = status;
            DataSet ds = DBHelpe.Query(sql, para);

            sb.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><thead><tr>");
            sb.Append("<td width=\"12%\"><a href=\"javascript:SelectAll();\">全选</a>│<a href=\"javascript:ReSelect();\">反选</a></td>");
            sb.Append("<td width=\"8%\">类别</td>");
            sb.Append("<td width=\"20%\">标题</td>");
            sb.Append("<td width=\"12%\">发布时间</td>");
            sb.Append("<td width=\"12%\">是否推荐</td>");
            sb.Append("<td width=\"33%\">管理</td></tr></thead>");
            if (ds != null & ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < (ds.Tables[0].Rows.Count > 20 ? 20 : ds.Tables[0].Rows.Count); i++)
                {
                    DataRow row = ds.Tables[0].Rows[i];
                    loansinfoIds     = row["Newsid"].ToString().Trim();      //编号
                    loansTitles      = row["NTitle"].ToString().Trim();      //标题
                    loanscreatetimes = row["createdate"].ToString().Trim();  // 发布时间
                    loanstypes       = row["TypeID"].ToString().Trim();      // 类别
                    LoginNames       = row["UserName"].ToString().Trim();    // 用户名
                    auditings        = row["audit"].ToString().Trim();       //审核状态
                    htmls            = row["urlhtml"].ToString().Trim();     // html
                    updatetimes      = row["recommendID"].ToString().Trim(); // 是否推荐
                    DateTime beg     = Convert.ToDateTime(loanscreatetimes);
                    string   begTime = beg.ToString("yyyy-MM-dd");
                    sb.Append("<tr><td><input id=\"cbxSelect\" name=\"cbxSelect\" type=\"checkbox\" value=\"" + loansinfoIds + "\" /></td>");
                    sb.Append("<td>" + SetDaikuanType(loanstypes) + "</td>");
                    sb.Append("<td><span class=\"lanl\"><a href='http://www.topfo.com/" + htmls + "' target=\"_blank\" class=\"lan1\" title='" + loansTitles + "'>" + StrLength(loansTitles) + "</a></span></td>");
                    sb.Append("<td>" + begTime + "</td>");
                    sb.Append("<td>" + Tuijian(updatetimes) + "</td>");
                    sb.Append("<td>");
                    sb.Append("<a href='javascript:updateloans(" + 0 + "," + loansinfoIds + ");' class=\"lan1\">修改</a> ");
                    sb.Append("<a href='javascript:DelNav(" + loansinfoIds + ");' onclick='javascript:Del()' class=\"lan1\">删除</a></td></tr>");
                }
            }
            sb.Append("</table>");


            return(sb.ToString());
        }