public SqlCommandString GenerateSqlCommandString(string sqlBody, string sqlWherePlaceHolderInBody) { SqlCommandString r = new SqlCommandString(); // SSC.DataStructure.Pair <string, List <string> > r_Internal = GenerateSqlWhere_Internal(1, 1); // r.Params = r_Internal.Data2; // r.CommandString = sqlBody + "\n"; // if (!string.IsNullOrEmpty(r_Internal.Data1)) { if (string.IsNullOrEmpty(sqlWherePlaceHolderInBody)) { r.CommandString += string.Format("WHERE\n{0}", r_Internal.Data1); } else { r.CommandString = r.CommandString.Replace(sqlWherePlaceHolderInBody, string.Format("WHERE\n{0}", r_Internal.Data1)); } } else if (!string.IsNullOrEmpty(sqlWherePlaceHolderInBody)) { r.CommandString = r.CommandString.Replace(sqlWherePlaceHolderInBody, ""); } // return(r); }
// public SqlCommandString Clone() { SqlCommandString r = new SqlCommandString(); r.CommandString = CommandString; r.Params = Params.ToList(); return(r); }