private List <ITC_Roles_M> DsToList(DataSet ds) { List <ITC_Roles_M> list = new List <ITC_Roles_M>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { ITC_Roles_M model = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new ITC_Roles_M(); model.Role_ID = ds.Tables[0].Rows[i]["Role_ID"].ToString().Trim(); model.Role_Name = ds.Tables[0].Rows[i]["Role_Name"].ToString(); model.Role_Remark = ds.Tables[0].Rows[i]["Role_Remark"].ToString(); if (ds.Tables[0].Rows[i]["Role_Status"].ToString() != "") { model.Role_Status = int.Parse(ds.Tables[0].Rows[i]["Role_Status"].ToString()); } if (ds.Tables[0].Rows[0]["Role_createdtime"].ToString() != "") { model.Role_createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["Role_createdtime"].ToString()); } model.Role_oprt = ds.Tables[0].Rows[i]["Role_oprt"].ToString(); list.Add(model); } } return(list); }
//编辑保存 public ActionResult SaveEdit(ITC_Roles_M model) { if (uifo.Exists(model.Role_ID)) { model.Role_createdtime = DateTime.Now; model.Role_oprt = UserContext.UserName; if (uifo.Update(model)) { EventContext.Add(MenuID, string.Format("修改:{0}", model.Role_ID)); return(Content("保存成功!")); } else { return(Content("保存失败!")); } } else { return(Content("保存失败! 编码[" + model.Role_ID + "]不存在!")); } }
//设置权限 public ActionResult SaveRight(FormCollection collection) { string roleid = Request["roleid"]; if (!string.IsNullOrEmpty(roleid)) { //删除菜单权限 操作权限 uifo.DeleteRoleRights(roleid); uifo.DeleteRoleOperator(roleid); if (collection.Count > 0) { string menuid = ""; string buttonid = ""; for (int i = 0; i < collection.Count; i++) { string key = collection.Keys[i]; string value = collection[i]; menuid = key.Split('|')[0]; buttonid = key.Split('|')[1]; //添加菜单权限 操作权限 if (value == "on") { uifo.AddRoleRights(roleid, menuid); uifo.AddRoleOperator(roleid, menuid, buttonid); } } } ITC_Roles_M model = uifo.GetModel(roleid); model.Role_oprt = UserContext.UserName; model.Role_createdtime = DateTime.Now; uifo.Update(model); EventContext.Add(MenuID, string.Format("设置权限:{0}", roleid)); return(Content("保存成功!")); } else { return(Content("参数错误!")); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ITC_Roles_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ITC_Roles set "); strSql.Append(" Role_Name = @Role_Name , "); strSql.Append(" Role_Remark = @Role_Remark , "); strSql.Append(" Role_Status = @Role_Status , "); strSql.Append(" Role_createdtime = @Role_createdtime , "); strSql.Append(" Role_oprt = @Role_oprt "); strSql.Append(" where Role_ID=@Role_ID "); SqlParameter[] parameters = { new SqlParameter("@Role_ID", SqlDbType.Char, 10), new SqlParameter("@Role_Name", SqlDbType.VarChar, 50), new SqlParameter("@Role_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Role_Status", SqlDbType.Int, 4), new SqlParameter("@Role_createdtime", SqlDbType.DateTime), new SqlParameter("@Role_oprt", SqlDbType.VarChar, 10) }; parameters[0].Value = model.Role_ID; parameters[1].Value = model.Role_Name; parameters[2].Value = model.Role_Remark; parameters[3].Value = model.Role_Status; parameters[4].Value = model.Role_createdtime; parameters[5].Value = model.Role_oprt; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ITC_Roles_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ITC_Roles("); strSql.Append("Role_ID,Role_Name,Role_Remark,Role_Status,Role_createdtime,Role_oprt"); strSql.Append(") values ("); strSql.Append("@Role_ID,@Role_Name,@Role_Remark,@Role_Status,@Role_createdtime,@Role_oprt"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Role_ID", SqlDbType.Char, 10), new SqlParameter("@Role_Name", SqlDbType.VarChar, 50), new SqlParameter("@Role_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Role_Status", SqlDbType.Int, 4), new SqlParameter("@Role_createdtime", SqlDbType.DateTime), new SqlParameter("@Role_oprt", SqlDbType.VarChar, 10) }; parameters[0].Value = model.Role_ID; parameters[1].Value = model.Role_Name; parameters[2].Value = model.Role_Remark; parameters[3].Value = model.Role_Status; parameters[4].Value = model.Role_createdtime; parameters[5].Value = model.Role_oprt; int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (result > 0) { return(true); } else { return(false); } }
//获取模型 public ActionResult GetModel(string id) { ITC_Roles_M mo = uifo.GetModel(id); return(Json(mo, JsonRequestBehavior.AllowGet)); }
public string GetRoleName(string roleid) { ITC_Roles_M model = GetModel(roleid); return(model != null ? model.Role_Name : ""); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ITC_Roles_M model) { return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(ITC_Roles_M model) { return(dal.Add(model)); }