private void DeleteSQL(DatabaseCore accessor, out string sql, out List <DbParameter> parameters)
{
sql = null;
parameters = null;
if (accessor == null)
{
return;
}
if (Keys == null || Keys.Count <= 0)
{
return;
}
var temp = string.Format("DELETE FROM {0}", TableName);
var select = new StringBuilder();
var where = new StringBuilder();
var list = new List <DbParameter>();
foreach (string key in Keys.Keys)
{
if (where.Length > 0)
{
where.AppendLine("AND");
}
var parameter = accessor.CreateParameter(Keys[key]);
where.AppendLine(string.Format("{0} = {1}", key, parameter.ParameterName));
list.Add(parameter);
}
select.AppendLine(temp);
if (where.Length > 0)
{
select.AppendLine("WHERE");
select.AppendLine(where.ToString());
}
parameters = list;
sql = select.ToString();
}
public void Export(DatabaseCore accessor, out string clause, out List <DbParameter> parameters)
{
clause = null; parameters = null;
if (accessor == null)
{
return;
}
var temp = text;
var list = new List <DbParameter>();
this.parameters.Keys.ToList().ForEach(key =>
{
var naked = NakedName(key);
var param = accessor.CreateParameter(naked, this.parameters[key]);
temp = temp.Replace(key, param.ParameterName);
list.Add(param);
});
clause = temp;
parameters = list;
}