Esempio n. 1
0
        // GET: api/Check_CheckAllProcess
        public string Get()
        {
            gnSqlNomal sqln      = new gnSqlNomal();
            general    gn        = new general();
            var        dicAppSet = gn.ReadAppseting();

            if (!dicAppSet.ContainsKey("pathcheckserver"))
            {
                return("{\"status\":\"Không chứa pathcheckserver\"}");
            }

            var strfileInfo = File.ReadAllText(dicAppSet["pathcheckserver"]);
            var dicFileInfo = sqln.convertParaToDic(strfileInfo);

            var str = "";

            foreach (Process p in Process.GetProcesses("."))
            {
                try
                {
                    var name = p.MainWindowTitle != "" ? p.MainWindowTitle : p.ProcessName;

                    str += "{\"name\":\"" + name + "\",\"status\":\"" + (p.Responding ?"Runing":"NotRespond") + "\",\"istype\":\"GetAllProcess\",\"servername\":\"" + dicFileInfo["servername"] + "\"},";
                }
                catch { }
            }
            var sum = str != "" ? str.Substring(0, str.Length - 1) : "";

            return("[" + sum + "]");
        }
Esempio n. 2
0
        // GET api/sqlsysdnpc/5
        public string Get(string id)
        {
            WS      ws = new WS();
            general gn = new general();

            var json = ws.GetGia(id, "dnpc@");
            var dt   = gn.ConvertJsonToDataTable(json, "dt");

            if (dt != null && dt.Rows.Count > 0)
            {
                var prDt = new SqlParameter("@dt", SqlDbType.Structured);
                prDt.Value = dt;
                var parameters = new[] { prDt };
                //   ExecuteSqlDataset("[DNPC].[AutoInsertGiaDien]", parameters);
            }


            //for (int i = 0; i <= 3; i++)
            //{
            //    var thu = DateTime.Now.AddMonths(-i).Month;
            //    var thu1 = DateTime.Now.AddMonths(-i).Year;
            //    var  dt1 = ws.GetCP(id, DateTime.Now.AddMonths(-i).Month, DateTime.Now.AddMonths(-i).Year,1, "dnpc@");
            //    if (dt1 != null && dt1.Rows.Count > 0)
            //    {
            //        ds.Tables.Add(dt1);

            //    }
            //}
            //var data = gn.ConvertDatasetToListJson(ds);
            //if (data == null) return "{\"result\":\"ERROR\",\"data\":\"Lỗi khi ConvertDatasetToListJson\"}";
            //json += gn.ConvertListToJson(data);

            return(json);
        }
