コード例 #1
0
        public ActionResult Create(ModelArticle model, FormCollection fc)
        {
            ViewBag.Categorys = QueryCategoryAll(model.Categoryid.ToString());
            ViewBag.CategorysTwo = QueryCategoryAll(model.CategoryTwo);
            var result = new ResultBase();
            var resultMsg = string.Empty;
            var fileName = CommonMethod.ImageUpload(out result, this.HttpContext);
            if (result.result == -2)
            {
                ViewBag.CustomScript = UtilityScript.ShowMessage(result.resultMsg, isCreate: true);
                return View(model);
            }

            model.Context = fc["editorValue"];
            model.Thumbnails = string.IsNullOrWhiteSpace(fileName) ? model.Thumbnails : fileName;
            model.Status = Convert.ToInt32(model.IsPermission);
            model.Isrecommend = Convert.ToInt32(model.IsRec);
            LogicArticle artDal = new LogicArticle();
            var res = artDal.ArticleInsertUpdate(out resultMsg, model);
            if (res > 0)
            {
                resultMsg = "操作成功!";
                ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "Goto");
            }
            else
            {
                resultMsg = "操作失败,请检查数据是否正确后重新操作!";
                ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "BtnShow");
            }
            return View(model);
        }
コード例 #2
0
ファイル: LogicArticle.cs プロジェクト: JasonDevStudio/Cnita
        /// <summary>
        ///  ��ѯʵ��
        /// </summary>
        /// <param name="id">ModelId ���</param>
        /// <returns>ModelArticle</returns>
        public ModelArticle ArticleDetail(out string resultMsg,Int32 id )
        {
            resultMsg = string.Empty;
            var model = new ModelArticle();
            try
            {
                //�洢��������
                string sql = "USP_ARTICLE_SELECT_DETAIL_BY_ID";

                //�������
                IList<DBParameter> parm = new List<DBParameter>();
                parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });

                //��ѯִ��
                using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
                {
                    IList<ModelArticle> list = GetModel(dr);
                    model = list.First();
                }
            }
            catch (Exception ex)
            {
                resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
            }
            return model;
        }
コード例 #3
0
        public ActionResult Create(ModelArticle model, FormCollection fc)
        {
            var customScript = string.Empty;
            IList<SelectListItem> categorys = new List<SelectListItem>();
            IList<SelectListItem> categorysTwo = new List<SelectListItem>();

            try
            {
                categorys = QueryCategoryAll(model.Categoryid.ToString());
                categorysTwo = QueryCategoryAll(model.CategoryTwo);
                var result = new ResultBase();
                var resultMsg = string.Empty;
                var fileName = CommonMethod.ImageUpload(out result, this.HttpContext);
                if (result.result == -2)
                {
                    customScript = UtilityScript.ShowMessage(result.resultMsg, isCreate: true);
                    return View(model);
                }

                model.Context = fc["editorValue"];
                model.Thumbnails = string.IsNullOrWhiteSpace(fileName) ? model.Thumbnails : fileName;
                model.Status = Convert.ToInt32(model.IsPermission);
                model.Isrecommend = Convert.ToInt32(model.IsRec);
                model.Createdate = model.Createdate;
                LogicArticle artDal = new LogicArticle();
                var resultInsertUpdate = artDal.ArticleInsertUpdate(out resultMsg,base.AuthorizeInfo, model);

                if (resultInsertUpdate > 0)
                    customScript = UtilityScript.ShowMessage(BaseDict.OperationSuccessfullyMsg, isCreate: true, isSuccess: true, funName: "Goto");
                else
                    customScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: false, funName: "BtnShow");
            }
            catch (AuthorizeException ex)
            {
                customScript = Library.Common.UtilityScript.ShowMessage("系统出错,错误信息:" + ex.Message, title: "警告", isSuccess: false, funName: "GotoLogin");
            }
            catch (Exception ex)
            {
                customScript = Library.Common.UtilityScript.ShowMessage("系统出错,错误信息:" + ex.Message, title: "警告");
            }

            ViewBag.Categorys = categorys;
            ViewBag.CategorysTwo = categorysTwo;
            ViewBag.CustomScript = customScript;
            return View(model);
        }
コード例 #4
0
 /// <summary>
 /// 新增文章
 /// </summary> 
 public ActionResult Create(string Id = null)
 {
     var model = new ModelArticle();
     if (!string.IsNullOrWhiteSpace(Id))
     {
         var idx = Convert.ToInt32(Id);
         LogicArticle artDal = new LogicArticle();
         var resultMsg = string.Empty;
         model = artDal.ArticleDetail(out resultMsg, idx);
         model.IsPermission = model.Status == 1 ? true : false;
         model.IsRec = model.Isrecommend == 1 ? true : false;
         ViewBag.Categorys = QueryCategoryAll(model.Id.ToString());
         ViewBag.CustomScript = string.Empty;
     }
     else
     {
         ViewBag.Categorys = QueryCategoryAll();
         ViewBag.CustomScript = string.Empty;
     }
     return View(model);
 }
