public ActionResult New(int?id, int pid) { int MoudleID = id == null ? 0 : (int)id; Model.SysMoudle model = new Model.SysMoudle(); model.ParentID = pid; if (MoudleID > 0) { model = Opr.GetEntity(MoudleID); ViewBag.Title = "模块管理-正在编辑模块编号: " + model.MoudleID; } else { model.MoudleID = 0; model.State = true; ViewBag.Title = "后端管理系统-新增模块"; } return(View(model)); }
/// <summary> /// 新增模块 /// </summary> /// <returns>返回新增模块ID</returns> /// <param name="Model">模块实体</param> public int Insert(Model.SysMoudle Model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" if not exists(select Name from SysMoudle where Name =@Name ) begin "); strSql.Append(" insert into SysMoudle("); strSql.Append(" ParentID,Name,LinkUrl,Style,OrderCode,State,MoudleDes)"); strSql.Append(" values ("); strSql.Append(" @ParentID,@Name,@LinkUrl,@Style,@OrderCode,@State,@MoudleDes)"); strSql.Append(" ; select @@IDENTITY; "); strSql.Append(" end ELSE begin SELECT -1 END"); SqlParameter[] parameters = { new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 50), new SqlParameter("@Style", SqlDbType.NVarChar, 50), new SqlParameter("@OrderCode", SqlDbType.NVarChar, 50), new SqlParameter("@State", SqlDbType.Bit, 1), new SqlParameter("@MoudleDes", SqlDbType.NVarChar, 500) }; parameters[0].Value = Model.ParentID; parameters[1].Value = Model.Name; parameters[2].Value = Model.LinkUrl; parameters[3].Value = Model.Style; parameters[4].Value = Model.OrderCode; parameters[5].Value = Model.State; parameters[6].Value = Model.MoudleDes; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 设置实体 /// </summary> /// <returns>返回对象实体</returns> /// <param name="dr">行</param> private Model.SysMoudle SetEntity(DataRow dr) { Model.SysMoudle model = new Model.SysMoudle(); if (dr != null) { if (dr["MoudleID"].ToString() != "") { model.MoudleID = int.Parse(dr["MoudleID"].ToString()); } if (dr["ParentID"].ToString() != "") { model.ParentID = int.Parse(dr["ParentID"].ToString()); } model.Name = dr["Name"].ToString(); model.LinkUrl = dr["LinkUrl"].ToString(); model.Style = dr["Style"].ToString(); model.OrderCode = dr["OrderCode"].ToString(); model.MoudleDes = dr["MoudleDes"].ToString(); if (dr["State"].ToString() != "") { if ((dr["State"].ToString() == "1") || (dr["State"].ToString().ToLower() == "true")) { model.State = true; } else { model.State = false; } } return(model); } else { return(null); } }
/// <summary> /// 修改模块 /// </summary> /// <returns>返回影响行数</returns> /// <param name="Model">模块实体</param> public int ModifyModel(Model.SysMoudle Model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update SysMoudle "); strSql.Append("Set ParentID=@ParentID,Name=@Name,LinkUrl=@LinkUrl,Style=@Style,MoudleDes=@MoudleDes "); strSql.Append("Where MoudleID=@MoudleID "); SqlParameter[] parameters = { new SqlParameter("@MoudleID", SqlDbType.Int, 4), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 50), new SqlParameter("@Style", SqlDbType.NVarChar, 50), new SqlParameter("@MoudleDes", SqlDbType.NVarChar, 500) }; parameters[0].Value = Model.MoudleID; parameters[1].Value = Model.ParentID; parameters[2].Value = Model.Name; parameters[3].Value = Model.LinkUrl; parameters[4].Value = Model.Style; parameters[5].Value = Model.MoudleDes; return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
public ActionResult New(Model.SysMoudle model) { Helper.ResultInfo <int> rs = new Helper.ResultInfo <int>(); if (ModelState.IsValid) { if (model.MoudleID > 0) { rs.Data = Opr.ModifyModel(model); if (rs.Data > 0) { rs.Msg = "修改成功."; rs.Result = true; } else { rs.Msg = "修改失败."; rs.Result = false; } JsonResult jr = new JsonResult(); jr.Data = rs; return(jr); } else { model.OrderCode = Opr.GetNewOrderCode(model.ParentID); rs.Data = Opr.Insert(model); if (rs.Data > 0) { rs.Msg = "新增成功."; rs.Result = true; } else { rs.Msg = "新增失败."; rs.Result = false; } JsonResult jr = new JsonResult(); jr.Data = rs; return(jr); } } else { System.Text.StringBuilder sbErrors = new System.Text.StringBuilder(); foreach (var item in ModelState.Values) { if (item.Errors.Count > 0) { for (int i = item.Errors.Count - 1; i >= 0; i--) { sbErrors.Append(item.Errors[i].ErrorMessage); sbErrors.Append("<br/>"); } } } rs.Data = 0; rs.Msg = sbErrors.ToString(); rs.Result = false; rs.Url = ""; JsonResult jr = new JsonResult(); jr.Data = rs; return(jr); } }
/// <summary> /// 修改模块 /// </summary> /// <returns>返回影响行数</returns> /// <param name="Model">模块实体</param> public int ModifyModel(Model.SysMoudle Model) { return(dal.ModifyModel(Model)); }
/// <summary> /// 新增模块 /// </summary> /// <returns>返回新增模块ID</returns> /// <param name="Model">模块实体</param> public int Insert(Model.SysMoudle Model) { return(dal.Insert(Model)); }