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