Closed tieuquyngok1995 closed 3 years ago
if (item.StartsWith("'")) { continue; }
if (item.EndsWith("'")) { item = item.Remove(item.Length - 1); item = item.TrimEnd(); } if (item.EndsWith("\"")) { item = item.Remove(item.Length - 1); } else if (item.Contains(CONSTANTS.CONST_CHAR_AMPERSAND)) { int numAmpersand = item.Count(f => (f == CONSTANTS.CONST_CHAR_AMPERSAND)); if (numAmpersand % 2 == 0) { item = string.Concat(item, CONSTANTS.CONST_STRING_SPACE, CONSTANTS.CONST_STRING_CHECK_PARAM_CLOSE); } } // Format str SQL if (item.Contains(string.Format(CONSTANTS.CONST_STRING_CHECK_CONTAINS_01, strSQLChar))) { item = CUtils.ReplaceFormat(item, CONSTANTS.CONST_STRING_CHECK_CONTAINS_01, string.Empty, strSQLChar); } else if (item.Contains(string.Format(CONSTANTS.CONST_STRING_CHECK_CONTAINS_02, strSQLChar))) { item = CUtils.ReplaceFormat(item, CONSTANTS.CONST_STRING_CHECK_CONTAINS_02, string.Empty, strSQLChar); } else if (item.Contains(string.Format(CONSTANTS.CONST_STRING_CHECK_CONTAINS_03, strSQLChar))) { item = CUtils.ReplaceFormat(item, CONSTANTS.CONST_STRING_CHECK_CONTAINS_03, string.Empty, strSQLChar); } else if (Regex.IsMatch(item, CONSTANTS.CONST_REGEX_WORD_CHARACTER)) { continue; } else if (!item.Contains(CONSTANTS.CONST_STRING_CHECK_IF) && !item.Contains(CONSTANTS.CONST_STRING_CHECK_ELSE) && !item.Contains(CONSTANTS.CONST_STRING_CHECK_ELSE_IF)) { continue; } // add value in list if ((item.Contains(CONSTANTS.CONST_STRING_CHECK_IF) && !item.Contains(CONSTANTS.CONST_STRING_CHECK_END_IF)) || item.Contains(CONSTANTS.CONST_STRING_CHECK_ELSE)) { result = result + item.Trim() + CONSTANTS.CONST_CHAR_LINE_BREAK; } else if (item.Contains(CONSTANTS.CONST_STRING_CHECK_SELECT_CASE)) { result = result + item.Trim().Replace(CONSTANTS.CONST_STRING_CHECK_SELECT_CASE, CONSTANTS.CONST_STRING_CHECK_SELECT_CASE + CONSTANTS.CONST_STRING_IS_SELECT_CASE) + CONSTANTS.CONST_CHAR_LINE_BREAK; numSelectCase++; } else { result = result + item.Trim() + CONSTANTS.CONST_CHAR_LINE_BREAK; } } } catch (Exception ex) { MessageBox.Show("An abnormal error occurs in the function: HandFormatStringInput\nError content: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return result; }
if (item.StartsWith("'")) { continue; }