// 递归树形 public string Recursion(E_tb_Action model, List <E_tb_RoleAction> RoleActionList) { string res_s = ""; //你想要在视图中得到的值 string strChecked = this.ActionIsChecked(RoleActionList, model.ActionID); if (RoleActionList.Where(p => p.ActionID == model.ActionID).Count() > 0) { strChecked = "true"; } res_s += "{\"id\":\"" + model.ActionID + "\",\"text\":\"" + model.ActionName + "(" + model.ActionCode + ")" + "\",\"checked\":" + strChecked; IList <E_tb_Action> list = tAction.GetModelList("ParentID=" + model.ActionID).ToList(); if (list != null) { res_s += "," + "\"children\":["; for (int i = 0; i < list.Count; i++) { if (i > 0) { res_s += ","; } res_s += Recursion(list[i], RoleActionList); } res_s += "]"; } ; res_s += "}"; return(res_s); }
/// <summary> /// 获得数据列表 /// </summary> public List <E_tb_Action> DataTableToList(DataTable dt) { List <E_tb_Action> modelList = new List <E_tb_Action>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { E_tb_Action model; for (int n = 0; n < rowsCount; n++) { model = new E_tb_Action(); if (dt.Rows[n]["ActionID"].ToString() != "") { model.ActionID = int.Parse(dt.Rows[n]["ActionID"].ToString()); } if (dt.Rows[n]["ParentID"].ToString() != "") { model.ParentID = int.Parse(dt.Rows[n]["ParentID"].ToString()); } model.ActionName = dt.Rows[n]["ActionName"].ToString(); model.ActionCode = dt.Rows[n]["ActionCode"].ToString(); model.RequestType = dt.Rows[n]["RequestType"].ToString(); model.RequestURL = dt.Rows[n]["RequestURL"].ToString(); if (dt.Rows[n]["ActionType"].ToString() != "") { model.ActionType = int.Parse(dt.Rows[n]["ActionType"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 保存信息 /// 作者:小朱 /// </summary> /// <param name="eAction">要处理的对象</param> /// <returns>返回是否处理成功</returns> public string Save(E_tb_Action eAction) { string msg = "0"; if (string.IsNullOrEmpty(eAction.ActionCode)) { eAction.ActionCode = Guid.NewGuid().ToString().Substring(0, 8); } if (eAction.EditType == "Add") { if (eAction.ParentID == null) { eAction.ActionType = 1; eAction.ParentID = 0; } tAction.Add(eAction); msg = "1"; } else { tAction.Update(eAction); msg = "1"; } return(msg); }
/// <summary> /// 显示详情页 模块 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult ActionEdit(E_tb_Action eAction, string EditType, int?InfoID) { if (EditType == "Edit") { eAction = tAction.GetModel(Convert.ToInt32(InfoID)); } eAction.EditType = EditType; return(View(eAction)); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_Action GetModel(int ActionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ActionID,ParentID,ActionName,ActionCode,RequestType,RequestURL,ActionType from tb_Action "); strSql.Append(" where ActionID=@ActionID"); SqlParameter[] parameters = { new SqlParameter("@ActionID", SqlDbType.Int, 4) }; parameters[0].Value = ActionID; E_tb_Action model = new E_tb_Action(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ActionID"].ToString() != "") { model.ActionID = int.Parse(ds.Tables[0].Rows[0]["ActionID"].ToString()); } if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "") { model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString()); } if (ds.Tables[0].Rows[0]["ActionName"] != null) { model.ActionName = ds.Tables[0].Rows[0]["ActionName"].ToString(); } if (ds.Tables[0].Rows[0]["ActionCode"] != null) { model.ActionCode = ds.Tables[0].Rows[0]["ActionCode"].ToString(); } if (ds.Tables[0].Rows[0]["RequestType"] != null) { model.RequestType = ds.Tables[0].Rows[0]["RequestType"].ToString(); } if (ds.Tables[0].Rows[0]["RequestURL"] != null) { model.RequestURL = ds.Tables[0].Rows[0]["RequestURL"].ToString(); } if (ds.Tables[0].Rows[0]["ActionType"].ToString() != "") { model.ActionType = int.Parse(ds.Tables[0].Rows[0]["ActionType"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 显示详情页 页面、操作 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult ActionPageEdit(E_tb_Action eAction, string EditType, int?ParentID, int?InfoID) { if (EditType == "Edit") { eAction = tAction.GetModel(Convert.ToInt32(InfoID)); eAction.ParentName = tAction.GetModel(Convert.ToInt32(eAction.ParentID)).ActionName; } else { E_tb_Action TempAction = tAction.GetModel(int.Parse(ParentID.ToString())); eAction.ParentID = ParentID; eAction.ActionType = TempAction.ActionType + 1; eAction.ParentName = TempAction.ActionName; } eAction.EditType = EditType; return(View(eAction)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_Action model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Action set "); strSql.Append("ParentID=@ParentID,"); strSql.Append("ActionName=@ActionName,"); strSql.Append("ActionCode=@ActionCode,"); strSql.Append("RequestType=@RequestType,"); strSql.Append("RequestURL=@RequestURL,"); strSql.Append("ActionType=@ActionType"); strSql.Append(" where ActionID=@ActionID"); SqlParameter[] parameters = { new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@ActionName", SqlDbType.NVarChar, 50), new SqlParameter("@ActionCode", SqlDbType.NVarChar, 50), new SqlParameter("@RequestType", SqlDbType.NVarChar, 50), new SqlParameter("@RequestURL", SqlDbType.NVarChar, 50), new SqlParameter("@ActionType", SqlDbType.Int, 4), new SqlParameter("@ActionID", SqlDbType.Int, 4) }; parameters[0].Value = model.ParentID; parameters[1].Value = model.ActionName; parameters[2].Value = model.ActionCode; parameters[3].Value = model.RequestType; parameters[4].Value = model.RequestURL; parameters[5].Value = model.ActionType; parameters[6].Value = model.ActionID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_Action model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Action("); strSql.Append("ParentID,ActionName,ActionCode,RequestType,RequestURL,ActionType)"); strSql.Append(" values ("); strSql.Append("@ParentID,@ActionName,@ActionCode,@RequestType,@RequestURL,@ActionType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@ActionName", SqlDbType.NVarChar, 50), new SqlParameter("@ActionCode", SqlDbType.NVarChar, 50), new SqlParameter("@RequestType", SqlDbType.NVarChar, 50), new SqlParameter("@RequestURL", SqlDbType.NVarChar, 50), new SqlParameter("@ActionType", SqlDbType.Int, 4) }; parameters[0].Value = model.ParentID; parameters[1].Value = model.ActionName; parameters[2].Value = model.ActionCode; parameters[3].Value = model.RequestType; parameters[4].Value = model.RequestURL; parameters[5].Value = model.ActionType; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_Action model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_Action model) { return(dal.Add(model)); }