public IList <SysUser> GetSysUsers(SysUser SysUser)
{
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysUser.GetSysUsers", SysUser);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysUser>("SysConfig.SysUser.GetSysUsers", SysUser);
logger.Debug("GetSysUsers:" + (reValue == null ? 0 : reValue.Count));
return(reValue);
}
public IList <ScOperation> GetReturnRoom()
{
Hashtable hashTable = new Hashtable();
//hashTable.Add("ID", ID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "Operation.ScOperation.GetReturnRoom", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <ScOperation>("Operation.ScOperation.GetReturnRoom", hashTable);
logger.Debug("ScOperation:" + (reValue == null ? 0 : reValue.Count));
return(reValue);
}
public IList <SysMenu> GetMenusByRoleID(int RoleID)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("RoleID", RoleID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysMenu.GetMenusByRoleID", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysMenu>("SysConfig.SysMenu.GetMenusByRoleID", hashTable);
return(reValue);
}
public SysMenu QueryOne(int ID)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("ID", ID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysMenu.QueryOne", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysMenu>("SysConfig.SysMenu.QueryOne", hashTable);
return((SysMenu)reValue.FirstOrDefault());
}
public List <SysParameter> GetChildNodesByCode(string Code)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("Code", Code);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysParameter.GetChildNodesByCode", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysParameter>("SysConfig.SysParameter.GetChildNodesByCode", hashTable);
return(reValue.ToList());
}
public SysParameter QueryOneByCode(string code)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("code", code);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysParameter.QueryOneByCode", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysParameter>("SysConfig.SysParameter.QueryOneByCode", hashTable);
return((SysParameter)reValue.FirstOrDefault());
}
public List <SysRole> GetChildNodes(int ParentID)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("ParentID", ParentID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysRole.GetChildNodes", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysRole>("SysConfig.SysRole.GetChildNodes", hashTable);
return(reValue.ToList());
}
public IList <OperationName> GetOperationNames(OperationName operationName)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("operationName", operationName);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "Operation.OperationName.GetOperationNames", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <OperationName>("Operation.OperationName.GetOperationNames", hashTable);
return(reValue);
}
public IList <ScOperation> QueryForEvaluation(string PATIENT_ID, int VISIT_ID)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("PATIENT_ID", PATIENT_ID);
hashTable.Add("VISIT_ID", VISIT_ID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "Operation.ScOperation.QueryForEvaluation", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <ScOperation>("Operation.ScOperation.QueryForEvaluation", hashTable);
return(reValue);
}
public IList <OperationMaster> GetSuspectedReturns(string PATIENT_ID, string VISIT_ID)
{
Hashtable hashTable = new Hashtable();
hashTable.Add("PATIENT_ID", PATIENT_ID);
hashTable.Add("VISIT_ID", VISIT_ID);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "Operation.OperationMaster.GetSuspectedReturns", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <OperationMaster>("Operation.OperationMaster.GetSuspectedReturns", hashTable);
logger.Debug("OperationMaster:" + (reValue == null ? 0 : reValue.Count));
return(reValue);
}
public int GetTotalCount(SysRole SysRole)
{
int totalCount = 0;
Hashtable hashTable = new Hashtable();
hashTable.Add("sysRole", SysRole);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysRole.GetTotalCount", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForObject("SysConfig.SysRole.GetTotalCount", hashTable);
totalCount = int.Parse(reValue.ToString());
return(totalCount);
}
public bool Update(SysMenu SysMenu)
{
try
{
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysMenu.Update", SysMenu);
base.GetSqlMapper(databaseName).Update("SysConfig.SysMenu.Update", SysMenu);
return(true);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(false);
}
}
public bool Update(SysParameter SysParameter)
{
try
{
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysParameter.Update", SysParameter);
base.GetSqlMapper(databaseName).Update("SysConfig.SysParameter.Update", SysParameter);
return(true);
}
catch (Exception ex)
{
GlobalMethod.log.Error(ex);
return(false);
}
}
public IList <SysRole> LoadPageList(int pageIndex, int pageSize, SysRole SysRole)
{
Hashtable hashTable = new Hashtable();
int start = (pageIndex - 1) * pageSize + 1;
int end = pageIndex * pageSize;
hashTable.Add("start", start);
hashTable.Add("end", end);
hashTable.Add("sysRole", SysRole);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysRole.LoadPageList", hashTable);
var reValue = base.GetSqlMapper(databaseName).QueryForList <SysRole>("SysConfig.SysRole.LoadPageList", hashTable);
logger.Debug("LoadPageList:" + (reValue == null ? 0 : reValue.Count));
return(reValue);
}
public bool ResetPassword(SysRole SysRole)
{
try
{
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysRole.ResetPassword", SysRole);
base.GetSqlMapper(databaseName).Update("SysConfig.SysRole.ResetPassword", SysRole);
return(true);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(false);
}
}
public bool Delete(int id)
{
try
{
Hashtable hashTable = new Hashtable();
hashTable.Add("ID", id);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysMenu.Delete", hashTable);
base.GetSqlMapper(databaseName).Update("SysConfig.SysMenu.Delete", hashTable);
return(true);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(false);
}
}
public bool ModifyValue(string code, string value)
{
try
{
Hashtable hashTable = new Hashtable();
hashTable.Add("code", code);
hashTable.Add("value", value);
string sql = IBatisHelper.GetRuntimeSql(base.GetSqlMapper(databaseName), "SysConfig.SysParameter.ModifyValue", hashTable);
base.GetSqlMapper(databaseName).Update("SysConfig.SysParameter.ModifyValue", hashTable);
return(true);
}
catch (Exception ex)
{
GlobalMethod.log.Error(ex);
return(false);
}
}
