private string staticQueryProperty() { StringBuilder sb = new StringBuilder(); #region SelectQueryStr StringBuilder selectQuery_SB = new StringBuilder(); selectQuery_SB.AppendLine("private static string SelectQuery_"); selectQuery_SB.Append("= "); //for (int i = 0; i < qm_.ColumnList_.Count - 1; i++) //{ // string upperItem = qm_.ColumnList_[i].ToUpper(); // selectQuery_SB.Append(upperItem + "_, "); //} //selectQuery_SB.AppendLine(qm_.ColumnList_[qm_.ColumnList_.Count - 1].ToUpper() + "_ \" + "); string inputViewQuery = qm_.getQuery(); StringReader sr = new StringReader(inputViewQuery); while (sr.Peek() >= 0) { selectQuery_SB.Append(" \" "); selectQuery_SB.Append(((sr.ReadLine()).Trim()).Replace(";", "")); selectQuery_SB.Append(" \""); if (sr.Peek() > 0) { selectQuery_SB.AppendLine(" + "); } } selectQuery_SB.AppendLine(";"); selectQuery_SB.AppendLine(); #endregion #region Not Use //#region InsertQueryStr //StringBuilder insertQuery_SB = new StringBuilder(); //insertQuery_SB.AppendLine("private static string InsertQuery_"); //insertQuery_SB.Append("= \"INSERT INTO " + this.tableName_ + " ("); //string upperItem_insertColumn = ""; //for (int i = 0; i < qm_.ColumnList_.Count - 1; i++) //{ // upperItem_insertColumn = qm_.ColumnList_[i].ToUpper(); // insertQuery_SB.Append(upperItem_insertColumn + "_, "); //} //upperItem_insertColumn = qm_.ColumnList_[qm_.ColumnList_.Count - 1].ToUpper(); //insertQuery_SB.AppendLine(upperItem_insertColumn + "_ )\" +"); //insertQuery_SB.Append("\"VALUES ("); //string upperItem_insertValue = ""; //for (int i = 0; i < qm_.ColumnList_.Count - 1; i++) //{ // upperItem_insertValue = qm_.ColumnList_[i].ToUpper(); // insertQuery_SB.Append("'@" + upperItem_insertValue + "VALUE@', "); //} //upperItem_insertValue = qm_.ColumnList_[qm_.ColumnList_.Count - 1].ToUpper(); //insertQuery_SB.AppendLine("'@" + upperItem_insertValue + "VALUE@' )\";"); //insertQuery_SB.AppendLine(); //#endregion //#region updateQueryStr //StringBuilder updateQuery_SB = new StringBuilder(); //updateQuery_SB.AppendLine("private static string UpdateQuery_"); //updateQuery_SB.Append("= \"UPDATE " + this.tableName_ + " SET "); //string upperItem_updateColumn = ""; //for (int i = 0; i < qm_.ColumnList_.Count - 1; i++) //{ // upperItem_updateColumn = qm_.ColumnList_[i].ToUpper(); // updateQuery_SB.Append(upperItem_updateColumn + "=" + "'@" + upperItem_updateColumn + "VALUE@'"); //} //upperItem_updateColumn = qm_.ColumnList_[qm_.ColumnList_.Count - 1].ToUpper(); //updateQuery_SB.Append(upperItem_updateColumn + "=" + "'@" + upperItem_updateColumn + "VALUE@'"); //updateQuery_SB.AppendLine("WHERE KeyColumn = '@KeyColumnValue@'\";"); //updateQuery_SB.AppendLine(); //#endregion //#region deleteQueryStr //StringBuilder deleteQuery_SB = new StringBuilder(); //deleteQuery_SB.AppendLine("private static string DeleteQuery_"); //deleteQuery_SB.Append("= \"DELETE FROM " + this.tableName_); //deleteQuery_SB.Append(" WHERE KeyColumn = '@KeyColumnValue@'\";"); //deleteQuery_SB.AppendLine(); //#endregion #endregion sb.Append(selectQuery_SB.ToString()); //insertQuery_SB.ToString() + //updateQuery_SB.ToString() + //deleteQuery_SB.ToString()); selectQuery_SB.AppendLine(); return(sb.ToString()); }