public string LogOn(string userName, string userPwd)
{
/* PersonManagment pm = new PersonManagment();
* Person_Info p = pm.Get_Person(userName);
* if (p == null)
* return "Index";
*
* else
* {
* CWFEngine.authority_params["currentuser"] = userName;
* Session["User"] = p;
* return "/Main/Index0";
* }*/
int a;
PersonManagment pm = new PersonManagment();
MD5 md5 = new MD5CryptoServiceProvider();
byte[] result = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(userPwd.Trim()));
// pm.ModifyPerson_Pwd(userName, result);
Person_Info p = pm.Get_Person(userName);
if (p == null)
{
return("Index");
}
else
{
byte[] r = p.Person_Pwd;
string userPwdMD5 = System.Text.UTF8Encoding.Unicode.GetString(result);
string userPwDb = System.Text.UTF8Encoding.Unicode.GetString(r);
if (!userPwDb.Equals(userPwdMD5))
{
return("Index");
}
//// string =System.Text.Encoding.Default.GetString(result);
else
{
Dictionary <string, object> dict_authority = new Dictionary <string, object>();
dict_authority["currentuser"] = userName;
Session["authority"] = dict_authority;
CWFEngine.authority_params = "authority";
Session["User"] = p;
return("/Main/Index0");
}
}
}
public int AddPerson_info(Person_Info New_Person)
{
try
{
using (var db = base.NewDB())
{
Person_Info newP = db.Persons.Add(New_Person);
db.SaveChanges();
return(newP.Person_Id);
}
}
catch
{
return(0);
}
}
/*功能：往数据库添加用户基本信息，并设置用户部门、角色、专业和系统菜单信息
* 参数： p 新用户Person_Info对象
* Depart_id 所属部门Id
* Role_IDs 分配的所有角色Id集合
* Speciaty_IDs 所属专业Id集合
* Menu_IDs 分配系统菜单Id集合
*返回值：bool
* */
public bool Add_Person(Person_Info p, int Depart_id, List <int> Role_IDs, List <int> EquipArchi_IDs, List <int> Speciaty_IDs, List <int> Menu_IDs)
{
try
{
int NewpP_id = Persons.AddPerson_info(p);
Persons.Person_LinkDepart(NewpP_id, Depart_id);
Persons.Person_LinkSpeciaties(NewpP_id, Speciaty_IDs);
Persons.Person_LinkEAs(NewpP_id, EquipArchi_IDs);
List <int> Zz_IDs = Get_EquipArchi_Allleafs(EquipArchi_IDs);
Persons.Person_LinkEquip(NewpP_id, Zz_IDs, Speciaty_IDs);
Persons.Person_LinkRole(NewpP_id, Role_IDs);
Persons.Person_LinkMenus(NewpP_id, Menu_IDs);
return(true);
}
catch { return(false); }
}
/*功能：修改用户的基本信息，并设置用户新的部门、角色、专业和系统菜单信息
* 参数： p 提交的用户基本新信息Person_Info对象
* Depart_id 新的所属部门Id
* Role_IDs 新分配的所有角色Id集合
* Speciaty_IDs 新的所属专业Id集合
* Menu_IDs 新分配的系统菜单Id集合
*返回值：bool
* */
public bool Update_Person(Person_Info p, int Depart_id, List <int> Role_IDs, List <int> EquipArchi_IDs, List <int> Speciaty_IDs, List <int> Menu_IDs)
{
try
{
Persons.ModifyPerson_info(p);
Persons.Person_LinkDepart(p.Person_Id, Depart_id);
Persons.Person_LinkSpeciaties(p.Person_Id, Speciaty_IDs);
Persons.Person_LinkEAs(p.Person_Id, EquipArchi_IDs);
List <int> Zz_IDs = Get_EquipArchi_Allleafs(EquipArchi_IDs);
Persons.Person_LinkEquip(p.Person_Id, Zz_IDs, Speciaty_IDs);
Persons.Person_LinkRole(p.Person_Id, Role_IDs);
Persons.Person_LinkMenus(p.Person_Id, Menu_IDs);
return(true);
}
catch { return(false); }
}
public bool AttachtoMenu(int personid, int menuid)
{
try
{
using (var db = base.NewDB())
{
Person_Info person = db.Persons.Where(s => s.Person_Id == personid).First();
Menu menu = db.Sys_Menus.Where(s => s.Menu_Id == menuid).First();
person.Person_Menus.Add(menu);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public string ModifyPWD(string userName, string userPwd, string newUserPWd)
{
int a;
PersonManagment pm = new PersonManagment();
MD5 md5 = new MD5CryptoServiceProvider();
byte[] result = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(userPwd.Trim()));
//pm.ModifyPerson_Pwd(userName, result);
Person_Info p = pm.Get_Person(userName);
if (p == null)
{
return("ModifyPWD_Index");
}
else
{
byte[] r = p.Person_Pwd;
string userPwdMD5 = System.Text.UTF8Encoding.Unicode.GetString(result);
string userPwDb = System.Text.UTF8Encoding.Unicode.GetString(r);
if (!userPwDb.Equals(userPwdMD5))
{
return("ModifyPWD_Index");
}
// string =System.Text.Encoding.Default.GetString(result);
else
{
result = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(newUserPWd.Trim()));
if (pm.ModifyPerson_Pwd(userName, result))
{
return("/Main/Home");
}
else
{
return("ModifyPWD_Index");
}
}
}
}
public bool ModifyPerson_info(Person_Info New_Person)
{
using (var db = base.NewDB())
{
try
{
var P = db.Persons.Where(a => a.Person_Id == New_Person.Person_Id).First();
if (P == null)
{
return(false);
}
else
{
P.Person_Name = New_Person.Person_Name;
// P.Person_Pwd = New_Person.Person_Pwd;
P.Person_tel = New_Person.Person_tel;
P.Person_mail = New_Person.Person_mail;
db.SaveChanges();
return(true);
}
}
catch { return(false); }
}
}
public string submitNewUser(string json1)
{
try
{
SpeciatyManagment SM = new SpeciatyManagment();
PersonManagment PM = new PersonManagment();
Person_Info newP = new Person_Info();
JObject item = (JObject)JsonConvert.DeserializeObject(json1);
newP.Person_Name = item["UserName"].ToString();
/*0710添加*/
var pwd = item["UserPwd"].ToString();
MD5 md5 = new MD5CryptoServiceProvider();
byte[] result = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(pwd.Trim()));
newP.Person_Pwd = result;
/*0710end*/
newP.Person_tel = item["UserTel"].ToString();
newP.Person_mail = item["UserMail"].ToString();
var equipArchiStr = item["UserEquipArchiSel"].ToString();
var roleStr = item["UserRole"].ToString();
var speciatyStr = item["UserSpeciatySel"].ToString();
var MenuStr = item["UserMenus"].ToString();
int Depart_id = Convert.ToInt32(item["UserDepartId"].ToString());
List <int> EquipArchiList = new List <int>();
if (equipArchiStr != "")
{
string[] s = equipArchiStr.Split(new char[] { ',' });
for (int i = 0; i < s.Length; i++)
{
EquipArchiList.Add(Convert.ToInt32(s[i]));
}
}
/* List<int> SpeciatyList = new List<int>();
* if (speciatyStr != "")
* {
* string[] s = speciatyStr.Split(new char[] { ',' });
* for (int i = 0; i < s.Length; i++)
* { SpeciatyList.Add(Convert.ToInt32(s[i])); }
* }*/
List <int> SpeciatyList = new List <int>();
if (speciatyStr != "")
{
string[] s = speciatyStr.Split(new char[] { ',' });
for (int i = 0; i < s.Length; i++)
{
int id = Convert.ToInt16(s[i]);
List <Speciaty_Info> r = SM.GetChildsspecialty(id);
if (r == null)
{
if (SpeciatyList.Where(x => x == id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(s[i]));
}
}
else
{
if (SpeciatyList.Where(x => x == id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(s[i]));
}
foreach (var t in r)
{
if (SpeciatyList.Where(x => x == t.Specialty_Id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(t.Specialty_Id));
}
}
}
}
}
List <int> MenuList = new List <int>();
if (MenuStr != "")
{
string[] s1 = MenuStr.Split(new char[] { ',' });
for (int i = 0; i < s1.Length; i++)
{
MenuList.Add(Convert.ToInt32(s1[i]));
}
}
List <int> RoleList = new List <int>();
if (roleStr != "")
{
string[] s2 = roleStr.Split(new char[] { ',' });
for (int i = 0; i < s2.Length; i++)
{
RoleList.Add(Convert.ToInt32(s2[i]));
}
}
PM.Add_Person(newP, Depart_id, RoleList, EquipArchiList, SpeciatyList, MenuList); //保存基础信息
return("保存成功！");
}
catch { return(""); };
}
public string submitUpdateUser(string json1)
{
try
{
SpeciatyManagment SM = new SpeciatyManagment();
PersonManagment PM = new PersonManagment();
Person_Info newP = new Person_Info();
JObject item = (JObject)JsonConvert.DeserializeObject(json1);
newP.Person_Id = Convert.ToInt32(item["UserId"].ToString());
newP.Person_Name = item["UserName"].ToString();
newP.Person_tel = item["UserTel"].ToString();
newP.Person_mail = item["UserMail"].ToString();
var roleStr = item["UserRole"].ToString();
var speciatyStr = item["UserSpeciatySel"].ToString();
var MenuStr = item["UserMenus"].ToString();
var equipArchiStr = item["UserEquipArchiSel"].ToString();
int Depart_id = Convert.ToInt32(item["UserDepartId"].ToString());
List <int> EquipArchiList = new List <int>();
if (equipArchiStr != "")
{
string[] s = equipArchiStr.Split(new char[] { ',' });
for (int i = 0; i < s.Length; i++)
{
EquipArchiList.Add(Convert.ToInt32(s[i]));
}
}
/* List<int> SpeciatyList = new List<int>();
* if (speciatyStr != "")
* {
* string[] s = speciatyStr.Split(new char[] { ',' });
* for (int i = 0; i < s.Length; i++)
* { SpeciatyList.Add(Convert.ToInt32(s[i])); }
* }*/
List <int> SpeciatyList = new List <int>();
if (speciatyStr != "")
{
string[] s = speciatyStr.Split(new char[] { ',' });
for (int i = 0; i < s.Length; i++)
{
int id = Convert.ToInt16(s[i]);
List <Speciaty_Info> r = SM.GetChildsspecialty(id);
if (r == null)
{
if (SpeciatyList.Where(x => x == id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(s[i]));
}
}
else
{
if (SpeciatyList.Where(x => x == id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(s[i]));
}
foreach (var t in r)
{
if (SpeciatyList.Where(x => x == t.Specialty_Id).Count() == 0)
{
SpeciatyList.Add(Convert.ToInt32(t.Specialty_Id));
}
}
}
}
}
List <int> MenuList = new List <int>();
if (MenuStr != "")
{
string[] s1 = MenuStr.Split(new char[] { ',' });
for (int i = 0; i < s1.Length; i++)
{
MenuList.Add(Convert.ToInt32(s1[i]));
}
}
List <int> RoleList = new List <int>();
if (roleStr != "")
{
string[] s2 = roleStr.Split(new char[] { ',' });
for (int i = 0; i < s2.Length; i++)
{
RoleList.Add(Convert.ToInt32(s2[i]));
}
}
PM.Update_Person(newP, Depart_id, RoleList, EquipArchiList, SpeciatyList, MenuList); //保存基础信息
return("用户信息修改成功！");
}
catch { return(""); };
}
