/// <summary> /// get ungranted data by groupid /// <summary> /// <param name=chkurl>chkurl</param> /// <param name=chkweburl>chkweburl</param> ///<returns>Details about all TaskGrant</returns> public BindingCollection <modTaskGrant> GetReadyData(bool chkurl, bool chkweburl, string roleid, out string emsg) { try { BindingCollection <modTaskGrant> modellist = new BindingCollection <modTaskGrant>(); string urlwhere = string.Empty; if (chkurl) { if (chkweburl) { urlwhere = "and LEN(rtrim(ltrim(url)))>0 and LEN(rtrim(ltrim(web_url)))>0 "; } else { urlwhere = "and LEN(rtrim(ltrim(url)))>0 "; } } else { if (chkweburl) { urlwhere = "and LEN(rtrim(ltrim(web_url)))>0 "; } else { urlwhere = string.Empty; } } string sql = string.Format("select task_code,task_name,form_name,group_id,task_type,url,web_url from sys_task_list where 1=1 " + urlwhere + " except select a.task_code,b.task_name,b.form_name,b.group_id,b.task_type,b.url,b.web_url from sys_task_grant a,sys_task_list b where a.task_code=b.task_code and a.role_id= '{0}' and b.status=1 order by task_code", roleid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modTaskGrant model = new modTaskGrant(); model.TaskCode = rdr["task_code"].ToString(); model.TaskName = rdr["task_name"].ToString(); model.TaskType = rdr["task_type"].ToString(); model.FormName = rdr["form_name"].ToString(); model.GroupId = rdr["group_id"].ToString(); model.Url = rdr["url"].ToString(); model.WebUrl = rdr["web_url"].ToString(); model.Checked = false; modellist.Add(model); } emsg = ""; return(modellist); } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
/// <summary> /// get all already granted data /// <summary> /// <param name=roleid>roleid</param> ///<returns>Details about all TaskGrant</returns> public BindingCollection <modTaskGrant> GetAllUserTask(string userid, out string emsg) { try { dalUserList daluser = new dalUserList(); modUserList moduser = daluser.GetItem(userid); BindingCollection <modTaskGrant> modellist = new BindingCollection <modTaskGrant>(); string sql = string.Format("select a.task_code,b.task_name,b.form_name,b.group_id,b.task_type,b.url,b.web_url from sys_task_grant a,sys_task_list b where a.task_code=b.task_code and a.role_id= '{0}' and b.status=1 order by a.task_code", userid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modTaskGrant model = new modTaskGrant(); model.TaskCode = rdr["task_code"].ToString(); model.TaskName = rdr["task_name"].ToString(); model.TaskType = rdr["task_type"].ToString(); model.FormName = rdr["form_name"].ToString(); model.GroupId = rdr["group_id"].ToString(); model.Url = rdr["url"].ToString(); model.WebUrl = rdr["web_url"].ToString(); model.Checked = true; modellist.Add(model); } } sql = string.Format("select a.task_code,a.task_name,a.form_name,a.group_id,a.task_type,a.url,a.web_url from sys_task_list a where a.status=1 and not exists (select '#' from sys_task_grant where task_code =a.task_code and (role_id='{0}' or role_id='{1}'))", moduser.RoleId, userid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modTaskGrant model = new modTaskGrant(); model.TaskCode = rdr["task_code"].ToString(); model.TaskName = rdr["task_name"].ToString(); model.TaskType = rdr["task_type"].ToString(); model.FormName = rdr["form_name"].ToString(); model.GroupId = rdr["group_id"].ToString(); model.Url = rdr["url"].ToString(); model.WebUrl = rdr["web_url"].ToString(); model.Checked = false; modellist.Add(model); } } emsg = string.Empty; return(modellist); } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
/// <summary> /// get granted data by userid and groupid /// <summary> /// <param name=chkurl>chkurl</param> /// <param name=chkweburl>chkweburl</param> /// <param name=userid>userid</param> /// <param name=groupidlist>groupidlist</param> /// <param name=tasktypelist>tasktypelist</param> ///<returns>get granted data by userid</returns> public BindingCollection <modTaskGrant> GetUserGrantData(bool chkurl, bool chkweburl, string userid, string groupidlist, string tasktypelist, out string emsg) { try { string groupwhere = string.Empty; if (!string.IsNullOrEmpty(groupidlist) && groupidlist != "ALL") { groupwhere = "and a.group_id in ('" + groupidlist.Replace(",", "','") + "') "; } string tasktypewhere = string.Empty; if (!string.IsNullOrEmpty(tasktypelist) && tasktypelist != "ALL") { tasktypewhere = "and a.task_type in ('" + tasktypelist.Replace(",", "','") + "') "; } string urlwhere = string.Empty; if (chkurl) { if (chkweburl) { urlwhere = "and LEN(rtrim(ltrim(url)))>0 and LEN(rtrim(ltrim(web_url)))>0 "; } else { urlwhere = "and LEN(rtrim(ltrim(url)))>0 "; } } else { if (chkweburl) { urlwhere = "and LEN(rtrim(ltrim(web_url)))>0 "; } else { urlwhere = string.Empty; } } BindingCollection <modTaskGrant> modellist = new BindingCollection <modTaskGrant>(); string sql = string.Format("select a.task_code,a.task_name,a.group_id,a.task_type,a.form_name,a.url,a.web_url from sys_task_list a,sys_task_grant b where a.task_code=b.task_code and b.role_id='{0}' " + urlwhere + groupwhere + "union select a.task_code,a.task_name,a.group_id,a.task_type,a.form_name,a.url,a.web_url from sys_task_list a,sys_task_grant b,sys_user_list c where a.task_code=b.task_code and b.role_id=c.role_id " + "and a.status=1 and c.user_id='{1}' " + urlwhere + groupwhere + tasktypewhere, userid, userid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modTaskGrant model = new modTaskGrant(); model.TaskCode = rdr["task_code"].ToString(); model.TaskName = rdr["task_name"].ToString(); model.TaskType = rdr["task_type"].ToString(); model.FormName = rdr["form_name"].ToString(); model.GroupId = rdr["group_id"].ToString(); model.Url = rdr["url"].ToString(); model.WebUrl = rdr["web_url"].ToString(); model.Checked = true; modellist.Add(model); } emsg = ""; return(modellist); } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }