public ActionResult Edit(ModelCategory model, FormCollection fc) { var resultMsg = string.Empty; ViewBag.Categorys = base.QueryCategoryAll(model.Parentcateg); var result = new ResultBase(); //图片上传 var fileName = CommonMethod.ImageUpload(out result, this.HttpContext); if (result.result == -2) { ViewBag.CustomScript = UtilityScript.ShowMessage(result.resultMsg, isCreate: true); return View(model); } model.Parentcateg = string.IsNullOrWhiteSpace(model.Parentcateg) ? "0" : model.Parentcateg; model.Thumbnails = string.IsNullOrWhiteSpace(fileName) ? model.Thumbnails : fileName; model.Introduction = fc["editorValue"]; //数据保存 LogicCategory logic = new LogicCategory(); var res = logic.CategoryInsertUpdate(out resultMsg,base.AuthorizeInfo, 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); }
public ActionResult Edit(string id = null, string Category=null) { ModelCategory model = new ModelCategory(); if (string.IsNullOrWhiteSpace(id)) { model.Parentcateg = Category; model.Createdate = DateTime.Now; ViewBag.Categorys = base.QueryCategoryAll(string.IsNullOrWhiteSpace(Category) ? null : Category); return View(model); } else { var idx = 0; int.TryParse(id, out idx); var resultMsg = string.Empty; LogicCategory logic = new LogicCategory(); model = logic.CategoryDetail(out resultMsg,base.AuthorizeInfo, idx); if (model != null && string.IsNullOrWhiteSpace(model.Parentcateg)==false) { ViewBag.Categorys = base.QueryCategoryAll(model.Parentcateg.ToString()); } else { ViewBag.Categorys = base.QueryCategoryAll(); } if (resultMsg.Contains(BaseDict.ErrorPrefix)) { ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true); } return View(model); } }
private IList<ModelCategory> GetModelThree(IDataReader dr) { var modelList = new List<ModelCategory>(); while (dr.Read()) { var model = new ModelCategory(); model.Id = dr["Id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]); model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString(); model.Parentcateg = dr["ParentCateg"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ParentCateg"]); model.Level = dr["LEVEL"] == DBNull.Value ? 0 : Convert.ToInt32(dr["LEVEL"]); modelList.Add(model); } return modelList; }
/// <summary> /// Model ��ֵ IDataReader /// </summary> private IList<ModelCategory> GetModel(IDataReader dr) { var modelList = new List<ModelCategory>(); while (dr.Read()) { var model = new ModelCategory(); model.Id = dr["Id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]); model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString(); model.Nameen = dr["NameEn"] == DBNull.Value ? string.Empty : dr["NameEn"].ToString(); model.Thumbnails = dr["Thumbnails"] == DBNull.Value ? string.Empty : dr["Thumbnails"].ToString(); model.Introduction = dr["Introduction"] == DBNull.Value ? string.Empty : dr["Introduction"].ToString(); model.Parentcateg = dr["ParentCateg"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ParentCateg"]); model.Sort = dr["Sort"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Sort"]); model.Isnav = dr["IsNav"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsNav"]); model.Isindex = dr["IsIndex"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsIndex"]); model.Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]); model.Createdate = dr["CreateDate"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["CreateDate"]); modelList.Add(model); } return modelList; }
/// <summary> /// ���� ���/���� /// </summary> /// <param name="category">ʵ��</param> /// <returns>ִ�н��</returns> public int CategoryInsertUpdate(out string resultMsg, ModelCategory category, DbTransaction tran = null) { resultMsg = string.Empty; int res = 0; try { //�洢�������� string sql = "USP_CATEGORY_INSERT_UPDATE"; //������� IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = category.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "NAME", ParameterValue = category.Name, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "NAMEEN", ParameterValue = category.Nameen, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "THUMBNAILS", ParameterValue = category.Thumbnails, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "INTRODUCTION", ParameterValue = category.Introduction, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "PARENTCATEG", ParameterValue = category.Parentcateg, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "SORT", ParameterValue = category.Sort, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "ISNAV", ParameterValue = category.Isnav, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "ISINDEX", ParameterValue = category.Isindex, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = category.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); //parm.Add(new DBParameter() { ParameterName = "CREATEDATE", ParameterValue = category.Createdate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime }); //parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String }); //����/����ִ�� 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; }
/// <summary> /// ��ѯʵ�� /// </summary> /// <param name="id">ModelId ���</param> /// <returns>ModelCategory</returns> public ModelCategory CategoryDetailByPid(out string resultMsg, Int32 id,DateTime StartDate ,DateTime EndDate) { resultMsg = string.Empty; var model = new ModelCategory(); try { //�洢�������� string sql = "usp_category_select_detail_by_pid"; //������� IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "Id", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "StartDate", ParameterValue = StartDate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime }); parm.Add(new DBParameter() { ParameterName = "EndDate", ParameterValue = EndDate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime }); //��ѯִ�� using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm)) { IList<ModelCategory> list = GetModel(dr); model = list.First(); } } catch (Exception ex) { resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return model; }
/// <summary> /// ��ѯʵ�� /// </summary> /// <param name="id">ModelId ���</param> /// <returns>ModelCategory</returns> public ModelCategory CategoryDetail(out string resultMsg, Int32 id) { resultMsg = string.Empty; var model = new ModelCategory(); try { //�洢�������� string sql = "USP_CATEGORY_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<ModelCategory> list = GetModel(dr); model = list.First(); } } catch (Exception ex) { resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return model; }