Esempio n. 3
0
        //get All text
        public string getResultAllTextDocTucThoi(string config, string para, Dictionary <string, string> dicAppset)
        {
            try
            {
                gnSqlNomal sqln      = new gnSqlNomal();
                general    gn        = new general();
                var        dicAppSet = gn.ReadAppseting();

                var dicConfig = sqln.convertConfigToDic(config);
                var dicPara   = sqln.convertParaToDic(para);

                var strfileInfo = File.ReadAllText(dicAppSet["dtt_infodoctucthoi"]);
                var dicFileInfo = sqln.convertParaToDic(strfileInfo);

                var fileExists = dicFileInfo["pathwritefilealltext"] + "\\" + dicConfig["namefile"];

                var lines = File.Exists(fileExists) ? File.ReadAllText(fileExists) : "[]";
                // var lines = File.ReadAllText(fileExists);
                return("{\"result\":\"OK\",\"data\":\"" + lines + "\"}");
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
Esempio n. 4
0
        public JsonResult UploadFileDaKy()
        {
            try
            {
                general gn        = new general();
                var     dicAppSet = gn.ReadAppseting();
                string  fileName  = "";
                for (int i = 0; i < Request.Files.Count; i++)
                {
                    HttpPostedFileBase file = Request.Files[i]; //Uploaded file
                    //Use the following properties to get file's name, size and MIMEType
                    int fileSize = file.ContentLength;
                    fileName = file.FileName;
                    string           mimeType    = file.ContentType;
                    System.IO.Stream fileContent = file.InputStream;

                    //To save file, use SaveAs method
                    //file.SaveAs(dicAppSet["hddt_path_downloadfilehoadon"] + fileName);
                    file.SaveAs(dicAppSet["hddt_path_filehoadondaky"] + fileName);
                    // var pathSave = Server.MapPath("~/UploadFile/") ;
                    //  file.SaveAs(Server.MapPath(pathSave)); //File will be saved in application root
                }
                var strResult = Json("{\"result\":\"OK\",\"data\":\"" + fileName + "\"}");
                return(strResult);
                //  return Json("{\"result\":\"OK\",\"data\":\"Không nhận được file\"}");
            }
            catch (Exception ex)
            {
                return(Json("{\"result\":\"ERROR\",\"data\":\"" + ex.Message + "\"}"));
            }
        }
Esempio n. 5
0
        // POST: api/DocTucThoi_ChecDangDoc
        public string Post(DocTucThoi value)
        {
            try
            {
                Dictionary <string, string> dicAppSet = null;
                if (dicAppSet == null || dicAppSet.Count == 0)
                {
                    general gn = new general();
                    dicAppSet = gn.ReadAppseting();
                    if (dicAppSet == null || dicAppSet.Count == 0)
                    {
                        return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
                    }
                }

                gnSqlNomal sqln        = new gnSqlNomal();
                var        strfileInfo = File.ReadAllText(dicAppSet["dtt_infodoctucthoi"]);
                var        dicFileInfo = sqln.convertParaToDic(strfileInfo);

                var files = Directory.GetFiles(dicFileInfo["dtt_savefiletofolder"]);

                return(files.Length > 0 ? "{\"result\":\"OK\",\"data\":\"Đang trong quá trình đọc tức thời\"}" : "{\"result\":\"OK\",\"data\":\"\"}");
            }catch (Exception ex)
            {
                return("");
            }
        }
Esempio n. 6
0
        // GET: api/Check_CheckDrives
        public string Get()
        {
            // Check Ổ đĩa
            var sum = "";

            gnSqlNomal sqln      = new gnSqlNomal();
            general    gn        = new general();
            var        dicAppSet = gn.ReadAppseting();

            if (!dicAppSet.ContainsKey("pathcheckserver"))
            {
                return("{\"status\":\"Không chứa pathcheckserver\"}");
            }

            var strfileInfo = File.ReadAllText(dicAppSet["pathcheckserver"]);
            var dicFileInfo = sqln.convertParaToDic(strfileInfo);


            DriveInfo[] allDrives = DriveInfo.GetDrives();

            var str = "";

            foreach (DriveInfo d in allDrives)
            {
                try
                {
                    str += "{\"driver\":\"" + d.Name.Substring(0, 1) + "\",\"totalfreespace\":\"" + Math.Round(Convert.ToDouble(d.TotalFreeSpace) / 1073741824) + " GB\",\"totalsize\":\"" + Math.Round(Convert.ToDouble(d.TotalSize) / 1073741824) + " GB\",\"istype\":\"CheckDrive\",\"servername\":\"" + dicFileInfo["servername"] + "\"},";
                }
                catch { }
            }

            sum = str != "" ? str.Substring(0, str.Length - 1) : "";

            return("[" + sum + "]");
        }
Esempio n. 7
0
        public JsonResult MCF_Upload_Firmware()
        {
            try
            {
                general            gn        = new general();
                var                dicAppSet = gn.ReadAppseting();
                string             fileName  = "";
                HttpPostedFileBase file      = Request.Files[0];

                int fileSize = file.ContentLength;
                fileName = file.FileName;
                string           mimeType    = file.ContentType;
                System.IO.Stream fileContent = file.InputStream;
                var strResult = Json("{\"result\":\"OK\",\"data\":\"OK\"}");
                if (!System.IO.File.Exists(dicAppSet["mcf_path_firmware"] + fileName))
                {
                    file.SaveAs(dicAppSet["mcf_path_firmware"] + fileName);
                    strResult = Json("{\"result\":\"OK\",\"data\":\"" + fileName + "\"}");
                }
                else
                {
                    strResult = Json("{\"result\":\"ERROR\",\"data\":\"Đã tồn tại, vui lòng chọn firmware khác hoặc xóa file cũ trước khi upload\"}");
                }
                //string fullpath = dicAppSet["mcf_path_firmware"] + fileName;
                //fullpath = Regex.Replace(fullpath, @"\\", @"\\");

                return(strResult);
                //  return Json("{\"result\":\"OK\",\"data\":\"Không nhận được file\"}");
            }
            catch (Exception ex)
            {
                return(Json("{\"result\":\"ERROR\",\"data\":\"" + ex.Message + "\"}"));
            }
        }
Esempio n. 8
0
        // POST: api/DocTucThoiGetResult
        public string Post(DocTucThoi value)
        {
            try
            {
                if (dicAppSet == null || dicAppSet.Count == 0)
                {
                    general gn = new general();
                    dicAppSet = gn.ReadAppseting();
                    if (dicAppSet == null || dicAppSet.Count == 0)
                    {
                        return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
                    }
                }

                if (value == null || value.config == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }
                var json = "";

                gnDocTucThoi orc = new gnDocTucThoi();
                json = orc.getResultDocTucThoi(value.config, value.para, dicAppSet);

                return(json);
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
        }
        // POST api/ExcuteOracle
        public string Post(ValueModelOracle value)
        {
            if (dicAppSet == null || dicAppSet.Count == 0)
            {
                general gn = new general();
                dicAppSet = gn.ReadAppseting();
                if (dicAppSet == null || dicAppSet.Count == 0)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
                }
            }

            if (value == null || value.config == null)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
            }

            Db_Access ac    = new Db_Access();
            var       check = ac.checkRequertLienTuc(HttpContext.Current, dicAppSet, value.config, value.para);

            if (!check)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không cho phép request liên tục\"}]}");
            }

            var json = "";

            gnOracleXml orc = new gnOracleXml();

            json = orc.ExcuteStores(value.config, value.para, dicAppSet);

            return(json);
        }
        // POST: api/Convert_HtmlToWord
        public string Post(HtmlToWord value)
        {
            try
            {
                Dictionary <string, string> dicAppSet;
                general gn = new general();
                dicAppSet = gn.ReadAppseting();
                if (dicAppSet == null || dicAppSet.Count == 0)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
                }

                var dicConfig = gn.ConfigConvertToDicConfig(value.config);
                if (dicConfig == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }

                getTextInHtml html = new getTextInHtml();
                string        data = html.GetHTMLfromUrl(dicConfig["fromurl"]);

                NoInkSoftware.HTMLtoDOCX NewFile = new NoInkSoftware.HTMLtoDOCX();
                var namefile = dicAppSet["path_saveonserver"] + dicConfig["namefile"];
                NewFile.CreateFileFromHTML(data, namefile);

                return("{\"result\":\"OK\",\"data\":\"" + namefile + "\"}");
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
        }
