public string ExcuteStores(string config, string para, Dictionary <string, string> dicAppset, Dictionary <string, string> dicProce) { try { var lstPara = gn.ParaConvertListPara(para); var dicConfig = gn.ConfigConvertToDicConfig(config); if (lstPara == null && dicConfig == null) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}"); } var dicConfigOk = gn.DecodeProcedueConfig(dicConfig, dicProce); if (dicConfigOk == null) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Chưa mã hóa thủ tục\"}]}"); } var paraOk = DecodeProceduePara(lstPara, dicConfigOk, dicAppset, dicProce); var json = ""; json = ExecuteSqlJson(dicConfig, paraOk); return(json); } catch (Exception ex) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}"); } }
// GET api/excel/5 public string Get(string id) { try { if (id == "") { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại userid\"}]}"); } var user = id; general gn = new general(); dicAppSet = gn.ReadAppseting(); var lst = JObject.Parse(_dicPara_exnom["StrColumnNames" + user]).SelectToken("kq").ToString(); var LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst); if (dicAppSet == null || dicAppSet.Count == 0) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}"); } var lstPara = gn.ParaConvertListPara(_dicPara_exnom["StrPara" + user]); var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_exnom["StrConfig" + user]); if (lstPara == null && dicConfig == null) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}"); } _dicPara_exnom.Remove("StrPara" + user); _dicPara_exnom.Remove("StrConfig" + user); _dicPara_exnom.Remove("StrColumnNames" + user); gnOracle orl = new gnOracle(); gnExcel exx = new gnExcel(); // var dtPara = orl.DecodeProceduePara(lstPara, dicConfigOk, dicAppSet); var dtPara = orl.DecodeProceduePara(lstPara, dicConfig, dicAppSet); var lstPrOrl = orl.dicParaToOraclePara(dtPara == null || dtPara.Tables.Count == 0 ? null : dtPara.Tables[0], lstPara); var ds = orl.ExcuteReturnDataSet(dicConfig["namesql"], (lstPrOrl == null ?null: lstPrOrl), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]); if (ds == null || ds.Tables.Count == 0) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không có dữ liệu xuất excel\"}]}"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { ds.Tables[0].Columns[i].ColumnName = ds.Tables[0].Columns[i].ColumnName.ToLower(); } exx.ExporttoExcel(new List <string>(), ds.Tables[0], LstColumnNames, dicConfig.ContainsKey("namefile") ? dicConfig["namefile"] : "" + DateTime.Now.ToString("dd-MM-yyyy"), 1, false, true); return(""); } catch (Exception ex) { return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}"); } }