public void AppendForUpdate(BColectieParametriSQL pListaParametri, StringBuilder pSet)
{
foreach (KeyValuePair <string, object> corespondenta in this)
{
pSet.AppendFormat(" {0} = @{0} , ", corespondenta.Key);
pListaParametri.Add(corespondenta.Key, corespondenta.Value);
}
}
public void AppendForInsert(BColectieParametriSQL pListaParametri, StringBuilder pColoane, StringBuilder pValori)
{
foreach (KeyValuePair <string, object> corespondenta in this)
{
pColoane.Append(string.Format("{0} , ", corespondenta.Key));
pValori.Append(string.Format("@{0} , ", corespondenta.Key));
pListaParametri.Add(string.Format("@{0}", corespondenta.Key), corespondenta.Value);
}
}
public void AppendForConditie(BColectieParametriSQL pListaParametri, StringBuilder pConditie)
{
foreach (KeyValuePair <string, object> coloanaId in this)
{
if (coloanaId.Value == DBNull.Value)
{
continue;
}
pConditie.AppendFormat(" {0} = @{0} AND ", coloanaId.Key);
pListaParametri.Add(coloanaId.Key, coloanaId.Value);
}
}