Пример #1
0
 public static void InsertAnalyseItemLog(string group_item_id, string start_name, string end_name, string EditdepartName)
 {
     //exec p_insert_mon_analyse_item_log @group_item_id='B5C417D2-A8A0-47CB-A46E-83B46DD03B28',@analyse_person=N'',@analyse_time=''2014-05-26 13:10:31:313'',@edit_person=N'',@edit_time=''2014-05-26 13:10:31:313'',@edit_person_department=N'',@action_type=N'修改',@remark=N''
     SqlParameter[] parmeters =
     {
         new SqlParameter("@group_item_id",          SqlDbType.UniqueIdentifier),
         new SqlParameter("@analyse_person",         SqlDbType.VarChar,          350),
         new SqlParameter("@analyse_time",           SqlDbType.DateTime),
         new SqlParameter("@edit_person",            SqlDbType.VarChar,           50),
         new SqlParameter("@edit_time",              SqlDbType.DateTime),
         new SqlParameter("@edit_person_department", SqlDbType.VarChar,           50),
         new SqlParameter("@action_type",            SqlDbType.VarChar,           50),
         new SqlParameter("@remark",                 SqlDbType.VarChar, 4000)
     };
     parmeters[0].Value = new Guid(group_item_id);
     parmeters[1].Value = start_name;
     parmeters[2].Value = DateTime.Now;
     parmeters[3].Value = end_name;
     parmeters[4].Value = DateTime.Now;
     parmeters[5].Value = EditdepartName;
     parmeters[6].Value = "修改";
     parmeters[7].Value = "";
     adoHelper.ExecuteSPNonQuery("p_insert_mon_analyse_item_log", parmeters);
     //v_mon_analyse_item_log
 }
Пример #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(LinkCategoryModel model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID",        SqlDbType.Int,        8),
                new SqlParameter("@Category",  SqlDbType.VarChar,   50),
                new SqlParameter("@AddedDate", SqlDbType.DateTime),
                new SqlParameter("@Sort",      SqlDbType.Int,        4),
                new SqlParameter("@Type",      SqlDbType.Int, 4)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.Category;
            parameters[2].Value     = model.AddedDate;
            parameters[3].Value     = model.Sort;
            parameters[4].Value     = model.Type;

            adoHelper.ExecuteSPNonQuery("sp_LinkCategory_Add", parameters);
            return((int)parameters[0].Value);
        }
Пример #3
0
 /// <summary>
 /// 删除类别表信息
 /// </summary>
 /// <param name="categoryId">类别编号</param>
 /// <returns></returns>
 public bool DeleteCategory(int categoryId)
 {
     SqlParameter[] parm =
     {
         new SqlParameter("@TopicsCategoryId", SqlDbType.Int, 4),
         new SqlParameter("@Return",           SqlDbType.Int, 4)
     };
     parm[0].Value     = categoryId;
     parm[1].Direction = ParameterDirection.Output;
     adoHelper.ExecuteSPNonQuery("sp_TopicsCategory_Del", parm);
     return(Convert.ToBoolean(parm[1].Value));
 }
Пример #4
0
    /// <summary>
    /// 返回节点集string
    /// </summary>
    /// <param name="CategoryId">节点</param>
    /// <returns></returns>
    public static string GetChildNodes(string CategoryId)
    {
        AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");

        SqlParameter[] parameters =
        {
            new SqlParameter("@CategoryId", SqlDbType.Int,     4),
            new SqlParameter("@Nodes",      SqlDbType.VarChar, 1000)
        };
        parameters[0].Value     = CategoryId;
        parameters[1].Direction = ParameterDirection.Output;
        adoHelper.ExecuteSPNonQuery("sp_GetChildNodes", parameters);
        return(parameters[1].Value.ToString());
    }
Пример #5
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(LinkModel model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@LinkId",      SqlDbType.BigInt,    8),
                new SqlParameter("@Title",       SqlDbType.VarChar,  50),
                new SqlParameter("@Link",        SqlDbType.VarChar, 100),
                new SqlParameter("@Image",       SqlDbType.VarChar, 100),
                new SqlParameter("@DisplayMode", SqlDbType.Int,       4),
                new SqlParameter("@Sort",        SqlDbType.Int,       4),
                new SqlParameter("@CategoryId",  SqlDbType.Int, 4)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.Title;
            parameters[2].Value     = model.Link;
            parameters[3].Value     = model.Image;
            parameters[4].Value     = model.DisplayMode;
            parameters[5].Value     = model.Sort;
            parameters[6].Value     = model.CategoryId;

            return(adoHelper.ExecuteSPNonQuery("sp_Link_Add", parameters));

            return((int)parameters[0].Value);
        }