Esempio n. 11
0
        // POST: api/BulkCopySqlRenameCol
        public string Post(paraExportXml value)
        {
            try
            {
                general gn        = new general();
                var     json      = "";
                var     dicConfig = gn.ConfigConvertToDicConfig(value.config);
                if (dicConfig == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }
                var table = JObject.Parse(value.para);
                if (table == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }

                gnSqlNomal gns  = new gnSqlNomal();
                var        para = gns.convertParaToDic(value.para);
                DataTable  dt   = new DataTable("dt");
                foreach (var val in table)
                {
                    dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
                    break;
                }

                gn.ExportTable(dt, dicConfig);
                return(json);
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
        }
Esempio n. 12
0
        // POST: api/ExcuteText

        public string Post(ValueText value)
        {
            if (value == null || value.connstr == null || value.connstr == "" || value.sqltext == null)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
            }

            general   gns       = new general();
            var       dicAppSet = gns.ReadAppseting();
            Db_Access ac        = new Db_Access();
            var       check     = ac.checkRequertLienTuc(HttpContext.Current, dicAppSet, value.sqltext, "");

            if (!check)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không cho phép request liên tục\"}]}");
            }

            var dicConfig = new Dictionary <string, string>();

            dicConfig.Add("connstr", value.connstr);
            dicConfig.Add("namesql", value.sqltext);
            dicConfig.Add("commandtype", "Text");

            var json = "";

            gnOracle orc = new gnOracle();

            json = orc.ExcuteReturnJson(dicConfig, null);

            return(json);
        }
