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());
}
