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