public DataTable getOriginTableByUserName()
{
MyWebControlLib.FieldValues fvs = new MyWebControlLib.FieldValues();
MyWebControlLib.FieldValue fv = new MyWebControlLib.FieldValue();
fv.FieldName = "username";
fv.Value = username;
fvs.Add(fv);
return(udb.GetOriginTableByKeys(fvs));
}
public DataTable getOriginTableByUserName()
{
MyWebControlLib.FieldValues fvs = new MyWebControlLib.FieldValues();
MyWebControlLib.FieldValue fv = new MyWebControlLib.FieldValue();
fv.FieldName = "username";
fv.Value = username;
fvs.Add(fv);
return udb.GetOriginTableByKeys(fvs);
}
/// <summary>
/// 构造函数：已知用户名和密码，创建用户实例
/// </summary>
/// <param name="userName">用户名（即员工号）</param>
/// <param name="passWord">密码</param>
public UserRoles(string userName, string passWord)
{
MyWebControlLib.FieldValues fvs= new MyWebControlLib.FieldValues();
MyWebControlLib.FieldValue fv= new MyWebControlLib.FieldValue();
fv.FieldName ="userName";
userName= userName.Replace("'","");
passWord = passWord.Replace("'", "");
fv.Value =userName;
username = userName;
password = passWord;
fvs.Add(fv);
fv= new MyWebControlLib.FieldValue();
fv.FieldName ="password";
fv.Value =passWord;
fvs.Add(fv);
DataTable table = udb.GetDataTable(fvs);
if (table.Rows.Count > 0)
{
isvalid = true;
unitcode = table.Rows[0]["unitCode"].ToString();
unitname = table.Rows[0]["unitName"].ToString();
bool flag = true;
//flag = false;//上海
if (flag)
{
truename = table.Rows[0]["truename"].ToString();
if (table.Rows[0]["isonline"].ToString() == "1")
isonline = true;
if (table.Rows[0]["isprivate"].ToString() == "1")
isPrivate = true;
for (int i = 0; i < table.Rows.Count; i++)
{
ModuleRole mr = new ModuleRole();
mr.ModuleKey = table.Rows[i]["ModuleKey"].ToString();
bool first = false;
int index = modulekeys.IndexOf(mr.ModuleKey);//该modulekey第一次出现的位置，若此次为第一次出现，则为-1
if (index == -1)
first = true;
if (table.Rows[i]["isadd"].ToString() == "1")
{
if (first)//第一次出现
mr.Add = true;
else//只对第一次出现该ModuleKey位置的ModuleRole赋值
modulekeys[index].Add = true;
}
if (table.Rows[i]["ischg"].ToString() == "1")
{
if (first)
mr.Edit = true;
else
modulekeys[index].Edit = true;
}
if (table.Rows[i]["isdel"].ToString() == "1")
{
if (first)
mr.Delete = true;
else
modulekeys[index].Delete = true;
}
if (table.Rows[i]["isapp"].ToString() == "1")
{
if (first)
mr.Approve = true;
else
modulekeys[index].Approve = true;
}
if (table.Rows[i]["iscom"].ToString() == "1")
{
if (first)
mr.Finish = true;
else
modulekeys[index].Finish = true;
}
if (table.Rows[i]["isrep"].ToString() == "1")
{
if (first)
mr.Report = true;
else
modulekeys[index].Report = true;
}
if (table.Rows[i]["ispub"].ToString() == "1")
{
if (first)
mr.Publish = true;
else
modulekeys[index].Publish = true;
}
modulekeys.Add(mr);
}
}
}
}
/// <summary>
/// 构造函数：已知用户名和密码，创建用户实例
/// </summary>
/// <param name="userName">用户名（即员工号）</param>
/// <param name="passWord">密码</param>
public UserRoles(string userName, string passWord)
{
MyWebControlLib.FieldValues fvs = new MyWebControlLib.FieldValues();
MyWebControlLib.FieldValue fv = new MyWebControlLib.FieldValue();
fv.FieldName = "userName";
userName = userName.Replace("'", "");
passWord = passWord.Replace("'", "");
fv.Value = userName;
username = userName;
password = passWord;
fvs.Add(fv);
fv = new MyWebControlLib.FieldValue();
fv.FieldName = "password";
fv.Value = passWord;
fvs.Add(fv);
DataTable table = udb.GetDataTable(fvs);
if (table.Rows.Count > 0)
{
isvalid = true;
unitcode = table.Rows[0]["unitCode"].ToString();
unitname = table.Rows[0]["unitName"].ToString();
bool flag = true;
//flag = false;//上海
if (flag)
{
truename = table.Rows[0]["truename"].ToString();
if (table.Rows[0]["isonline"].ToString() == "1")
{
isonline = true;
}
if (table.Rows[0]["isprivate"].ToString() == "1")
{
isPrivate = true;
}
for (int i = 0; i < table.Rows.Count; i++)
{
ModuleRole mr = new ModuleRole();
mr.ModuleKey = table.Rows[i]["ModuleKey"].ToString();
bool first = false;
int index = modulekeys.IndexOf(mr.ModuleKey);//该modulekey第一次出现的位置，若此次为第一次出现，则为-1
if (index == -1)
{
first = true;
}
if (table.Rows[i]["isadd"].ToString() == "1")
{
if (first)//第一次出现
{
mr.Add = true;
}
else//只对第一次出现该ModuleKey位置的ModuleRole赋值
{
modulekeys[index].Add = true;
}
}
if (table.Rows[i]["ischg"].ToString() == "1")
{
if (first)
{
mr.Edit = true;
}
else
{
modulekeys[index].Edit = true;
}
}
if (table.Rows[i]["isdel"].ToString() == "1")
{
if (first)
{
mr.Delete = true;
}
else
{
modulekeys[index].Delete = true;
}
}
if (table.Rows[i]["isapp"].ToString() == "1")
{
if (first)
{
mr.Approve = true;
}
else
{
modulekeys[index].Approve = true;
}
}
if (table.Rows[i]["iscom"].ToString() == "1")
{
if (first)
{
mr.Finish = true;
}
else
{
modulekeys[index].Finish = true;
}
}
if (table.Rows[i]["isrep"].ToString() == "1")
{
if (first)
{
mr.Report = true;
}
else
{
modulekeys[index].Report = true;
}
}
if (table.Rows[i]["ispub"].ToString() == "1")
{
if (first)
{
mr.Publish = true;
}
else
{
modulekeys[index].Publish = true;
}
}
modulekeys.Add(mr);
}
}
}
}
