/// <summary> /// 更新一条数据 /// </summary> public bool Update(ITC_Sysmenus_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ITC_Sysmenus set "); strSql.Append(" Menu_Oprt = @Menu_Oprt , "); strSql.Append(" Menu_Status = @Menu_Status , "); strSql.Append(" Menu_Name = @Menu_Name , "); strSql.Append(" Menu_Remark = @Menu_Remark , "); strSql.Append(" Menu_Ico = @Menu_Ico , "); strSql.Append(" Menu_Type = @Menu_Type , "); strSql.Append(" Menu_Order = @Menu_Order , "); strSql.Append(" Menu_Url = @Menu_Url , "); strSql.Append(" Menu_ParentID = @Menu_ParentID , "); strSql.Append(" Menu_createdtime = @Menu_createdtime "); strSql.Append(" where Menu_ID=@Menu_ID "); SqlParameter[] parameters = { new SqlParameter("@Menu_ID", SqlDbType.Char, 10), new SqlParameter("@Menu_Oprt", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Status", SqlDbType.Int, 4), new SqlParameter("@Menu_Name", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Menu_Ico", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Type", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Order", SqlDbType.Int, 4), new SqlParameter("@Menu_Url", SqlDbType.VarChar, 500), new SqlParameter("@Menu_ParentID", SqlDbType.Char, 10), new SqlParameter("@Menu_createdtime", SqlDbType.DateTime) }; parameters[0].Value = model.Menu_ID; parameters[1].Value = model.Menu_Oprt; parameters[2].Value = model.Menu_Status; parameters[3].Value = model.Menu_Name; parameters[4].Value = model.Menu_Remark; parameters[5].Value = model.Menu_Ico; parameters[6].Value = model.Menu_Type; parameters[7].Value = model.Menu_Order; parameters[8].Value = model.Menu_Url; parameters[9].Value = model.Menu_ParentID; parameters[10].Value = model.Menu_createdtime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ITC_Sysmenus_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ITC_Sysmenus("); strSql.Append("Menu_ID,Menu_Oprt,Menu_Status,Menu_Name,Menu_Remark,Menu_Ico,Menu_Type,Menu_Order,Menu_Url,Menu_ParentID,Menu_createdtime"); strSql.Append(") values ("); strSql.Append("@Menu_ID,@Menu_Oprt,@Menu_Status,@Menu_Name,@Menu_Remark,@Menu_Ico,@Menu_Type,@Menu_Order,@Menu_Url,@Menu_ParentID,@Menu_createdtime"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Menu_ID", SqlDbType.Char, 10), new SqlParameter("@Menu_Oprt", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Status", SqlDbType.Int, 4), new SqlParameter("@Menu_Name", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Menu_Ico", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Type", SqlDbType.VarChar, 50), new SqlParameter("@Menu_Order", SqlDbType.Int, 4), new SqlParameter("@Menu_Url", SqlDbType.VarChar, 500), new SqlParameter("@Menu_ParentID", SqlDbType.Char, 10), new SqlParameter("@Menu_createdtime", SqlDbType.DateTime) }; parameters[0].Value = model.Menu_ID; parameters[1].Value = model.Menu_Oprt; parameters[2].Value = model.Menu_Status; parameters[3].Value = model.Menu_Name; parameters[4].Value = model.Menu_Remark; parameters[5].Value = model.Menu_Ico; parameters[6].Value = model.Menu_Type; parameters[7].Value = model.Menu_Order; parameters[8].Value = model.Menu_Url; parameters[9].Value = model.Menu_ParentID; parameters[10].Value = model.Menu_createdtime; int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (result > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取名称(缓存) /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetNameByCache(string id) { if (!string.IsNullOrEmpty(id)) { ITC_Sysmenus_M model = CacheList.Find(m => m.Menu_ID == id); if (model != null) { return(model.Menu_Name); } else { return(""); } } else { return(""); } }
/// <summary> /// 获取MenuID(缓存) /// </summary> /// <param name="url"></param> /// <returns></returns> public static string GetMenuIDByUrl(string url) { if (!string.IsNullOrEmpty(url)) { ITC_Sysmenus_M model = CacheList.Find(m => m.Menu_Url.ToLower().Contains(url.ToLower())); if (model != null) { return(model.Menu_ID); } else { return(""); } } else { return(""); } }
//编辑保存 public ActionResult SaveEdit(ITC_Sysmenus_M model) { model.Menu_createdtime = DateTime.Now; model.Menu_Oprt = UserContext.UserName; if (uifo.Exists(model.Menu_ID)) { if (uifo.Update(model)) { MenuContext.InitCache(); EventContext.Add(MenuID, string.Format("修改:{0}", model.Menu_ID)); return(Content("保存成功!")); } else { return(Content("保存失败!")); } } else { return(Content("保存失败! 编码[" + model.Menu_ID + "]不存在!")); } }
//将ds中的数据转换成list返回 private List <ITC_Sysmenus_M> DsToList(DataSet ds) { List <ITC_Sysmenus_M> list = new List <ITC_Sysmenus_M>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { ITC_Sysmenus_M model = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new ITC_Sysmenus_M(); model.Menu_ID = ds.Tables[0].Rows[i]["Menu_ID"].ToString().Trim(); model.Menu_Oprt = ds.Tables[0].Rows[i]["Menu_Oprt"].ToString(); if (ds.Tables[0].Rows[i]["Menu_Status"].ToString() != "") { model.Menu_Status = int.Parse(ds.Tables[0].Rows[i]["Menu_Status"].ToString()); } model.Menu_Name = ds.Tables[0].Rows[i]["Menu_Name"].ToString(); model.Menu_Remark = ds.Tables[0].Rows[i]["Menu_Remark"].ToString(); model.Menu_Ico = ds.Tables[0].Rows[i]["Menu_Ico"].ToString(); model.Menu_Type = ds.Tables[0].Rows[i]["Menu_Type"].ToString(); if (ds.Tables[0].Rows[i]["Menu_Order"].ToString() != "") { model.Menu_Order = int.Parse(ds.Tables[0].Rows[i]["Menu_Order"].ToString()); } model.Menu_Url = ds.Tables[0].Rows[i]["Menu_Url"].ToString(); model.Menu_ParentID = ds.Tables[0].Rows[i]["Menu_ParentID"].ToString().Trim(); if (ds.Tables[0].Rows[i]["Menu_createdtime"].ToString() != "") { model.Menu_createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["Menu_createdtime"].ToString()); } list.Add(model); } } return(list); }
/// <summary> /// 获取菜单名称 /// </summary> /// <param name="Menu_ID"></param> /// <returns></returns> public string GetMenuName(string Menu_ID) { ITC_Sysmenus_M model = GetModel(Menu_ID); return(model != null ? model.Menu_Name : ""); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ITC_Sysmenus_M model) { return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(ITC_Sysmenus_M model) { return(dal.Add(model)); }
//获取模型 public ActionResult GetModel(string id) { ITC_Sysmenus_M mo = uifo.GetModel(id); return(Json(mo, JsonRequestBehavior.AllowGet)); }