コード例 #5
0
        /// <summary>
        /// 新增文章
        /// </summary> 
        public ActionResult Create(string Id = null)
        {
            var model = new ModelArticle();
            var customScript = string.Empty;
            IList<SelectListItem> categorys = new List<SelectListItem>();
            IList<SelectListItem> categorysTwo = new List<SelectListItem>();
            try
            {
                if (!string.IsNullOrWhiteSpace(Id))
                {
                    var idx = Convert.ToInt32(Id);
                    LogicArticle artDal = new LogicArticle();
                    var resultMsg = string.Empty;
                    model = artDal.ArticleDetail(out resultMsg, base.AuthorizeInfo, idx);
                    model.IsPermission = model.Status == 1 ? true : false;
                    model.IsRec = model.Isrecommend == 1 ? true : false;
                    categorys = QueryCategoryAll(model.Id.ToString());
                    customScript = string.Empty;
                }
                else
                {
                    model.Createdate = DateTime.Now;
                    categorys = QueryCategoryAll();
                    customScript = string.Empty;
                }
            }
            catch (AuthorizeException ex)
            {
                customScript = Library.Common.UtilityScript.ShowMessage("系统出错,错误信息:" + ex.Message, title: "警告", isSuccess: false, funName: "GotoLogin");
            }
            catch (Exception ex)
            {
                customScript = Library.Common.UtilityScript.ShowMessage("系统出错,错误信息:" + ex.Message, title: "警告");
            }

            ViewBag.Categorys = categorys;
            ViewBag.CategorysTwo = categorysTwo;
            ViewBag.CustomScript = customScript;
            return View(model);
        }
コード例 #6
0
ファイル: LogicArticle.cs プロジェクト: JasonDevStudio/Cnita
        /// <summary>
        ///  ��ѯʵ��
        /// </summary>
        /// <param name="categoryId">ModelId ���</param>
        /// <returns>ModelArticle</returns>
        public ModelArticle ArticleDetailByIsRecommend(out string resultMsg, Int32 categoryId)
        {
            resultMsg = string.Empty;
            var model = new ModelArticle();
            try
            {
                //�洢��������
                string sql = "usp_article_select_detail_by_isrecommend";

                //�������
                IList<DBParameter> parm = new List<DBParameter>();
                parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = categoryId, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });

                //��ѯִ��
                using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
                {
                    IList<ModelArticle> list = GetModel(dr);
                    model = list.First();
                }
            }
            catch (Exception ex)
            {
                resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
            }
            return model;
        }
コード例 #7
0
ファイル: LogicArticle.cs プロジェクト: JasonDevStudio/Cnita
        /// <summary>
        /// Model ��ֵ IDataReader
        /// </summary>
        private IList<ModelArticle> GetModel(IDataReader dr)
        {
            var modelList = new List<ModelArticle>();

            while (dr.Read())
            {
                var model = new ModelArticle();
                model.Id = dr["Id"]== DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]);
                model.Title = dr["Title"]== DBNull.Value ? string.Empty : dr["Title"].ToString();
                model.Author = dr["Author"]== DBNull.Value ? string.Empty : dr["Author"].ToString();
                model.Source = dr["Source"]== DBNull.Value ? string.Empty : dr["Source"].ToString();
                model.Context = dr["Context"]== DBNull.Value ? string.Empty : dr["Context"].ToString();
                model.Abstract = dr["Abstract"]== DBNull.Value ? string.Empty : dr["Abstract"].ToString();
                model.Thumbnails = dr["Thumbnails"]== DBNull.Value ? string.Empty : dr["Thumbnails"].ToString();
                model.Categoryid = dr["CategoryId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["CategoryId"]);
                model.CategoryTwo = dr["CategoryTwo"] == DBNull.Value ? string.Empty : dr["CategoryTwo"].ToString();
                model.Keyword = dr["Keyword"]== DBNull.Value ? string.Empty : dr["Keyword"].ToString();
                model.Isrecommend = dr["IsRecommend"]== DBNull.Value ? 0 : Convert.ToInt32(dr["IsRecommend"]);
                model.Titlecolor = dr["TitleColor"]== DBNull.Value ? string.Empty : dr["TitleColor"].ToString();
                model.Titleisbold = dr["TitleIsBold"]== DBNull.Value ? 0 : Convert.ToInt32(dr["TitleIsBold"]);
                model.Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]);
                model.CategoryName = dr["CategoryName"] == DBNull.Value ? string.Empty : Convert.ToString(dr["CategoryName"]);
                model.Createdate = dr["CreateDate"]== DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["CreateDate"]);
                modelList.Add(model);
            }
            return modelList;
        }
コード例 #8
0
ファイル: LogicArticle.cs プロジェクト: JasonDevStudio/Cnita
        /// <summary>
        /// ���� ���/����
        /// </summary>
        /// <param name="article">ʵ��</param>
        /// <returns>ִ�н��</returns>
        public int ArticleInsertUpdate(out string resultMsg,ModelArticle article,DbTransaction tran =null)
        {
            resultMsg = string.Empty;
            int res = 0;
            try
            {
                //�洢��������
                string sql = "USP_ARTICLE_INSERT_UPDATE";
                //�������
                IList<DBParameter> parm = new List<DBParameter>();
                parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = article.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "TITLE", ParameterValue = article.Title, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "AUTHOR", ParameterValue = article.Author, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "SOURCE", ParameterValue = article.Source, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "CONTEXT", ParameterValue = article.Context, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "ABSTRACT", ParameterValue = article.Abstract, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "THUMBNAILS", ParameterValue = article.Thumbnails, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "CATEGORYID", ParameterValue = article.Categoryid, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "Categorytwo", ParameterValue = article.CategoryTwo, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "KEYWORD", ParameterValue = article.Keyword, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "ISRECOMMEND", ParameterValue = article.Isrecommend, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "TITLECOLOR", ParameterValue = article.Titlecolor, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
                parm.Add(new DBParameter() { ParameterName = "TITLEISBOLD", ParameterValue = article.Titleisbold, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
                parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = article.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });

                //����/����ִ��
                res = DBHelper.ExecuteNonQuery(sql, true, parm, tran);

            }
            catch (Exception ex)
            {
                if(tran != null)
                    tran.Rollback();
                resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
            }
            return res;
        }