Пример #1
0
        public int AddArticle(AC_Article m)
        {
            var sql = @"INSERT INTO [AC_Article]
                                   ([Title]
                                   ,[SourceType]
                                   ,[Editor]
                                   ,[PublishDateTime]
                                   ,[IsEableComment]
                                   ,[IsPublish]
                                   ,[IsEnable]
                                   ,[CreateDateTime]
                                   ,[LastUpdateDateTime]
                                   ,[LastUpdateEditor]
                                   ,[ImageId]
                                   ,[EditorId]
                                   ,[ArticleType])
                             VALUES
                                   (@Title
                                   ,@SourceType
                                   ,@Editor
                                   ,@PublishDateTime
                                   ,@IsEableComment
                                   ,@IsPublish
                                   ,@IsEnable
                                   ,@CreateDateTime
                                   ,@LastUpdateDateTime
                                   ,@LastUpdateEditor
                                   ,@ImageId
                                   ,@EditorId
                                   ,@ArticleType)";

            using (SqlConnection conn = new SqlConnection(TruckhomeConncetionString))
            {
                var r = conn.Execute(sql, new
                {
                    Title              = m.Title,
                    SourceType         = m.SourceType,
                    Editor             = m.Editor,
                    PublishDateTime    = m.PublishDateTime,
                    IsEableComment     = m.IsEableComment,
                    IsPublish          = m.IsPublish,
                    IsEnable           = m.IsEnable,
                    CreateDateTime     = m.CreateDateTime,
                    LastUpdateDateTime = m.LastUpdateDateTime,
                    LastUpdateEditor   = m.LastUpdateEditor,
                    ImageId            = m.ImageId,
                    EditorId           = m.EditorId,
                    ArticleType        = m.ArticleType
                });
                return(r);
            }
        }
Пример #2
0
 public int AddArticle(AC_Article m)
 {
     return(ar.AddArticle(m));
 }