public bool Update(DataObject Data, WhereStatement Where)
{
_WHERE += Where.ToString();
_Params.AddRange(Where.GetParas());
try
{
StringBuilder SB = new StringBuilder();
SB.Append("UPDATE ");
SB.Append(_TableName);
SB.Append(" SET ");
foreach (var Item in Data.Keys)
{
SB.Append(Item);
SB.Append(" = ");
SB.Append("@" + Item);
SB.Append(",");
}
SB.Append(" WHERE ");
SB.Append(_WHERE);
string SQL = SB.ToString();
return(_Helper.ExecuteNonQuery(SQL, _Params.ToArray()));
}
catch (Exception e)
{
throw e;
}
}
public bool Delete(WhereStatement Where)
{
_WHERE += Where.ToString();
_Params.AddRange(Where.GetParas());
try
{
StringBuilder SB = new StringBuilder();
SB.Append("UPDATE ");
SB.Append(_TableName);
SB.Append(" SET [status] = -1");
SB.Append(" WHERE ");
SB.Append(_WHERE);
string SQL = SB.ToString();
return(_Helper.ExecuteNonQuery(SQL, _Params.ToArray()));
}
catch (Exception e)
{
throw e;
}
}
public L2Database Where(WhereStatement WhereStatement)
{
_WHERE += WhereStatement.ToString();
_Params.AddRange(WhereStatement.GetParas());
return(this);
}