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 <ActionResult> LoadMainTainModule(string modId, string subModId, string parram, [FromBody] List <ModuleFieldInfo> fieldsInfos) { var outPut = new RestOutput <object>(); try { var m_Client = new CoreController(_configuration); var data = m_Client.LoadMainTainModule(modId); MaintainModuleInfo modMaintain = null; var store = ""; if (data.Any()) { modMaintain = data.First(); store = CommonFunction.GetStoreRunModMaintain(modMaintain, subModId ?? ESubMod.MVW.ToString()); } var fields = CommonFunction.GetModuleFields(fieldsInfos, modId, FLDGROUP.PARAMETER); var cm = new WebApiCore.CommonFunction(); var lst = new List <string>(); if (!string.IsNullOrEmpty(store)) { var param = m_Client.DiscoveryParameters(store.IndexOf(".") > 0 ? store : store); cm.GetNpgsqlParameterValues(param, fields); var dataStore = m_Client.RunStoreToDataTable(store, param); outPut.Data = JsonConvert.SerializeObject(dataStore); return(Ok(outPut)); } return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } }
public async Task <ActionResult> DeleteModule(string store, [FromBody] List <ModuleFieldInfo> fieldsInfos) { var outPut = new RestOutput <string>(); try { var m_Client = new CoreController(_configuration); var cm = new WebApiCore.CommonFunction(); //var lst = new List<string>(); //var param = m_Client.DiscoveryParameters(store); ////cm.GetSQLServerParameterValues(out lst, store, param, fieldsInfos); //cm.GetNpgsqlParameterValues(param, fieldsInfos); //var userName = GetUserName(); //var dataStore = m_Client.RunStore(store, lst, userName); var param = m_Client.DiscoveryParameters(store.IndexOf(".") > 0 ? store : _Schema + "." + store); cm.GetNpgsqlParameterValues(param, fieldsInfos); var userName = GetUserName(); var dataStore = m_Client.RunFunction(store, param); outPut.Data = dataStore; outPut.ResultCode = 1; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); } return(Ok(outPut)); }
public async Task <string> SearchModSearch([FromBody] SearchModSearch searchModSearch) { var outPut = new RestOutput <string>(); try { var m_Client = new CoreController(_configuration); var whereExtension = string.Empty; var query = BuildQuerySearch.BuildSearchCondition(searchModSearch.ModInfo, ref whereExtension, null, searchModSearch.StaticConditionInstances.First()); //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)); }
//Dongpv:15/06/2020 //public async Task<List<dynamic>> getQuery(ParramModuleQuery parram) public async Task <List <dynamic> > getQuery(Message msg) //ParramModuleQuery parram ModalParameters { try { //var json = JsonConvert.SerializeObject(obj); //var json = JsonConvert.DeserializeObject<string>(apiResponse); //ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId); //1. Convert obj to arraylist //foreach (ParramModuleQuery moduleFieldInfo in parram) //{ // if (moduleFieldInfo.Value != null) // { // Body.Add(moduleFieldInfo.FieldName); Body.Add(moduleFieldInfo.Value); // enity = moduleFieldInfo.Entity; // } //} var json = JsonConvert.SerializeObject(msg); //2. CALL HOST var result = await SendMessage(json); DataTable tb = new DataTable(); if (!string.IsNullOrEmpty(result) && result != "null") { tb = SysUtils.Json2Table(result); } //DataTable tb = SysUtils.Json2Table(data); //var moduleds = JsonConvert.DeserializeObject<string> (data); //var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data); //DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); //var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds.Data); //var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds); // return moduledData; //DataTable dt = (DataTable)JsonConvert.DeserializeObject(data, (typeof(DataTable))); var outPut = new RestOutput <string>(); outPut.Data = JsonConvert.SerializeObject(tb, 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); var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut)); DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data); return(moduledData); //return data; } catch (Exception ex) { throw ex; } }
public async Task <RestOutput <string> > UpdateData(string modId, string enity, string keyEdit, List <ModuleFieldInfo> fieldEdits) { try { //var json = JsonConvert.SerializeObject(obj); //var json = JsonConvert.DeserializeObject<string>(apiResponse); //ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId); //1. Convert obj to arraylist //ArrayList Body = new ArrayList(); //foreach (ModuleFieldInfo moduleFieldInfo in fieldEdits) //{ // Body.Add(moduleFieldInfo.FieldName); Body.Add(moduleFieldInfo.Value); //} var order = new { UserID = "0000", IP = "00000", BranchID = "000", ModuleID = modId, ObjectName = enity, MsgType = Constants.MSG_MNT_TYPE, MsgAction = Constants.MSG_UPDATE_ACTION, Body = fieldEdits }; var json = JsonConvert.SerializeObject(order); var result = await SendMessage(json); DataTable tb = new DataTable(); if (!string.IsNullOrEmpty(result) && result != "null") { tb = SysUtils.Json2Table(result); } //var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data); var outPut = new RestOutput <string>(); outPut.Data = JsonConvert.SerializeObject(tb, Formatting.Indented, new JsonSerializerSettings { Converters = new[] { new DataSetConverter() } }); outPut.ResultCode = 1; outPut.Message = ""; var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut)); DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data); return(moduleds); } catch (Exception ex) { throw ex; } }
public async Task Save() { //HomeBus homeBus = new HomeBus(moduleService, iConfiguration, distributedCache); var excute = new RestOutput <string>(); string store = ""; string modId = ""; string keyEdit = ""; //Dongpv: excute = (await moduleService.UpdateData(modId, store, keyEdit, Conver2FieldInfos(ContractModel))); }
public async Task <ActionResult> Get(string moduleName) { var outPut = new RestOutput <ModuleInfoViewModel>(); var moduleInfo = new ModuleInfoViewModel(); try { var modulesInfo = new List <ModuleInfo>(); var fieldsInfo = new List <ModuleFieldInfo>(); var buttonsInfo = new List <ButtonInfo>(); var buttonParamsInfo = new List <ButtonParamInfo>(); var languageInfo = new List <LanguageInfo>(); var oracleParamsInfo = new List <OracleParam>(); var m_Client = new CoreController(_configuration); m_Client.ForceLoadModule(out modulesInfo, out fieldsInfo, out buttonsInfo, out buttonParamsInfo, out languageInfo, out oracleParamsInfo, moduleName); var fields = fieldsInfo.Where(x => String.IsNullOrEmpty(x.ParentId)).ToList(); var parentIds = fieldsInfo.Where(x => !String.IsNullOrEmpty(x.ParentId)).Select(x => x.ParentId).Distinct().ToList(); if (parentIds != null) { foreach (var parentId in parentIds) { var field = fields.Where(x => x.FieldID == parentId); if (field != null && field.Any()) { field.First().FieldChilds = fieldsInfo.Where(x => x.ParentId == parentId).ToList(); } } } //var dicFieldInfo = new Dictionary<ModuleFieldInfo, string>(); moduleInfo = new ModuleInfoViewModel { ButtonParamsInfo = buttonParamsInfo, ButtonsInfo = buttonsInfo, FieldsInfo = fields, LanguageInfo = languageInfo, ModulesInfo = modulesInfo, OracleParamsInfo = oracleParamsInfo }; outPut.Data = moduleInfo; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } return(Ok(outPut)); }
private Task StartRestWriter(BlockingCollection <Wrapper <OutputBase> > output) { return(Task.Factory.StartNew(() => { var objectCount = 0; using (var client = new WebClient()) { client.Headers.Add("content-type", "application/json"); client.Headers.Add("Accept", "application/json; charset=UTF-8"); client.Headers.Add("Authorization", _options.GetEncodedUserPass()); var coll = new RestOutput(); var serializer = new JavaScriptSerializer(); foreach (var obj in output.GetConsumingEnumerable()) { var item = obj.Item; if (item is DomainTrust temp) { foreach (var x in temp.ToMultipleParam()) { coll.AddNewData(temp.TypeHash(), x); } } else { coll.AddNewData(item.TypeHash(), item.ToParam()); } obj.Item = null; objectCount++; if (objectCount % 500 != 0) { continue; } var data = serializer.Serialize(coll.GetStatements()); client.UploadData(_options.GetURI(), "POST", Encoding.Default.GetBytes(data)); coll.Reset(); } var remainingData = serializer.Serialize(coll.GetStatements()); var responseArray = client.UploadData(_options.GetURI(), "POST", Encoding.Default.GetBytes(remainingData)); //Console.WriteLine(Encoding.ASCII.GetString(responseArray)); } }, TaskCreationOptions.LongRunning)); }
public async Task <ActionResult> GetAllCodeInfo() { var outPut = new RestOutput <List <CodeInfo> >(); try { var m_Client = new CoreController(_configuration); var data = m_Client.GetAllCodeInfo(); outPut.Data = data; return(Ok(outPut)); } catch (Exception ex) { } return(Ok(outPut)); }
public async Task <ActionResult> LoadModMaintainByModId(string modId) { var outPut = new RestOutput <List <MaintainModuleInfo> >(); try { var m_Client = new CoreController(_configuration); var data = m_Client.LoadMainTainModule(modId); outPut.Data = data; return(Ok(outPut)); } catch (Exception ex) { } return(Ok(outPut)); }
public async Task <RestOutput <string> > DeleteModule(string store, List <ModuleFieldInfo> fieldDels) { try { var url = string.Format("Module/DeleteModule?store={0}", store); var data = await PostApi(url, fieldDels); var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(data); return(moduleds); } catch (Exception ex) { var outPut = new RestOutput <string>(); outPut.Data = ex.Message; return(outPut); } }
public async Task <ActionResult> LoadModSearchByModId(string modId) { var outPut = new RestOutput <List <SearchModuleInfo> >(); try { var m_Client = new CoreController(_configuration); var data = m_Client.LoadModSearchByModId(modId); outPut.Data = data; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); } return(Ok(null)); }
public async Task <ActionResult> LoadDefModByTypeValue(string parameter) { var outPut = new RestOutput <List <CodeInfo> >(); try { var m_Client = new CoreController(_configuration); var outPutData = m_Client.LoadDefModByTypeValue(parameter); outPut.Data = outPutData; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } return(Ok(outPut)); }
public async Task <ActionResult> GetGroupModByUserId(string userId) { try { var outPut = new RestOutput <List <GroupMod> >(); try { var m_Client = new CoreController(_configuration); var data = m_Client.GetGroupModByUserId(userId); outPut.Data = data; return(Ok(outPut)); } catch (Exception ex) { } return(Ok(outPut)); } catch (Exception ex) { } return(Ok(null)); }
public async Task <ActionResult> InsertLog([FromBody] LOG log) { var outPut = new RestOutput <int>(); var m_Client = new CoreController(_configuration); SqlConnection conn = new SqlConnection(m_Client.ConnectionString); try { var cm = new WebApiCore.CommonFunction(); var lst = new List <string>(); var store = "sp_LOG_INS"; var param = m_Client.DiscoveryParameters(store); var fieldInfos = new List <SqlParameter>(); fieldInfos.Add(new SqlParameter("@ModId", log.ModId)); fieldInfos.Add(new SqlParameter("@Type", log.Type)); fieldInfos.Add(new SqlParameter("@ActionError", log.ActionError)); fieldInfos.Add(new SqlParameter("@Note", log.Note)); var userName = GetUserName(); fieldInfos.Add(new SqlParameter("@UserName", userName)); fieldInfos.Add(new SqlParameter("@Ip", log.Ip)); conn.Open(); var comm = new SqlCommand(store, conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddRange(fieldInfos.ToArray()); comm.ExecuteNonQuery(); return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } finally { conn.Close(); } }
public async Task <ActionResult> GetAllIcon() { var outPut = new RestOutput <List <LanguageInfo> >(); try { var m_Client = new CoreController(_configuration); var menu = m_Client.GetAllLanguageIcon(); if (!menu.Any()) { outPut.Data = null; return(Ok(outPut)); } outPut.Data = menu; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } }
public async Task <ActionResult> GetUserLogin(string userName, string password) { var outPut = new RestOutput <User>(); try { var m_Client = new CoreController(_configuration); var users = m_Client.GetUserByUserNamePassword(userName, password); if (!users.Any()) { outPut.Data = null; return(Ok(outPut)); } outPut.Data = users.First(); return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } }
public async Task <ActionResult> GetAllSysVar() { var outPut = new RestOutput <List <SysVar> >(); try { var m_Client = new CoreController(_configuration); var sysVar = m_Client.GetAllSysVar(); if (!sysVar.Any()) { outPut.Data = null; return(Ok(outPut)); } outPut.Data = sysVar; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } }
public async Task Save() { //Dongpv:FIX TO RUN //ErrorValidate = new List<string>(); //foreach (var item in moduleFieldInfo) //{ // var validator = new Common.FluentValidation(); // var rsErr = validator.Validate(item); // if (!rsErr.IsValid) // { // ErrorValidate.AddRange(rsErr.Errors.Select(x => x.ErrorMessage)); // } //} //if (ErrorValidate.Any()) //{ // return; //} //Dongpv:FIX TO RUN HomeBus homeBus = new HomeBus(moduleService, iConfiguration, distributedCache); string validate = ""; var modMaintain = await homeBus.LoadMaintainModuleInfo(modId); var store = ""; //Dongpv: var excute = new RestOutput <string>(); if (string.IsNullOrEmpty(keyEdit)) { store = modMaintain.AddInsertStore; //Dongpv: excute = (await moduleService.SaveData(modId, store, keyEdit, moduleFieldInfo)); } else { store = modMaintain.EditUpdateStore; //Dongpv: excute = (await moduleService.UpdateData(modId, store, keyEdit, moduleFieldInfo)); } //var excute = (await moduleService.SaveEditModule(modId, store, keyEdit, fieldEdits)); //Dongpv: //var excute = (await moduleService.SaveEditModule(modId, store, keyEdit, moduleFieldInfo)); //Dongpv: if (excute.Data != "success" && excute.ResultCode != 1) { var err = excute.Data.GetError(); var redrectToSearch = string.IsNullOrEmpty(parram) ? modMaintain.AddRepeatInput : modMaintain.EditRepeatInput; JSRuntime.InvokeAsync <string>("bb_alert", excute.Data, DotNetObjectReference.Create(this), "AlertCallBack", redrectToSearch); } else { if (modMaintain.ShowSuccess == "Y" || excute.ResultCode == 1) { var title = "Lưu dữ liệu thành công"; JSRuntime.InvokeAsync <string>("bb_alert", title, DotNetObjectReference.Create(this), "AlertCallBack"); //Modal.Show<Pages.Edit>(moduleInfoModel.ModulesInfo.ModuleName.GetLanguageTitle(moduleInfoModel.LanguageInfo), parameters); } } }
public async Task <List <dynamic> > getDetail(string modId, string modSearchId, List <ModuleFieldInfo> fieldEdits) //ParramModuleQuery parram ModalParameters { try { //var json = JsonConvert.SerializeObject(obj); //var json = JsonConvert.DeserializeObject<string>(apiResponse); //ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId); //1. Convert obj to arraylist var order = new { UserID = "0000", MsgIP = "00000", BranchID = "000", ModId = modId, ObjectName = Constants.OBJ_DETAIL, MsgType = Constants.MSG_MISC_TYPE, MsgAction = Constants.MSG_SEARCH, Body = fieldEdits }; var json = JsonConvert.SerializeObject(order); //2. CALL HOST var result = await SendMessage(json); DataTable tb = new DataTable(); if (!string.IsNullOrEmpty(result) && result != "null") { tb = SysUtils.Json2Table(result); } //DataTable tb = SysUtils.Json2Table(data); //var moduleds = JsonConvert.DeserializeObject<string> (data); //var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data); //DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); //var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds.Data); //var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds); // return moduledData; //DataTable dt = (DataTable)JsonConvert.DeserializeObject(data, (typeof(DataTable))); var outPut = new RestOutput <string>(); outPut.Data = JsonConvert.SerializeObject(tb, 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); var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut)); DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data); return(moduledData); //return data; } catch (Exception ex) { throw ex; } }
public async Task <RestOutput <string> > SaveData(string modId, string enity, string keyEdit, List <ModuleFieldInfo> fieldEdits) { try { //var json = JsonConvert.SerializeObject(obj); //var json = JsonConvert.DeserializeObject<string>(apiResponse); //ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId); //1. Convert obj to arraylist //ArrayList Body = new ArrayList(); //foreach (ModuleFieldInfo moduleFieldInfo in fieldEdits) //{ // if (moduleFieldInfo.Value != null) // { // if(string.IsNullOrEmpty(enity)) enity = moduleFieldInfo.Entity; // string controlType = moduleFieldInfo.ControlType; // string fileName = moduleFieldInfo.FieldName.Trim(); // object value = moduleFieldInfo.Value; // if (controlType == "GE") // { // ArrayList arrDetail = new ArrayList(); // SysUtils.String2ArrayList(ref arrDetail, value.ToString().Replace("[", "").Replace("]", "").Replace("{", "").Replace("}", "").Replace("\r\n", "").Replace("\"", ""), ",", ":"); // value = arrDetail; // } // Body.Add(fileName); Body.Add(value); // } //} var message = new { UserID = "0000", IP = "00000", BranchID = "000", ModuleID = modId, ModId = modId, ObjectName = enity, MsgType = Constants.MSG_MNT_TYPE, MsgAction = Constants.MSG_ADD_ACTION, Body = fieldEdits }; var json = JsonConvert.SerializeObject(message); var result = await SendMessage(json); DataTable tb = new DataTable(); if (!string.IsNullOrEmpty(result) && result != "null") { tb = SysUtils.Json2Table(result); } var outPut = new RestOutput <string>(); outPut.Data = JsonConvert.SerializeObject(tb, 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 = ""; //var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data); var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut)); DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable))); var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data); return(moduleds); } catch (Exception ex) { throw ex; } }
public async Task <ActionResult> LoadDefModByTypeValue([FromBody] List <CodeInfoParram> codeInfos) { var outPut = new RestOutput <List <CodeInfoModel> >(); var outPutData = new List <CodeInfoModel>(); try { var m_Client = new CoreController(_configuration); foreach (var item in codeInfos) { try { if (item.ListSource == null) { continue; } if (item.ListSource.Contains(":")) { var codeInfoModel = new CodeInfoModel { Name = item.Name, CodeInfos = m_Client.LoadDefModByTypeValue(item.ListSource) }; outPutData.Add(codeInfoModel); } else { var parram = new List <string>(); if (!string.IsNullOrEmpty(item.Parrams)) { parram.Add(item.Parrams); } var param = new List <SqlParameter>(); var storeName = item.ListSource; if (!(item.ListSource.IndexOf("(") < 0 && item.ListSource.IndexOf(")") < 0)) { storeName = item.ListSource.Substring(0, item.ListSource.IndexOf("(")); var strParr = item.ListSource.Substring(item.ListSource.IndexOf("(") + 1, item.ListSource.IndexOf(")") - item.ListSource.IndexOf("(") - 1); if (!string.IsNullOrEmpty(strParr)) { parram.AddRange(strParr.Split(',')); } } param = m_Client.DiscoveryParameters(storeName); int index = 0; foreach (var pr in param) { //if (pr.NpgsqlDbType != NpgsqlTypes.NpgsqlDbType.Refcursor) //{ pr.Value = parram[index]; index++; //} } var data = new DataTable(); data = (DataTable)m_Client.RunStoreToDataTable(storeName, param); if (data != null) { if (data.Columns.Contains("VALUE"))//Trường hợp load các Listsource không phải callback { if (item.CtrlType != EControlType.SCL.ToString()) { var codeInfoControls = (from p in data.AsEnumerable() select new CodeInfo { CodeValue = p["VALUE"].ToString(), CodeValueName = p["TEXT"].ToString() }).ToList(); var codeInfoModel = new CodeInfoModel { ControlType = item.CtrlType, Name = item.Name, CodeInfos = codeInfoControls }; outPutData.Add(codeInfoModel); } else { var scheduleControl = (from p in data.AsEnumerable() select new ScheduleControlModel { id = p["id"].ToString(), title = p["title"].ToString(), className = p["className"].ToString(), end = p["end"].ToString(), start = p["start"].ToString(), url = p["url"].ToString(), modId = p["modId"].ToString() }).ToList(); var codeInfoModel = new CodeInfoModel { ControlType = item.CtrlType, Name = item.Name, ScheduleControls = scheduleControl }; outPutData.Add(codeInfoModel); } } else//Trường hợp load các Listsource callback { var dataCallBack = JsonConvert.SerializeObject(data); var codeInfoModel = new CodeInfoModel { ControlType = item.CtrlType, Name = item.Name, DataCallBack = dataCallBack }; outPutData.Add(codeInfoModel); } } } } catch (Exception e) { } } outPut.Data = outPutData; outPut.ResultCode = 1; return(Ok(outPut)); } catch (Exception ex) { outPut.ResultCode = -1; outPut.Message = ex.ToString(); return(Ok(outPut)); } return(Ok(outPut)); }