public virtual void Save()
{
if (change.Count != 0 || mode == "Add")
{
string statement = SQL_UPD;
/*собрать Update*/
foreach (string st in change)
{
statement += st;
}
statement += ("updated='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',");
statement += ("updated_by='" + Pref.LoginName + "' ");
if (mode == "Add")
{
statement += (",status='Active' ");
}
statement += "where (id=" + id.ToString() + ")";
/*чистим изменения*/
change.Clear();
/*обновляем*/
MySqlResultExec rs = new MySqlResultExec();
rs = MySqlExecuteNonQuery(statement, null);
if (rs.HasError)
{
LastErrorMessage = rs.ErrorText;
throw new System.InvalidOperationException("Ошибка при обновлении записи!\n\n" + rs.ErrorText);
}
}
}
public void Audit(string entity, string field, object old_value, object new_value)
{
string old = old_value == null ? "" : old_value.ToString();
string new_v = new_value == null ? "" : new_value.ToString();
MySqlResultExec rs = new MySqlResultExec();
string statement = "INSERT INTO " + Pref.Scheme + "." + "audit " + "(tbl,clmn,old_value,new_value,updated_by,created_by)" +
" VALUES(@param1,@param2,@param3,@param4,@param5,@param6);";
rs = Mig.DB.MySqlExecuteNonQuery(statement, new List <object> {
entity, field, old, new_v, Pref.LoginName, Pref.LoginName
});
if (rs.HasError)
{
LastErrorMessage = rs.ErrorText;
throw new System.InvalidOperationException("Ошибка при добавлении записи аудита!\n\n" + rs.ErrorText);
}
}
public virtual void Add()
{
mode = "Add";
string statement = SQL_INS;
/*собрать INSERT + дефолтные поля*/
statement += "(" + SQL_ENTITY_ID + ",status,created_by) VALUES(" + GetNextEntityId().ToString() + ",'Blank','" + Pref.LoginName + "');";
/*обновляем*/
MySqlResultExec rs = new MySqlResultExec();
rs = MySqlExecuteNonQuery(statement, null);
if (rs.HasError)
{
LastErrorMessage = rs.ErrorText;
throw new System.InvalidOperationException("Ошибка при добавлении новой записи!\n\n" + rs.ErrorText);
}
id = rs.Result;
}
