/// <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);
}
}