Esempio n. 13
0
        // GET api/Xml_ExportOracle/5
        public HttpResponseMessage Get(string idrandom)
        {
            general gn             = new general();
            var     dicAppSet      = gn.ReadAppseting();
            var     lst            = JObject.Parse(_dicPara_xml["StrColumnNames" + idrandom]).SelectToken("kq").ToString();
            var     LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);

            // lay du lieu
            gnOracle or = new gnOracle();

            if (dicAppSet == null || dicAppSet.Count == 0)
            {
                return(null);
            }

            var dicPara   = gn.ParaConvertDicPara(_dicPara_xml["StrPara" + idrandom]);
            var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_xml["StrConfig" + idrandom]);

            if (dicPara == null && dicConfig == null)
            {
                return(null);
            }
            _dicPara_xml.Remove("StrPara" + idrandom);
            _dicPara_xml.Remove("StrConfig" + idrandom);
            _dicPara_xml.Remove("StrColumnNames" + idrandom);

            var dsParaOnSql = or.DecodeProceduePara_New(dicConfig, dicAppSet);
            var paraOk      = or.dicParaToOraclePara_New(dsParaOnSql, dicPara);

            var ds = or.ExcuteReturnDataSet(dicConfig["namesql"], paraOk.ToList(), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);

            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            var ds1 = gn.convertDatasetToLower(ds);

            string filePath = dicAppSet["path_saveonserver"] + dicConfig["namefile"] + ".xml";

            System.IO.StreamWriter xmlSW = new System.IO.StreamWriter(filePath);
            ds1.WriteXml(xmlSW, XmlWriteMode.WriteSchema);
            xmlSW.Close();

            var        response   = new HttpResponseMessage();
            FileStream fileStream = File.Open(filePath, FileMode.Open);

            response.Content = new StreamContent(fileStream);
            response.Content.Headers.ContentDisposition
                = new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment");
            response.Content.Headers.ContentDisposition.FileName = dicConfig["namefile"] + ".xml";
            response.Content.Headers.ContentType
                = new System.Net.Http.Headers.MediaTypeHeaderValue("application/octet-stream");

            response.Content.Headers.ContentLength
                = fileStream.Length;
            return(response);

            //return System.Web.Mvc.Controller.(filePath, MimeMapping.GetMimeMapping(filePath));
        }
Esempio n. 14
0
        // POST: api/Email_SendMail
        public string Post(EmailValue value)
        {
            try
            {
                gnSqlNomal gn        = new gnSqlNomal();
                general    gns       = new general();
                var        dicAppSet = gns.ReadAppseting();

                if (value == null || value.config == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại dữ liệu đầu vào\"}]}");
                }

                var config = gn.convertConfigToDic(value.config);

                var ToEmail   = config["sendtomail"];
                var ToEmailCC = config["sendcctomail"];

                MailMessage mail = new MailMessage();
                mail.From = new MailAddress(dicAppSet["email_guithuc"], config["tenthaythe"]);

                String[] tmp = ToEmail.Split(',');

                foreach (string amail in tmp)
                {
                    if (amail.Length > 0)
                    {
                        mail.To.Add(amail);
                    }
                }
                foreach (string amail in ToEmailCC.Split(','))
                {
                    if (amail.Length > 0)
                    {
                        mail.CC.Add(amail);
                    }
                }

                mail.Subject      = config["chude"].ToString();
                mail.Priority     = MailPriority.High;
                mail.Body         = config["noidung"].ToString();
                mail.ReplyTo      = new MailAddress(dicAppSet["email_guithuc"]);
                mail.BodyEncoding = System.Text.Encoding.UTF8;
                mail.IsBodyHtml   = true;
                SmtpClient mySmtpClient = new SmtpClient();
                mySmtpClient.Host        = dicAppSet["email_smtp"];
                mySmtpClient.Credentials = new System.Net.NetworkCredential(dicAppSet["email_emailsend"], dicAppSet["email_passsend"]);
                mySmtpClient.EnableSsl   = dicAppSet["email_ssl"] == "true" ? true : false;
                mySmtpClient.Port        = Convert.ToInt32(dicAppSet["email_port"]);
                mySmtpClient.Send(mail);

                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Gửi mail thành công\"}]}");
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message + "\"}]}");
            }
        }
