Exemplo n.º 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public static int Add(Model.Links model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Links(");
            strSql.Append("linkname,linktitle,linkurl,addtime,isTj)");
            strSql.Append(" values (");
            strSql.Append("@linkname,@linktitle,@linkurl,@addtime,@isTj)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@linkname",  SqlDbType.NVarChar,                       50),
                new SqlParameter("@linktitle", SqlDbType.VarChar,                       100),
                new SqlParameter("@linkurl",   SqlDbType.NVarChar,                      500),
                new SqlParameter("@addtime",   SqlDbType.DateTime), new SqlParameter("@isTj",SqlDbType.Int, 4)
            };
            parameters[0].Value = model.linkname;
            parameters[1].Value = model.linktitle;
            parameters[2].Value = model.linkurl;
            parameters[3].Value = model.addtime;
            parameters[4].Value = model.istj;
            object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(1);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static int Update(Model.Links model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Links set ");
            strSql.Append("linkname=@linkname,");
            strSql.Append("linktitle=@linktitle,");
            strSql.Append("linkurl=@linkurl,");
            strSql.Append("isTj=@isTj");
            strSql.Append(" where id=@id ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id",        SqlDbType.Int,        4),
                new SqlParameter("@linkname",  SqlDbType.NVarChar,  50),
                new SqlParameter("@linktitle", SqlDbType.VarChar,  100),
                new SqlParameter("@linkurl",   SqlDbType.NVarChar, 500),
                new SqlParameter("@isTj",      SqlDbType.Int, 4)
            };
            parameters[0].Value = model.id;
            parameters[1].Value = model.linkname;
            parameters[2].Value = model.linktitle;
            parameters[3].Value = model.linkurl;
            parameters[4].Value = model.istj;
            return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters));
        }
Exemplo n.º 3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public static Model.Links GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from Links ");
            strSql.Append(" where id=@id ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;

            Model.Links model = new Model.Links();
            DataSet     ds    = DBHelperSQL.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());
                }
                if (ds.Tables[0].Rows[0]["isTj"].ToString() != "")
                {
                    model.istj = int.Parse(ds.Tables[0].Rows[0]["isTj"].ToString());
                }
                model.linkname  = ds.Tables[0].Rows[0]["linkname"].ToString();
                model.linktitle = ds.Tables[0].Rows[0]["linktitle"].ToString();
                model.linkurl   = ds.Tables[0].Rows[0]["linkurl"].ToString();
                if (ds.Tables[0].Rows[0]["addtime"].ToString() != "")
                {
                    model.addtime = DateTime.Parse(ds.Tables[0].Rows[0]["addtime"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }