public List <CodeTableItemDto> GetGeneralTable(CodeTableDto model)
{
string strSql = String.Format("SELECT CONVERT(NVARCHAR(100),{0}) id,{1} text FROM {2} WHERE 1=1 {3} " + model.Order,
model.ValueField, model.TextField, model.TableName, string.IsNullOrEmpty(model.Where) ? "" : " and " + model.Where);
return(_codeTableRepository.SqlQuery <CodeTableItemDto>(strSql));
}
public string GetList(CommonComboModel model, FromWayEnum way = FromWayEnum.FromCodeTable)
{
var modelDto = new CodeTableDto()
{
TableName = model.refTable,
ValueField = model.valueField,
TextField = model.textField,
Where = model.whereStr,
UseCache = model.useCache
};
var itemList = new List <CodeTableItemDto>();
switch (way)
{
case FromWayEnum.FromCodeTable:
itemList = _codeTableService.GetCodeTable(modelDto);
break;
case FromWayEnum.FromGeneralTable:
itemList = _codeTableService.GetGeneralTable(modelDto);
break;
default:
itemList = null;
break;
}
if (itemList != null)
{
model.optionList = Mapper.Map <List <CodeTableItemDto>, List <CommonItemModel> >(itemList);
}
return(JSONHelper.ToJson(model.optionList));
}
/// 返回codeTable缓存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <CodeTableItemDto> GetCodeTable(CodeTableDto model)
{
var cacheKey = model.TableName;
var strSql = "DECLARE @SQL NVARCHAR(2000) SELECT @SQL = SelectSql FROM tbCOM_CodeTable WHERE Name = @p0; ";
if (!string.IsNullOrEmpty(model.Where))
{
strSql += string.Format(" SELECT @SQL=N'SELECT * FROM ('+@SQL+N') AS temp WHERE {0}' ", model.Where);
}
strSql += " EXEC(@SQL) ";
SqlParameter[] parameters = { new SqlParameter("@p0", model.TableName) };
Func <List <CodeTableItemDto> > loadFun = () =>
{
var data = DbHelperSql.Query(DbHelperSql.DefaultQueryConn, strSql, parameters);
return(data != null && data.Tables.Count > 0 ? Conversion.ConvertToList <CodeTableItemDto>(data.Tables[0]) : null);
};
if (model.UseCache && string.IsNullOrEmpty(model.Where))
{
ICacheManager cacheManager = IocObjectManager.GetInstance().Resolve <IHttpContextCacheManager>();
return(cacheManager.Get(cacheKey, 60, loadFun, () => { return _versionControlService.GetVersionFlag(cacheKey); }));
}
else
{
return(loadFun());
}
}
/// 返回codeTable缓存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <CodeTableItemDto> GetCodeTable(CodeTableDto model)
{
var cacheKey = "CodeTable_" + model.TableName;
var strSql = "";
List <SqlParameter> parameters = new List <SqlParameter>()
{
};
if (model.SqlParameters != null && model.SqlParameters.Count >= 0)
{
model.SqlParameters.ForEach(m => parameters.Add(m));
strSql = this.GetModel(m => m.TableName == model.TableName).SelectSql;
if (!string.IsNullOrEmpty(model.Where))
{
strSql = string.Format("SELECT * FROM ({0}) AS temp WHERE {1} {2}", strSql, model.Where, model.Order);
}
}
else
{
strSql = "DECLARE @SQL NVARCHAR(2000) SELECT @SQL = Select_Sql FROM tbCOM_Code_Table WHERE Table_Name = @p1989; ";
parameters.Add(new SqlParameter("@p1989", model.TableName));
if (!string.IsNullOrEmpty(model.Where))
{
strSql += string.Format(" SELECT @SQL=N'SELECT * FROM ('+@SQL+N') AS temp WHERE {0}' " + model.Order, model.Where);
}
strSql += " EXEC(@SQL) ";
}
Func <List <CodeTableItemDto> > loadFun = () =>
{
var data = DbHelperSql.Query(DbHelperSql.CouQuery, strSql, parameters.ToArray());
return(data != null && data.Tables.Count > 0 ? Conversion.ConvertToList <CodeTableItemDto>(data.Tables[0]) : null);
};
if (model.UseCache && string.IsNullOrEmpty(model.Where))
{
ICacheManager cacheManager = IocObjectManager.GetInstance().Resolve <IHttpContextCacheManager>();
return(cacheManager.Get(cacheKey, 60, loadFun, () => { return _versionControlService.GetVersionFlag(cacheKey); }));
}
else
{
return(loadFun());
}
}
public ActionResult FromDB(CommonComboModel model)
{
var modelDto = new CodeTableDto()
{
TableName = model.refTable,
ValueField = model.valueField,
TextField = model.textField,
Where = model.whereStr
};
var itemList = new List <CodeTableItemDto>();
itemList = _codeTableService.GetGeneralTable(modelDto);
if (itemList != null)
{
model.optionList = Mapper.Map <List <CodeTableItemDto>, List <CommonItemModel> >(itemList);
}
return(PartialView("CommonCombo", model));
}
public async Task <IViewComponentResult> InvokeAsync(CommonComboModel model, FromWayEnum way)
{
var modelDto = new CodeTableDto()
{
TableName = model.refTable,
ValueField = model.valueField,
TextField = model.textField,
Where = model.whereStr,
UseCache = model.useCache
};
var itemList = new List <CodeTableItemDto>();
switch (way)
{
case FromWayEnum.FromCodeTable:
itemList = _codeTableService.GetCodeTable(modelDto);
break;
case FromWayEnum.FromGeneralTable:
itemList = _codeTableService.GetGeneralTable(modelDto);
break;
default:
itemList = null;
break;
}
if (itemList != null)
{
model.optionList = Mapper.Map <List <CodeTableItemDto>, List <CommonItemModel> >(itemList);
}
var comboClass = "";
switch (model.comboType)
{
case ComboTypeEnum.EasyUI:
comboClass = "CommonCombo";
break;
case ComboTypeEnum.ACE:
comboClass = "CommonComboForAce";
break;
}
return(View("/Views/RdpTemplate/CommonCombo/" + comboClass + ".cshtml", model));
}
public ActionResult Create(CommonComboModel model, FromWayEnum way)
{
var modelDto = new CodeTableDto()
{
TableName = model.refTable,
ValueField = model.valueField,
TextField = model.textField,
Where = model.whereStr,
UseCache = model.useCache
};
var itemList = new List <CodeTableItemDto>();
switch (way)
{
case FromWayEnum.FromCodeTable:
itemList = _codeTableService.GetCodeTable(modelDto);
break;
case FromWayEnum.FromGeneralTable:
itemList = _codeTableService.GetGeneralTable(modelDto);
break;
default:
itemList = null;
break;
}
if (itemList != null)
{
model.optionList = Mapper.Map <List <CodeTableItemDto>, List <CommonItemModel> >(itemList);
}
var comboClass = "";
switch (model.comboType)
{
case ComboTypeEnum.EasyUI:
comboClass = "CommonCombo";
break;
case ComboTypeEnum.ACE:
comboClass = "CommonComboForAce";
break;
}
return(PartialView(comboClass, model));
}
public ActionResult FromCache(CommonComboModel model, string comboTypes = null)
{
var modelDto = new CodeTableDto()
{
TableName = model.refTable,
ValueField = model.valueField,
TextField = model.textField,
Where = model.whereStr,
UseCache = model.useCache
};
var itemList = new List <CodeTableItemDto>();
itemList = _codeTableService.GetCodeTable(modelDto);
if (itemList != null)
{
model.optionList = Mapper.Map <List <CodeTableItemDto>, List <CommonItemModel> >(itemList);
}
return(PartialView(string.IsNullOrEmpty(comboTypes) ? "CommonCombo" : comboTypes, model));
}
public IEnumerable <CodeTableDto> CodeTablesRead()
{
var result = new List <CodeTableDto>();
try
{
var dto = new CodeTableDto {
TableID = 1, TableName = "Adjustment Reason Codes"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 2, TableName = "Agreement Classifications"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 3, TableName = "Agreement Types"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 4, TableName = "BIA Classifications"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 5, TableName = "Company Payor Codes"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 6, TableName = "Lease Classifications"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 7, TableName = "ONRR Transaction Codes"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 8, TableName = "Payment Methods"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 9, TableName = "Payor Codes"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 10, TableName = "Product Code Cross Reference"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 11, TableName = "Sales Types"
};
result.Add(dto);
dto = new CodeTableDto {
TableID = 12, TableName = "States"
};
result.Add(dto);
return(result);
}
catch (Exception ex)
{
log.Error(ex.Message + Environment.NewLine + ex.StackTrace);
throw;
}
}