Esempio n. 15
0
        public string Post(ValueExportXml value)
        {
            general gn        = new general();
            var     dicAppSet = gn.ReadAppseting();

            _dicPara_xml.Add("StrPara" + value.idrandom, value.para);
            _dicPara_xml.Add("StrConfig" + value.idrandom, value.config);
            _dicPara_xml.Add("StrColumnNames" + value.idrandom, value.colum);
            return("");
        }
Esempio n. 16
0
        public string ExcuteReturnJson(Dictionary <string, string> dicConfig, List <OracleParameter> lstOrlPara)
        {
            OracleConnection  conn    = null;
            OracleCommand     cmd     = null;
            OracleDataAdapter adapter = null;

            try
            {
                string connectOracle = ConfigurationManager.ConnectionStrings[dicConfig["connstr"]].ConnectionString;
                conn = new OracleConnection(connectOracle);
                conn.Open();
                cmd             = new OracleCommand();
                cmd.Connection  = conn;
                cmd.CommandText = dicConfig["namesql"];
                cmd.CommandType = dicConfig.ContainsKey("commandtype") && dicConfig["commandtype"].ToLower() == "text" ? CommandType.Text: CommandType.StoredProcedure;
                cmd.BindByName  = true;
                if (lstOrlPara != null)
                {
                    cmd.Parameters.AddRange(lstOrlPara.ToArray());
                }

                adapter = new OracleDataAdapter(cmd);
                var ds = new DataSet();
                adapter.Fill(ds);
                general gn   = new general();
                var     data = gn.ConvertDatasetToListJson(ds);
                if (data == null)
                {
                    return("{\"result\":\"OK\",\"data\":\"[{\"status\":[]\"}]}");
                }
                ;
                var json      = gn.ConvertListToJson(data);
                var strResult = "{\"result\":\"OK\",\"data\":" + json + "}";
                return(strResult);
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
            finally
            {
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (adapter != null)
                {
                    adapter.Dispose();
                }
                if (conn != null && conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
        }
Esempio n. 17
0
        // GET api/ExcuteOracle
        public IEnumerable <string> Get()
        {
            try
            {
                OracleConnection  conn    = null;
                OracleCommand     cmd     = null;
                OracleDataAdapter adapter = null;
                try
                {
                    string connectOracle = ConfigurationManager.ConnectionStrings["ConnectOracle"].ConnectionString;
                    conn = new OracleConnection(connectOracle);
                    conn.Open();
                    cmd             = new OracleCommand();
                    cmd.Connection  = conn;
                    cmd.CommandText = "SELECT 'OK' OK FROM DUAL";
                    cmd.CommandType = CommandType.Text;
                    cmd.BindByName  = true;
                    adapter         = new OracleDataAdapter(cmd);
                    var ds = new DataSet();
                    adapter.Fill(ds);
                    general gn   = new general();
                    var     data = gn.ConvertDatasetToListJson(ds);
                    if (data == null)
                    {
                        return new string[] { "ok 1", "1" }
                    }
                    ;
                    var json      = gn.ConvertListToJson(data);
                    var strResult = "{\"result\":\"OK\",\"data\":" + json + "}";
                    return(new string[] { "ok 2", json });
                }
                catch (Exception ex)
                {
                    return(new string[] { "ERROR 3", ex.Message });
                }
                finally
                {
                    if (cmd != null)
                    {
                        cmd.Dispose();
                    }
                    if (adapter != null)
                    {
                        adapter.Dispose();
                    }
                    if (conn != null && conn.State != ConnectionState.Closed)
                    {
                        conn.Close();
                    }
                }

                return(new string[] { "value1", "value2" });
            }
            catch (Exception ex) { return(new string[] { "errror 4 ", ex.Message }); }
        }
        // POST: api/BulkCopySqlRenameCol
        public string Post(paraBulkTableSqlRename value)
        {
            try
            {
                general gn        = new general();
                var     json      = "";
                var     dicConfig = gn.ConfigConvertToDicConfig(value.config);
                if (dicConfig == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }
                var table = JObject.Parse(value.table);
                if (table == null)
                {
                    return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
                }

                gnSqlNomal gns  = new gnSqlNomal();
                var        para = gns.convertParaToDic(value.para);
                DataTable  dt   = new DataTable("dt");
                foreach (var val in table)
                {
                    dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);

                    break;
                }

                // thay doi ten cot
                for (var c = 0; c < dt.Columns.Count; c++)
                {
                    dt.Columns[c].ColumnName = "Col" + c;
                }
                var nextCol = dt.Columns.Count;
                // ADD THEM COT RONG VAO BANG. CHO DU 30 COT
                for (var j = nextCol; j < 50; j++)
                {
                    try
                    {
                        DataColumn myColumn = new DataColumn();
                        myColumn.Caption      = "Col" + j;
                        myColumn.ColumnName   = "Col" + j;
                        myColumn.DefaultValue = "";
                        dt.Columns.Add(myColumn);
                    }
                    catch (Exception ex) { }
                }
                gnSql sql = new gnSql();
                json = sql.BulkCopyToSqlNoLower(dt, dicConfig, para);
                return(json);
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
        }
Esempio n. 19
0
 public virtual ActionResult Download_MCF_Firmware(string fileName)
 {
     try
     {
         general gn        = new general();
         var     dicAppSet = gn.ReadAppseting();
         string  fullPath  = dicAppSet["mcf_path_firmware"] + fileName;
         return(File(fullPath, "application/text", fileName));
     }
     catch { return(null); }
 }
Esempio n. 20
0
        // GET api/values
        public IEnumerable <string> Get()
        {
            general gn = new general();

            dicAppSet = gn.ReadAppseting();

            Db_Access ac = new Db_Access();

            var check = ac.checkRequertLienTuc(HttpContext.Current, dicAppSet, "test", "test");

            return(new string[] { "value1", (!check ? "Không được thực hiện lệnh liên tục trong " + dicAppSet["time_requestlientuc"] + " ms":"ok") });
        }
Esempio n. 21
0
        // 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", "") + "\"}]}");
            }
        }
Esempio n. 22
0
        // POST: api/TCP_OverServiceTcp
        public string Post(classTcp value)
        {
            try
            {
                gnSqlNomal gn        = new gnSqlNomal();
                general    gns       = new general();
                var        dicAppSet = gns.ReadAppseting();

                if (value == null || value.config == null)
                {
                    return(null);
                }

                var config = gn.convertConfigToDic(value.config);
                var para   = gn.convertParaToDic(value.para);


                var result = "";

                if (para["type"].ToLower() == "checkconnect" || para["type"].ToLower() == "receive")
                {
                    var pathReceive = dicAppSet["pathfoldertcpreceive"] + config["namefile"];
                    if (File.Exists(pathReceive))
                    {
                        var    resultByte = File.ReadAllText(pathReceive).Replace("\r\n", "-0D-0A-");
                        byte[] data       = Array.ConvertAll <string, byte>(resultByte.Substring(0, resultByte.Length - 1).Split('-'), s => Convert.ToByte(s, 16));
                        result = System.Text.ASCIIEncoding.ASCII.GetString(data);
                        File.Delete(pathReceive);
                    }
                    else
                    {
                        return("");
                    }
                }
                else
                {
                    var str = "";
                    foreach (var val in para)
                    {
                        str += val.Value + "\r\n";
                    }
                    File.WriteAllText(dicAppSet["pathfoldertcpsend"] + config["namefile"], str);
                }

                return(result);
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
        // GET api/ExcelExportOracle/5
        public string Get(string idrandom)
        {
            general gn             = new general();
            var     dicAppSet      = gn.ReadAppseting();
            var     lst            = JObject.Parse(_dicPara_exoracle["StrColumnNames" + idrandom]).SelectToken("kq").ToString();
            var     LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);

            // lay du lieu
            gnOracle or = new gnOracle();

            if (dicAppSet == null || dicAppSet.Count == 0)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
            }

            var dicPara   = gn.ParaConvertDicPara(_dicPara_exoracle["StrPara" + idrandom]);
            var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_exoracle["StrConfig" + idrandom]);

            _dicPara_exoracle.Remove("StrPara" + idrandom);
            _dicPara_exoracle.Remove("StrConfig" + idrandom);
            _dicPara_exoracle.Remove("StrColumnNames" + idrandom);

            if (dicPara == null && dicConfig == null)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
            }

            var dsParaOnSql = or.DecodeProceduePara_New(dicConfig, dicAppSet);
            var paraOk      = or.dicParaToOraclePara_New(dsParaOnSql, dicPara);

            var ds = or.ExcuteReturnDataSet(dicConfig["namesql"], paraOk.ToList(), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);

            if (ds == null || ds.Tables.Count == 0)
            {
                return("");
            }
            var ds1 = gn.convertDatasetToLower(ds);

            gnExcel exx = new gnExcel();

            var idtable = 0;

            if (dicConfig.ContainsKey("exporttable"))
            {
                idtable = Convert.ToInt32(dicConfig["exporttable"]);
            }

            exx.ExporttoExcel(new List <string>(), ds1.Tables[idtable], LstColumnNames, dicConfig.ContainsKey("namefile") ? dicConfig["namefile"] : "" + DateTime.Now.ToString("dd-MM-yyyy"), 1, false, true);
            return("");
        }
