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