public async Task <string> LoadQueryModule([FromBody] ParramModuleQuery query)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
var ds = m_Client.LoadProcedure(query.Store, query.Parram);
if (ds != null)
{
//Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
//json.Converters.Add(new DataSetConverter());
//(((DataSet)ds).Tables[0])
outPut.Data = JsonConvert.SerializeObject(((DataSet)ds).Tables[0], Formatting.Indented, new JsonSerializerSettings {
Converters = new[] { new DataSetConverter() }
});
//string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented, new JsonSerializerSettings { Converters = new[] { new Newtonsoft.Json.Converters.DataSetConverter() } });
outPut.ResultCode = 1;
outPut.Message = "";
return(JsonConvert.SerializeObject(outPut));
}
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(JsonConvert.SerializeObject(outPut));
}
return(null);
}
public async Task <string> ExcuteStore2DataTable(ParramModuleQuery query)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
PostgresqlHelper postgresqlHelper = new PostgresqlHelper();
var param = m_Client.DiscoveryParameters(query.Store);
// var checkParram = param.Where(x => x.SqlDbType != SqlDbType.);
if (param != null && param.Any())
{
if (query.Parram.Length > 0)
{
param.First().Value = query.Parram.First();
}
}
var tb = (DataTable)m_Client.RunStoreToDataTable(query.Store, param); //m_Client.ExecuteStoreProcedurePostgreSQL(query.Store, query.Parram.Length>0? query.Parram.First().ToString():"");
if (tb != null)
{
outPut.Data = JsonConvert.SerializeObject(tb);
outPut.ResultCode = 1;
outPut.Message = "";
return(JsonConvert.SerializeObject(outPut));
}
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(JsonConvert.SerializeObject(outPut));
}
return(JsonConvert.SerializeObject(outPut));
}
public async Task <DataTable> LoadQueryModuleDataTable(ParramModuleQuery parram)
{
try
{
var url = "Module/LoadQueryModule";
var data = await PostApi(url, parram);
var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(data);
DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
return(dt);
}
catch (Exception ex)
{
//Common.ErrorLog.WriteLog("LoadQueryModule", ex.ToString());
return(null);
}
}
public async Task <List <TreeviewInfo> > GetDataTreeviewInfo(ParramModuleQuery query)
{
try
{
var url = string.Format("Module/GetDataTreeviewInfo");
var data = await PostApi(url, query);
return(JsonConvert.DeserializeObject <RestOutput <List <TreeviewInfo> > >(data).Data);
////var dataQuery = JsonConvert.DeserializeObject<RestOutput<string>>(data);
//if (!string.IsNullOrEmpty(dataQuery.Data))
//{
// return JsonConvert.DeserializeObject<RestOutput<List<TreeviewInfo>>>(dataQuery.Data).Data;
//}
}
catch (Exception ex)
{
}
return(null);
}
protected override async Task OnInitializedAsync()
{
if (!string.IsNullOrEmpty(ModId))
{
ModuleInfo = await moduleService.GetModule(ModId);
HomeBus homeBus = new HomeBus(moduleService, iConfiguration, distributedCache);
var tree = await homeBus.GetModTreeviewById(ModId);
if (tree != null)
{
var query = new ParramModuleQuery {
Store = tree.ExecuteTreestore
};
TreeView = await moduleService.GetDataTreeviewInfo(query);
//RawTreeView = CreateTreeView();
}
}
}
public async Task <List <dynamic> > ExcuteStore2DataTable(ParramModuleQuery query)
{
try
{
var url = string.Format("Module/ExcuteStore2DataTable");
var data = await PostApi(url, query);
var dataQuery = JsonConvert.DeserializeObject <RestOutput <string> >(data);
if (!string.IsNullOrEmpty(dataQuery.Data))
{
return(JsonConvert.DeserializeObject <List <dynamic> >(dataQuery.Data));
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
//Dongpv:20/07/20
//public async Task<DataTable> Store2DataTable(ParramModuleQuery query)
//{
// try
// {
// var url = string.Format("Module/ExcuteStore2DataTable");
// var data = await PostApi(url, query);
// var dataQuery = JsonConvert.DeserializeObject<RestOutput<string>>(data);
// if (!string.IsNullOrEmpty(dataQuery.Data))
// {
// return JsonConvert.DeserializeObject<DataTable>(dataQuery.Data);
// }
// return null;
// }
// catch (Exception ex)
// {
// return null;
// }
//}
public async Task <DataTable> Store2DataTable(ParramModuleQuery query)
{
try
{
//Dongpv:20/07/20
//var url = string.Format("Module/ExcuteStore2DataTable");
//var data = await PostApi(url, query);
//var dataQuery = JsonConvert.DeserializeObject<RestOutput<string>>(data);
//if (!string.IsNullOrEmpty(dataQuery.Data))
//{
// return JsonConvert.DeserializeObject<DataTable>(dataQuery.Data);
//}
var data = await PostApi(query);
return(data);
}
catch (Exception ex)
{
return(null);
}
}
//Dongpv:20/07/2020
public async Task <DataTable> PostApi(object obj)
{
try
{
ParramModuleQuery query = (ParramModuleQuery)obj;
Message msg = new Message();
msg.ObjectName = Constants.OBJ_SEARCH;
msg.MsgType = Constants.MSG_MISC_TYPE;
msg.MsgAction = Constants.MSG_SEARCH;
msg.Body.Add("SearchObject");
msg.Body.Add(query.Store);
msg.Body.Add("Condition");
msg.Body.Add(" WHERE 1=0");
msg.Body.Add("Page");
msg.Body.Add(0);
var json = JsonConvert.SerializeObject(msg);
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
return(tb);
}
catch (Exception ex)
{
ErrorHandler.Process(ex);
}
return(null);
}
public async Task <string> PostApi(string url, object obj)
{
try
{
//Dongpv:20/07/2020
if (url == "Module/ExcuteStore2DataTable")
{
ParramModuleQuery query = (ParramModuleQuery)obj;
Message msg = new Message();
msg.ObjectName = Constants.OBJ_SEARCH;
msg.MsgType = Constants.MSG_MISC_TYPE;
msg.MsgAction = Constants.MSG_SEARCH;
msg.Body.Add("SearchObject");
msg.Body.Add(query.Store);
msg.Body.Add("Condition");
msg.Body.Add(" WHERE 1=0");
msg.Body.Add("Page");
msg.Body.Add(0);
var json = JsonConvert.SerializeObject(msg);
var result = await SendMessage(json);
return(result);
}
else
{
var uri = _remoteServiceBaseUrl + url;
ErrorHandler.WirteTrace(uri);
using (var client = new HttpClient())
{
var textBytes = Encoding.UTF8.GetBytes(_Configuration["ConfigApp:UserNameApi"] + ":" + _Configuration["ConfigApp:PasswordApi"] + ":" + "" /* _session.GetString("UserName")*/);
_authToken = Convert.ToBase64String(textBytes);
//Dongpv
//var requestMessage = new HttpRequestMessage(HttpMethod.Post, uri);
var requestMessage = new HttpRequestMessage(System.Net.Http.HttpMethod.Post, uri);
JsonSerializerSettings jsonSerializerSettings = new JsonSerializerSettings();
//jsonSerializerSettings.NullValueHandling= NullValueHandling.Ignore;
requestMessage.Content = new StringContent(JsonConvert.SerializeObject(obj, jsonSerializerSettings), System.Text.Encoding.UTF8, "application/json");
requestMessage.Headers.Authorization = new AuthenticationHeaderValue("Basic", _authToken);
try
{
var data = await client.SendAsync(requestMessage);
var dataString = await data.Content.ReadAsStringAsync();
return(dataString);
}
catch (Exception ex)
{
ErrorHandler.Process(ex);
}
}
}
//Dongpv:20/07/2020
}
catch (Exception ex)
{
ErrorHandler.Process(ex);
}
return(null);
}
