public string GetLoginPerson(string loginName, string password) { string strReturn = string.Empty; HdisModels.Person.PersonModel personModel = this.GetPersonByLoginName(loginName); if (personModel == null) { return("用户名错误"); } else { if (personModel.ISSOURCEHIS == "0") { if (personModel.LOGINPASS == HdisCommon.Ciphertext.Encrypt(password.Trim())) { return(HdisCommon.Fuction.PersonInfoForXml(personModel)); } else { return("密码错误"); } } else { } } return(strReturn); }
/// <summary> /// 登录人员 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string PersonInfoForXml(HdisModels.Person.PersonModel model) { string strReturn = string.Empty; using (System.IO.StringWriter stringWriter = new StringWriter(new StringBuilder())) { XmlSerializer xmlSerializer = new XmlSerializer(typeof(HdisModels.Person.PersonModel)); xmlSerializer.Serialize(stringWriter, model); strReturn = stringWriter.ToString(); } return(strReturn); }
/// <summary> /// 通过登录账号查人员信息 /// </summary> public List <HdisModels.Person.PersonModel> QueryNurseList() { List <HdisModels.Person.PersonModel> list = new List <HdisModels.Person.PersonModel>(); HdisModels.Person.PersonModel model = null; string strSQL = @"select a.* from HDIS_ROL_PERSON a where a.roleid='03' or a.roleid='04'"; strSQL = string.Format(strSQL); try { if (this.ExecSQLQuery(strSQL) == -1) { return(null); } while (this.Reader.Read()) { model = new HdisModels.Person.PersonModel(); model.PERSONID = Reader["PERSONID"].ToString(); model.PERSONNAME = Reader["PERSONNAME"].ToString(); model.LOGINNAME = Reader["LOGINNAME"].ToString(); model.HOSPITALID = Reader["HOSPITALID"].ToString(); model.HOSPITALNAME = Reader["HOSPITALNAME"].ToString(); model.DEPTID = Reader["DEPTID"].ToString(); model.DEPTNAME = Reader["DEPTNAME"].ToString(); model.ROLEID = Reader["ROLEID"].ToString(); model.ROLENAME = Reader["ROLENAME"].ToString(); model.ISSOURCEHIS = Reader["ISSOURCEHIS"].ToString(); model.LOGINPASS = Reader["LOGINPASS"].ToString(); list.Add(model); } return(list); } catch (Exception ex) { return(null); } finally { this.oracleDb.CloseReader(); this.oracleDb.CloseDB(); } }
/// <summary> /// 通过登录账号查人员信息 /// </summary> private HdisModels.Person.PersonModel GetPersonByLoginName(string LoginName) { HdisModels.Person.PersonModel model = null; string strSQL = @"select a.* from HDIS_ROL_PERSON a where a.loginname='{0}' and a.isenabled='1' "; strSQL = string.Format(strSQL, LoginName); try { if (this.ExecSQLQuery(strSQL) == -1) { return(null); } if (this.Reader.Read()) { model = new HdisModels.Person.PersonModel(); model.PERSONID = Reader["PERSONID"].ToString(); model.PERSONNAME = Reader["PERSONNAME"].ToString(); model.LOGINNAME = Reader["LOGINNAME"].ToString(); model.HOSPITALID = Reader["HOSPITALID"].ToString(); model.HOSPITALNAME = Reader["HOSPITALNAME"].ToString(); model.DEPTID = Reader["DEPTID"].ToString(); model.DEPTNAME = Reader["DEPTNAME"].ToString(); model.ROLEID = Reader["ROLEID"].ToString(); model.ROLENAME = Reader["ROLENAME"].ToString(); model.ISSOURCEHIS = Reader["ISSOURCEHIS"].ToString(); model.LOGINPASS = Reader["LOGINPASS"].ToString(); } return(model); } catch (Exception ex) { return(null); } finally { this.oracleDb.CloseReader(); this.oracleDb.CloseDB(); } }