Esempio n. 24
0
        // GET api/excelsqlexcute/5
        public string Get(string id)
        {
            try
            {
                if (id == null || id == "undefind" || 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_exsql["StrColumnNames_SqlExcute" + 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\"}]}");
                }

                gnSqlNomal gns       = new gnSqlNomal();
                var        dicConfig = gns.convertConfigToDic(_dicPara_exsql["StrConfig_SqlExcute" + user]);
                var        dicPara   = gns.convertParaToDic(_dicPara_exsql["StrPara_SqlExcute" + user]);
                _dicPara_exsql.Remove("StrPara_SqlExcute" + user);
                _dicPara_exsql.Remove("StrConfig_SqlExcute" + user);
                _dicPara_exsql.Remove("StrColumnNames_SqlExcute" + user);

                gnSql   sql = new gnSql();
                gnExcel exx = new gnExcel();

                var paraSql = gn.ConvertDicToSqlPara(dicPara);

                var ds = sql.DynamicSelectDataset(dicConfig["namesql"], (paraSql == null ?null: paraSql), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);
                if (ds == null || ds.Tables.Count == 0)
                {
                    return("{\"result\":\"OK\",\"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", "") + "\"}]}");
            }
        }
        // POST: api/LayDanhSachFileTrongThuMuc
        public string Post(DanhSachFile value)
        {
            try
            {
                general    gns       = new general();
                gnSqlNomal gn        = new gnSqlNomal();
                var        dicAppSet = gns.ReadAppseting();

                var lst     = new List <string>();
                var folders = gns.GetAllFolder(dicAppSet["hddt_path_downloadfilechuaky_log"]);
                var para    = gn.convertParaToDic(value.para);

                // neu la  thang nam
                var namthangky = "";
                var loai       = "";
                if (para.ContainsKey("namthangky"))
                {
                    namthangky = para["namthangky"];
                }
                if (para.ContainsKey("loai"))
                {
                    loai = para["loai"];
                }
                foreach (var fol in folders)
                {
                    var files = Directory.GetFiles(fol);
                    foreach (var file in files)
                    {
                        if (namthangky != "" && file.ToLower().IndexOf(loai) >= 0 &&
                            file.ToLower().IndexOf(namthangky) >= 0)
                        {
                            var sp   = file.Split('\\');
                            var name = sp[sp.Length - 1];
                            lst.Add(name);
                        }
                        else
                        {
                            var sp   = file.Split('\\');
                            var name = sp[sp.Length - 1];
                            lst.Add(name);
                        }
                    }
                }

                var integers = Newtonsoft.Json.JsonConvert.SerializeObject(lst);
                return(integers);
            }
            catch (Exception ex) { return(ex.Message); }
        }