Пример #6
0
        /// <summary>
        /// 添加日志
        /// </summary>
        /// <param name="userId">用户标识</param>
        /// <param name="ip">登陆用户所在机子的IP地址</param>
        /// <param name="url">引发日志操作所在的页面地址</param>
        /// <param name="description">操作描述</param>
        /// <returns>添加成功,返回日志标识,否则返回-1</returns>
        public int Add(int userId, string ip, string url, string description)
        {
            AdoHelper helper = AdoHelper.CreateHelper("DB_Instance");

            SqlParameter[] paras = new SqlParameter[5];
            paras[0]           = new SqlParameter("@UserId", userId);
            paras[1]           = new SqlParameter("@IP", ip);
            paras[2]           = new SqlParameter("@Url", url);
            paras[3]           = new SqlParameter("@Description", description);
            paras[4]           = new SqlParameter("@LogId", SqlDbType.Int, 4);
            paras[4].Direction = ParameterDirection.Output;

            if (helper.ExecuteSPNonQuery("sp_Log_Add", (IDataParameter[])paras) == 1)
            {
                return((int)paras[4].Value);
            }
            return(-1);
        }
Пример #7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int  Add(NewsModel model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@NewsID",          SqlDbType.Int,          4),
                new SqlParameter("@Title",           SqlDbType.VarChar,    100),
                new SqlParameter("@SubHead",         SqlDbType.VarChar,    100),
                new SqlParameter("@Body",            SqlDbType.Text),
                new SqlParameter("@AddedUserId",     SqlDbType.Int,          4),
                new SqlParameter("@PublicationUnit", SqlDbType.VarChar,     50),
                new SqlParameter("@AddedDate",       SqlDbType.DateTime),
                new SqlParameter("@IsTop",           SqlDbType.Int,          4),
                new SqlParameter("@IndexCommend",    SqlDbType.Int,          4),
                new SqlParameter("@ArticleType",     SqlDbType.Int,          4),
                new SqlParameter("@ReleaseDate",     SqlDbType.DateTime),
                new SqlParameter("@ExpireDate",      SqlDbType.DateTime),
                new SqlParameter("@CategoryId",      SqlDbType.Int,          4),
                new SqlParameter("@Approved",        SqlDbType.Int,          4),
                new SqlParameter("@ViewCount",       SqlDbType.Int,          4),
                new SqlParameter("@ImgLink",         SqlDbType.VarChar,    500),
                new SqlParameter("@IsState",         SqlDbType.Int,          4),
                new SqlParameter("@HotPic",          SqlDbType.VarChar,    100),
                new SqlParameter("@KeyWord",         SqlDbType.VarChar,    500),
                new SqlParameter("@HotDays",         SqlDbType.Int,          4),
                new SqlParameter("@FromSource",      SqlDbType.VarChar,     50),
                new SqlParameter("@IsComment",       SqlDbType.Int,          4),
                new SqlParameter("@IsScrool",        SqlDbType.Int,          4),
                new SqlParameter("@Period",          SqlDbType.VarChar,    100),
                new SqlParameter("@Leaderid",        SqlDbType.Int,          4),
                new SqlParameter("@ShareToPlatform", SqlDbType.VarChar,     50),
                new SqlParameter("@ShareToSubject",  SqlDbType.VarChar,   1000),
                new SqlParameter("@ShareToMarket",   SqlDbType.VarChar, 1000)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.Title;
            parameters[2].Value     = model.SubHead;
            parameters[3].Value     = model.Body;
            parameters[4].Value     = model.AddedUserId;
            parameters[5].Value     = model.PublicationUnit;
            parameters[6].Value     = model.AddedDate;
            parameters[7].Value     = model.IsTop;
            parameters[8].Value     = model.IndexCommend;
            parameters[9].Value     = model.ArticleType;
            parameters[10].Value    = model.ReleaseDate;
            parameters[11].Value    = model.ExpireDate;
            parameters[12].Value    = model.CategoryId;
            parameters[13].Value    = model.Approved;
            parameters[14].Value    = model.ViewCount;
            parameters[15].Value    = model.ImgLink;
            parameters[16].Value    = model.IsState;
            parameters[17].Value    = model.HotPic;
            parameters[18].Value    = model.KeyWord;
            parameters[19].Value    = model.HotDays;
            parameters[20].Value    = model.FromSource;
            parameters[21].Value    = model.IsComment;
            parameters[22].Value    = model.IsScrool;
            parameters[23].Value    = model.Period;
            parameters[24].Value    = model.Leaderid;
            parameters[25].Value    = model.ShareToPlatform;
            parameters[26].Value    = model.ShareToSubject;
            parameters[27].Value    = model.ShareToMarket;

            adoHelper.ExecuteSPNonQuery("sp_News_Add", parameters);
            return((int)parameters[0].Value);
        }