public Department GetDepartment(int id) { string sql = "select * from Depart where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Department dep = new Department(); dep.ID = id; dep.Name = dt.Rows[0]["Name"].ToString(); dep.Manager = dt.Rows[0]["Manager"].ToString(); if (dt.Rows[0]["Parent"] != null && dt.Rows[0]["Parent"] != DBNull.Value) { dep.ParentID = Convert.ToInt32(dt.Rows[0]["Parent"]); } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { dep.Remark = dt.Rows[0]["Remark"].ToString(); } else { dep.Remark = ""; } return(dep); } return(null); }
public Permission GetPermission(int id) { string sql = "select * from Permission where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Permission perm = new Permission(); perm.ID = id; perm.Name = dt.Rows[0]["Name"].ToString(); perm.IsExcept = Convert.ToBoolean(dt.Rows[0]["IsExcept"]); perm.TheModule = ModuleLogic.GetInstance().GetModule(Convert.ToInt32(dt.Rows[0]["TheModule"])); perm.TheAction = ActionLogic.GetInstance().GetAction(Convert.ToInt32(dt.Rows[0]["TheAction"])); if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { perm.Remark = dt.Rows[0]["Remark"].ToString(); } else { perm.Remark = ""; } return(perm); } return(null); }
public UserGroup GetUserGroup(int id) { string sql = "select * from UserGroup where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { UserGroup ug = new UserGroup(); ug.ID = id; ug.Name = dt.Rows[0]["Name"].ToString(); if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { ug.Remark = dt.Rows[0]["Remark"].ToString(); } else { ug.Remark = ""; } return(ug); } return(null); }
public Module GetModule(int id) { string sql = "select * from Module where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Module module = new Module(); module.ID = id; module.Name = dt.Rows[0]["Name"].ToString(); if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value) { module.FormName = dt.Rows[0]["FormName"].ToString(); } else { module.FormName = ""; } if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value) { module.ControlName = dt.Rows[0]["ControlName"].ToString(); } else { module.ControlName = ""; } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { module.Remark = dt.Rows[0]["Remark"].ToString(); } else { module.Remark = ""; } return(module); } return(null); }
public Action GetAction(int id) { string sql = "select * from [Action] where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Action action = new Action(); action.ID = id; action.Name = dt.Rows[0]["Name"].ToString(); if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value) { action.FormName = dt.Rows[0]["FormName"].ToString(); } else { action.FormName = ""; } if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value) { action.ControlName = dt.Rows[0]["ControlName"].ToString(); } else { action.ControlName = ""; } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { action.Remark = dt.Rows[0]["Remark"].ToString(); } else { action.Remark = ""; } return(action); } return(null); }
public Role GetRole(int id) { string sql = "select * from [Role] where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Role role = new Role(); role.ID = id; role.Name = dt.Rows[0]["Name"].ToString(); role.Flag = Convert.ToBoolean(dt.Rows[0]["Flag"]); role.Permissions = Common.GetPermissions(dt.Rows[0]["Permissions"].ToString()); if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { role.Remark = dt.Rows[0]["Remark"].ToString(); } else { role.Remark = ""; } return(role); } return(null); }
public User GetUser(int id) { string sql = "select * from [User] where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { User user = new User(); user.ID = id; user.Username = dt.Rows[0]["Username"].ToString(); user.Departments = Common.GetDepartments(dt.Rows[0]["Depart"].ToString()); user.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]); if (dt.Rows[0]["Password"] != null && dt.Rows[0]["Password"] != DBNull.Value) { user.Password = dt.Rows[0]["Password"].ToString(); } else { user.Password = ""; } if (dt.Rows[0]["Roles"] != null && dt.Rows[0]["Roles"] != DBNull.Value) { user.Roles = Common.GetRoles(dt.Rows[0]["Roles"].ToString()); } if (dt.Rows[0]["Usergroup"] != null && dt.Rows[0]["Usergroup"] != DBNull.Value) { user.Usergroups = Common.GetUserGroups(dt.Rows[0]["Usergroup"].ToString()); } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { user.Remark = dt.Rows[0]["Remark"].ToString(); } return(user); } return(null); }