Esempio n. 26
0
        // GET: api/Check_PingServer
        public string Get()
        {
            gnSqlNomal sqln      = new gnSqlNomal();
            general    gn        = new general();
            var        dicAppSet = gn.ReadAppseting();

            if (!dicAppSet.ContainsKey("pathcheckserver"))
            {
                return("{\"status\":\"Không chứa pathcheckserver\"}");
            }

            var strfileInfo = File.ReadAllText(dicAppSet["pathcheckserver"]);
            var dicFileInfo = sqln.convertParaToDic(strfileInfo);

            return("{\"status\":\"OK\",\"istype\":\"PingServer\",\"servername\":\"" + dicFileInfo["servername"] + "\"}");
        }
Esempio n. 27
0
 public string Post(ValueExcelSqlXcuteTable value)
 {
     try
     {
         general gn = new general();
         dicAppSet = gn.ReadAppseting();
         _dicPara_exsql1.Add("StrPara_SqlExcute" + value.userid, value.para);
         _dicPara_exsql1.Add("StrConfig_SqlExcute" + value.userid, value.config);
         _dicPara_exsql1.Add("StrColumnNames_SqlExcute" + value.userid, value.colum);
         _dicPara_exsql1.Add("StrTable_SqlExcute" + value.userid, value.table == null ? "" : value.table);
         return("");
     }
     catch (Exception ex)
     {
         return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
     }
 }
