public async Task <IActionResult> getThuebao(string key, [FromQuery] Models.Core.QueryString query)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
var tmp = key.Trim(',').Split(',');
key = "";
foreach (var item in tmp)
{
key += $"{item},";
}
var qry = $"select * from CONTRACT_CUSTOMER_TB where hdkh_id in({key.Trim(',')})";
var data = await db.Connection.QueryAsync <Models.Core.HD_THUEBAO>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
public async Task <IActionResult> GetByKey(string key, [FromQuery] Models.Core.QueryString query)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var tmp = key.Trim(',').Split(',');
key = "";
foreach (var item in tmp)
{
key += $"'{item}',";
}
var qry = $"select * from Permissions where app_key in({key.Trim(',')}) and flag={query.flag}";
var data = await db.Connection.QueryAsync <Models.Core.Permissions>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> GetByModule(string key, [FromQuery] Models.Core.QueryString query)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var tmp = key.Trim(',').Split(',');
key = "";
foreach (var item in tmp)
{
key += $"'{item}',";
}
var qry = $"select * from Dictionary where lower(module_code) in({key.Trim(',').ToLower()})";
var data = await db.Connection.QueryAsync <Models.Core.Dictionary>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
