public int Update(string organizationId, Name name, TypeModify typeModify) { int result = 0; string updateSql = @"update system_Flag_Data_Modified set flag_modified=@flagModified, DateModified=@dateModified,TypeModify=@typeModified where OrganizationID=@organizationId and Name=@name"; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@organizationId", organizationId)); parameters.Add(new SqlParameter("@name", GetNameByEnum(name))); parameters.Add(new SqlParameter("@typeModified", typeModify)); parameters.Add(new SqlParameter("@dateModified", DateTime.Now)); parameters.Add(new SqlParameter("@flagModified", 1)); _dataFactory.ExecuteSQL(updateSql, parameters.ToArray()); return result; }
public int Update(string organizationId, Name name, TypeModify typeModify) { int result = 0; string updateSql = @"update system_Flag_Data_Modified set flag_modified=@flagModified, DateModified=@dateModified,TypeModify=@typeModified where OrganizationID=@organizationId and Name=@name"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@organizationId", organizationId)); parameters.Add(new SqlParameter("@name", GetNameByEnum(name))); parameters.Add(new SqlParameter("@typeModified", typeModify)); parameters.Add(new SqlParameter("@dateModified", DateTime.Now)); parameters.Add(new SqlParameter("@flagModified", 1)); _dataFactory.ExecuteSQL(updateSql, parameters.ToArray()); return(result); }