Esempio n. 28
0
        public string Post(ValueExcel value)
        {
            try
            {
                general gn = new general();
                dicAppSet = gn.ReadAppseting();
                _dicPara_exnom.Add("StrPara" + value.userid, value.para);
                _dicPara_exnom.Add("StrConfig" + value.userid, value.config);
                _dicPara_exnom.Add("StrColumnNames" + value.userid, value.colum);

                return("");
            }
            catch (Exception ex)
            {
                return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
            }
        }
Esempio n. 29
0
 public string Post(dataExcel value)
 {
     try
     {
         _dicPara_table = new Dictionary <string, string>();
         general gn = new general();
         dicAppSet = gn.ReadAppseting();
         _dicPara_table.Add("StrTableData" + value.userid, value.para);
         _dicPara_table.Add("StrTableConfig" + value.userid, value.config);
         _dicPara_table.Add("StrTableColumnNames" + value.userid, value.colum);
         return("");
     }
     catch (Exception ex)
     {
         return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
     }
 }
        // GET: api/Check_CheckNotRepond
        public string Get()
        {
            gnSqlNomal sqln      = new gnSqlNomal();
            general    gn        = new general();
            var        dicAppSet = gn.ReadAppseting();

            if (!dicAppSet.ContainsKey("pathcheckserver"))
            {
                return("{\"status\":\"Không chứa pathcheckserver\"}");
            }

            var strfileInfo = File.ReadAllText(dicAppSet["pathcheckserver"]);
            var dicFileInfo = sqln.convertParaToDic(strfileInfo);

            var dicProcess = new Dictionary <string, string>();

            foreach (Process p in Process.GetProcesses("."))
            {
                try
                {
                    var name = p.MainWindowTitle != "" ? p.MainWindowTitle : p.ProcessName;

                    dicProcess.Add(name.ToLower(), p.Responding ? "Runing" : "NotRespond");
                }
                catch { }
            }

            if (!dicFileInfo.ContainsKey("checklstnotrespond"))
            {
                return("{\"status\":\"Không chứa checklstnotrespond\"}");
            }
            var lstCheck = dicFileInfo["checklstnotrespond"].Split(new string[] { "===" }, StringSplitOptions.None);
            var str      = "";

            foreach (var name in lstCheck)
            {
                if (dicProcess.ContainsKey(name.ToLower()))
                {
                    str += "{\"name\":\"" + name + "\",\"status\":\"" + dicProcess[name.ToLower()] + "\",\"istype\":\"CheckNotRespond\",\"servername\":\"" + dicFileInfo["servername"] + "\"},";
                }
            }

            var sum = str != "" ? str.Substring(0, str.Length - 1) : "";

            return("[" + sum + "]");
        }