/// <summary>
/// 医生登录,陈洁修改
/// </summary>
/// <param name="account_name">登录账户-手机号</param>
/// <param name="password">登录密码</param>
/// <returns></returns>
public JsonMsg <LoginInfoModel> DoctorLogin(string account_name, string password)
{
string passwordMD5 = QWPlatform.SystemLibrary.Utils.Strings.StrToMD5(password);
var result = JsonMsg <LoginInfoModel> .OK(null, "人员登录成功!");
LoginInfoModel loginInfo = null;
try
{
using (var db = new DbContext())
{
//定义sql执行对象
var sqlBuilder = db.Sql("");
//SQL动态参数
List <string> list = new List <string>();
//如果包括account_name参数则使用account_name
sqlBuilder.Parameters("account", account_name);
list.Add("account");
sqlBuilder.Parameters("password", passwordMD5);
list.Add("password");
//获取执行的sql
string sql = db.GetSql("AB00001-平台身份认证", null, list.ToArray());
//执行数据查询
var items = sqlBuilder.SqlText(sql).GetModelList <LoginInfoModel>();
if (items == null || !items.Any())
{
result.msg = "账户或密码不正确！";
result.code = ResponseCode.Error;
return(result);
}
loginInfo = items.FirstOrDefault(x => x.account_status == 1);
if (loginInfo == null)
{
result.msg = "账户已被停用,请与管理员联系！";
result.code = ResponseCode.Error;
return(result);
}
loginInfo = items.FirstOrDefault(x => x.account_status == 1 && x.status == 1);
if (loginInfo == null)
{
result.msg = "该账户已被停用,请与管理员联系！";
result.code = ResponseCode.Error;
return(result);
}
result.data = loginInfo;
}
}
catch (Exception ex)
{
result.msg = "查询人员登录信息发生异常！";
result.code = ResponseCode.Error;
Logger.Instance.Error(result.msg, ex);
}
return(result);
}
/// <summary>
/// 查询数据字典信息
/// </summary>
/// <returns></returns>
public JsonMsg <List <DicInfo> > GetDicItems(DicParam entity)
{
//提示信息
var result = JsonMsg <List <DicInfo> > .OK(null, "查询成功");
//个人id必传
if (entity.type <= 0)
{
result.code = ResponseCode.Error;
result.msg = "请选择需要查询的字典信息!";
return(result);
}
var param = new List <string>();
try
{
using (var db = new DbContext())
{
var sqlBuilder = db.Sql("");
DicType dictype = (DicType)entity.type;
//字典表名
string tablename = dictype.ToString();
//获取字典信息
var sqlStr = $"SELECT '{tablename}' as 表名,编码, 简码, 名称 FROM { tablename}";
//执行SQL脚本
var items = sqlBuilder.SqlText(sqlStr)
.GetModelList <DicInfo>();
result.data = items;
}
}
catch (Exception ex)
{
result.code = ResponseCode.Error;
result.msg = "查询数据字典信息发生异常!";
Logger.Instance.Error(result.msg, ex);
}
return(result);
}