public IEnumerable <string> Get()
{
PostgresqlHelper postgresqlHelper = new PostgresqlHelper("User ID=core;Password=core;Host=10.36.36.12;Port=5432;Database=core;");
//postgresqlHelper.ExecuteStore();
return(new string[] { "value1", "value2" });
}
private string BuildSearchExtension(SearchModuleInfo searchInfo, SearchConditionInstance conditionIntance)
{
var fields = FieldUtils.GetModuleFields(searchInfo.ModuleID);
using (var conn = new NpgsqlConnection(ConnectionString))
{
using (var comm = new NpgsqlCommand(searchInfo.WhereExtension, conn))
{
conn.Open();
comm.CommandType = CommandType.StoredProcedure;
PostgresqlHelper.DiscoveryParameters(comm);
foreach (var field in
fields.Where(field => field.WhereExtension == WebCore.CODES.DEFMODFLD.WHEREEXTENSION.YES))
{
comm.Parameters[field.FieldName].Value = DBNull.Value;
foreach (var condition in conditionIntance.SubCondition)
{
if (condition.ConditionID == field.FieldID && string.IsNullOrEmpty(condition.SQLLogic))
{
comm.Parameters[field.FieldName].Value = condition.Operator;
}
}
}
comm.ExecuteNonQuery();
return(comm.Parameters["RETURN_VALUE"].Value.ToString());
}
}
}
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 void BuildStaticConditions(SearchModuleInfo searchInfo, NpgsqlCommand comm, List <SearchConditionInstance> staticConditionInstances)
{
var fields = FieldUtils.GetModuleFields(searchInfo.ModuleID, WebCore.CODES.DEFMODFLD.FLDGROUP.PARAMETER);
if (fields == null || fields.Count == 0)
{
fields = PostgresqlHelper.ExecuteStoreProcedurePostgreSQL <ModuleFieldInfo>(ConnectionString, SYSTEM_STORE_PROCEDURES.LIST_FIELD_INFO_BY_MODID, searchInfo.ModuleID);
if (AllCaches.ModuleFieldsInfo == null)
{
AllCaches.ModuleFieldsInfo = new List <ModuleFieldInfo>();
}
AllCaches.ModuleFieldsInfo.AddRange(fields);
}
foreach (var field in fields)
{
switch (field.FieldName)
{
case CONSTANTS.ORACLE_SESSION_USER:
//comm.Parameters.Add(":" + field.ParameterName, Session.Username);
break;
case CONSTANTS.ORACLE_CURSOR_OUTPUT:
//comm.Parameters.Add(new OracleParameter(":" + field.ParameterName, OracleDbType.RefCursor))
// .Direction = ParameterDirection.Output;
break;
}
}
var parameter = new NpgsqlParameter();
fields = FieldUtils.GetModuleFields(searchInfo.ModuleID, WebCore.CODES.DEFMODFLD.FLDGROUP.SEARCH_CONDITION);
foreach (var condition in staticConditionInstances)
{
foreach (var field in fields)
{
if (field.FieldID == condition.ConditionID)
{
if (string.IsNullOrEmpty(condition.Value))
{
parameter.ParameterName = field.ParameterName;
parameter.NpgsqlDbType = NpgsqlDbType.Text;
parameter.Value = DBNull.Value;
comm.Parameters.Add(parameter);
//comm.Parameters.Add(":" + field.ParameterName, DBNull.Value);
}
else
{
parameter.ParameterName = ":" + field.ParameterName;
parameter.NpgsqlDbType = NpgsqlDbType.Text;
parameter.Value = condition.Value.Decode(field);
comm.Parameters.Add(parameter);
//comm.Parameters.Add(":" + field.ParameterName, condition.Value.Decode(field));
}
}
}
}
}
